header5

Reports

Open Order Component Usage Report

 

Open Order Component Usage Report provides a listing of all of the components of finished goods items on open orders.  The report will give information on both the finished good and the component level.  The report is not program specific and will report on any component whether a *item from COMP or a component from any other program.

 

 

Report Setup

 

Item Number.  Enter the item number to print on the report.  If all items on all open orders are to print, press Spacebar.

 

Date Range.  This is the starting and the ending dates for the open orders to print on the report. The date that the system uses to determine printing is the order entry or order booked date.  If all dates are to print, press Spacebar. If a specific date is to be entered into the starting, the ending or both starting and ending, press Spacebar in the field without the specific date.  An example would be a listing of all orders from March 31, 20XX to today's date.  Enter 03/31/XX in the starting date field and Spacebar in the ending date field.

 

Order Source.  The report is able to list the usage of components from either open, closed or both open and closed orders.  To list only open orders, enter "O".  To list only history, or closed, orders, enter "H".  For both open and closed orders, enter "B".

 

The report will print the following information:

 

Order Number.  The order on which the component is used as part of a selling item.

 

T.  The item class, C=Co-op or F=Fulfillment.

 

Item Number and Description.  The item number and the item description are formatted into two lines.  The upper line is the finished good.  The lower line is the component.

 

Finished Good.  This section is divided into three columns, ordered, rec'd, and balance.  The ordered column is the quantity field from Order Entry.  The rec'd column is the amount of the component moved from its normal program location to the finished good by way of invoicing the order.  The balance is the difference between ordered and rec'd.

 

Component.  This section is also divided into three columns, alloc (allocated), used, and balance.  The allocated is the amount of the component needed to fulfill the order quantity in Order Entry.  The used is the amount of the component moved to the finished good.  The balance is the difference between the allocated and the used.