The Transaction Header table and the Trans. Sales Entry table both include a cost amount for Transaction items.
The cost amount is taken from the item card. This cost amount should be considered an approximation
due to the following reason:
The cost amounts of Ledger Entries are frequently updated. Replication of items to the POS Terminals is usually scheduled with some hours in-between,
which means that the cost price registered on the POS may be different from the one registered in
the BackOffice. The cost price in the transactions should therefore be considered an approximation
only - as well as the profit calculations based on it.
When a statement is posted, the system calculates new cost price for the items included in the statement.
This new cost price is taken from the item card and represents the actual cost price for the item.
Stock postings are therefore done using the new and updated cost price.
While it is recommended to use Item Ledgers for long term profit statistics you can still update
the Transaction Cost price and Statistic based on the Transactions. Note that this results in updating the Transaction Header and Trans.
Sales Entry tables.
Enable the cost update by placing a check-mark in the Update Cost Amount field on the Posting tab of Retail Setup.
To Update Cost Price:
1) Click on LS Retail - BackOffice, Periodic Activities, Costing, Adjust Cost Price From Value Entries.
2) Or run Codeunit 99001492 in Scheduler.