Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BP (is Vendor and also Customer) reconciliation

Hi Experts,

I am an user of SAP B1. I tried the internal reconciliation for BP who is both Customer and Vendor. The function is working. But the multicurrency has problem.

Here is the detail of my testing: trade in USD, local currency is CAD, System currency is USD.

AR in#101195 amount $600.00USD(FC), $757.08CAD(LC), Ex Rate:1.2618

Two AP transactions: In#102865 is $594.00USD(FC), $653.40CAD(LC), Ex Rate:1.1, In#102863 is $495.00USD(FC), $624.59CAD(LC), Ex Rate:1.2618

The reconciliation like below on April 7, 2009, Ex Rate:1.2

Origin Origin No. G/L Acct/BP Code Ref. 1 Due Date Amount Applied Amount

PU 102865 VTest 102865 4/3/2009 CAD (653.40) CAD (653.40)

IN 101195 CTest 101195 4/6/2009 CAD 757.08 CAD 757.08

PU 102863 VTest 102863 4/6/2009 CAD (624.59) CAD (103.68)

From USD amount AR in#101195 $600.00USD, reconciled AP in#102865 $594.00USD. There is only $6USD difference. But after reconciliation system took $82.17(103.68/1.2618, reconciled amount/AP In#102863 ex rate) out of AP In#102863. This is only for $600USD reconciliation.

The total reconciled FC is $682.17USD. Total reconciled SC is $630.90USD(757.08/1.2). The Should Be amount is $600.00USD.

Could you please help to find a solution?

Not what you were looking for? View more on this topic or Ask a question