Dynamics 365 Business Central – How to post a Sales Credit for an Item without affecting Inventory using an Item Charge
When issuing a sales credit for an item that remains with the customer, using an Item Charge linked to the original sales shipment is preferable to posting directly to a GL account because it creates value entries that correctly update inventory reports and the Sales Amount (Actual) on item ledger entries.
"any reports based on the Inventory tables will reflect the accurate values."
Key points
- Posting a sales credit memo with an inventory item automatically creates item ledger entries that return the item to inventory, which may not match the business scenario.
- Using a GL account for the credit avoids inventory adjustments but leaves the original item ledger entry’s Sales Amount (Actual) unchanged, causing inventory-based reports to show incorrect values.
- Item charges can be assigned to the original sales shipment, creating value entries that properly adjust the Sales Amount (Actual) on the item ledger entry.
- The item charge approach maintains accurate inventory records and ensures reports based on inventory tables reflect correct sales amounts.
Quotes
- “any reports based on the Inventory tables will reflect the accurate values.” (Demonstrates the practical benefit of the item charge approach for downstream reporting accuracy.)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- table 32 “Item Ledger Entry”
- table 5802 “Value Entry”
- table “Customer Ledger Entry”
Not found in BC28-30: table “Customer Ledger Entry”.
Context
- Features: Sales Credit Memo, Item Charges, Item Charge Assignment, GL Accounts
Source: The Dynamics Explorer, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.