Customer has an opening balance from last year (31st Dec 2009) which amount of (50000).
Two invoices issued for this particular customer:
INV 1 20000
INV 2 20000
How can I apply this formula 50000 - 40000 = (10000)? I want the statement of account to would show only (10000) is still open?
I know in Microsoft Dynamics Navision I can apply 40000 to the open (50000) to get (10000). In SAP B1, we cannot do partial reconciliation.
You can do this through reconciliation in business partners. Click on amount to reconcile and change the amount there say 4000 as what you have described and create and incoming payment or JE. Next time you select the same customer in reconciliation window, you'll see the balance as 1000. We can do this in 2007B. Hope this helps.