26 May 2005 – Training Material

1. 26 May 2005 – Training Material Inventory Module Item Journal Item Reclassification Journal Physical Inventory Journal Periodic Activities

2. Agenda – Inventory Module • 10:00 am Item Journal • 11:00am Item Reclassification Journal • 12:30pm Lunch Break • 13:30pm Physical Inventory Journal • 15:30pm Break • 15:45pm Periodic Activities

3. Item Journal • Usage of Item Journal : • Opening Balance (Positive Adjustment) • Adjustments : Damage, Loss (Negative Adjustment) • Production -> Consumption (Phase 1) • Production -> Output (Phase 1)

4. Item Journal(Opening Balance – Positive Adjustment) Opening Entries for Item are input in Item Journal. Give a meaningful Document No. for opening balance which ease for audit trail. Define Location, Quantity. In order to make sure Dimension are carried properly to posted entries. Click on Line button, Dimension. Print out Test Report for data checking purpose. Once confirm everything are accurately input, click Post, to post the entries.

5. Item Journal(Adjustment : Damage – Negative Adj) System by default retrieve Gen Prod Posting for item Define Reason code for the journal entries Amend Gen Prod Posting Group to “damage”. System will Credit Inventory Item and Debit Damage Account.

6. Item Journal(Production : Consumption Journal) Input the consumption journal here during phase 1. Negative Adjustment for ingredients with Cost, Location code, and Reason code. (Do not amend “Gen Prod Posting” for consumption journal) Reason code for consumption journal, do not give impact on the double entries, it is served as an audit trail.

7. Item Journal(Production : Output Journal) Similar, enter output entries at Item Journal with Cost, Location and Reason code. (Do not change “Gen Prod Posting” , it is only applied to adjustment entries) Define Reason code for output journal are served as audit trial for this journal entries.

8. Item Reclassification Journal • Usage of Item Reclassification Journal : • Transfer Product between location. • Reclass Product to another grade product. (Using Item Redesignate Journal)

9. Item Reclassification Journal A typical example of transferring product within location, from dummy receiving oil location to actual location. Define Item No., Location, New Location, Quantity. Once confirmed, post journal. Item availability by location – can be analysed at each item card.

10. Item Redesignate Journal Define products that reclass to different grade, quantity, and unit cost (if any) Once New Unit Cost entered, system will post the variance amount to GL accordingly.

11. Item Redesignate Journal Click on Function, “Redesignate”.

12. Item Redesignate Journal System will auto-create 2 entries, one entry with negative adjustment, another entry with negative adjustment.

13. Physical Inventory Journal You use the Phys. Inventory Journal window to maintain an up-to-date record of your inventory at different locations. The physical inventory feature can also assist you in taking a physical inventory by comparing the actual quantity on hand, as determined by the physical count, with the quantity on hand calculated by the program. If there are any differences, you must record and post them.

14. Physical Inventory Journal Physical Inventory Journal is a batch job to suggest all products from inventory module.

15. Physical Inventory Journal Filter Location code to WP-FG, system will suggest tose items available in this location. Key in Posting Date, Document No. and check on “Item not on Inventory”

16. Physical Inventory Journal System will suggest all product in the particular location with system calculated quantities.

17. Physical Inventory Journal Update actual quantity calculated in this field during physical count activities. At the same time, system will based on the quantity entered to amend the Entry Type accordingly.

18. Physical Inventory Journal Write Off During Physical Count : Show Column for Gen Product Posting Group and define ‘Write Off” code here. Upon checking, Post the entries.

19. Periodic Activities • Adjust Cost - Item Entries Batch Job This batch job to adjust value entries so that you use the correct adjusted cost for updating the general ledger with the “Post Inventory to GL” batch job. Under normal circumstances, closing month date will be the date for this batch job.

20. Item Revaluation Journal Criteria : Adjust Cost – Item entries batch job must performed before Item Revaluation Journal . Click on this, let system will suggest those items with latest adjusted cost.

21. Item Revaluation Journal Define Posting Date, Document No., and select calculation base, by location, by variant and Update Standard cost and click OK.

22. Item Revaluation Journal Amend Unit Cost (Revalued) field.