Background -
We are in SAP 2007 A PL42.
We have two companies in SAP B1. Canada company has CAD as Local, USD as System. USA company has USD as Local, CAD as System.
There is intercompany transaction. In each company the other company is created as a Business Partner.
Specific Details -
Canada company receive an AP invoice $1000.00USD(FC), $1100.00CAD(LC) on July 1 (say Exch. 1USD=1.1CAD)
CR USA Company Payable $1000USD(FC), $1100CAD(LC)
DR Expense $1000USD(FC, $1100CAD(LC)
Canada company issue payment on Oct 1 (Exch. 1USD=1.2CAD).
The Transaction is:
Canada Company
CR Bank account $1000.00USD(FC), $1200.00CAD(LC)
DR USA company payable $1000.00USD(FC), $1100.00CAD(LC)
DR Currency Gain/Loss $100.00CAD(LC)
Canadian Database is fine.
In USA company, the corresponding AP Invoice will reflect as a AR Invoice with posting on July 1 as:
DR Canada company Receivable $1000.00USD(LC), $1100.00CAD(SC)
CR Revenue $1000.00USD(LC), $1100.00CAD(SC)
US Company received payment from canadian company on Oct 1 itself (Exch. 1USD=1.2CAD)
DR Bank Account $1000.00USD(LC), $1200.00CAD(SC)
CR Canada company Receivable $1000.00USD(LC), $1200.00CAD(SC)
You can see in LC (USD) there is no problem. But in System currency (CAD) there is $100CAD difference. When we ask auditor, they say the posting in US company in System currency should be $1100CAD.
My question is if SAP B1 has a way to handle this, one company has a currency gain/loss and other company does not.
Regards
Manish
Edited by: Manish Chaturvedi on Mar 20, 2009 11:11 AM