brucechangcpa
|
If this is a computerized system, you retain all of your individual receipt and shipment (withdrawal from inventory) transactions with the date and perhaps time that the transaction took place. Each transaction is assigned a sequential number.
Another kind of transaction pair, a commitment and a sale can be added if sales and commitment are a significant part of business.
Your master record for the SKU will never be allowed to have a negative balance. The master record will record the date and time of the last update and its sequence number, for audit purposes, and the updated total. Sold or committed totals are adjusted if that is what the transaction was.
The master record will be locked by a transaction that will be updating it until either the update is completed or rolled back so that no two transactions will be adding to the value in the undatedd master.
 Posted 538 days ago
|