IN-O User Defined Inventory Transactions

Purpose of Program

Use this program to get a list of inventory transactions for one or a range of inventory items.  This provides a history of inventory movements for the item.

General Program Operation

Enter an existing report name or create a new one.  The use of multiple report names enables you to predefine a variety of combinations of selection filters that can be reused.  Once reports have been defined, you need only select the report name, click over and enter item number and/or date range and click Print.

Select a sort order for the report.  The sort order is important as it directly affects the speed of the report and which indexes are used to select and optimize the data.

Select whether you want Detail and subtotals or subtotals only, or beginning balance with ending total (Evo-ERP only)

Accept or use the space bar to remove the ?selecting the  transaction types desired  The transaction types are:

A - Adjustments (IN-C, IN-K or Physical Inventory)

B - Bin transfer

C - PO  Price Change entered in AP-C

G - Scrap

I - Stock issues to work-in-process

J - Purchase order receipts to work-in-process

O - Outside Processing (Service) PO Receipt to Work Order

P -  Purchase order receipts to stock

Q - Purchase Receipt to QC

R - Service & Repair shipment

S -  Shipments

T - Location Transfer

W - Work order receipts to stock

 

Select whether to print audit info and which items to include when running with beginning balances.  1 includes all items.  2 includes only items with transaction activity within the date range and 3 includes all items with activity and/or non-zero balances.

Next select the Item number or range of items to report on, Transaction date range  and any additional filters desired.  You can click Print at any time to run the report based on the filters specified.  Clicking Next Screen brings up some additional filters.  If you are selecting by a filter other than date range (such as all transactions for a Work Order) the report will run much faster if you also specify a date range which includes the expected transaction dates.  The sort order selected indicates which index is used to open the file.  If you do not select a item number range, the program first looks through the file indexed by date limited to any date range specified so specifying no dates requires it to go through the entire file.  Once it has identified the entries meeting the defined filters it will rearrange them to print the report in the sort order specified.   You can also specify whether to include Audit detail which consists of the entry date and time of the transaction and the User Login ID of the person generating the transaction

So if, for example you are searching for all I type transactions associated with a given work order regardless of item number then specifying only the I type and the Work Order number range will require the program to go through the entire Inventory Transaction file which can become a huge file over time.  On the other hand, including a date range limit that brackets the work order activity dates will limit the amount of the file the program needs to look through during the first pass through the data.

To report on a single item or range of items for a date range (a common use of this report), use Item Number as the sort criterion and then select the transaction type(s), the item number or range and date range, then click Print.

If you select Detail and Subtotals, the report provides two calculated totals and some reference information  after each item number:

Net Units is the net difference between additions to inventory and deductions from inventory within the ranges selected.  This lets you know how much the inventory on-hand went up or down.

Avg Cost(period)   calculates an average cost for the transactions within the ranges selected.  This gives you a feel for the basic cost level that occurred

In addition, the current Average, Last and Standard Cost of the item from the inventory master are included as a reference.

If you select Subtotal only, you will get the net unit change, the Average Cost of the transactions included within the range and the current Average Cost from the inventory master.