BP (is Vendor and also Customer) reconciliation
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?