Exchange rate issue in CCO & SAP B1

[harpreet_singh79]

Hi,

Our SAP system local currency is USD but CCO local currency is SGD. When we post the receipt in CCO then based on B1if integration Sap Business one Invoice was posted in SGD with Sap exchange rate but payments not posted with Sap exchange rate because it follows CCO exchange rate due this reason payment entry have huge difference in Realize exchange rate gain & loss ledger. if Invoice is posted with Sap exchange rate then payment also should be posted with Sap exchange rate otherwise payment entry always have huge difference in Realize exchange ledger.

[JoergAldinger]

Hello harpreet_singh79

We had the same scenario a while back and discovered the same problem as you. Unfortunately, using CCO in a different currency than the B1 main currency is not officially supported as far as I know.

However, we proceeded to customize the PostInvoicePayment step to correct the posting of the payment. And to do that, basically you only need to do two things:

• Remove the "DocRate" from the Payment structure --> this causes B1 to use the daily exchange rate already in the system
• Adjust the CashFlowAssignment by setting AmountFC instead of AmountLC --> to prevent the "unbalanced cash flow error"

If I remember correctly, that's pretty much there is to it. Maybe there's an IR to support this natively, but I don't really remember any more. If there is, make sure to vote for it.

Best regards,

Joerg.

[harpreet_singh79]

Hi joerg.ceo,

Thanks.

Can you share the customized PostInvoicePayment solution?

Thanks again.

[JoergAldinger]

I can share by e-mail, but of course without any guarantee or support. Please contact me by direct message, for example on LinkedIn: Joerg Aldinger | LinkedIn

Best regards,

Joerg.