Code Setup / Master Maintenance

1. Debtor / Customer Maintenance in S$ and Foreign Currency

2. Debtor / Customer Listing

3. Creditor / Supplier Maintenance in S$ and Foreign Currency

4. Creditor / Vendor Listing

5. Stock Maintenance by 3 levels - Group, Categories or Brand, Item or Part No.

6. Opening/Closing Stock Entry

7. Opening/Closing Work-in-Progress (WIP) entry

8. Opening/Closing stock at different location

9. Maintain history of Selling Price by Debtor / Customer

10. Maintain history of Purchase Price by Creditor / Supplier

11. Bills of Material Maintenance/Template for Part No.

12. Copy BOM from existing BOM to new BOM

13. Miscellaneous Charges Maintenance

14. More description Code Setup

15. Location and Shelf Code Maintenance for stock item in details

16. Maintain Project or Job Titles in detail

17. Maintain additional remarks to item description

18. Unlimited multiple currency code and rate maintenance

19. Maintain the Customer delivery address and ship to address

20. Agent Code Maintenance, Salesman Code Maintenance

21. Area Code Maintenance, Territory Code Maintenance

Transaction

1. Supplier/Creditor

    ° Issue & Print Purchase Order for stock and non-stock item (with expected Delivery date)

    ° Issue & Print Stock Received Note at one or more location/warehouse/store/outlets

    ° Issue & Print Purchase Return

    ° Match supplier invoice with Delivery Order

    ° Update to Accounts Payables

2. Issue stock / Consignment Note

3. Customer/Debtor

    ° Issue & Print Quotation

    ° Issue & Print Sales Order (with expected Delivery date)

    ° Issue & Print Delivery Order from single to multiple Sales Order

    ° Issue & Print Invoice / Cash Sales from single to multiple Delivery Order

    ° Issue & Print Debit Note

    ° Issue & Print Credit Note

    ° Match multiple Sales Order and Delivery Order

    ° Update to Accounts Receivables

4. Stock transfer in / out for different location/warehouse/store/outlets

5. Adjustment to Stock quantity and value

6. Assemble item/Part from BOM, updating from components to Finished Goods

7. Dismantle

Inquiry

1. Selling Price (Historical)

    ° Based on Item to Customer

    ° Based on Customer to Item

2. Purchase Price (Historical)

    ° Based on Item to Vendor

    ° Based on Vendor to Item

3. Inquiry on Stock detail and location

4. To check month to date item status

5. Check detail movement of stock in Stock Card

6. Check Invoice, Cash Sales, Debit Note, Credit Note Stock Received and Purchase Return by date, Customer / Supplier and Invoice no.

7. Check Debtor / Customer in detail

8. Check Creditor / Supplier in detail

Reports

1. Print & select by grouping for D/O, Invoice, Cash Sales, Debit Note, Credit Note, Goods Received Note, Purchase Return Note, Issue Note, Consignment Note, Sales Order, P/O or Quotation

2. Print out bill check list for checking or verification of accounts code entry

3. Listing of "Outstanding" Delivery Order

4. Listing of "Completed" Delivery Order

5. Transaction Audit Trail for Item Assembly, D/O, Stock Received, Issue, Location Transfer, Adjustment Audit Trail, Invoice, Cash Sales, Credit Note, Debit Note, Purchase Return, P/ O, Sales Order

6. Report of Packing List

    ° Base on D/O

    ° Base on S/Order

    ° Base on Invoice

7. Transaction Summary by Product Group/Category /Item No/Part No./ Period

8. Print Goods Received Note by Vendor by Product Group

9. Print Issue Note by customer by Product Group

10. Report of Over limit Customer Listing

11. Listing on Miscellaneous charges

12. Print Sales Report by Group by period

13. Print Sales report by Category by Group by period

14. Print Sales Analysis Report

    ° By Customer

    ° By Agent by Customer

    ° By Agent by Product

    ° By Agent by Area

    ° By Agent by Group

    ° By Agent by Bill

    ° By Area By Customer

    ° By Area By Product

    ° By Area by Summary

    ° By Area by Group

    ° By Item by Part by Location

    ° By Bill by Customer by period

    ° By Customer by Agent by period

15. Yearly Sales Report by Customer / Agent / Area / Product / Group / Area & Product

16. Listing of Outstanding Sales Order, select by customer, item, Location, expected order Date, Agent & Area

17. Listing of Item in Sales Order, select by customer, item code, Sales Order No.

