102 Invoice Processing - Processing Options

This chapter contains these topics:

Section 102.1, "Invoice Entry (P03105)"
Section 102.2, "A/R and A/P Journal Entries (P03101)"
Section 102.3, "Speed Invoice Entry (P031015)"
Section 102.4, "General Ledger Post (P09800)"
Section 102.5, "Invoice Journal Report (P03305)"
Section 102.6, "Customer Ledger Inquiry with SQL (P032002)"
Section 102.7, "Account Status Summary (P03203)"
Section 102.8, "Recycle Recurring Invoices (P038101)"
Section 102.9, "Rev Rec - Hierarchy/Date Setup - All (P0325)"
Section 102.10, "Revenue Recognition - Batch Recognition (P03502)"
Section 102.11, "Batch Invoice Add to Revenue Recognition (P03503)"
Section 102.12, "Remove Invoices from RR Process (P03504)"
Section 102.13, "Revenue Recognition Workbench (P03116) (Release A9.3 Update)"

102.1 Invoice Entry (P03105)

Processing Option	Processing Options Requiring Further Description
FIELD DISPLAY CONTROL:
1. You may activate certain capabilities by entering a '1' for the following: Sales/Use/VAT Tax Processing PO Number Entry Extra Date for Service/Tax Payment Instrument
TWO CYCLE OPTION:
2. Enter a '1' for 2 Cycle data entry.
FORMAT CONTROL:
3. Enter sequence numbers (1-6) to indicate which formats will appear and in what order when using the format selection function key. Standard - Net Due Date Standard - Discount Due Date Tax Amounts - Net Due Date Tax Amounts - Discount Due Date G/L Offset - Net Due Date G/L Offset - Discount Due Date
4. Enter a '1' to review the Invoice Category Codes with an Add or Change.
DREAM WRITER VERSIONS:
Enter the version for each program: If left blank, ZJDE0001 will be used.
5. A/R and A/P Journal Entries (P03101)
6. A/R Invoice Processing (XT0311Z1)
7. E-Mail (P012401)
8. Customer Ledger Inquiry (P032002)
9. Customer Master Revisions (P01053)
10. Category Code Window (P0311W)
FIELD PROTECTION CONTROL:
11. Enter a '1' to protect the Pay Status. If left blank, the Pay Status will be unprotected.
12. Enter a '1' to protect the Exchange Rate field. If left blank, the Exchange Rate will not be protected.

102.2 A/R and A/P Journal Entries (P03101)

