xuyang400
Member
Dear All:
I use P035001 to produce some reports and found the following information at the bottom of each page:
ACCOUNT SUMMARY
---------------
Open Amount - as of 09/30/01
New Invoices
Discounts Taken
Payments Received - Thank You
Adjustments
Current Balance Due
Payment Terms: 45 day + 7 day
My question is : How did system get the date of '09/30/01', where did it come from? I try to change the processing options and also check the company constants but nothing changed on my report. Can someone here give me a hand?
The following is my processing options: Sorry for the long mail.
1. Enter a '1' to run the statements
in final mode. If left blank, the
statements will be run in proof mode
and no updates will occur.
COMPANY CONSOLIDATION:
2. Enter a company to be used for the
'Remit To' company, aging constants
and/or special text when performing
company consolidation. If left
blank, separate statements will be
printed per company.
3. Enter a '1' to rebuild the temporary 1
A/R Credit/Cash Management work file
(F0315WJA) prior to printing A/R
statements. The Based On File must
be F0315WJA. If left blank, the
existing Credit/Cash Management file
(F0315JA) will be used.
4. Enter a '1' to include zero open 1
balance records when rebuilding the
temporary A/R Credit/Cash Management
work file (F0315WJA).
5. Enter a '1' to retrieve the aging
specifications and statement date
from A/R Company Constants, ignoring
the following options 4 through 7.
Leave blank to use the following
processing options 4 through 7 to
specify the statement date and
aging.
6. Enter the statement date. Open 12/31/01
balances are aged as of this date
and detail records are selected
based on this date.
7. Specify the date from which to age I
open balances:
D = Due Date (default)
I = Invoice Date
G = General Ledger Date
S = Statement Date
8. Specify the method for defining aging 1
categories:
1 = Aging Days (default)
2 = Fiscal Periods
3 = Calendar
9. If using the Aging Days method, enter -
the aging day ranges:
Beginning 0
thru 30
thru 60
thru 90
thru 120
thru
10. Enter a '1' to apply credits to the
current aging balance. Leave blank
to age credits.
11. Enter the version number for the ZJDE0001
F0311 selection and sorting DREAM
Writer (Form ID P03500X). If left
blank, version 'ZJDE0003' will be
used. See program helps for more
information.
12. Enter a '1' to exclude future 1
amounts.
13. Enter a '1' to exclude paid
invoices. Blank will print paid
invoices with current activity.
14. Enter a '1' to process with multi-
currency. Leave blank to process
statements in domestic currency
only.
15. Specify the date to be used to
select detail records. This date
will be compared to the Statement
Date:
D = Due Date
I = Invoice Date
G = General Ledger Date
S = Statement Date
Leave blank to use aging date.
PRINT FORMAT: -
16. Enter a '1' to print aging
information on the statement.
17. Enter a '1' to suppress printing
the account summary information
at the end of the statement.
18. Enter a '1' to print the invoice
date on the statement. Leave blank
to print the due date.
19. Enter a '1' for RIBA draft format.
Leave blank for standard format.
20. Enter a '1' to print the following -
at the top of each statement:
Statement Number . . . .
Remit To Address . . . . 1
21. Specify which address is used as the 200001
"Remit To" address:
blank = Company (default)
A = 1st Address Number
B = 2nd Address Number
C = 3rd Address Number
D = 4th Address Number
E = Factor/Special Payee
F = 5th Address Number
address = address entered +
22. Enter a '1' to summarize each
invoice on a single detail line.
Leave blank to print each pay item
on a separate detail line.
STATEMENT NUMBER UPDATE:
23. Enter one of the following values
to update the statement number
in the A/R Ledger file:
' ' = Always update statement number
'1' = Never update statement number
'2' = Update only blank statement
numbers
And I also copy the data selection and past that below:
A/R Stmts - With Credit Mgmt File Build
I Explanation . . Selection . .
N Rel. Value
Y Statement Cycle. . . . . . . . . . . . . EQ *ALL
And Y Parent Child Relationship. . . . . . . . EQ *BLANK
And Y Print Statement (Y/N). . . . . . . . . . EQ Y
And Y Company. . . . . . . . . . . . . . . . . NE 00000
And Y Address Number . . . . . . . . . . . . . EQ *RANGE
Thanks in advance!
I use P035001 to produce some reports and found the following information at the bottom of each page:
ACCOUNT SUMMARY
---------------
Open Amount - as of 09/30/01
New Invoices
Discounts Taken
Payments Received - Thank You
Adjustments
Current Balance Due
Payment Terms: 45 day + 7 day
My question is : How did system get the date of '09/30/01', where did it come from? I try to change the processing options and also check the company constants but nothing changed on my report. Can someone here give me a hand?
The following is my processing options: Sorry for the long mail.
1. Enter a '1' to run the statements
in final mode. If left blank, the
statements will be run in proof mode
and no updates will occur.
COMPANY CONSOLIDATION:
2. Enter a company to be used for the
'Remit To' company, aging constants
and/or special text when performing
company consolidation. If left
blank, separate statements will be
printed per company.
3. Enter a '1' to rebuild the temporary 1
A/R Credit/Cash Management work file
(F0315WJA) prior to printing A/R
statements. The Based On File must
be F0315WJA. If left blank, the
existing Credit/Cash Management file
(F0315JA) will be used.
4. Enter a '1' to include zero open 1
balance records when rebuilding the
temporary A/R Credit/Cash Management
work file (F0315WJA).
5. Enter a '1' to retrieve the aging
specifications and statement date
from A/R Company Constants, ignoring
the following options 4 through 7.
Leave blank to use the following
processing options 4 through 7 to
specify the statement date and
aging.
6. Enter the statement date. Open 12/31/01
balances are aged as of this date
and detail records are selected
based on this date.
7. Specify the date from which to age I
open balances:
D = Due Date (default)
I = Invoice Date
G = General Ledger Date
S = Statement Date
8. Specify the method for defining aging 1
categories:
1 = Aging Days (default)
2 = Fiscal Periods
3 = Calendar
9. If using the Aging Days method, enter -
the aging day ranges:
Beginning 0
thru 30
thru 60
thru 90
thru 120
thru
10. Enter a '1' to apply credits to the
current aging balance. Leave blank
to age credits.
11. Enter the version number for the ZJDE0001
F0311 selection and sorting DREAM
Writer (Form ID P03500X). If left
blank, version 'ZJDE0003' will be
used. See program helps for more
information.
12. Enter a '1' to exclude future 1
amounts.
13. Enter a '1' to exclude paid
invoices. Blank will print paid
invoices with current activity.
14. Enter a '1' to process with multi-
currency. Leave blank to process
statements in domestic currency
only.
15. Specify the date to be used to
select detail records. This date
will be compared to the Statement
Date:
D = Due Date
I = Invoice Date
G = General Ledger Date
S = Statement Date
Leave blank to use aging date.
PRINT FORMAT: -
16. Enter a '1' to print aging
information on the statement.
17. Enter a '1' to suppress printing
the account summary information
at the end of the statement.
18. Enter a '1' to print the invoice
date on the statement. Leave blank
to print the due date.
19. Enter a '1' for RIBA draft format.
Leave blank for standard format.
20. Enter a '1' to print the following -
at the top of each statement:
Statement Number . . . .
Remit To Address . . . . 1
21. Specify which address is used as the 200001
"Remit To" address:
blank = Company (default)
A = 1st Address Number
B = 2nd Address Number
C = 3rd Address Number
D = 4th Address Number
E = Factor/Special Payee
F = 5th Address Number
address = address entered +
22. Enter a '1' to summarize each
invoice on a single detail line.
Leave blank to print each pay item
on a separate detail line.
STATEMENT NUMBER UPDATE:
23. Enter one of the following values
to update the statement number
in the A/R Ledger file:
' ' = Always update statement number
'1' = Never update statement number
'2' = Update only blank statement
numbers
And I also copy the data selection and past that below:
A/R Stmts - With Credit Mgmt File Build
I Explanation . . Selection . .
N Rel. Value
Y Statement Cycle. . . . . . . . . . . . . EQ *ALL
And Y Parent Child Relationship. . . . . . . . EQ *BLANK
And Y Print Statement (Y/N). . . . . . . . . . EQ Y
And Y Company. . . . . . . . . . . . . . . . . NE 00000
And Y Address Number . . . . . . . . . . . . . EQ *RANGE
Thanks in advance!