Chapter 8 Recalculate Stock Costing & Global Price Change
CHAPTER 08.01 RECALCULATE STOCK COSTING
Recalculate Stock Costing is used to recalculate stock costing value should there were changes in setting or entries (e.g. change of prices) that are likely to affect the costing value.
a) Go to Tool – Recalculate Stock Costing
Question: The item has zero quantity but the stock report still showing a balance in value. Why? How to correct this?
Answer: This is caused by the timing of back-order transaction….especially when sales documents are issued with negative stock balance (quantity) and purchase documents are recorded at a later time.
To correct it, first backup your database, then go to Tools > Recalculate Stock Costing and run the recalculation.
If you are doing back-order transaction frequently, it is advisable to run stock costing recalculation before taking the stock value for financial reporting purpose.
1. SAMPLE 1
a) Stock Card of Item TRADING for Inv:I-000008 & Stock Adjustment key in before Purchase Invoice:PI-00008, therefore autocount using the standard cost set RM50 in Item Code.
b) Standard Cost as per Stock Item
c) Run Recalculate stock Costing
d) Recalculate stock Costing completed
e) Stock card after Run Recalculate stock Costing
2. SAMPLE 2
a) Stock Card of Item SPC002 without set standard cost for Inv:I-000009 key in before Purchase Invoice:PI-000010, therefore autocount using the standard cost RM0 in Item Code.
b) Run & Completed Recalculate Stock Costing
c) Stock Card after Run Recalculate Stock Costing
CHAPTER 08.02 GLOBAL PRICE CHANGE
Global Price Change is used to make changes of price in general, by item/group/type, by price book or by debtor/creditor.
a) Go to Tool – Global Price Change
b) Click New
c) Step 1 – Filter Options
d) Step 2 – Using Markup Ratio
e) Step 2 – Using by Item Code/Price Book
f) Step 3 – Apply Update on Customer/Supplier Price
g) check tab to view/verify changes
h) Confirm change