Knock-off transactions

[Former Member]

Hi experts,

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.

Please advice.

Regards,

Lim

[Former Member · Accepted solution]

Hi Lim,

You may build your own report for this requirement.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

Thanks for your answer. Solving it with my own report is not a big deal, but the problem is how could I knock off all those invoices in the system because the reconciliation is not 0.

Please advice.

Regards,

Lim

[Former Member · Accepted solution]

Hi Tim,

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.

Thanks,

Joseph