Can anyone help me with Forex gain & loss transaction in SAP bydesign?

[former_member517828]

Hi Experts,

For one of our customer account when I post receipt entry against invoice the clearing ID gets generated. So at the time of posting incoming check the amount is 9,781.48 USD and the invoice amount is 9,836.48 USD, the remaining balance what we have is 55 USD which is our bank charges amount. So I enter the remaining balance of 55 USD as Other discount/credit and specify the payment difference reason as Bank charge and post the receipt. Now, in journal entry 55 USD is showing in G/L 700001495-other differences as it should be reflected in G/L of 44010101-Bank charges. Please help as it is hitting the wrong G/L.

Regards,

Priyanka

[Anantpatel]

Hi Priyanka,

Go to Business Config --> Implementation Project --> select activity: Charts of Accounts --> select Account Determination : Cash --> go to Interest/Charge tab --> enter your correct G/L Account: 44010101-Bank charges for Bank Charge/Fees.

Once you do the setting like shown above than when you enter the remaining balance of 55 USD as Other discount/credit and specify the payment difference reason as Bank charge and post the receipt. You will have the differences be reflected in G/L of 44010101-Bank charges.

Regards,

Anant Patel

[former_member517828]

Thanks, Frank I'll just cross-check and update you.

Regards,

Priyanka

[frank_jahnigen]

Hi Priyanka,

The current logic as to recognition of payment differences as bank-charges and corresponding account-determination is as follows.
In case an incoming payment (e.g. check) is confirmed in a bank-statement, incurred bank-charges are also confirmed and can be allocated
as such in the subsequent payment allocation under tab: Bank Charges/Fees. The account determination for Cash/ Interest/Charge / Bank Charges/Fees kicks in and assigned expense-account is debited in a separate posting.
In case the invoice is directly cleared before the bank statement and Other Discounts/Credit are applied (e.g. Clearing in Account Monitor) the account determination is derived from activity: 'Reasons for Payment Differences'. Here concrete Payment Difference Reasons are matched with Groups for Payment Difference Reasons.
If Bank charges is matched with 'Under- and Overpayment' a difference account (e.g. other differences, cash discount etc.) as defined under: Charts of Accounts, Financial Reporting Structures, Account Determination / Accounts Receivable / Payment Differences will be posted. The same would apply to postings declared as exchange rate differences.
Consequently the posting logic would depend on when the bank charge is realized and under which applicable account determination.

Hope this helps,
Frank