This chapter contains these topics:
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DEFAULT VALUES: | |
| 1. Enter the specific date to be used as the A/R Invoice date OR | |
| 2. Select the date to be used as the A/R Invoice date:
'1' = Date of the Sales Invoice '2' = Actual Shipment date '3' = Sales Update execution date If both options 1 and 2 are blank, the Sales Invoice date will be used. If both options 1 and 2 are not blank, the date in option 1 will be used. |
If you enter 1 in this option, all sales orders selected by the program must have a pre-assigned invoice date. If you enter 2 in this option all sales orders selected by the program must have an actual shipment date.
You can view the dates applicable to an order in Customer Service Inquiry (P42045) by inquiring on the order, taking an option 5 to view the detail, and selecting F8 to view the dates. |
| 3. Enter the specific date to be used as the General Ledger date OR | |
| 4. Select the date to be used as the General Ledger date:
'1' = Date of the Sales Invoice '2' = Actual Shipment date '3' = Sales Update execution date If both options 3 and 4 are blank, the sales update execution date will be used. If both options 3 and 4 are not blank, the date in option 3 will be used. |
If you enter 1 in this option, all sales orders selected by the program must have a pre-assigned invoice date. If you enter 2 in this option all sales orders selected by the program must have an actual shipment date.
You can view the dates applicable to an order in Customer Service Inquiry (P42045) by inquiring on the order, taking an option 5 to view the detail, and selecting F8 to view the dates. |
| 5. Specify the G/L Account Cost Center (CC) if the AAI CC is blank.
If left blank, the default is '3'. '1' = Use the Subsequent CC. If it is also blank, use the CC from the order detail. '2' = Sold to address number '3' = Use the Subsequent CC. If it is also blank, use the CC from the order header for sales entries and the CC in the detail for inventory entries. |
The 'Subsequent Cost Center' refers to the Project Number attached to the cost center/branch in Revise Single Business Units (P0006). |
| 6. Enter the override next status code for lines processed.
If left blank, will use status code '999' to close out the line. |
|
| 7. Enter the 3 character code to be used to update the billing remarks in the G/L file (F0911). | |
| PRINT SALES JOURNAL: | |
| 8. Enter '1' to print a Sales Journal. | |
| 9. Enter the version of Sales Journal (P42810) to print.
If left blank, version ZJDE0001 will be used. |
|
| SUMMARIZATION: | |
| 10. Enter '1' to summarize your A/R entries within the Invoice Number.
If left blank, A/R entries will be written in detail. |
Enter 1 to have the program summarize lines on a sales order into a single pay item on the invoice. The program will only summarize lines with identical tax and payment term information.
If you include tax on sales orders, the value you enter in this processing option should correspond with the method by which you tax orders, that is, at the line level (detail) or the order total level (summary). You specify this method in Tax Rules by Company (P0022). |
| 11. Enter '1' to summarize your G/L entries within the Invoice Number.
If left blank, G/L entries will be written in detail. |
Enter 1 in this option to have the program summarize journal entries by account number, subledger and subledger type. |
| 12. Enter '1' to summarize your Cost of Goods and Inventory G/L entries to a separate batch. These entries will be summarized at the batch level. This option is not allowed in currency mode. | If you choose to summarize Inventory and COGs into a separate batch, the program creates a batch type 'G' for these entries. |
| UPDATE OPTIONS: | |
| 13. Enter '1' to run this program in final mode.
If left blank, this program will produce only the reports and will perform no file or status update. |
|
| 14. Enter '1' to bypass updating any or all of the following systems:
Accounts Receivables (F0311) Inventory (F41021/F4115) Commissions (F42005) Sales History Summary (F4229) Sales Rebate History (F4079) Accounts Payable (F0411) |
If you choose to bypass Accounts Receivable, the program still assigns an invoice number to each sales order, but it doesn't create an invoice record in the A/R system. Instead of writing a journal entry to the A/R trade account at the post (P09800), this program will pull the revenue offset account from AAI 4245.
If you choose to bypass A/R the system will not write tax records to the Tax file (F0018). Also, instead of an I batch, the system creates a G batch. The option to bypass Accounts Payable only applies to interbranch orders, and your selection in processing option 26. |
| 15. Enter '1' to purge all associated text lines in the Text Detail File (F4314). These are text lines entered through a selection exit from Sales Order Entry. | |
| 16. Enter '1' to leave completed records in the F4211 file.
If left blank, the F4211 record will be purged to the Sales History file (F42119). |
|
| 17. Enter '1' to leave Sales Header records in the F4201 file.
If left blank, AND all associated detail records have been purged, the F4201 records will be purged to the Sales Header History file (F42019). NOTE: If you have specified to update the order number to the Subledger field in the G/L, this option must be set to '1'. |
|
| 18. Enter '1' to purge all pricing history records (F4074).
If left blank, pricing history will remain in file. |
|
| 19. Select the type of information to be updated to the Subledger field in the journal entries (F0911):
'1' = Order Number '2' = Salesman Number '3' = Sold To Address Number '4' = Ship To Address Number '5' = Item Number (Short) |
|
| INVOICE NUMBER UPDATE: | |
| 20. Enter an index number (1-10) used to assign the A/R Next Number.
If left blank, index 01 will be used as the default. |
If you use Sales Update to assign invoice numbers to sales orders, enter the next number bucket from which the program is to retrieve a beginning invoice number. You set up next numbers for invoices in the Next Numbers screen (P0002) under system code 03 (Accounts Receivable). |
| 21. Enter the document type to be used for the invoice. If left blank, 'RI' will be used.
NOTE: You will have to use the above options if you have not already assigned the A/R number at the time of invoice print. |
|
| SALES COST UPDATE: | |
| 22. Enter '1' to update the item cost with the current inventory cost by running the Sales Cost Update (P42950) prior to sales update. | The P42950 serves three purposes depending on the version you run. It will update sales order costs, prices, or exchanges rates (and the corresponding amounts).
You set this option to 1 to have the P42950 make updates to sales orders before they run through Sales Update. You specify the version of P42950 you want to run in processing option 23. The P42950 will not change costs on sales order lines for which items have been relieved from inventory (via Ship Confirm). When inventory is relieved, the system writes a Cardex record (F4111) containing the cost; therefore, changing the costs afterwards could cause integrity problems. |
| 23. Enter the version of Sales Cost Update to run.
If left blank, will use version ZJDE0002. |
Version ZJDE0002 is preset to update sales order costs. |
| SALES FLEX ACCOUNTING: | |
| 24. Enter '1' to use sales flex accounting.
If left blank, sales flex accounting will not be used. |
Sales flex accounting allows you to define the business unit, subsidiary or subledger portion of an account number based on category codes and other variables that pertain to an item or address number on a sales order. You work with flexible sales accounting in P40296. |
| INTER-BRANCH SALES: | |
| 25. Enter the Order Type used to record inter-branch sales. To specify more than one, type them one after the other along this field. | |
| 26. Enter a '1' to create A/R (F0311) and A/P (F0411) batches.
If left blank, an interbranch JE (F0911) batch will be created. |
|
| DREAM WRITER VERSIONS:
Enter the version for each program. If left blank, ZJDE0001 will be used. |
|
| 27. A/R Functional Server (XT0311Z1) | The A/R server you specify here will have some affect on the invoices created by Sales Update. See processing options for XT0311Z1 for more details. |
| 28. G/L Functional Server (XT0911Z1) | The G/L server you specify here will have some affect on the journal entries created by Sales Update. See processing options for XT0911Z1 for more details. |
| 29. A/P Functional Server (XT0411Z1) | |
| BULK PRODUCT OPTIONS: | |
| 30. Enter a '1' if the quantity shipped is at standard for sales lines without bulk quantities.
Leave blank if the quantity shipped is at ambient. |
|
| 31. Enter the address book number to be used as the owner for duty paid when the tank is commingled for duty and the owner has not been specified. | |
| 32. Enter the address book number to be used as the owner for duty free when the tank is commingled for duty and the owner has not been specified. | |
| 33. Enter a '1' to record temperature gain/loss based on cost.
Enter a '2' to record temperature gain/loss based on revenue. Leave blank if no temperature gain/loss is to be recorded. |
|
| 34. Enter a '1' to update quantities to the following files at ambient if the order was priced at ambient.
Leave blank to update all quantities at standard. If this processing option is used, item quantities may not balance to the item ledger since the item ledger is updated at standard. . Sales History Summary (F4229) . Item History (F4115) . G/L Account Ledger (F0911) More .... |
|
| AGREEMENT MANAGEMENT CONTROL: | |
| 35. If the agreement management system is in use and the depot from which product will be relieved is a foreign depot, an agreement search will be performed to find a valid borrow agreement.
Specify which destination should be used by the search program. Enter the specific branch/plant to be used as the destination. OR Enter '1' to use *ANY or enter '2' to use the user's default br/plt. |
|
| INTERNAL SALES OPTION: | |
| 36. Enter a '1' to use the Account number from the sales detail as the Revenue account or leave blank to use the account number as the Cost of Goods Sold account number. | |
| FREE GOODS: | |
| 37. Enter a '1' to record a free good as a discount.
List price will be recorded as a revenue and the actual price will be used to calculate the price adjustment. If left blank, the actual price will be treated as revenue and no adjustment recorded. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| RECORD SELECTIONS: | |
| 1. Enter '1' to update the Status Codes of the Sales Order.
If left blank the Status Codes of the order will not be changed. |
|
| 2. Enter the override Next Status code for the sales order.
If left blank the next available status code from the Order Activity Rule (F40203) will be used. This option will only be in effect if processing option one is set to '1'. |
|
| PRINT OPTION: | |
| 3. Select the currency printing mode of this report:
' ' - Print in Domestic Only '1' - Print in Foreign Only '2' - Print in Both Domestic and Foreign currencies. |
| 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'. |
|
| SKIP SUSPENDED TAX POST | |
| 19. Enter '1' to bypass automatic submittal of the suspended VAT post. | |
| BATCH TYPE SELECTION:
Note: This option should NOT be changed by User. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT OPTIONS: | |
| 1. Select Account number to print:
'1' = account number '2' = short account ID '3' = unstructured account '4' = number entered during input. If left blank, the number entered during input will be printed. |
|
| 2. Enter a '1' to print units.
If left blank, units will not be printed. |
|
| 3. Enter a '1' to suppress commas when displaying amount fields. This will allow the printing of additional significant digits in each amount field. | |
| ALTERNATE CHART OF ACCOUNTS PRINT: | |
| 4. Select which account category code (1 - 23) to print in place of the account number.
Default of blank will print the account number specified in option number 1. |
|
| GENERIC TEXT: | |
| 5. Enter a '1' to print the generic text for journal entry lines in a 40-character width, a '2' to print text in an 80-character width.
If left blank, generic text will not be printed. |