18. Listing of Sales Order in Delivery Order / Invoice / Credit Note Listing, select by customer by Item Code

19. Listing of Outstanding Purchase Order, select by Vendor, Item Code, Location, expected Receive Date

20. Listing of Item in Purchase Order, select by Vendor, Item Code, Purchase Order No.

21. Listing of Purchase Order in Stock Received / Purchase Return, select by Vendor, Item Code, P/order No.

22. Listing of Top Sales by Quantity / Sales Value, select by Date, Group, Category, Location

23. Listing of Bottom Sales by Quantity / Sales Value, select by Date, Group, Category, Location

24. Listing of Yearly Purchase by Vendor / Product / Group

25. Listing of Purchase Analysis, select by Vendor, Date

26. Listing of Top Purchase by Quantity / Value, select by Date, Group, Category, Location

27. Listing of Bottom Purchase by Quantity / Value, select by Date, Group, Category, Location

28. Listing of Gross Profit Report

    ° By Invoice, select by Date, Item Code, Invoice No, Group, Category

    ° By Cash Sales, select by Date, Item Code, Group, Category

    ° By Customer, select by Date, Item Code, Customer, Group, Category

    ° By Agent, select by Date, Item Code, Agent, Group, Category, Area, Customer

    ° By Area, select by Item Code, Area, Group, Category

    ° By Product, select by Date, Item Code, Customer, Group, Category

    ° By Group, select by Date

    ° By Category, select by Date

29. Listing of Stock Control Report for Physical Worksheet, select by Item No, Location, Until Date, Shelf, Group, Category

30. Listing of Stock Card Report, select by Item Code, Location, Date, Group, Category, Date

31. Listing of month to date item status, select by Item Code, Date, Group, Location

32. Listing of Item Valuation Report, select by Item Code, Until Date, Group, Category, Location

33. Listing of Reorder Advice Report, select by Group, Category, Item Code, Vendor, Until Date

34. Listing of Yearly Issue by Product, select Item Code, Date

35. Listing of Available Stock Balance Report, select by Item Code, Date, Group, Category, Location, Shelf No.

36. Listing of Stock Aging, select by Group, Category, Item Code

37. Listing of No Transaction Item, select by Item Code, Date, Group, Category

38. Listing of Quantity on hand by location, select by Item Code, Until Date, Location, Group, Category

39. Listing of location sales / Profit, select by Item Code, Date, Location, Group, Category

40. Listing of Quotation Report based on Item No. / Customer No. / Agent / Area

Housekeeping

1. Determine the format setting for Inventory System

2. Determine the format setting for Delivery Order, Invoice, Cash Sales, Debit Note, Credit Note, Goods Received Note, Purchase Return Note, Issue Note, Consignment Note, Sales Order, Purchase Order, Quotation printouts

3. Recover index and data files if the record is corrupted in the case of power failure

4. Reorganise index files or remove marked files

5. Change update status allows to unpost the posted bills

6. Update the transactions to Accounting System if it is linked

7. Scan Error Bills

8. Copy file to disk

9. Remove the Data for Selling Price / Purchase Price / Sales Order / Purchase Order / Item Assembly Audit Trail / Quotation / Unit Cost Audit Trail / Month End Data Audit Trail

10. Clear All Data from the system

11. Post all the transactions into the inventory database at Year End Processing, After the Year End Processing, the system will calculate the opening balance automatically

12. Backup / Restore Data File or Report Format

13. Change D/O Flag allows to unmark the Delivery Order for deleted invoice

14. Mark Completed Sales and Purchase Order

15. Recalculate the unit cost or quantity if using Moving Average Costing method

16. Update Selling Price by certain percentage

17. Export / Import the Transaction / Item / Customer / Creditor / Sales Order / Purchase Order to the file

18. Copy File to Disk

19. Change the status of the exported transactions

System Administrator

1. Set User ID and Password, and the permission group

2. Allows the authorised person to check the password for each user and the last time the password was changed

3. Allows the authorized person to set group permission for users who belong to the same group

4. Track user's field data changes, record additions and deletions

5. Print the Audit Trail for checking purposes

6. Clear all the Audit Trail

7. Track the error made during the usage of Inventory System

8. Print Error List for checking purposes

9. Clear all the Error List

10. Data Manager

11. Change code for Customer / Vendor No. / Item No. / Group / Category / Location / Project / Job

12. Upgrade Data File

13. Lock the Debtor / Creditor