25 Manufacturing Accounting Processing Options

This chapter contains these topics:

Section 25.1, "AAI Revisions (P40901),"
Section 25.2, "Generate and Print Work Orders (P31410),"
Section 25.3, "Work Order Inventory Issues (P31113),"
Section 25.4, "Component Scrap Transactions (P31116),"
Section 25.5, "Manufacturing WIP Journal Entries (P31802),"
Section 25.6, "Manufacturing Variance Journal Entries (P31804),"
Section 25.7, "Work Order Closing and Clear WIP (P31806),"
Section 25.8, "Manufacturing Accounting for Orderless Completion (P31862),"
Section 25.9, "PO/Receipt/Voucher Inquiry (P43260),"
Section 25.10, "Purchase Order/Receipt/Voucher Report (P43560),"
Section 25.11, "Gain/Loss Analysis Report (P415402),"
Section 25.12, "General Ledger Post (P09870),"
Section 25.13, "Item Ledger/Account Integrity (P41543)."
Section 25.14, "Manufacturing Work Order Entry - Z File (P48013Z)"

25.1 AAI Revisions (P40901)

Processing Option	Processing Options Requiring Further Description
DEFAULT INFORMATION:
1. Enter the default skip to AAI Number:

25.2 Generate and Print Work Orders (P31410)

