IdealWare Online Users Manual

IY2-12 I/Y PROCESSING
30124 System Balancing Test

 

PURPOSE

 

The inventory system balancing test program prints the status of your inventory to ensure that all inventory system files are in balance. The report balances the inventory statistics file (quantity, value on hand, month to date and year to date statistics) for all products against the monthly transaction summary file.

 

This report is printed as part of the month end processing procedures. If your inventory system is out of balance, contact your IdealWare consultant before proceeding with the month or year end purge.

 

The inventory system balancing test does not include figures from the G/L inventory control account. To verify that the inventory system balances with the G/L inventory control account it is necessary to compare the valuation reported in the system balancing test with the current balance displayed for the G/L inventory control account. This can be accomplished quickly by displaying the appropriate account information in the G/L inquiry program. If you have multiple inventory control accounts that do not group into a single account you can print a G/L trial balance specifying the range of accounts that encompasses your G/L inventory accounts.

 

The Inventory System Balancing Test is accessed from:

  • Inventory Processing menu.

 

PROCEDURE

 

Select System Balancing Test from the Inventory Processing menu. The following prompts display.

 

** ENTER STORE CODE:

 

Enter desired store code.

 

[Enter] for all stores.

 

In a single store environment this value defaults to the normal store code.

 

 

** PRESS CR TO CONTINUE:

 

[Enter] to perform balancing test.

 

[F4] to exit to menu.

 

You are taken to the printer selection menu.

 


PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example inventory system balancing test printout follows.

  



                          IDEAL BUILDING SUPPLIES LTD.
09/11/07  15:10:19                                               PAGE: 1

       INVENTORY SYSTEM BALANCING TEST FOR IDEAL BUILDING SUPPLY LTD YARD
--------------------------------------------------------------------------------
                                      QUANTITY        VALUE
TOTAL DESCRIPTION                     IN STOCK       ON HAND
--------------------------------------------------------------------------------

STORE CONTROL QUANTITY:             15,603,313       992,617

STORE MONTHLY MOVEMENT:             15,603,313       992,617

STORE YEARLY MOVEMENT:              15,603,313       992,617

MONTHLY TRANSACTION SUMMARY:        15,603,313       992,617



FIELDS

TOTAL DESCRIPTION        description
QUANTITY IN STOCK        quantity
VALUE ON HAND            value
STORE CONTROL QUANTITY   quantity and value of on hand amounts
STORE MONTHLY MOVEMENT   accumulation of month to date quantity and value statistics