Hi there,
Our auditor perform audit our company want to obtain information to calculate Cost of Goods Sold (CGOS). But NS Income statement only capture Cost on each sales.
They calculate it as CGOS = Opening inventory + Purchase – Closing inventory
I tried to get data by the following report but the CGOS calculated has a big difference compare with CGOS on NS Income Statement report
Open Inventory from Inventory Valuation report
Purchase from from Purchase Order History
Closing Inventory from Inventory Snapshot
May I know how to get the following information include all adjustment made to those order and which report should use?
- Open Inventory
- Purchase
- Closing Inventory
Our auditor suggest if Inventory valuation can break into 4 parts. Can NS Inventory valuation can do that?
=============
Inventory Valuation may need to be broken into 4 parts to generate the data. (If the customer service provides a report including the below requirement then only that report is enough)
- Inventory receipt. The amount of inventory receipts should be equal to the receipt amount receipt of the Excel "Purchase Order History"
- Inventory used. The amount should be equal to the Cost of Goods Sold on the Excel "Income Statement"
- Inventory adjustment. The amount should be equal to the Product - Model change and Product - Stock adjustment on the Excel "Income Statement"
- The full list of Inventory Valuation. The total amount of inventory should be equal to the total amount in the stock list. It may be a little bit different due to the amount of inventory not being adjusted to HK$0 due to the system problem
=============
Thanks in advance.
Regards, kf