Bill Material and Work Order Processing BMWIPSCN Help - Elliott Business Software



WIP 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

 

 

 

 

                                                                 W I P   S U M M A R Y   R E P O R T                                                                 Loc: All

 

Range:  All Orders

        All Items

        All Product Categories

 

 Order# Lc Item-No         Item-Description              Complete-Qty      Start@    Age Outstanding    Mtrl-WIP Dir-Lab-WIP Shr-Lab-WIP  Burden-WIP   Other-WIP   Total-WIP

                                                            Scrap-Qty                            Qty

 

 

 

O000109 LA PC-386          386 Personal Computer                  .00      09/20/10    8        1.00      997.65                                                      997.65

                           Customize During Order Entry

 

O000129 LA FLANGE          Flange w/ 6 holes                      .00      09/20/10    8        1.00      212.00                                                      212.00

 

P200064 LA DRIVE-SHAFT     Universal Joint Drive Shaft            .00      09/13/10   15       10.00    3,994.20      129.64        0.00        4.28        0.00    4,128.12

 

P200071 LA FLANGE          Flange w/ 6 holes                      .00      09/22/10    6        2.00      472.00       40.00        0.00        0.42        0.00      512.42

 

 

                                             Grand Total:                                      14.00    5,675.85      169.64        0.00        4.70        0.00    5,850.19

  4 Orders Printed

 

 

 

 

 (Figure 60) WIP Detail Report

 


WIP Variance Report

Application Overview

The WIP Variance Report prints out the WIP Variance Amount, Standard Cost Variance Amount and Scrap Amount for each production transaction.  The transactions are posted through the Post Production Transactions program to create these variance amounts.

 

During the production, Work-In-Process amounts may accumulate due to material, labor, burden or outside process costs put into a work order.  Once the work order is complete, the WIP amount becomes the production cost of the parent item.  The system will create G/L distributions for both the WIP Account and the Finished Goods Account.  If the system is unable to distribute the amount left in the WIP Account to the Finished Goods Account, WIP Variance amount occurs.  These situations occur when:

  • Reporting zero quantity in the last operation to complete a Plus Work Order that contains a WIP amount will distribute the amount to the WIP Variance Account.
  • If a Plus Work Order is a disassembly order, where the order quantity is negative, the production cost not related to material is distributed to the WIP Variance Account instead of the Finished Goods Account or the Inventory Account of the component.  The variance between the sum of the material cost and parent item cost is distributed to the WIP Variance Account as well, instead of Standard Cost Variance Account.

Only Legacy and Plus Work Orders can have a WIP Variance Amount.

 

Standard Cost Variance amount may be present if Standard Cost is used as the Inventory Cost Method.  Legacy, Material and Plus Work Orders will have this amount when the production cost differs from the standard cost.

 

Scrap amount will be present only for Plus Work Orders.  This feature needs to be set by changing BOMP Global Setup field 44, Report Scrap to a Separate Account, to “Y” and set a valid scrap account in field 45, WO+ Scrap Account.  Any piece scrapped during production will have the production cost distribute to the Scrap Account.  The system only calculates a scrap amount when posting a transaction for the last operation, therefore you will only find a scrap amount in the Y Count Point transaction.

 

If a production transaction creates G/L distribution records for any variance account, the amount will be stored in transaction history and will be printed on this report if selected.  The report can select transaction history records by a range of transaction dates, locations, order numbers, parent item numbers and product categories.


Run Instructions

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

 

 

(Figure 61) WIP Variance Report Entry Screen

 

Entry Field Descriptions

Name

Type and Description

Starting Trx Date

A standard date format.

 

Enter the starting date of a range of transactions to print.

 

Defaults to All.

Ending Trx Date

A standard date format.

 

Enter the ending date of a range of transactions to print.

 

Defaults to the starting date.

Location

2 alphanumeric characters.

 

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

 

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.

 

 

 

 

(Figure 62) WIP Variance Report Entry Screen

 

 

 

 

                                    W O R K   I N   P R O C E S S   V A R I A C E   R E P O R T                             Loc: All

 

Ranges: All Dates

Range:  All Orders

        All Items

        All Product Categories

 

 Order# Lc Item-No           Qty-Ordered  Opr# T ID   WC     Dept     Qty-Complete Prd-Unt-Cst   Mtrl-Amnt WIP-Variance WIP-Var/Qty

  TRX-Date Description                    Description                 Qty-Scrapped Std-Unt-Cst  Labor-Amnt Std-Cost-Var     SCV/Qty

 CP Job-No                                                                 Scrap-%             Burden-Amnt  Scrap-Amnt

                                                                                                Other-Amnt

 

O000131 LA FLANGE                   2.00                                     1.00      80.0000

  09/28/10 Flange w/ 6 holes                                                           80.0000                  172.00     172.0000

 

M100005 LA DRIVE-SHAFT             10.00                                     2.00     414.6500

  02/23/10 Universal Joint Drive Shaft                                                414.6500                  189.30-     94.6500-

 

P200026 LA FLANGE                  10.00- 0010 M PRE  WHS    GEN             5.00-                    0.00       20.01       4.0020-

  04/08/10 Flange w/ 6 holes              Material Preparation                .00                    20.00

                                                                                                       .01

 

P200040 LA FLANGE                  10.00  0030 P MIL  MIL    CNC             7.00      60.1814        0.00

  05/11/10 Flange w/ 6 holes              Milling                            3.00       7.5400        0.14      368.49      52.6414

  Y                                                                         30.00 %                  10.01

 

P200042 LA FLANGE                  10.00  0030 P MIL  MIL    CNC              .00       0.0000        0.00        2.10

  05/11/10 Flange w/ 6 holes              Milling                             .00       7.5400        0.00

  Y                                                                                                    .00

 

 

                                                                                       Grand WIP Variance:       22.11

                                                                                       Grand Std Cost Var:      351.19

  5 Transactions Printed

 

 

 

(Figure 63) WIP Variance Report



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile