40 Daily/Periodic Activity Processing Options

This chapter contains these topics:

Section 40.1, "Speed Voucher Entry (P041015)"
Section 40.2, "Voucher Entry (P04105)"
Section 40.3, "Speed Invoice Entry (P031015)"
Section 40.4, "Invoice Entry (P03105)"
Section 40.5, "Order Entry (P4311)"
Section 40.6, "Journal Entries with Tax (P09106)"
Section 40.7, "General Ledger Post (P09800)"
Section 40.8, "Suspended Tax - Process Hold Pmts/Rcpts (P09861)"
Section 40.9, "Generic VAT Reports (P700001),"

40.1 Speed Voucher Entry (P041015)

Processing Option	Processing Options Requiring Further Description
FIELD DISPLAY CONTROL:
1. Enter '1' to select the following capabilities of this program: Sales/Use/VAT Tax Processing PO Number Entry Extra Date for Service/Tax
2. You may activate certain capabilities by entering a '1' for the following: Approver Number Entry Category Code 07 Entry
FORMAT CONTROL:
3. Enter sequence numbers (1-5) to indicate which formats will appear and in what order. If all are left blank, all formats will appear in the order shown below: Standard Speed Voucher Entry Voucher Entry with Subledger Voucher Entry with F/A Number Voucher Entry with Units Voucher Entry with Phase Code Note: This is used with the Format Selection function key.
4. Enter a 1 to review the Voucher Category Codes with an Add or Change.
TWO CYCLE OPTION:
5. Enter a '1' for 2 Cycle processing.
DREAM WRITER VERSIONS: Enter the version of each program: If left blank, ZJDE0001 will be used.
6. A/P Voucher Processing (XT0411Z1)
7. Journal Entry Processing (XT0911Z1)
8. Supplier Ledger Inquiry (P042003)
9. Supplier Master Information (P01054)
10. Name Search (P01200)
11. Voucher Category Code Review(P0411W)
12. Organization Structure Revs (P0150)
FIELD PROTECTION CONTROL:
13. Enter a '1' to protect the Pay Status field. If left blank the Pay Status field will be unprotected.
14. Enter a '1' to protect the Exchange Rate field. If left blank, the Exchange Rate will not be protected.

40.2 Voucher Entry (P04105)

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 Approver Number Entry Category Code 07 Entry Payment Instrument
FORMAT CONTROL:
2. Select the default screen format: ' ' = Standard Voucher Entry '1' = Voucher Entry with Taxes '2' = Alternate Payee
3. Enter a 1 to review the Voucher Category Codes with an Add or Change.
TWO CYCLE OPTION:
4. Enter a '1' for 2 Cycle data entry.
PREPAYMENT OPTIONS:
5. Enter the G/L offset to use for creating prepayment pay items. You must enter a value to allow automatic creation of prepayment pay items.
6. Enter the default payment status for prepayment pay items. If blank, prepayment pay items will default to a payment status of 'H'.
7. Enter the number of days to add to the due date of the prepayment pay items.
VOUCHER LOGGING:
8. Enter a '1' if you wish to perform Voucher Logging from within Voucher Entry. Note: When doing Voucher Logging, processing options for Prepayments will be ignored.
9. Enter a '1' if you want the system date to be defaulted to the G/L date and protected from being overridden.
DREAM WRITER VERSIONS:
10. Enter the version for each program: If left blank, ZJDE0001 will be used. A/R and A/P Journal Entries (P03101) A/P Voucher Processing (XT0411Z1) Supplier Ledger Inquiry (P042003) Supplier Master Information (P01054) Name Search (P01200) Voucher Category Code Review (P0411W) Organization Structure Revs (P0150)
FIELD PROTECTION CONTROL:
11. Enter a '1' to protect the Pay Status field. If left blank the Pay Status field will be unprotected.
12. Enter a '1' to protect the Exchange Rate field. If left blank, the Exchange Rate will not be protected.

40.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.

40.4 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.

40.5 Order Entry (P4311)

