Symptom
You are receiving an error message while posting the Payment Allocation.
Account determination missing for supplier. Define the account for char of accounts <PQR>, tab Exchange Rate Differences'field 'Gains from Exchange Rate.
Enter a general ledger account for the account determination group for suppliers Foreign, third party.
(Here, PQR refers Account Determination Profile)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Payment Management work center.
- Go to the Payment Allocation view.
- Click on Allocation id.
- Enter the Supplier details in Customer/Supplier ID
- Select the required invoice
- Click on Post to view the error message:
Account determination missing for supplier. Define the account for char of accounts <PQR>, tab Exchange Rate Differences' field 'Gains from Exchange Rate F.Enter a general ledger account for the account determination group for suppliers Foreign, third party.
Cause
You have posted Supplier invoice in different currency than Company currency.
You have not maintained the Exchange rate differences for the account determination group for suppliers 123. (Here, 123 refers Account Determination Group)
G/L Account should be maintained for Gain from Exchange Rate Differences for Account Determination Group under Accounts Payable Subledger.
Resolution
You should maintain G/L Account for Gain from Exchange Rate Differences for Account Determination Group 123 party under Accounts Payable Subledger by the following steps:
- Go to the Business Configuration Work center.
- Go to the Overview View.
- Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
- Go to Account Determination and Select Accounts Payable.
- Go to Exchange Rate Differences tab.
- Maintain G/L Accounts for Gain from Exchange Rate Differences for Account Determination Group 123.
Once you have configured the above steps, you are able to post the Payment allocation without error.
Keywords
Payment allocaiton; account determination group; account determination missing for supplier; tab exchange rate differences
++ISSUE DEFINITION++
--Symptom--
You are receiving an error message while posting the Payment Allocation 50 in the Bank statement 5.
Account determination missing for supplier. Define the account for char of accounts <ZTSM>, tab Exchange Rate Differences'field 'Gains from Exchange Rate F.
Enter a general ledger account for the account determination group for suppliers Foreign, third party.
--Environment--
Production
--Steps to Reproduce--
Go to the Payment Management work center.
Go to the Payment Allocation view.
Click on Allocation id.
Enter the Supplier details in Customer/Supplier ID
Select the required invoice
Click on Post to view the error message:
Account determination missing for supplier. Define the account for char of accounts <123>, tab Exchange Rate Differences' field 'Gains from Exchange Rate F.
Enter a general ledger account for the account determination group for suppliers Foreign, third party.
--Business Impact--
Document cannot be created
--Customer Contact--
Liat
+972 545597035
++TROUBLESHOOTING++
--Data Collected--
Supplier Invoicing - Invoices and Credit Memos
Search for invoice:HUPY-112-2022
Supplier invoice is posted in USD currency
We have verified the Company id:11and Company Currency :HUF
--Research (internal)--
KBA:3289806 - Error Message: 'Account Determination Missing for Supplier. Define the Account for Chart of Accounts <PQR>, tab Exchange Rate Differences' Field 'Gains from Exchange Rate' while Posting the Payment Allocation Version 1 valid from 12.01.2023 to active
++SOLVING++
--Cause--
We have your system and
Supplier Invoicing - Invoices and Credit Memos
Search for invoice:HUPY-112-2022
Supplier invoice is posted in USD currency
We have verified the Company id:11and Company Currency :HUF
You have not maintained the Exchange rate differences for the account determination group for suppliers Foreign, third party.
G/L Account should be maintained for Gain from Exchange Rate Differences for Account Determination Group under Accounts Payable Subledger.
We have verified
--Solution--
You should maintain G/L Account for Gain from Exchange Rate Differences F for Account Determination Group 4020 - Foreign, third party under Accounts Payable Subledger by the following steps:
Go to the Business Configuration Work center.
Go to the Overview View.
Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
Go to Account Determination and Select Accounts Payable.
Go to Exchange Rate Differences tab.
Maintain G/L Accounts for Gain from Exchange Rate Fluctuations and Loss from Exchange Rate Fluctuations for Account Determination Group 4020 - Foreign, third party.
Once you have configured the above steps, you are able to post the Payment allocation.
--Next Action--
Solution proposal to customer , KBA , account determination group , exchange rate differences , account determination missing for suppli , payment allocation error , SRD-FIN-CLM , Cash and Liquity Managment , Problem