Adjusting advance with Bill

soumya ( Accountant) (48 Points)

08 May 2011  

IT IS in TALLY ERP9

Q Adjusting advance amount with the bill

Suppose advance given 1000000 with tds deducted with 20000 coming automatically 
with journal entry as

party dr 1000000
tds dr     20000
to bank  980000

and after certain period bill amt 2000000 received  (10lakh advance paid+rest 10lakh is adjusted)

after making an advance entry from payment screen ,   i go to Journal for adusting the bill

       

after enter  the service ledger  as Advertising Expense i got  in TDS Details screen i select agnst ref where i got automatically the asseciable amount and the net payable amount is coming of the payment bill  &

after that when i choose the rest of the amount of 10lakh in new ref it got nicely coming the TDS amount and the net payable amount after that

the problem arise when  in BILL WISE DETAILS screen  the bill-wise details for Part upto 10lakh is coming not the total after

deducting the earlier paid tds that is 20lakh-20000 that is 9lakh80thousand in bill wise screen it is only adjusting on 10lakh the new

ref which is made in the  TDS details screen.

     How could I get that 9800000 in the Bill details screen to adjust the total.