Scenario:
A user is trying to update or modify the General Ledger (G/L) impact generated by an Item Fulfillment transaction.
Solution:
Once a transaction is saved and its GL impact is posted, the system does not allow direct editing of the GL impact. This is by design to preserve financial audit integrity. For Item Fulfillment specifically:
- The GL impact is determined by the associated item types, item cost, location, and the accounting setup (e.g., Inventory Asset, COGS accounts).
- If the GL impact is incorrect, it is usually due to configuration issues such as:
- Incorrect account mapping in the Item Record.
- Improper Inventory Costing Method setup.
- Errors in the related Sales Order or Item Receipt (for drop-ship or special order processes).
To correct or change the GL impact, you have a few options:
- Void or Delete the Fulfillment (if possible) and re-create it after correcting the root configuration issue.
- Adjust the GL impact through a Journal Entry, making sure to document why the adjustment is needed.
- Review Item and Accounting configuration:
- Navigate to the item record: Lists > Accounting > Items > <Pick your Item>
- Check the "Accounting" tab for account settings.
Important:
Changing the GL impact retroactively is not supported. Always make configuration changes before transaction entry and test in a sandbox environment if unsure.
-----
If you find this information useful, let us know by reacting or commenting on this post!