Processing Option	Processing Options Requiring Further Description
DEFAULT VALUES:
1. Order Type (Required)
2. Line Type (Optional)	The default line type for new order lines. If you leave this option blank, you must manually enter line types on the order; however, if you enter an inventory item on an order line, the system retrieves the line type from item/branch information (F4102).
3. Status Code (Required)	The beginning status code for order detail lines.
4. Override Next Status (Optional)	The next status code on new order lines. If you leave this option blank, the default next status code comes from Order Activity Rules (P40240).
5. Unit of Measure (Optional)
6. Line Increment (Optional)
7. Enter a '1' to default the primary unit of measure from the item master into the transaction unit of measure. If left blank, the purchasing unit of measure from the item master will be used.
8. Enter the Landed Cost Rule to be used. If left blank, it will default from either the "Ship-to" or the "Supplier" purchasing instructions.
9. Enter a '1' to automatically load header values to the detail lines after a change. If left blank, it must be done manually.
10. Enter a '1' to calculate Promise Date from Average Leadtime. If left blank, today's date is used.	Enter 1 to have the program add the number of Average Leadtime days to the Order Date to determine a Promised Delivery Date. You can view Average Leadtime for an item in Routing Analysis Revisions (P43090) in the fold area.
ORDER DUPLICATION DEFAULT VALUES:	When you press F21 to copy an order to create a new order, these are the default values for the new order.
11. Order Type
12. Beginning Status
13. Override Next Status (Optional)
14. Enter text duplication selection: '1' to copy line text '2' to copy line and order text '3' to copy order text
WORK ORDER DEFAULT VALUES:
15. Enter the status to update the work order to when the quantity or promised date on the purchase order changes.
PROMPTING CONTROL:
16. Enter the Screen Format: 1 = Item, Quantity, Price 2 = Item, Quantity, Description 3 = Account Number, Description 4 = Account Number, Item Number (If left blank, format 1 is used.) Enter a '1' to:	The video (screen) format you choose should correspond to the line types you will enter on the order; for example, if you use this version of order entry for stock items, you'll want to use format 1 or 2 for easy access to the Item Number field. If you order goods or services via an expense account, you'll want to use formats 3 or 4 for access to the Account Number field.
17. Display Headings first.
18. Be prompted to accept the order.
19. Allow the addition of a Supplier Master record, if not set up.	You set this option to 1 if you want the Supplier Master screen to automatically display when you enter a supplier address number for which master information doesn't exist. If you set this option to 1, you must add master information for the address number before the system will accept the order.
20. Enter which Item Search screen is to be used to return items: 1 = Item Search Window allowing the return of multiple items 2 = Full Item Search screen with Query capabilities 3 = Supplier Item Selection with the return of multiple catalog items (If left blank, the Item Search screen allowing the return of a single item will be used.)
FIELD DISPLAY CONTROL:
21. Enter a '1' to suppress canceled or closed lines.
22. Enter a '1' to protect prices, or a '2' to make prices non-display.
23. Enter a '1' to protect status codes.
24. Enter a '1' to protect the order type field.
25. Enter the next status at which detail lines cannot be changed. The detail line will be protected if the next status is greater than or equal to this status. If left blank there is no restriction.
APPROVAL PROCESSING:
26. Enter where the approval route code should be defaulted from, OR enter a specific route code value. If left blank, no approval processing will be performed. 1 = Originators Address Book Number 2 = Originators User Profile 3 = Branch/Plant Route Code 4 = Default Locations Route Code	Enter the specific approval route name This is the unique route name that you assigned when you created the route. Enter a 1 - Originators Address Book Number Set up an approval route that is named the same as each person's address book number. This is useful when you want each user to have a separate route code. Enter a 2 - Originators User Profile Set up an approval route that is named the same as each person's user profile. This is the same as the previous option, however the system uses the user profile rather than the address book number. Enter a 3 - Branch/Plant Route Code The approval route is attached to the branch/plant in the branch/plant constants screen on page 1.You can attach the same approval route to more than one branch/plant. This option is useful when you have different branch managers heading various groups. Enter a 4 - Default Locations Route Code The approval route is attached in the Default Location and Printers. The route will be associated to the terminal/user ID. This allows groups of users to be attached to the same approval route code.
27. Enter the Awaiting Approval status.	You set up status codes for approval processing in Order Activity Rules (P40204). If, for example, you set up a certain document/line type so the last and next status codes are 220/230 for Order Entry and 230/240 for Approval Processing, order lines remain at statuses 220/230 until fully approved, at which time the statuses change to 230/240. Based on this scenario, the Awaiting Approval status is 230 and the Approved Status is 240.
28. Enter the Approved status.
PRINT CONTROL:
29. Enter a '1' to automatically print POs via the subsystem.	Set this option to 1 to automatically call the Print Purchase Order program via the subsystem each time you create or change an order. You must set up and activate program J43500S in the subsystem to use this option.
30. Enter the version of Print P.O. On-Demand to call when the function key is pressed.
INTERFACES:
31. Enter a '1' to validate the Branch against the Branch/Plant Constants file. If left blank, the Cost Center Master file will be used.
32. Enter a '1' to bypass PBCO warning.
33. Enter a '1' to bypass PACO warning.
BUDGET CHECKING:
34. Enter a '1' if Budget Checking is desired. If left blank, ALL other options related to budgeting will be omitted.	Budgeting functionality only applies to detail lines that have a line type with an Inventory Interface of A or B.
BUDGETING DEFAULT VALUES:
35. Budget Hold Code	The hold code you enter here must be set up in UDC table 42/HC. The standard code is B1. If you enter a code here and you don't have a budget set up for the account, the order will go on hold.
36. Budget Tolerance Limit (10 = 10%)	The number you enter here establishes a percentage by which you can exceed a budget amount without the order going on hold.
37. Level of Detail to accumulate the budget (5-9). If left blank, 9 will be used.	Enter a value here to indicate the level of detail the system uses to check your chart of accounts to find an available budget. If the account on the order doesn't have a budget amount set up for it and the level of detail for the account is greater than the one specified in this processing option, the system looks upward in the chart of accounts to find the first account number, at the level of detail specified in the option, above the account on the detail line of the PO.
38. Budget Ledger Type	Use this processing option to indicate the ledger type for which to check the budget. For financial budgets the standard ledger type is BA and for Job Cost the standard ledger type is JA.
39. If Financial Budgeting, specify the budget total method (1-3). If left blank, method 1 will be used: 1 = Original Budget + Period Amounts for current year + Prior year postings (same as Job Cost budget calculation). 2 = Sum of period amounts for current year (standard financial budget). 3 = Original budget + period amounts for current year (standard financial spread with changes).	To compute the available budget, the system will check against the F0902 file for budget amounts.
BUDGET PROCESSING: Enter a '1' to:
40. Accumulate the budget through the current period. If left blank, the budget will accumulate for the total year.	Enter a value here only if you have selected method 2 in the previous processing option. It is used to provide flexibility when budgets for the accounts are set up on a period basis. A value of 1 will add all available budgets from the beginning of the year to the current period. A value of 2 will indicate to the system to check the total year budget for the account.
41. Receive warning that a detail line amount will exceed budget.
CROSS REFERENCE INFORMATION:
42. Enter the cross reference code for retrieving item substitutions.
43. Enter the cross reference code for retrieving item replacements for obsolete items.
KIT PROCESSING: Enter a '1' to:
44. Display kit component lines.	The system always writes kit component lines to the detail file (F4311). This option determines whether the components actually display on the screen.
ITEM AVAILABILITY:
45. Enter a '1' to update the "Quantity on Other PO's" field (OT1A) in the Item Branch or Location files (i.e. Requisitions and Blanket orders). If left blank, the "Quantity on PO" field (PREQ) will be updated. Warning: If PO Generation performs the automatic blanket order release processing, enter a '1'.	This option applies to stock items only. You indicate if you expect to receive the items you enter via this version of Order Entry. Receipts are based on order type, that is, you normally expect to receive items on a purchase order, but not those on a requisition, blanket, or quote order, as these are usually pre-requisites to actual purchase orders. The system maintains item quantities you expect to receive in the Quantity on PO bucket and those you don't expect to receive in the Quantity on Other PO's bucket. You can view both quantities in Detailed Availability (P41023). You must set this option to 1 when you enter blanket orders that are subsequently released to purchase orders via the automatic Blanket Order Release window; otherwise, the on receipt quantity will be counted twice, once on the blanket and again on the PO. The Blanket Order Release program is accessible from multiple programs, including PO Generator (P43011).
CHANGE ORDER PROCESSING:
46. Enter a '1' to function as Change Order Entry, which only allows changes to existing purchase orders. Enter a '2' to function as Change Order Entry, which allows changes to purchase orders and the addition of new purchase orders. If left blank, no change order processing is performed.	You set this option to 1 or 2 if you use this version of Order Entry to send changed orders back through the approval process. This causes the system to update the Next Status code on changed order lines to the Override Status you enter in processing option 4.
47. Enter the next status to start processing all changes made to a purchase order as a change order. If left blank, all changes will be processed as change orders.
48. Enter a '1' to automatically allow text entry when a change order is entered.	When you activate change order processing, you enter 1 in this option to have the system display a window when you make changes to a detail line so you can document a reason for the changes.
DREAM WRITER VERSIONS: Enter the version for each program: If left blank, ZJDE0001 will be used.
49. Open Order Inquiry (P430301)
50. Supply/Demand Inquiry (P4021)
51. Supplier Analysis (P43230)
52. Supplier Master (P01054)
53. SMS Rate & Route server (PSMR9300)
54. Approval Review called using the function key from E-Mail (P43080).	Persons responsible for approving orders can access the Approval Review screen (P43080) by pressing F15 in Approval Notification (P012501) or via e-mail if system setup allows. You use this option to specify beforehand the appropriate version of P43080 that displays when the user presses F15.
BLANKET/QUOTE PROCESSING:
55. Enter a '1' for automatic access to the blanket/quote release processing. The cost on the released order will be used. Enter a '2' for automatic access to the blanket/quote release processing using special pricing. If left blank, no automatic blanket/quote release processing will be performed.
ORDER TEMPLATE PROCESSING:
56. Enter a '1' to perform automatic order template processing. If blank, no order template processing will be performed.
SUPPLIER ANALYSIS:
57. Enter a '1' to capture supplier analysis information. If left blank, no Supplier analysis information is captured.	Enter 1 to have the system create a record in the Supplier/Item Relationship file (F43090) if it doesn't already exist, and also to update order information to the file.
CURRENCY PROCESSING:
58. Enter a tolerance limit percentage to warn of radical currency rate changes (15.0 = 15% +/-).
ENCUMBRANCE CHECKING PROCESSING
59. Enter a '1' to warn if extended amount is less than vouchered amounts Enter a '2' to stop entry of an extended amount less than the vouchered amounts If left blank, no check will be made.	Set this option to 1 or 2 to have the program edit changes you make to amounts on existing lines to partial vouchers already created for the line. This option only applies if you track commitments or encumbrances, in which case the line type for the order line has an inventory interface of A or B.

