Applies to Product - Dynamics 365 Commerce
What’s happening?
The cost amount in the store sales transaction is different from the cost amount in the item transaction.
Reason:
The discrepancy in cost amounts is due to the transfer order, which may have had a manually defined cost price that was incorrectly captured in the system. The cost amount in the store sales transaction is derived from the RetailTransactionSalesTrans table, while the average unit cost on the released product form is calculated from the InventSum table. If the prices are not configured correctly in the Released Products setup, they may be updated dynamically based on the most recent financial costs posted in source documents.
Resolution:
- Verify that the cost prices are correctly configured in the Released Products setup under the Manage Costs fast tab.
- Check the transfer orders to see if any manual cost prices were defined that could affect the calculations.