Processing Option	Processing Options Requiring Further Description
GENERATION INFORMATION:
1A. Enter one of the following: 1 = Parts List only 2 = Routing only 3 = Both Parts List and Routing If left blank, neither parts list nor routing will be generated.	Note: If using Backflush to Work Center location in Manufacturing Constants, then routings must be attached first for commitments to be made correctly.
1B. Enter a '1' to prevent the update of existing parts list and routing instructions. Commitment and substitute processing of parts lists will occur as usual. If left blank, existing parts list and/or routing will be rewritten.	Note: If transactions have occurred against the order the parts list and routing should be protected from update.
2. Enter a '1' to use the W.O. Date for effectivity checking. If left blank, the W.O. Start Date is used.
UPDATE INFORMATION:
3. Enter the new Status Code for the work order/rate header. If left blank, status will not be changed.
WORK ORDER PRINT INFORMATION:
4. Enter a '1' to print work orders. If printing work orders:
PARTS LIST PRINT INFORMATION:
5. Enter a '1' to print Parts List
6. Enter a '1' to print the 2nd line of information, which is scrap and related work center.
7. Enter a '1' to print Parts List on a new page.
8. Enter the version of the Parts List program (P31415). If left blank, 'ZJDE0001' will be used.
9. Enter a '1' to print a consolidated Parts List.
ROUTING PRINT INFORMATION:
10. Enter a '1' to print the Routing.
11. Enter a '1' to print Routing on a new page.
12. Enter the version of the Routing Instructions program (P314151). If left blank, the operation sequence is used.
BACKSCHEDULING INFORMATION:
13. Enter the Unit of Measure for backscheduling.	Note: Hours is the standard unit of measure for backscheduling. If this option is left blank, backscheduling will not calculate correctly.
SHOP PACKET SUMMARY INFORMATION:
14a.Enter a '1' to print the Shop Packet Summary. 14b.Enter the version of the Shop Packet Summary program (P31416). If left blank, 'ZJDE0001' will be used.
SHORTAGE REPORT INFORMATION:
15. Enter the version of the Shortage Report program (P31418). If left blank, no shortage report will be printed.
BAR CODE INFORMATION:
16. Enter the version of the Bar Code Print program (P31413) for the desired print overrides.
INVENTORY ISSUE INFORMATION:
17. Enter the version of Batch Inventory Issues program (P31420). If left blank, Inventory Issues will not be called.
PURCHASE ORDER INFORMATION:
18. Enter the version of Write Purchase Orders program (P3420). If left blank, 'ZJDE0002' will be used.
SALES ORDER INFORMATION:
19. Enter the new Line Type for kit and configured components. This is used to avoid issuing inventory from Sales Order processing. The Line Type used should be inventory interface 'N'. If left blank, Line Type will not be changed.
20. Enter the Next Status for Sales Order kit and configured component lines. (This is used to bypass the normal flow of the order, i.e., Pick Slip.) If left blank, next status will not be changed.
21. Enter a '1' to delete the existing Work Order Text and copy the Sales Order Text to the Work Order. Enter a '2' to append the Sales Order Text to the end of the existing Work Order Text. If left blank (default) the Work Order Text will not be updated.
CONFIGURED ITEM COSTS:
22. Enter one of the following options for calculating the standard cost for configured items in the Production Cost File (F3102). 1 = Always calculate the standard cost 2 = Only calculate the standard cost if it has not already done (no variance records exist) If left blank, standard cost will not be calculated.
BOM SUBSTITUTES:
23. Enter '1' to allow the use of Bill of Material substitutes in case of a shortage.
PURCHASING JOURNAL ENTRIES:
24. Enter a '1' to load the Work Order Number into the Subledger field of the purchasing J/E's.
BLANKET/QUOTE PROCESSING:
25. Enter a '1' for automatic blanket order release processing.
BUILD AGAINST PRIOR REVISIONS:
26. Enter a '1' to permit building work orders against prior revision levels. The revision level in the work order header (F4801) will be used to select the parts list to attach to the work order. If left blank, prior revision level bills will not be selected.
WAREHOUSE PROCESSING:
27. Enter the request processing mode: 1 = Generate requests only 2 = Generate requests and process using the subsystem. If left blank, requests will not be generated.
28. If processing pick requests using the subsystem, enter the version of Process Pick Requests (P46171) to call. If left blank, 'XJDE0002' will be used.
29. Enter the default staging location for moving goods out of the warehouse.
30. Enter a '1' if the default staging location should be checked for availability. If the part is available at the staging location a request will NOT be generated. Note: This option only applies to parts with no work center locations.
GENERIC TEXT PRINT OPTIONS:
31. Enter a '1' to print the component's generic text on the Parts List.
32. Enter a '1' to print the operation's generic text on the Routing.
BAR CODE INFORMATION:
34. Enter the format for bar code printing. 1 = Code 3 of 9 (Code 39) 2 = Code 128 If left blank, bar codes will not print.
COMMITMENT PROCESSING:
35. Enter a '1' to bypass commitment processing when creating the Parts List. If left blank, commitments will be processed per Commitment Control in Manufacturing Constants (P3009).
QUALITY MANAGEMENT:
36. Enter '1' to print Manufacturing Specifications.
37. Enter the version of the Manufacturing Specifications print program to call (P37470). If left blank, 'ZJDE0001' will be used.
PHANTOM OPERATION SEQUENCE NUMBER:
38. Enter a '1' to default the phantom's (parent) operation sequence for the components on the parts list. If left blank, the component's operation sequence will be used.
WORK ORDER START DATE UPDATE:
39. Enter a '1' to update the Work order Start Date with the Start Date of the first routing operation for variable lead time. If left blank no updating will be performed
LOT EXPIRATION DATE:
40. Select the date that will be used to determine the eligibility of lot/ /serial numbered components. Only lots with effective dates less than or equal to the date specified AND expiration dates (based on the item's commitment date method) greater than or equal to the date specified will be considered. ' ' = Parts list required date (default) '1' = Work order start date '2' = Work order requested (completion) date
AUTOMATIC LOT NUMBER GENERATION:
41. Enter a '1' to automatically generate a lot number upon co/by products creation for items with a lot process type of 1 or 2.

25.3 Work Order Inventory Issues (P31113)

Processing Option	Processing Options Requiring Further Description
UPDATE INFORMATION:
1. Enter the Document Type associated with an inventory issue.
2. Enter the Status Code for update to the work order header. If left blank, the header will not be updated. Enter '*' to update according to Work Order Activity Rules.
3. Enter the default value for the Material Status Code. If left blank, material status will not be updated.
4. Enter the Status Code beyond which issues cannot be made.
INQUIRY INFORMATION:
5. Enter a '1' to display only valid Issue Type Codes. If left blank, all Parts List items will display.
6. Enter a '1' to preload all screen detail lines with the selection value to process the issue.
OPERATION SEQUENCE FIELD:
7. Enter a '1' to display operations that equal the entered Operation Sequence. If left blank, the value will be used as a 'Skip To' field.
REQUESTED DATE FIELD:
8. Enter a '1' to display operations that equal the entered Requested Date. If left blank, the value will be used as a 'Skip To' field.
EDIT INFORMATION:
9. Enter a '1' to give an error if the quantity on hand is negative.
ITEM SALES HISTORY INFORMATION:
10. Enter a '1' to update Item Sales History (F4115) file.
HOLD CODE TO ISSUE:
11. Enter the lot hold codes (up to 5) that are acceptable for inventory issues, or enter a '*' to allow issues to all held lots. If left blank, issues to held lots will not be allowed.
SHORTAGE MAINTENANCE:
12. Enter the version of Shortage Maintenance (P3118) to be called. If left blank, 'ZJDE0001' will be used.
UNPLANNED ISSUES:
13. Enter '1' to allow for unplanned issues.
14. Enter a '1' to default the Location and Lot from the Primary Location. If left blank, the user must specify a valid Location and Lot.
LOT NUMBER:
15. Enter '1' to protect the lot number from entry.
PROCUREMENT INFORMATION:
16. Enter the document type for purchase orders. (Default is 'OP')
17. Enter the version of the Open Inquiry Window program (P3160W) to use. If left blank, 'ZJDE0001' will be used.
18. Enter the default route type to be used to search for a receipt route. (Default is 'OT')
RECEIPT ROUTINGS:
19. Enter the value of the default route to be used for items without a receipt routing.
20. Enter the version of Receipt by PO/Item/Account (P4312) to call. If left blank, 'ZJDE0008' will be used.
MOVE AND DISPOSITION:
21. Enter the version of Move and Disposition (P43250) to call. If left blank, 'ZJDE0002' will be used.
FOR STANDARD COSTING:
22. Enter a '1' to use the cost from F4105 for manufacturing accounting. If left blank, use cost from F30026 for manufacturing accounting.
OPTION TO CLOSE A LINE:
23. Enter a '1' to prevent closing a line (option 9) with issued quantities. If left blank closing any line will be allowed.
FOR ACTUAL COSTING:
24. Enter a '1' to provide a warning message when any component unit cost does not exist or is less than or equal to zero. Enter a '2' to provide a hard error message. If left blank, the component unit cost is not checked for the component items.

25.4 Component Scrap Transactions (P31116)

Processing Option	Processing Options Requiring Further Description
DEFAULT FORMAT:
1. Enter a '1' for Item Number entry. If left blank, Work Order Number entry will be used.
DEFAULT VALUES:
2. Enter the Item Ledger Transaction date. If left blank, the system date will be used.
3. Reason Code (Optional)
4. Enter the Document Type associated with the Component Scrap Transaction.
SERIAL NUMBER PROCESSING:
5. Enter the Document Type to use for Serial Number Issues. If left blank, 'IM' will be used.

25.5 Manufacturing WIP Journal Entries (P31802)

Processing Option	Processing Options Requiring Further Description
PROCESSING CONTROL:
1. Enter the G/L Date. If left blank, the system date will be used.
2. Enter a '1' to create journal entries. If left blank, Proof mode is assumed.
JOURNAL ENTRY SUMMARIZATION:
3. Enter a '1' to summarize Material Issues by Account within a document.
4. Enter a '1' to summarize by Account ACROSS documents. WARNING: This option will reduce the number of journal entries.	NOTE: If you summarize ACROSS work orders you cannot activate processing option 9 to default the Work Order Number into the Subledger field
REPORT OPTIONS:
5. Enter a '1' to print an Accounting Journal.
6. Enter a '1' to print subtotals by Document Type and Document.
REPORT SUMMARIZATION:
7. Enter a '1' to summarize Material Issues within a document.
8. Enter a '1' to summarize by Account ACROSS documents. Caution: This option will reduce the report output.	NOTE: If you summarize ACROSS work orders you cannot activate processing option 9 to default the Work Order Number into the Subledger field.
SUBLEDGER/WORK ORDER NUMBER:
9. Enter a '1' to default the document number into the Subledger field.
WORK ORDER STATUS CHANGE:
10. Enter the new Status Code for the document. If left blank, the status will not be changed.
ADDITIONAL WORK ORDER TYPES:
11. Enter the Document Type associated with Inventory Scrap.
12. Enter the Document Type to default for Shop Floor Activity. NOTE: This will only be used if no Document Type exists in the Routing file (F3112).
ISSUES OF MATERIAL:
13. Enter a '1' to use the Charge to Business Unit for the Credit Side of IM Transactions. If left blank, Component Branch/Plant is used.
CARDEX USER-ID UPDATE:
14. Enter a '1' to update the User ID in the Cardex File (F4111). If left blank, the User ID will not be changed.
CARDEX USER-ID UPDATE:
14. Enter a '1' to update the following transaction information in the Item Ledger File (F4111): Trans. Date, Creation Date, Time of Day, User ID, Work Station ID, and Program ID. If left blank, these fields will not be updated.
FLEX ACCOUNTING:
15. Enter '1' to use flex accounting. If left blank, flex accounting will not be used.
JOURNAL ENTRIES BY WORK CENTER
16. Enter a '1' to write accrual journal entries by Work Center. If left blank, accrual journal entries will not be written by Work Center.

25.6 Manufacturing Variance Journal Entries (P31804)

Processing Option	Processing Options Requiring Further Description
PROCESSING CONTROL:
1. Enter the G/L date. If left blank, the system date will be used.
JOURNAL ENTRY SELECTIONS:
2. Enter '1' to create journal entries. If left blank, program will run in Proof mode and no journal entries will be created.
3. Enter '1' to summarize by account ACROSS documents. WARNING: This option will reduce the number of journal entries.
REPORT SELECTIONS:
4. Enter '1' to print an accounting journal.
5. Enter '1' to print subtotals by document.
6. Enter '1' to summarize by account ACROSS documents. WARNING: This option will reduce the report output.
SUBLEDGER/WORK ORDER NUMBER:
7. Enter '1' to default the Document Number into the Subledger field (not recommended if processing options 3 or 6 are selected).
DOCUMENT TYPE:
8. Enter the Document Type associated with manufacturing variances.
WORK ORDER STATUS CHANGE:
9. Enter the new status code for the document. If left blank, the status will not be updated. Enter '*' to update according to Work Order Activity Rules.
OVER/UNDER COMPLETIONS
10. Enter '1' to re-state the standard, current, and planned production costs based on completed + scrapped quantity. Note: This will eliminate the 'Other' type variance caused by the over/under completion. The use of PROOF mode is recommended, to avoid unexpected updates to Production Cost File (F3102).
CLOSED ORDER STATUS
11. Enter the status beyond which documents should not be allowed to have additional activity. If left blank, '99' will be used. When the value specified here is less than or equal to the status specified in processing option 9, the variance flag (PPFG) will be updated to closed (3).
FLEX ACCOUNTING:
12. Enter '1' to use flex accounting. If left blank, flex accounting will not be used.

25.7 Work Order Closing and Clear WIP (P31806)

Processing Option	Processing Options Requiring Further Description
1. Enter the G/L Date. If left blank, the current date will be used.
JOURNAL ENTRY SELECTIONS:
2. Enter a '1' to create journal entries. If left blank, 'Proof' mode is assumed.
3. Enter a '1' to summarize by Account ACROSS work orders. WARNING: This option will reduce the number of journal entries. See Helps.	NOTE: If you summarize ACROSS work orders you cannot activate processing option 7 to default the Work Order Number into the Subledger field.
REPORT SELECTIONS:
4. Enter a '1' to print an Accounting Journal.
5. Enter a '1' to print subtotals by Document.
6. Enter a '1' to summarize by Account ACROSS work orders. WARNING: This option will reduce the report output. See Helps.	NOTE: If you summarize ACROSS work orders you cannot activate processing option 7 to default the Work Order Number into the Subledger field.
7. Enter a '1' to default the Work Order Number into the Subledger field.
8. Enter the Document Type for Completion. If left blank, 'IC' will be used.
9. Enter the Document Type for Scrap. If left blank, 'IS' will be used.
10. Enter the new Status Code for the Work Order. If left blank, the status will not be changed.

25.8 Manufacturing Accounting for Orderless Completion (P31862)

Processing Option	Processing Options Requiring Further Description
1. Enter the G/L date. If left blank, the current date will be used.
2. Enter a '1' to create journal entries. If left blank, 'Proof' mode is assumed.
JOURNAL ENTRY SUMMARIZATION:
3. Enter a '1' to summarize Material Issues by Account within a document.
4. Enter a '1' to summarize by Account ACROSS documents. WARNING: This option will reduce the number of journal entries. See Helps.
REPORT OPTIONS:
5. Enter a '1' to print an Accounting Journal.
6. Enter a '1' to print subtotals by Document Type and Document.
REPORT SUMMARIZATION:
7. Enter a '1' to summarize Material Issues within a document.
8. Enter a '1' to summarize by Account ACROSS documents. WARNING: This option will reduce the report output. See Helps.
DOCUMENT TYPES:
9. Enter the Document Type associated with Inventory Issues.
10. Enter the Document Type associated with Orderless Shop Floor Activity.
11. Enter the Document Type associated with Inventory Completions.
12. Enter the Document Type associated with Inventory Scrap.
13. Enter the Document Type associated Accounting Variances.
FLEX ACCOUNTING:
14. Enter '1' to use flex accounting. If left blank, flex accounting will not be used.

25.9 PO/Receipt/Voucher Inquiry (P43260)

Processing Option	Processing Options Requiring Further Description
DEFAULT VALUES:
1. Order Type (Required)
DISPLAY OPTIONS:
2. Enter '1' to display all G/L transactions generated by individual steps in the Receipt Route. If left blank, only the final G/L transaction generated from the Receipt Route will be displayed.
3. Enter '1' to display all Landed Cost transactions lines. If left blank, no landed cost transactions will be displayed.
DREAM WRITER VERSIONS: Enter the version for each program.
4. Order Inquiry (P43030W)
5. Review Unmatched Receipts (P43214W)
6. Purchase Order Detail (P4311)
7. Receipt Routing Inquiry (P43252)
8. Open Order Inquiry (P430301)
9. Voucher Match (P4314)
10. Work Order Maintenance (P48013)

25.10 Purchase Order/Receipt/Voucher Report (P43560)

Processing Option	Processing Options Requiring Further Description
1. Enter '1' to display all G/L transactions generated by individual steps in the Receipt Route. If left blank, only the final G/L transaction generated from the Receipt Route will be displayed.
2. Enter '1' to display all Landed Cost transactions lines. If left blank, no landed cost transactions will be displayed.
3. Enter currency mode (D/F) If left blank, the default is 'D'

25.11 Gain/Loss Analysis Report (P415402)

Processing Option	Processing Options Requiring Further Description
1. Enter the range of transaction dates for inclusion of records. (Blanks will default to system date) From Date Thru Date
2. Enter the relation to use for the variance selection. GT = greater than LT = less than EQ = equal to
3. Enter the quantity to compare the variance to for selection.
4. Enter one of the following: A = compare the volume difference % = compare the percent variance

25.12 General Ledger Post (P09870)

Processing Option	Processing Options Requiring Further Description
BATCH SELECTION:
1. Enter Batch Number or Batch Date or Batch User ID
PRINT SELECTION:
2. Identify how to print amount fields on Post Journal: '1' = to Millions (w/ commas) '2' = to Billions (w/o commas) Blank (Default) = No Journal Printed.
3. Identify which account number to print on report: '1' = Account Number '2' = Short Account ID '3' = Unstructured Account '4' = (Default) Number Entered During Input
FIXED ASSETS:
4. Enter a '1' to post F/A entries to Fixed Assets. Note: DREAM Writer version ZJDE0001 of Post G/L Entries to Assets (P12800) is executed when this option is selected. All transactions selected from that DREAM Writer will be posted rather than just the current entries being posted to G/L.
5. Enter a 'Y' if you wish to explode parent item time down to the assembly component level. Component billing rates will be used. (This applies to batch type 'T' only.)
CASH BASIS ACCOUNTING:
6. Enter a '1' to create and post Cash Basis accounting entries. (Applies to batch type G, K, M, W, & R only.)
7. Enter units ledger type for Cash Basis Accounting entries. (Default of blank will use "ZU" ledger type.)
ACCOUNTING FOR 52 PERIODS:
8. Enter a '1' for 52 Period Post. Note: DREAM Writer data selection is used for 52 period posting ONLY. It is NOT used for the standard post to the F0902. Additionally, 52 period date patterns must be set up.
TAX FILE UPDATE:
9. Identify when to update the Tax Work file (F0018): '1' = V.A.T. or Use Tax only '2' = for All Tax Amounts '3' = for All Tax Explanation Codes Blank (Default) = No Update to File Note: When using Vertex Taxes the Vertex Tax Register file will be updated instead of the Tax Work file for methods '1', '2', and '3'.
10. Adjust VAT Account for Cash Receipt Adjustments and Write Offs. Tax explanation must be a 'V'. '1' = update VAT amount only '2' = update VAT amount, extended price and taxable amount
11. Adjust VAT Account for Discount Taken. The Tax Rules file must be set to Calculate Tax on Gross Amount, including Discount and Calculate Discount on Gross Amount, including Tax. Tax explanation must be a 'V'. '1' = update VAT amount only '2' = update VAT amount, extended price and taxable amount
PROPERTY MANAGEMENT:
12. Enter DREAM Writer version of Property Management G/L Transaction Creation to be executed. Default is version ZJDE0001. (This applies to batch types '2' and '/'.)
UPDATE OPTION:
13. Enter '1' to update short ID number, company, fiscal year/period number, century, and fiscal quarter in unposted transaction records selected for posting. (May be required for custom input programs.)
REPORT FORMAT:
14. Enter a '1' to print the Posting Journal in a 198 character format. The default of blank will print the format with 132 characters.
DETAILED CURRENCY RESTATEMENT:
15. Enter a '1' to create currency restatement entries. This creates records in the XA, YA, and/or ZA ledgers depending on the version you are running.
16. Enter the version of the Detailed Currency Restatement (P11411) to execute. Default of blank will execute ZJDE0001.
RECONCILIATION FILE PROCESSING:
17. Enter a '1' to update the Cross-Environment Reconciliation file. Blank will not update the reconciliation file. Note: The Cross-Environment Reconciliation file can also be updated through the stand-alone Cross-Environment File Creation program.
REVERSING JOURNAL ENTRIES:
18. When normal number of periods = 12 or 13 and posting a reversing entry into period 12 or 13, enter a '1' to create reversing journal entries to the first period of the following year. This is to avoid posting reversing entries to an adjusting period. Example: Normal number of periods = 12. Period 12 ends 12/30/xx and period 13 ends 12/31/xx. Journal Entry date of 12/30/xx will post reversing entry to period 01 of next year if processing option is set to '1'.
BATCH TYPE SELECTION: Note: This option should NOT be changed by User.

25.13 Item Ledger/Account Integrity (P41543)

Processing Option	Processing Options Requiring Further Description
REPORT DISPLAY:
1. Enter the beginning Item Ledger date.
2. Enter the ending Item Ledger date.
SUMMARIZED MANUFACTURING J/E's:
3. Enter a '1' to indicate that Manufacturing J/E's are summarized by account.
Enter Document Types associated with:
4. Inventory Issues
5. Inventory Completions
6. Parent Scrap
LOAD AND DELIVERY DOCUMENT TYPE:
7. Enter the Load and Delivery document type. (This should be same value as used in the Load and Delivery Transaction Server XT49799 document type.) 'CT' is the default.
DIRECT SHIP LINE TYPE:
8. Enter the Line Type for Direct Ship Sales Order lines. If left blank, there will not be a check for direct ship lines.

25.14 Manufacturing Work Order Entry - Z File (P48013Z)

Processing Option	Processing Options Requiring Further Description
DREAM WRITER VERSIONS:
1. Enter the version to be used to call Work Order Master (P48013). If left blank, ZJDE0001 will be used.
ERROR REPORTING:
1. Enter '1' to skip printing the error report. If left blanks, the report will print.
2. Enter the version to be used to call the error report program (P41ZERR). If left blank, XJDE0011 will be used.