40.6 Journal Entries with Tax (P09106)

Processing Option	Processing Options Requiring Further Description
DW VERSION FOR JOURNAL ENTRY PROCESSOR:
1. 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 setup.
EXCHANGE RATE:
2. Enter a '1' to protect the Exchange Rate field. If left blank, the Exchange Rate will not be protected.
FORMAT CONTROL:
3. Select default screen format: BLANK = Exclusive Tax '1' = Inclusive Tax

40.7 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.

40.8 Suspended Tax - Process Hold Pmts/Rcpts (P09861)

Processing Option	Processing Options Requiring Further Description
PAID VOUCHER/INVOICE:
1. Enter a '1' to bypass processing of receipts/payments if the original invoice/voucher is not completely paid or received. If left blank, selected payments/receipts will be processed regardless of pay status.
PROCESSED DATE:
2. Enter the date to be used as the 'Processed' date. If left blank, the System Date will be used.

40.9 Generic VAT Reports (P700001)

Processing Option	Processing Options Requiring Further Description
GENERIC VAT REPORT IDENTIFICATION:
1. Enter the Report ID. The value must exist in the Report Identification (74/RI) UDC file.
PROCESSING MODE:
2. Specify in which mode the program is run. Values are: Blank: proof mode. The system prints a report and does not update files. 1: prints the report in final mode. In final mode, all printed documents are saved in the F700018 file.
3. Enter Y to enable the functionality. If left blank, the functionality is disabled.
DATA SELECTION:
4. Specify the reporting period beginning date to select records from the F0018 file.
5. Specify the reporting period ending date to select records from the F0018 file.
6. Specify on which date field the data selection is performed. Values are: 1: G/L Date 2: Service Date 3: Order/Transaction date
FISCAL INFORMATION:
7. Enter the fiscal company for the report. It must exist in the Company Master file. The system uses this value to retrieve the VAT report header information.
8. Enter the address book number of the company's legal representative. The system uses this value to retrieve the name of the company's legal representative.
DECLARATION INFORMATION:
9. Enter the identification number of the declaration.
10. Specify the declaration identification type. Values are: Blank: Standard 1: Complementary 2: Substitutive
11. Specify if the report is monthly, quarterly or yearly. Values are: 1: Monthly 2: Quarterly 3: Yearly
12. Enter the declaration period. If Monthly, enter a value from 01 (January) to 12 (December). If Quarterly, enter a value from 01 (January to March) thru 04 (October to December). If Yearly, leave blank.
13. Specify the declaration date.
14. Specify the declaration year.
15. Specify the declaration site.
ADDRESS BOOK DEFAULTS:
16. Specify the line ID number for a who's who record.
17. Select an URL/Email category code for email address retrieval. Select a value from the URL/Email Category Code (01/UC) UDC file.