CNET_ERP Stock management system

1. CNET_ERP Stock management system Course 2545 and 2520

2. Course contents • Setting up Stock management system • Stock transaction • Audit and reporting

3. Setting up CNET_ERP Stock management • Maintain Global System Library (GSL) • Maintaining Store • Maintaining Recipe • Maintaining beginning balance • Proof reading and checking setting

4. 1.1Maintain Global System Library (GSL)

5. Global System Library (GSL) • Items - Non processed raw material • Products – Processed value added Product • Finished Product and None finished Product. • Customers – Buyers, Guests, Patients… • Suppliers – Seller, vendors, provider • Employees – Workers of the organization • Miscellaneous – Various

6. Global system library illustration Global System Library (GSL) Sales Module Inventory Module Accounting Module FBM Module • Customer • Item • Product • Employee • Supplier • Item • Product • Employee • Customer • Supplier • Employee • Item • Product

7. GSL Grouping

8. Item/Products • General • Price list • Supplier list (Only for item) • Balance list • Specification list • Catalogue list • Package • Advanced • Master record • Medicine, Book, Electronic, Garment,

9. General • Article Code • Auto, Manual, Barcode • Article Name • Brand + Generic + Size • Family • Main Family, immediate family • Unit of measurement • Smallest Processing Unit (SPU) • Article tax • Taxable or not taxable

10. Price List • Price modification • Adjusting price (will be tracked) • Multiple price selection • Whole sales, retail, consumer • Price tagging • Assign a price for a customer or group of customers • Price and time • Assign a price for time

11. Balance list • Balance in terms of Quantity • Balance in terms of Cost • Balance must be accompanied by cut of period.

12. Suppliers list • Help to stream line the suppliers • Maintain multiple supplier for single article • Assign one of the supplier as favorite

13. Customer/Supplier • General • Name and TIN (No Abbreviation) • Address • Local Address • International Address • Advanced • Picture • Translator

14. Employee • General • Address • Local Address • International Address • Advanced • Picture • Translator

15. Miscellaneous • Department • Cart • Period • Commission • Font • Fixed Asset Class • Cost factor* • Bank • Tax • Message* • Lookup • Table* • Item category* • Store* • Exchange rate

16. Methods of Maintaining GSL • Automatic (Using data migrator) • From Excel (Standard formats) • From Pervious version of CNET_ERP V.4.0 • During Synchronization • Fast Registration • Manual maintenance • All GSL maintenance are found on maintain main menu. • Maintain history

17. Methods of editing GSL • From maintain dialogue box • Must select the GSL to edit • Make changes and save • From editing list • Excel like sheet • Has searching criteria • Multiple editing at once • Takes effect after saved • Edit history

18. 1.2Maintain Store

19. What is store • Store is like a water tanker • Has inlet and outlet • All inlets and outlets are accompanied by document • Will automatically balance to full • All stores must have an account • The system requires at least one main store

20. Water tanker example Normal Inlet Minimum Outlet

21. Water tanker example • Has inlet • Has outlet • Will store • Will balance the level automatically • Minimum level • Normal level

22. Maintaining levels • Minimum order qty • Normal qty • On the balance list tab • Needs analysis and a formula can be applied • For every store

23. Store Types • Single Store • Multiple • Hierarchy stores* • Parallel store

24. Single Store Model Store

25. Multiple hierarchy stores model

26. Multiple parallel store model Store 1 Store 2

27. 1.3 Maintaining Recipe

28. What is Recipe • Formulation, ingredient, composition. • A one to many relationship. • One product is made out of one or more raw material. • A product can be used to make another product called semi finished product.

29. Recipe chart Item/Products Products Water Tea Tea Grinded Meet Sugar Steak souse Burger Bread Tomato Spaghetti Onion Pasta Olive oil Cheese

30. Methods of recipe formula • Lot size • Unit conversation • Portion calculation • 4 decimal place • Measurement tools must be used during production • One to one relationship • Application of semi finished products • Cost is calculated automatically

31. 1.4 Maintaining beginning balance

32. Balance list • Balance in terms of Quantity • Balance in terms of Cost • Balance must be accompanied by cut of period.

33. Qty balance • Inventory count is taken in every store • Can be done by a counting machine • Inventory count • Dynamic inventory • Taking inventory while transaction is active • Special program is used • Static inventory • Traditional way • All transaction will freeze

34. Balance in cost • Taken from the old system • From Stock card • Last purchase price • If the qty balance is 0 the beginning cost will be 0

35. Cut off period • Balance is subjected to date • Beginning of the fiscal year • Half year • Quarter • Period (Month)

36. 2.1 Vouchers (Transactions) Source Document layer

37. Vouchers (Transactions) • Transactions are made out of one or many GSL • Transactions are curried via Vouchers • Vouchers are building blocks of subsystems • There are 39 Vouchers in 5 Subsystems in CNET_ERP V.5.0 • Vouchers are source documents • Will take effect after being issued • Voucher will be further processed to produce Journal

38. Kinds of Vouchers • With respect to structure • Line Item Voucher (29 – 75%) • None line item Voucher (10 – 25%) • With respect to Stock movements • Stock Moving • None Stock moving

39. Vouchers and Sub systems division • Core Sub system • Sales (7) • Inventory (15) • Accounts (7) • Extended Sub system • Front office management (3) • Productions management (7) • Human Resource management (-)

40. Rules of Vouchers • Sequentially Numbered • Need time stamp • Need one or more owner • Should be contained in a single page • Can not be modified after being issued • Need a copy distribution management (CDM) • Can be void • Must support multiple print size and formats • Has execution procedure

41. Line Item and None Line item Vouchers • All Sales, inventory and production Vouchers are line item vouchers • All Accounting Vouchers and FOMS vouchers are non line item vouchers • Dual Life vouchers • Credit sales (FOMS Room sales) • Refund (FOMS Room Refund)

42. Parts of line item voucher • Value section • Cart Section • Batch section • Payment method • Store Section • Operation Section • Reference section • Purpose section • Address section • Item Information/ (Nested reference) • Command section • Item collector • Term Section • Summery Section • Voucher no Section

43. Parts of non Line Item Voucher • Address Section • Reference section (Nested) • Tax Section • Account Section • Voucher No Section • Amount Section • Description Section • Cart Section • Payment method section • Operation Section

44. Sales subsystem • Sales Order • Performa Invoice • Cash sales Invoice • Credit sales invoice • Sales return (Refund) • Consignment sales invoice • Consignment sales return

45. Item moving Vouchers (Sales)

46. Inventory Sub system • Store Request • Store Issue Voucher • Store Transfer Voucher • Goods Receiving Voucher • Cash Goods Receiving • Credit Goods Receiving • Dispensary Goods Receiving • Consignment Goods Receiving • Purchase Request • Purchase order • Store Return Voucher • Disposal Voucher • Stock Adjustment voucher • Supplier Return • Consignment Supplier return • Delivery Order

47. Item moving Vouchers (Inventory)

48. None Item moving Voucher

49. Accounting Vouchers • Cash Receipt Voucher • Bank Advise Voucher • Bank Payment Voucher • Pity cash Payment Voucher • I O U Voucher • Bank Deposit Voucher • Payment Order Voucher

50. Sales Order • Line Item Voucher • Do not move item • Shows customer interest or order info. • Generally used to analyze market demand