Accounting Cost Generation - Calculations

A.   Housekeeping

1.   See the Common Processing Routines - Housekeeping section of this manual for a general discussion of this subroutine.  Processing specific to this program is described below.

2.   Key lists are defined for each file retrieved by the program.

3.   Work fields are defined and program constants are initialized.

4.   The system time is saved for printing on reports.

5.   The default Company Name is retrieved from the entity name record Reference File category 002 .  If this record is not found, a default message is used, and processing continues.

6.   The Manufacturing Company Name is retrieved from the entity name record (Reference File category 002).  If this record is not found, a default message is used, and processing continues.

7.   The Date Format is retrieved from Reference File category 049.  If none is found or an error occurs the date defaults to Month/Day/Year.

8.   A priming read is performed on the Accounting Cost Generation Requests file (IA310AP).  If no records are found, an error message is printed on the Accounting Cost Generation Request Exception report (IA100A), and processing is terminated.

B.   Mainline

1.   The Accounting Cost Generation Requests file (IA310AP) is read sequentially for all accounting cost generation requests.  Each request is validated as follows:

a.   The request is validated for correct request option.  Possible request options are:

b.   If the request contains a range option (option 2 or 5), the option is validated for proper range -- "to" part or workcenter number greater than "from" part or workcenter number.

c.   A selected parts (option 3), workcenters (option 6), or configuration codes (option 9) request is validated to ensure the selected part(s), workcenter(s), or configuration code(s) exist on the transaction files (IA300AP1 for selected parts, IA300AP2 for selected workcenters, and IA300AP3 for selected configuration codes).

d.   If the request is not valid for any of these reasons, an error message is written to the Accounting Cost Generation Request Exception report (IA100A) and processing continues with the next request.

2.   Based on the request option, the parts to be processed are determined.

a.   For a selected parts request (option 3), all records on the Accounting Cost Generation Part Transaction file (IA300AP1) that have the identical transaction ID, plant, post date and post time as the request record are processed.  After each matching record is processed, it is deleted from the transaction file.

b.   For a range of parts request (option 2), each part within the requested range is processed.

c.   For an all parts (option 1) or all parts and workcenters (option 7) request, all parts on the Part Master file (DE100M) are processed.

d.   For an all Configuration Costed Parts (option 8) request, all parts that are configuration costed (PMCFCO = 3 or 4) are processed.

e.   For a Selected Configuration Code (option 9) request, all records on the Accounting Cost Generation Configuration Code Transaction file (IA300AP3) that have an identical transaction ID, plant, part date, and post time as the request are processed.  After each matching record is processed, it is deleted form the transaction file.

f.    For an All New Configuration Costs (option 10) request, all records in the Configuration Code logical file (EC140ML6) are processed.

3.   For each part processed, its record is retrieved from the Part Master file (DE100M).  If the part is configuration costed (PMCFCO = 3 or 4), each of the part's configuration codes are processed.  Otherwise, the following calculations are performed:

a.   The Total Cost is calculated as the sum of all Standard Costs (labor, material and burden).

b.   The Material Cost is calculated as the Total Accounting Cost minus the labor and burden that are incurred at the parent part level, minus the Standard Miscellaneous Material Costs.  Thus, Accounting Material Cost will include any labor or burden costs associated with component parts.

c.   The Labor Cost is calculated as the Standard Labor Costs incurred at the parent part level minus the Standard Miscellaneous Labor costs.

d.   The Burden Cost is calculated as the Standard Burden Costs incurred at the parent part level minus the Standard Miscellaneous Burden Costs.

e.   The Miscellaneous Cost fields are updated by moving the Standard Miscellaneous Cost fields (material, labor, burden, fixed, and variable) to Accounting Miscellaneous Cost fields.

f.    The Standard Average Order Quantity is updated with the Average Order Quantity.

g.   The Saved Accounting Code is updated with the Accounting Code.

4.   The Part Master file (DE100M) is updated with the new values.

5.   For each Part Master file record processed, all corresponding part cost element records are updated, moving the standard cost to the Accounting Standard Cost field and the WIP accounting code is move to the saved WIP accounting code field.

