The Inventory Control module forms the core of the accounting, distribution and manufacturing facilities.
It is designed to integrate with all the major functions of the systems and to provide flexible reporting on inventory holdings. Features include multiple warehouses and bin numbers, multiple costing methods, a full Kardex facility, a stock take system and extensive reporting.
This task outlines the procedures you should follow to set up your Inventory module before you begin to process transactions.
Some of these steps are optional and depend on how you intend implementing this module.
Navigate to the Set Key Information program.
Indicate the properties and numbering method you require for your Inventory keys.
Navigate to the General Ledger Codes program.
Define the General Ledger control accounts for the Inventory module.
If you want to integrate Inventory to the General Ledger, then you require the following account codes in the General Ledger:
Inventory control account.
You can define one Inventory control account per warehouse or a single Inventory control account for the company.
Subcontract operations control account
This is used when receipting a purchase order line directly to a Work in Progress job and the GRN suspense system is not required.
GRN suspense control account.
This applies when the GRN system is in use.
In addition to the control accounts, you need to define the General Ledger expense accounts for Inventory transactions for Adjustments, Cost changes, Issues, Cost modifications, Physical counts, Receipts and Warehouse transfers.
General Ledger Integration
Navigate to the General Ledger Integration program and indicate the following:
Select the Inventory Interfaces option.
Using the Inventory Ledger Interface program, indicate the interface ledger accounts required when processing non sales-related inventory transactions.
Select the Warehouses option.
Using the Warehouses program, define the warehouses used for Inventory.
Inventory Setup
Define the Configuration, Preferences, Financial Periods, History and User Defined Fields setup options you require for Inventory.
Use the Buyers program to define details of your buyers responsible for purchasing stock items.
Use the Planners program to define details of planners responsible for planning the manufacture of made-in stock items
Use the Cost Unit of Measure program to define conversion factors for stocked items where the unit of measure in which the item is stocked is not the same as the unit of measure in which the item is costed.
This applies if you require your inventory costs to be held in a unit of measure other than the stocking unit of measure.
Use the Warehouses program to define the warehouses in which your stock items will be held.
Use the program to define the
Use the Stock Codes program and capture the details of all your stocked items.
Use the Inventory Warehouse Maintenance for Stock Code program (accessed from the Browse on Stock Codes program) to link stock items to the warehouses in which hey are stocked.
Use the Pricing for a Stock Code, Inventory Pricing for a Price Code and Stock Code Quantity Discounts programs to define the coded prices and quantity discount breaks you want to assign to selected stock items.
If you intend selling and/or buying stock items in a foreign currency then use the Inventory Foreign Price Codes program to assign a foreign currency to selected price codes and the Inventory Foreign Purchase Prices program to assign foreign prices to selected stock items.
Use the Inventory Alternate Stock Codes program to create a link between stock codes whereby one item can be used as a substitute for another when a shortage of the primary stock item occurs.
Use the Inventory Alternate Suppliers program to assign alternate suppliers to selected stock items. This allows you to use one supplier as a substitute for another when a shortage of the stock item supplied by the primary supplier occurs.
Approved manufacturers
This facility is typically used if you source parts from numerous manufacturers and you need to specify from which manufacturer you sourced a specific part or you want to link a specific supplier with a preferred manufacturer.
Use the Approved Manufacturers program to maintain approved manufacturers from whom your company obtains parts.
Use the Approved Manufacturers Parts program to define details of approved manufacturers' part numbers and to link these part numbers to your SYSPRO stock codes.
Use the Approved Manf Supplier Maintenance program to link approved SYSPRO suppliers to the part numbers of approved manufacturers.
Use the Inventory Initial Sales Quantity History program to capture details of quantities sold for each existing stock item over the last 12 months, as well as additional sales history information.
Use the Inventory Initial Aged Valuation program to take on each stock item's year end quantity on hand for the last five years.
Use the Inventory Document Format program to define the page layout for printing your Inventory documents for transactions created using the Inventory Movements program.
Use the Inventory Label Format program to define the page layout for printing stock code labels.
Use the Stock Take Ticket Format program to define the stationery format required for printing stock take tickets. This is only required if you intend using stock take tickets.
The following sections outline the procedures that you should follow to ensure that the integrity of the Inventory system is maintained.
Ensure your daily procedures for Inventory are complete, including processing the required transactions against your stock codes (e.g. receipts, adjustments, issues etc).
If the option: Create GL journal is not enabled for Inventory (General Ledger Integration) then run the Inventory GL Integration program to ensure that all the General Ledger journals for transactions processed in the Inventory module are created.
If the option: Post GL journal is not enabled for Inventory (General Ledger Integration) then use the GL Journal Entry or GL Post Multiple Normal Journals program to post the General Ledger journals for Inventory into the General Ledger.
Print the Inventory Valuation report for all warehouses.
Print an Inventory balance report using the Balance function of the Inventory Period End program.
Check that the total Inventory amount agrees with the sum of the Inventory warehouse control accounts in the General Ledger.
Ensure that the balance in the Inventory warehouse control account(s) in the General Ledger balance to the total of the Inventory Valuation report and to the Inventory resulting balance total on the Inventory balance report from the Inventory Period End program.
Resolve any discrepancies before continuing.
Optionally reprint the Inventory Journal Report report for the month for audit trail purposes. These reports can be saved in PDF format.
Optionally print the following reports as required:
Aged Inventory Valuation
Kardex Report
Inventory Amendment Journal
Goods in Inspection
Goods in Inspection Offsite
Inventory Movement
![]() |
|
It is strongly recommended that you take a backup of your data before processing a Month end, a Year end, or a Purge. |
After you have completed the pre-month end reporting process:
Select the Month end only or Month end and purge option from the Inventory Period End program to close off the current Inventory period and to enable you to process transactions for the following period.
Indicate the After processing completed options you require.
Select Start Processing.
Check the final page of the report produced to ensure that the month end was completed without errors.
Run the Inventory at a Glance program and check the Posting period information to verify that the month number now reflects the new month.
The year end procedure is similar to the month end procedure except that it can only be processed in the final accounting period of your financial year. The year end process transfers current year information to previous year and sets the current year-to-date information to zero.
![]() |
|
It is strongly recommended that you take a backup of your data before processing a Year end. |
Ensure that the pre-month end reporting procedure is completed.
Select the Year end function of the Inventory Period End program to close off the final Inventory period of the financial year and to enable you to process transactions for the first period of the following financial year.
Indicate the After processing completed options you require.
Select Start Processing.
Check the final page of the report produced to ensure that the year end was completed without errors.
Run the Inventory at a Glance program and check the Posting period information to verify that the month number now reflects the first month of your new financial year.