117 Technical Processes Processing Options

This chapter contains these topics:

117.1 Update A/R from Address Book (P03802)

Processing Option Processing Options Requiring Further Description
FIELD UPDATES:  
1. Enter a '1' to update the entire A/R Ledger (F0311).

If left blank, only those records that have been revised since the last run of this program will be updated.

Note: It is recommended that if you are deleting records that a complete update be performed.

  
2. Enter a '1' to UPDATE the Alternate Payers in your A/R Ledger (F0311) with Address Book values.

If left blank, this field will not be updated.

  
3. Enter '1' to PROTECT the fields below in your A/R Ledger from being updated with Address Book Values.

If left blank, the field will be updated:

Alpha Name

Category Code 01

Category Code 02

Category Code 03

Category Code 04

Category Code 05

Category Code 06

Category Code 07

Category Code 08

Category Code 09

Category Code 10

  

117.2 Update YTD Invoice Amount (P03820)

Processing Option Processing Options Requiring Further Description
DATE OPTIONS:  
1. Enter a "From" date to be used as the beginning period for the close.  
2. Enter a "Thru" date to be used as the ending period for the close.  
UPDATE CONTROL:  
3. Enter a '1' to update Customer Master balances in Final Mode.

If left blank, Customer Master balances will not be updated (Proof Mode).

Note: A run in proof mode is highly recommended if using computation method 2.

  
COMPUTATION METHOD:  
4. Enter a '1' to compute prior invoiced using the "From" and "Thru" dates. This method assumes no F0311 records have been purged since "From" date.

Enter a '2' to compute prior invoiced as the existing YTD invoiced less the computed YTD invoiced, using the "Thru" date only.

Note: This method CANNOT be executed more than once without erroneous results. See HELPS for further clarification.

  
AMOUNT CURRENCY UPDATE:  
5. For COMPUTATION METHOD '1' only, Final Mode only. Enter a currency here to be updated to the Amount Currency in the Customer Master file.

If left blank, the Amount Currency will not be updated.

Caution: All of the records within your DREAM Writer Data Selection will be updated.

  

117.3 Balance Forward Update (P03501)

Processing Option Processing Options Requiring Further Description
A/R Constants:  
1. Enter a '1' to retrieve the 'As Of' Date and Comparison Date from A/R Constants.

A default of blank will use the processing option values.

  
As Of Date:  
2. Enter the 'As Of' Statement date to be used to summarize Invoices.

Invoices dated prior to and including this date will be summarized.

If left blank, the current date is used as the default.

  
Comparison Date:  
3. Specify one of the following dates to compare from:

D = Due Date

I = Invoice Date

G = General Ledger Date

S = Statement Date

  

117.4 Customer Master Conversion (P0301E)

Processing Option Processing Options Requiring Further Description
UPDATE CONTROL:  
1. Enter a '1' to update Customer Master balances.

If left blank, Customer Master balances will not be updated.

  
DATE OPTIONS:  
2. Enter a date to be used as the exchange rate date.

If left blank, the current date is used as the default.

  
AMOUNT CURRENCY & CURRENCY CODE UPDATE:  
3. Enter a currency here to be updated to the Amount Currency in the Customer Master file.

If left blank, the Amount Currency will not be updated.

 This applies to the CRCA field in F0301 and indicates the currency that will be used to store amounts such as invoiced this year, invoiced prior year, credit limit, and so on.
4. Enter a currency here to be updated to the Currency Code in the Customer Master file.

If left blank, the Currency Code will not be updated.

 This applies to the CRDC field in F0301 and indicates the transaction currency for the customer.
ROUNDING FACTOR:  
5. Enter the desired rounding factor for the following limit fields:

Credit Limit

Minimum Order Value

Maximum Order Value

For example, a value of 100 will round the converted amount to the nearest hundred, 50 to the nearest 50, etc.

If left blank, limit values will not be rounded.

  

117.5 Global Update Customer Master (P03490)

Processing Option Processing Options Requiring Further Description
Enter the data value to be replaced or "plugged" into the selected Customer Master fields. (*BL = blanks): The following processing options are used to update specific fields in the Customer Master file with the data you indicate. All Customer Master records that are selected in Data Selection will be updated with these values. Verify the Data Selection on this Dream Writer prior to submitting the version. No fields will update where the processing option is left blank. To place a blank in one of the fields, use *BL.
1. Collection Manager  
2. Credit Manager  
3. Send Invoice To  
4. Send Statement To  
5. Payment Terms - A/R  
6. Alternate Payor  
7. Hold Invoices  
8. Payment Instrument  
9. Print Statement (Y/N)  
10. Auto Receipt (Y/N)  
11. Ledger Inquiry Sequence  
12. Auto Receipt Algorithm  

117.6 Global Update - A/R Company/Business Unit Defaults (P034905)

Processing Option Processing Options Requiring Further Description
Enter the data value to replace or be "plugged" into selected Customer Co/Bus. Unit file fields.

(*BL=Blank/Zeros)

 The following processing options are used to update specific fields in the Customer Company/Business Unit File with the data you indicate. All Customer Company/Business Unit records that are selected in Data Selection will be updated with these values. Verify the Data Selection on this Dream Writer prior to submitting the version. No fields will update when the processing option is left blank. To place a blank in one of the fields, use *BL.
1. Collection Manager  
2. Credit Manager  
3. Send Invoice To  
4. Send Statement To  
5. Payment Terms - A/R  
6. Special Factor/Payee  
7. Bank Type  
8. Payment Instrument  
9. Print Statement (Y/N)  
10. Delinquency Notice  
11. Apply Finance Charge  
12. Finance Charge Percentage  
13. Collection Report  
14. Tax Explanation Code  
15. Tax Rate Area  
16. Currency Code  
17. G/L Class  
18. Model JE Document Company

Model JE Document

Model JE Document Type

  
19. Default Rev Account Bus. Unit

Default Rev Account Object

Default Rev Account Subsidiary

  
20. Unapplied Cash G/L Class  
21. Invoice Method  
22. Reference  
23. Category Code 1  
24. Category Code 2  
25. Category Code 3  
26. Category Code 4  
27. Category Code 5  
28. Category Code 6  
29. Category Code 7  
30. Category Code 8  
31. Category Code 9  
32. Category Code 10  
33. Adjustment Schedule  
34. Customer Price Group  
35. Delivery Note  
36. Trade Discount  
37. Minimum Order Value  
38. Maximum Order Value  
39. Print Message  
40. Order Template  
41. Deliver Instructions 1  
42. Deliver Instructions 2  
43. Allow Backorders  
44. Substitutes Allowed  
45. Partial Line Shipments  
46. Partial Order Shipments  
47. Price Pick List  
48. Adjustment on Invoice  
49. Invoice Copies  
50. Held Orders Code  
51. Priority Code  
52. Apply Freight  
53. Freight Handling Code  
54. Route  
55. Stop  
56. Zone  
57. Preferred Carrier  
58. Display Weight UOM  
59. Display Volume UOM  
60. Commission Code 1  
61. Commission Rate 1  
62. Commission Code 2  
63. Commission Rate 2  
64. Tax Service Date Set  

117.7 Purge Closed A/R Records (P03800)

Processing Option Processing Options Requiring Further Description
Enter G/L Purge 'As Of' Date.