6.   After a part is processed, all of its warehouse balance records on the Warehouse Balance file (IC140M) are read, processed and updated, according to the type of warehouse.

a.   For a manufacturing warehouse, no processing or updating is performed.

b.   For all other warehouses, the corresponding record is retrieved from the Warehouse Description file (IC170M) to retrieve the Warehouse Costing Option.

(1)  For a standard distribution warehouse, the Accounting Standard Unit Cost field on the warehouse balance record is updated with the Standard Unit Cost on the Warehouse Balance file (IC140M).  Also, the Accounting Acquisition Cost field is updated with the standard acquisition cost.  For each Warehouse Balance file record processed, all corresponding warehouse cost element records are updated, moving the standard cost to the Accounting Standard Cost field.

(2)  For a moving average warehouse, no further processing is performed.

7.   If a part is configuration costed (PMCFCO = 3 or 4) accounting costs of all associated configuration codes are updated.  Several miscellaneous accounting fields are also updated.

a.   The Accounting Total Cost is updated with the Standard Total Cost.

b.   The Accounting Material Cost is updated with the Standard Material Cost.

c.   The Accounting Labor Cost is updated with the Standard Labor Cost.

d.   The Accounting Overhead Cost is updated with the Standard Overhead Cost.

e.   The Accounting Miscellaneous Material Cost is updated with the Standard Miscellaneous Material Cost.

f.    The Accounting Miscellaneous Labor Cost is updated with the Standard Miscellaneous Labor Cost.

g.   The Accounting Miscellaneous Overhead Cost is updated with the Standard Miscellaneous Overhead Cost.

h.   The Accounting Miscellaneous Fixed Cost is updated with the Standard Miscellaneous Fixed Cost.

i.    The Accounting Miscellaneous Variable Cost is updated with the Standard Miscellaneous Variable Cost.

j.    The Accounting acquisition Cost is updated with the Standard Acquisition Cost.

k.   The Accounting Average Order Quantity is updated with the Standard Average Order Quantity

l.    The New Cost Flag is updated with No.

m.  The Accounting Generation Date is updated with today's date.

n.   The Accounting Generation Time is updated with the time stamp.

o.   The Last Maintenance Date is updated with the Accounting Generation Date.

p.   The Last Maintenance Time is updated with the Accounting Generation Time.

q.   The Last Maintenance Operator is updated with the User ID.

      Additionally, if the request was for all configuration costed parts, all calculations and processing for the parts is done after the configuration costs are updated.

8.   Based on the request option, the workcenters to be processed are determined.

a.   For a selected workcenters request (option 6), all records on the Accounting Cost Generation Workcenter Transactions file (IA300AP2) that have the identical transaction ID, post date and post time as the request are processed.  After each matching record is processed, it is deleted from the transaction file.

b.   For a range of workcenters request (option 5), all workcenters within the requested range are processed.

c.   For an all workcenters (option 4) or all parts and workcenters (option 7) request, all workcenters on the Workcenter file (ME100M) are processed.

9.   For each workcenter processed, its record is retrieved from the Workcenter file (ME100M) and the following calculations are performed:

a.   The Accounting Labor Rate is updated with the Standard Labor Rate.

b.   The Accounting Burden Rate is updated with the Standard Burden Rate.

10.  The Workcenter file (ME100M) is updated with the new values.

11.  For miscellaneous cost workcenters, the rate code and total miscellaneous cost fields are moved to the corresponding accounting fields and the Miscellaneous Cost Header file (ME160M1) is updated.  The detailed cost elements are moved and the detail file (ME160M2) is updated.

12.  For each Workcenter file record processed, all corresponding workcenter rate element records are updated, moving the standard rate to the Accounting Standard Rate field.

13.  After each request on the Accounting Cost Generation Requests file (IA310AP) is processed, it is deleted from the file, and the next request is retrieved and processed.  This continues until the end of the file has been reached.

14.  Any exceptions that occur while validating or processing a request on the Accounting Cost Generation Requests file (IA310AP) are captured and printed on the Accounting Cost Generation Request Exception report (IA100A).

IA100E Program Menu

• Purpose
• Calculations
• Files
• Reports