Introduction/ Issue:
Unable to Generate Accounting for Receipt GRNs
Why we need to do / Cause of the issue:
Unable to Generate Accounting for Receipt Accounting. Create Accounting for Receiving completes in Warning.
In the Review Receipt Accounting Distributions window, the credit to the Delivery to Expense account is blank, with the Status Invalid and an error message
Error:
Subledger Accounting was unable to retrieve a value for the accounting flex field account rule. Cause: GL account cannot be derived by account rule. Action: Review the account rule definition and the extract source values, if applicable, for the event and make sure a valid GL account can be derived for the sub ledger journal entry’s feature can be turned off or advise a workaround.
How do we solve:
Steps to Reproduce:
1. Create PO Receipts and Correct Receipts Transactions.
2. Run Transfer Transactions from Receiving to Costing.
3. Run Create Receipt Accounting Distributions.
4. Run Create Accounting and notice the above error in the report output.
Custom Account Rule for Receipt into Inspection and Custom JERS and Custom Accounting Method needs to be defined.
SLA setup for Receipt Accounting is not working out of the Box.
Additional information like the Receipt into inspection account needs to be defined.
Conclusion:
To implement the solution, please execute the following steps:
- Create a Custom Account Rule for Receipt into Inspection.
2. Create Custom JERS for Receiving and Delivery events (include Receipt into Inspection, Delivery to Expense, Correct to Receipt, and Correct to Expense)
3. Link the custom Account Rule of Receipt into Inspection to each JERS created in step 2.
4. Create a custom Accounting Method and link it to the General Ledger option from the Task: Specify Ledger Option.
5. Link the JERS created in Step 2 to the Custom Accounting Method.
6. Run the Create accounting again and confirm the error is resolved.
