This chapter contains these topics:
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROCESSING DATE: | |
| 1. Enter the G/L Date to execute.
Default of blank will use the current date. (The period to process will be determined by this date.) |
|
| DREAMWRITER VERSION ID: | |
| 2. Enter the DREAM Writer Version ID to determine the company selection from the Item/Pool Valuation Master File (DREAM Writer Form ID P391201):
Default = XJDE0001 (NOTE: This DREAM Writer Version controls company selection ONLY. If Item or Pool ID is selected, it will be ignored.) |
|
| RESTART OPTION: | |
| 3. Enter a '1' to restart the extraction for the period clearing any calculated allocations that already exist in the layer file.
Enter a '2' to restart the extraction for the period clearing the period file, layers file and document summary file for the period and pulling in transactions from the prior execution. Default of blank will not perform any restart operations. |
Blank, 1, and 2 are the only valid values.
Only one version is necessary, as all data sequencing is the same. |
| USER DEFINED CODES: | |
| 4. List the User Defined Code containing the document types for the following:
Incoming Transactions: System Code Record Type Outgoing Transactions: System Code Record Type Document Types to repress error message - "Doc Type not incoming or outgoing": System Code Record Type |
|
| 5. Enter the version of the Item/Pool Error Report to use.
(DREAM Writer Form ID X391214): Default = ZJDE0001 This processing option will only affect Replacement/Current Cost valuation methods. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| REPORT OVERRIDES: | |
| 1. Enter the first Fiscal Period you want to print on the report.
Blank will default to current fiscal period for the company. |
|
| 2. Enter the Fiscal Year of the first period you want to print on the report.
Default of blank will use the current fiscal year for the company. |
|
| 3. Enter a '1' if you would like to print the report displaying Average Unit Cost for Closing Inventory.
If left blank the report will display Average Unit Cost for Incoming Transactions. |
|
| 4. Enter a '1' to include dual currency amounts on report.
Default of blank will not include dual currency amounts on report. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| G/L UPDATE METHOD: | |
| 1. Enter a '1' to print the report using the G/L Update Valuation Method for each Item/Item Pool.
Default of blank will print all valuation methods. |
|
| 2. Enter a '1' to also print the period incoming and period outgoing on the report along with the Year to date quantities and amounts for LIFO valuation methods.
Default of blank will not print the period incoming and period outgoing quantity and amount. |
|
| 3. Enter a '1' to include dual currency amounts on report.
Default of blank will not include dual currency amounts on report. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROOF OR FINAL: | |
| 1. Enter a '1' to execute in update mode which will create journal entries and set the update flag on the period detail record.
Default of blank will execute in PROOF mode (no update will occur). |
|
| G/L JOURNAL ENTRY OPTIONS: | |
| 2. G/L date
(Default = current) |
|
| 3. Document Type
(Default = JE) |
|
| 4. Enter '1' to summarize entries by account
(Default = detail entries) |
|
| G/L JOURNAL ENTRY SERVER: | |
| 5. Enter the version ID to use for the G/L Journal Entry Server program (XT0911Z1).
Default = ZJDE0001 |
|
| YEAR-END PROCESSING: | |
| 6. Enter a '1' to roll up remaining FIFO layers for year-end processing. | Year End Processing: Except for FIFO valuations, the system always rolls up all layers at the end of the year into a single layer for the opening balance for the next year.
If you want the FIFO valuation to remain, leave this option blank. If you want the FIFO valuations to roll up into one layer, enter 1 in this option. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| Enter the version for each program:
If left blank, ZJDE0001 will be used. |
|
| 1. Valuation Period Review (P39051) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| Enter the version for each program:
If left blank, ZJDE0001 will be used. |
|
| 1. Document Summary Review (P3906) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| Enter the version for each program:
If left blank, ZJDE0001 will be used. |
|
| 1. Valuation Period Review (P39051) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| Enter the version for each program:
If left blank, ZJDE0001 will be used. |
|
| 1. Item Ledger (P4111) | |
| 2. Item Pool Inquiry (P39001) |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROCESSING DATE: | |
| 1. Enter the G/L Date to execute.
Default of blank will use the current date. (The period to process will be determined by this date.) |
|
| DREAMWRITER VERSION ID: | |
| 2. Enter the DREAM Writer Version ID to determine the company selection from the Item/Pool Valuation Master File (DREAM Writer Form ID P391201):
Default = XJDE0001 (NOTE: This DREAM Writer Version controls company selection ONLY. If Item or Pool ID is selected, it will be ignored.) |
|
| RESTART OPTION: | |
| 3. Enter a '1' to restart the extraction for the period clearing any calculated allocations that already exist in the layer file.
Enter a '2' to restart the extraction for the period clearing the period file, layers file and document summary file for the period and pulling in transactions from the prior execution. Default of blank will not perform any restart operations. |
Blank, 1, and 2 are the only valid values.
Only one version is necessary, as all data sequencing is the same. |
| USER DEFINED CODES: | |
| 4. List the User Defined Code containing the document types for the following:
Incoming Transactions: System Code Record Type Outgoing Transactions: System Code Record Type Document Types to repress error message - "Doc Type not incoming or outgoing": System Code Record Type |
|
| 5. Enter the version of the Item/Pool Error Report to use.
(DREAM Writer Form ID X391214): Default = ZJDE0001 This processing option will only affect Replacement/Current Cost valuation methods. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. Enter a '1' to include dual currency amounts on report.
Default of blank will not include dual currency amounts on report. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. Enter a '1' to include dual currency amounts on report.
Default of blank will not include dual currency amounts on report. |
| 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. |