Work Order Plus Management Manual 8

B/M Distribution Report

Application Overview

Prior to Elliott 7.5, distribution were created in the I/M Distribution To G/L File when BOMP production transactions were posted.  Elliott 7.5 adds B/M Distribution To G/L File for all Legacy, Material and Plus Work Order distributions.  The B/M Distribution Report prints the information from this file to verify exactly which accounts were updated and the amounts posted.

Run Instructions

Main Menu è Distribution è Bill of Material Processor è Reports è B/M Distribution Report

 

(Figure 55) B/M Distribution Report Entry Screen

Entry Field Descriptions

Name

Type and Description

1.  Purge File ?

Y or N.

Do not purge if you interface with the General Ledger package.

Defaults to N.

2.  Period Starting Date

A date in the standard date format.

Enter the beginning date of the period to print on the report.

Defaults to EARLIEST.


 

3.  Period Ending Date

A date in the standard date format.

Enter the ending date of the period to print on the report.

Defaults to the starting date.  If the starting date is EARLIEST, the defaults will be the current date.

4. Starting Account

An account in standard account format 

Enter the starting account number of the range of accounts to print on the report. Press the F7 Key to search for an account by account number.  Press the F8 Key to search for an account by account description.

Defaults to All.

5. Ending Account

An account in standard account format.

Enter the ending account number of the range of accounts to print on the report. Press the F7 Key to search for an account by account number.  Press the F8 Key to search for an account by account description.

Defaults  to the starting account number.

6. Starting Product Cat

3 alphanumeric characters.

Enter the starting product category of the range of parent items to print on the report. Press the F1 Key for parent items that have no product category.  Press the F7 Key to search existing production categories.

Defaults to All.

7. Ending Product Cat

3 alphanumeric characters.

Enter the ending product category of the range of parent items to print on the report. Press the F1 Key for parent items that have no product category.  Press the F7 Key to search existing production categories.

Defaults to the starting product category.

8. Starting Product No

15 alphanumeric characters.

Enter the starting item number of a range of parent items to print on the report. Press the F7 Key to search for an item by item number.  Press the F8 Key to search for an item by item description.

Defaults to All.

9. Ending Product No

15 alphanumeric characters.

Enter the ending item number of a range of parent items to print on the report.  Press the F7 Key to search for an item by item number.  Press the F8 Key to search for an item by item description. 

Defaults to the starting product number.


 

10. Customer No

6 alphanumeric characters.

Enter a customer number and work order distributions for the customer that have been copied from COP will be printed.  Press the F1 Key to select work orders not copied from COP.  Press the F7 Key to search for a customer by customer number.  Press the F8 Key to search for a customer by customer name.

Defaults to All.

11. Job No

6 alphanumeric characters.

Enter the job number for distributions to print.  Press the F1 Key to print distributions without a job number.  Press the F7 Key to search for a Job Number if the BOMP module uses job numbers 

Defaults to All.

12. Order Type

1 alphanumeric character.

Valid entries are:

Space    - All

O           - Legacy Work Order

M           - Material Work Order

P           - Plus Work Order

Enter the type of orders to include on the report.

Defaults to All.

13. Starting Order No

6 numeric digits.

Enter starting work order number for a range of work orders to print on the report.

Defaults to All.

14. Ending Order No

6 numeric digits.

Enter ending work order number for a range of work orders to print on the report.

Defaults to the starting order number.

15. Print Dist Type

1 alphanumeric character.

Valid entries are:

1 for Labor absorb, 2 for Material usage, 3 for Outside process absorb, 5 for Burden absorb, 6 for Inc-WIP, 7 Dec-WIP, 8 for Finish good or Cost of good sold.

Enter up to four distribution types to print on the report.

Defaults to All.

16.  Detail Or Summary ?

1 alphabetic character.

Enter D to print the full detail of every distribution.  Enter S and all transactions for a single date for an account will be summarized and print on one line.

Defaults to D.

 



(Figure 56) B/M Distribution Report Entry Screen

 


(Figure 57) B/M Distribution Report

 


WIP Report

Application Overview

After production has started and before work orders are closed, the WIP Account may contain an amount.  This WIP Report will print all unfinished work orders and their WIP amount.

 

The summary format prints one line per work order and the detail format prints the WIP amount at the operation level for each work order.  You can print the outside WIP amount, the inside WIP amount or both.

 

Parts sent outside the company for processing will distribute to the outside WIP amount.  This report can separate outside and inside WIP amounts. The system calculates outside pieces based on unfinished productions with outside process operations.  Unfinished productions have been started, but not yet reported.  They are also called Open Productions in WO+.

 

The WIP Report supports both Legacy Work Orders and Plus Work Orders.  Material Work Orders are excluded because they have no WIP.

 

Printing a legacy work order in detail format will list all components of a selected work order.  The component WIP amount total may vary from the actual WIP amount of the order since the WIP amount of a component is based on current unit cost.  The unit cost can vary from when the WIP amount occurs.  This can happen if Average or Last Cost is used as the Inventory Cost Method, or if Standard Cost is used and the standard cost of the component is changed.

Run Instructions

Main Menu è Distribution è Bill of Material Processor è Reports è Work in Process Report è Print è WIP Report

 

(Figure 58) WIP Detail Report Entry Screen

Entry Field Descriptions

Name

Type and Description

Location

2 alphanumeric characters.

Enter the location of work orders to print on the report.  The field supports a wildcard format.

Defaults to All.

Order Type

1 alphanumeric character 

Valid entries are:

Space   - All

O           - Legacy Work Order only

P           - Plus Work Order only

Enter the type of work order to print on the report.

Defaults to All.

Starting Order No

6 numeric digits.

Enter the starting order number of a range of orders to print on the report.

Defaults to All.

Ending Order No

6 numeric digits

Enter the ending order number of a range of orders to print on the report.

Defaults to the starting order number.

Starting Item No

15 alphanumeric characters

Enter the starting item number of a range of parent items to print on the report. Press the F7 Key to search for an item by item number.  Press the F8 Key to search for an item by description.

Defaults to All.

Ending Item No

15 alphanumeric characters.

Enter the ending item number of a range of parent items to print on the report.  Press the F7 Key to search for an item by item number.  Press the F8 Key to search for an item by description.

Defaults to the starting item number.

Starting Prod Cat

3 alphanumeric characters.

Enter the starting product category of a range of parent items to print on the report. Press the F7 Key to search for a product category.

Defaults to All.

Ending Prod Cat

3 alphanumeric characters 

Enter the ending production category of a range of parent items to print on the report.  Press the F7 Key to search for a product category.

Defaults to the starting product category.

Print Format

1 alphanumeric character.

Valid entries are:

D      - Detail format.  Includes routing and components.

S      - Summary format.  One order per line.

Enter the format you want to print for the report.

Defaults to S.

Print Currently Outside or Inside

1 alphanumeric character.

Valid entries are:

B      - Both Outside and Inside WIP.

S      - Print Outside and Inside WIP separately.  Only available if Print Format is S.

O      - Outside WIP only.

I       - Inside WIP only.

Enter the WIP amount type to print.

Defaults to B.

 

(Figure 59) WIP Detail Report Entry Screen


 


(Figure 60) WIP Detail Report

 

Feedback and Knowledge Base