Processing Option	Processing Options Requiring Further Description
DEFAULT PROCESSING:
1. Enter a '1' to disallow an exit out of balance and require that the ledger balances with the voucher or invoice amount. If left blank, an exit out of balance will be permitted through the use of a function key.
FORMAT CONTROL:
2. Enter the sequence numbers (1-7) to indicate the order in which formats will appear. If all are left blank they will appear in default order: Standard Journal Entries Journal Entries with Sub Ledger Journal Entries with Energy Info. Journal Entries with F/A Journal Entries with Units Journal Entries with Phase Code Journal Entries with Debit/Credit Note: This is used with the Format Selection function key.
FIELD DISPLAY CONTROL:
3. Enter a '1' to retain the G/L Date and Document Type on the screen between entries.
4. You may activate certain fields for entry by entering a '1' for the following: Home Business Unit Entry Document Pay Item Entry (on Debit/Credit screen format) Reference 1 Entry
5. Enter a '1' to display amounts to billions without commas. If left blank, amounts will be displayed to millions with commas.
FIXED ASSETS:
6. Enter a '1' to require the entry of an Asset ID if an account is in an AAI asset account range. If left blank, an Asset ID is not required.
DW VERSION FOR JOURNAL ENTRY PROCESSOR:
7. To override standard journal entry processing (DREAM Writer XT0911Z1, version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system wide set up.
EXCHANGE RATE:
8. Enter a '1' to protect the Exchange Rate field. If left blank, the Exchange Rate will not be protected.

102.3 Speed Invoice Entry (P031015)

Processing Option	Processing Options Requiring Further Description
FIELD DISPLAY CONTROL:
1. Select method for entry of sales credit (G/L distribution) amounts: ' ' = Credit amounts appear and are entered as negative numbers '1' = Credit amounts appear and are entered as positive numbers. For both methods, the amounts are stored negative in the A/R Ledger file (F0311).
2. Enter '1' to select the following capabilities of this program: Sales/Use/VAT Tax Processing PO Number Entry Extra Date for Service/Tax
TWO CYCLE OPTION:
3. Enter a '1' for 2 cycle data entry.
FORMAT CONTROL:
4. Enter sequence numbers (1-4) to indicate the order in which formats will appear. If all are left blank, all formats will appear in the following order: Standard Speed Invoice Entry Invoice Entry with Subledger Invoice Entry with F/A Number Invoice Entry with Units Note: This is used with the Format Selection function key.
5. Enter a '1' to review the Invoice Category Codes with an Add or Change.
DREAM WRITER VERSIONS:
Enter the version for each program: If left blank, ZJDE0001 will be used.
6. A/R Invoice Processing (XT0311Z1)
7. Journal Entry Processing (XT0911Z1)
8. Cust. Ledger Inquiry-w/SQL (P032002)
9. E-Mail (P012401)
10. Cust. Master Information (P01053)
11. Name Search (P01200)
12. Category Code Window (P0311W)
FIELD PROTECTION CONTROL:
13. Enter a '1' to protect the pay status field. If left blank, this field will be unprotected.
14. Enter a '1' to protect the Exchange Rate field. If left blank, the Exchange Rate field will not be protected.

102.4 General Ledger Post (P09800)

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.

102.5 Invoice Journal Report (P03305)

Processing Option	Processing Options Requiring Further Description
PRINT FORMAT CONTROL:
1. Enter a format to print: ' ' = 132 characters '1' = 198 characters, including tax amounts and Journal Entry remarks.
SUBHEADING CONTROL:
2. Enter a '1' to print the User ID from the Batch Header file (F0011) in the report subheading. If left blank, the User ID from the A/R Ledger file (F0311) will print.
ACCOUNT NUMBER DISPLAY MODE:
3. Enter the type of the account number to print on the Journal: ' ' = Number entered during input. '1' = Structured Account. '2' = Short Account ID. '3' = Unstructured Account.
ROUNDING FACTOR:
4. Enter desired rounding factor: ' ' = no rounding '0' = round to whole numbers '1' = divide by 10 '2' = divide by 100 '3' = divide by 1,000 '4' = divide by 10,000 '5' = divide by 100,000 Amounts will be rounded to the nearest whole number. Actual amounts are used to accumulate totals.
TAX PROCESSING:
5. Enter a '1' to use the Tax Workfile (F0018) to print the VAT Receivable amounts and also to balance A/R Ledger and General Ledger amounts with Use and VAT Taxes (for posted invoices). If left blank, only the tax amount from the A/R Ledger file (F0311) will be printed. Note: This option is only valid when option 1 is set to '1' (Print 198 character format).
TAX PROCESSING (CONT'D):
6. Enter a '1' to bypass out of balance errors on unposted invoices with non-recoverable tax. If left blank, errors will be processed.

102.6 Customer Ledger Inquiry with SQL (P032002)

Processing Option	Processing Options Requiring Further Description
FORMAT CONTROL:
1. Enter sequence of numbers (1-10) to indicate which formats will appear and in what order. If all are left blank, all formats will appear in the order shown: Due Date Customer Number Statement Number P.O. Number G/L Date Currency Code Disc Due Date Document Company Domestic/Foreign Large Amount Reference Note: Format controlled with format selection function key.
2. Enter a '1' to allow display and selection of the Payment Instrument.
3. Enter a '1' to suppress commas from amount fields.
DATE SEQUENCE:
4. If sequencing by Due Date, Invoice Date or G/L Date, enter a '1' to display dates in descending order, (latest to earliest date). If left blank, dates will display in ascending order.
INVOICE ENTRY MODE:
5. Enter a '1' to allow changes in Invoice Entry (Option 1). If left blank, Invoice Entry will be restricted to inquiry mode when accessed from this program.
DEFAULT SEQUENCE:
6. Enter the Default Sequence to be used if there is no default in the Address Book or Data Dictionary.
PRE-LOADED DATA SELECTIONS:
7. Any values entered in the following options will be loaded upon entry into the program: Sequence Paid Company Payment Inst. (*=All) Currency Code
ADDITIONAL PRE-LOADED SELECTIONS:
8. Any values entered in the following options will be loaded into the Additional Selections upon entry into the program. Alternate Payer G/L Class Code (*=All) - Include/Exclude (1) Document Type - Include/Exclude (1) Matching Doc Type - Include/Exclude (1) Consolidation Code
SQL OPTIONS:
9. Enter a '1' to only allow inquiries that are compatible with existing Logical Files. If left blank, SQL will be used for inquiries that cannot be processed with a logical file.
DREAM WRITER VERSIONS:
Enter the version for each program: If left blank, ZJDE0001 will be used.
10. A/R and A/P Journal Entries (P03101)
11. Standard Invoice Entry (P03105)
12. Cash Receipts Entry (P03103)
13. Sales Order Entry (P4211)
14. Supplier Ledger Inquiry (P042003)
15. Supplier Payment Inquiry (P042004)
16. Account Status Summary (P03203)
17. Parent/Child Inquiry (P01270)
18. Name Search (P01200)
19. Draft Receipts Entry (P03103) If 19 left blank, ZJDE0003 will default.
AS-IF CURRENCY DISPLAY:
20. Enter the currency code for as-if currency display. This option allows for amounts to display in a currency other than the currency they are stored in. This option is activated by function key F19. Amounts will be translated and displayed in this as-if currency. If left blank, amounts will display in their database currency.
21. Enter the "As Of" date for processing the current exchange rate for the as-if currency. If left blank, the Thru date will be used. Note: A valid exchange rate must exist in the exchange rate table between the two currencies, based on the As Of date.

102.7 Account Status Summary (P03203)

Processing Option	Processing Options Requiring Further Description
AGING:
1. Specify one of the following dates to age accounts from: D = Due Date I = Invoice Date G = General Ledger Date S = Statement Date (If left blank "D" is the default.)
2. Specify one of the following methods for aging calculations: 1 = Aging Days 2 = Fiscal Periods 3 = Calendar (If left blank, "1" is the default.)
3. Enter the following aging category information: Aging days: Beginning thru . . . thru . . . thru . . . thru . . . thru . . . thru . . . Thru . . .
4. Enter a '1' to retrieve the aging specifications from A/R Company Constants. (Default of blank will use the processing options for aging.) Note: If selected, all other aging processing options will be ignored.
5. Enter a '1' to process aging in the "Real Time" mode. (If left blank "As of" is the default.)
CREDIT PROCESSING:
6. Specify one of the following for credits: ' '= Age Credits (Default) '1'= Apply Credits to Current Column '2'= Apply Credits to oldest active Aging Column. '3'= Separate Credits (Real Time Only)	This processing option allows you to specify how to view credit amounts. In addition to the options of how to age credit amounts, option 3 allows you to view all credit amounts as a separate total in the 'Real Time' mode.
DRAFT PROCESSING:
7. Indicate which drafts to include in the outstanding draft calculation: ' ' = Do not include drafts (Default) '1' = Include ALL unpaid drafts '2' = Include only drafts not due
CREDIT LIMIT:
8. Enter a 1 to display the Child credit limit. If left blank, the parent credit limit will be displayed.

102.8 Recycle Recurring Invoices (P038101)

Processing Option	Processing Options Requiring Further Description
DEFAULT PROCESSING:
1. Enter a '1' to use today's date as the invoice date. Enter a '2' to duplicate the invoice date. Default of blank will increment the invoice date.
2. Enter the currency code that represents the EURO currency in your system.
DOCUMENT TYPE DEFAULT:
3. Enter one of the following values to determine the Document Type of the newly created invoice. blank = 'RR' (Default) '*' = Same Document Type as the originating invoice. XX = Where 'XX' is a valid Document Type (UDC 00/DT and 00/DI).

102.9 Rev Rec - Hierarchy/Date Setup - All (P0325)

Processing Option	Processing Options Requiring Further Description
SYSTEM FORMAT CONTROL:
1. Enter sequence numbers (1-4) to indicate which system formats will appear and in what order when using the format selection function key. If left blank, all will show in the order below. Invoice Set-Up. (default) Sales Order Set-Up Contract Billing Service Billing

Processing Option

Processing Options Requiring Further Description

SYSTEM FORMAT CONTROL:

1. Enter sequence numbers (1-4) to indicate which system formats will appear and in what order when using the format selection function key. If left blank, all will show in the order below.

Invoice Set-Up. (default)

Sales Order Set-Up

Contract Billing

Service Billing

102.10 Revenue Recognition - Batch Recognition (P03502)

Processing Option	Processing Options Requiring Further Description
ELIGIBLE FOR RECOGNITION DATE:
1. Enter the Eligible for Recognition date. Invoices eligible through this date will be selected. If left blank, the current date will be used.	When you use blind recognition, the program disregards this processing option. The program processes any invoices you select for blind recognition, regardless of eligible for recognition date.
G/L DATE:
2. Enter the G/L Date to apply to the recognition journal entries. If left blank, the current date will be used.	When you use blind recognition, the program disregards this processing option. The program uses the G/L date you enter in the interactive window.
REASON CODE:
3. Enter a reason code for this action to be applied to the Invoice items in the Invoices file (F03116). Use of this field is optional.	When you use blind recognition, the program disregards this processing option. The program uses the reason code you enter in the interactive window for the invoice and the distribution records in the F03116 and F03117.
REPORT DATA:
4. Enter '1' to print all revenue account detail on successfully recognized invoices. If left blank, only invoice document information will print.	When you use blind recognition, the program disregards this processing option. The program does not print a report for invoices it processes successfully.
PRINT WARNINGS:
5. Enter a '1' to print warnings on the error report if the transaction is in error. If left blank, only errors will print.
DW VERSION FOR JOURNAL ENTRY PROCESSOR:
6. To override standard journal entry processing (DREAM Writer XT0911Z1, version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system wide set up.
AUTOMATIC POST
7. Enter a '1' to automatically submit the post after processing/creating recognition g/l transactions. If left blank, the post is not submitted automatically.	You can bypass the post at this time and post manually at a later time. Note that system does not recognize the revenue until you post the journal entries. These journal entries appear on integrity reports showing an out of balance situation until you post them.

102.11 Batch Invoice Add to Revenue Recognition (P03503)

Processing Option	Processing Options Requiring Further Description
TRIGGER PROCESSING:
1. Enter a '1' to bypass using the trigger processing to determine each invoices eligibility for the Revenue Recognition process. All invoices selected will be processed to RR. If left blank, invoices will be evaluated through trigger processing.	When you use Standard Invoice Entry (P03105) to add an invoice to revenue recognition, P03105 accesses this program. This program disregards this processing option in this situation. The system adds any invoice when using Standard Invoice Entry unless an error occurs. This program disregards this processing option for interbranch invoices from Sales. For interbranch invoices, the system evaluates invoices using only the trigger configuration setup. If you use the Create A/R and G/L Entries program (P48199) to create invoices for contract billing and service billing, P48199 accesses this program. This program disregards this processing option and uses only the trigger configuration setup.
ELIGIBLE FOR RECOGNITION:
2. Enter the Eligible for Recognition Date to apply to the invoices. If left blank, the current date will be used.
G/L DATE:
3. Enter the G/L Date to apply to the recognition journal entries. Enter *TODAY to use the current date. If left blank, the invoice's G/L Date will be used.	When you use Standard Invoice Entry (P03105) to add an invoice to revenue recognition, P03105 accesses this program. This program disregards this processing option in this situation. You must enter the G/L Date in the interactive window. If you want to use the same G/L Date as the invoice you are adding, you must enter it. For interbranch invoices, the G/L Date the program uses is always the same date as the Invoice G/L Date.
DW VERSION FOR JOURNAL ENTRY PROCESSOR:
4. To override standard journal entry processing (DREAM Writer XT0911Z1, version ZJDE0001), enter an override version number. This should only be changed by persons responsible for system wide set up.
AUTOMATIC POST BYPASS:
5. Enter a '1' to bypass automatic submittal of the 'RR' batch of G/L transactions created for recognition. If left blank, the 'RR' batch is submitted automatically if the invoice batch is completely posted.	You can bypass the post at this time and post manually at a later time. Note that these journal entries will appear on integrity reports showing an out of balance situation until you post them. If you use the Create A/R and G/L Entries program (P48199) to create invoices for contract billing and service billing, P48199 accesses this program. This program does not access the Post program in this situation and disregards this processing option.
PRINT REPORT SELECTION:
6. Enter a '1' to print the accounting details (revenue and PLA accounts) for successfully added invoices. If left blank, the accounting details will not be printed.

102.12 Remove Invoices from RR Process (P03504)

Processing Option	Processing Options Requiring Further Description
PURGE FILES:
1. Enter one of the following values to indicate how to treat the invoice and distribution data from F03116 and F03117: blank = All to Purge Files 1 = Only Posted to Purge Files 2 = Nothing to Purge Files
AUTOMATIC POST BYPASS:
2. Enter a '1' to bypass automatic post submittal of the 'RR' batch of G/L transactions for any voids. If left blank, the 'RR' batch is submitted automatically if any voids are performed.

102.13 Revenue Recognition Workbench (P03116) (Release A9.3 Update)

Processing Option	Processing Options Requiring Further Description
PRE-LOADED DATA SELECTIONS:
1. Any values entered in the following options will be loaded upon entry into the program: Display Posted (* = All) Rev Recognition Status Rev Recognition Status Currency Code (* = All) Paid Company COGS Status (* = All) Type of Invoice (*=All)
DREAM WRITER VERSIONS:
Enter the version for each program: If left blank, version ZJDE0001 will be used. 2. Pay Item/Guided Recognition (P031163) 3. Blind/Batch Recognition (P03502) 4. Remove from Rev Recognition (P03504) 5. Cost of Goods Sold Recognition (P031164)
6. Enter '1' to allow recognition of COGS after recognizing Revenue for Sales invoices with unrecognized COGS. If left blank, the COGS video will not automatically display.