IdealWare Online Users Manual

IY3-01 I/Y INQUIRY
30972 Inventory Transaction Inquiry

 

PURPOSE

 

The inventory transaction inquiry enables you to display or print transactions affecting product inventory quantities. The detailed inquiry displays each product's transactional information on a transaction by transaction basis. For example, each individual invoice, inventory receipt or inventory adjustment that affects a product's quantity or value is displayed. Invoice information such as the invoice number, invoice line number, customer code, invoice date and quantity sold is displayed. Inventory receipt information such as the receipt number, receipt line number, supplier code, receipt date, packing slip number and quantity received is displayed. The inquiry can display prior period transactional information (as far back as the detailed transaction file has been accumulating data).

 

Inventory Transaction Inquiry is accessed from:

  • Inventory Processing menu.

 

PROCEDURE

 

Select Inventory Transaction Inquiry from the Inventory Processing menu. The inventory transaction inquiry program can also be accessed from screen 4 of the inventory maintenance program by entering "TS" to display a transaction summary and "TD" to display transaction details. The following prompts display.

 

STORE:

 

Enter store code.

 

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

 

 

CR FOR CURRENT, 'YYMM' FOR HISTORICAL

 

Enter month to inquire upon in format YYMM.

 

[Enter] for current period.

 

PRODUCT

 

Enter product code to inquire upon.

 

[F5] to access product inquiry for selection.


Example Inventory Transaction Inquiry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│09/04/07           ***** INVENTORY TRANSACTION INQUIRY *****                    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│STORE:    01 IDEAL BUILDING SU     PERIOD: CURRENT     BASE:  UNIT              â”‚
│PRODUCT:  100007       BUDGIE CAGE LARGE ROUND WHITE   ALT-1:       (0.0)       â”‚
│                                                       ALT-2: PCE   (0.0)       â”‚
│────────────────────────────────────────────────────────────────────────────────│
│  DATE/  SOURCE/  <--------TRANSACTION---------> <--------ACCUMULATED---------> â”‚
│  TIME   BATCH         QTY       COST      VALUE      QTY       COST      VALUE â”‚
│────────────────────────────────────────────────────────────────────────────────│
│Jul15/96 RECEIPT        10      8.500      85.00       10      8.500      85.00 â”‚
│14:25:39 YR0057                                                                 â”‚
│Jul15/96 RECEIPT        10      8.500      85.00       20      8.500     170.00 â”‚
│14:31:09 YR0058                                                                 â”‚
│Aug07/96 RECEIPT        50      8.560     427.98       70      8.543     597.98 â”‚
│10:46:40 YR0059                                                                 â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│────────────────────────────────────────────────────────────────────────────────│
│** PRESS CR TO CONTINUE; 'P' FOR PRINTOUT:  _                                   â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO CONTINUE; 'P' FOR PRINTOUT:

 

[Enter] to clear display.

 

"P" to print display.

 

The printer selection menu displays when you exit the program.

 

 

 

FIELDS

 

DATE/TIME

 

Displays the date and time of the transaction.

 

SOURCE

 

Displays the source of the transaction (ie receipt, invoice, adjustment, etc).

 

BATCH

 

Displays the batch number of the source transaction.

 

TRANSACTION QTY

 

Displays the transaction quantity.

 

TRANSACTION COST

 

Displays the transaction unit cost.

 

TRANSACTION VALUE

 

Displays the transaction value (unit cost x quantity).

 

ACCUMULATED QTY

 

Displays the inventory + transaction quantity.

 

ACCUMULATED COST

 

Displays the inventory + transaction cost.

 

ACCUMULATED VALUE

 

Displays the inventory + transaction value.