Regd: Due amount in Invoice
How are we suppose to get the Due amount for a particular Invoice.
Like if the customer has already paid Rs.50000 in advance and the Invoice amount is for Rs.1lakh, where will the balance or the Due Amount for that particular Invoice can be caputerd and in which DB Table will it store the values.
I Checked in T-code FBL5N and the field is DMSHB but the relevant field is reffering to a structure only and not to any DB Table, This too refers for a particular Customer only and not for Particular Invoice.
Is there any possible way to to get the Due amount for a particular Invoice from any DB Table.
Help and Sugesstions will be much Appreciated.
Thanks & Regds.