This chapter contains these topics:
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 |
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. |
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 |
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. |
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 |
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 |
Processing Option | Processing Options Requiring Further Description |
---|---|
Enter G/L Purge 'As Of' Date. |