Sharron
Member
RE: AR display error
Has anyone run into this? JDE tells me they have 'heard' of it happening,
but can't recreate it, although it happens to us consistently:
The issue is this: When the users enter a payment (example $400.00) and
then reverse the payment F13 function (again for $400) using P03103 Receipts
and Adjustment processing, instead of showing a 'Last paid amount of 0.00 or
even $400.00' in F0301 (Last Paid Amount A5ALP), it shows $800.00.
Here are some screen views:
Reversal of a paid item:
03103 Receipts Entry Prev Recpt:
Mode (F) . . D Display Acct 7679079
CAD
Action Code. . . . I xxxxxxxxxxxxxxxxxx Co 00001
Cheque/Ref.#. . . 789 Batch Number 1731267
Payment Amount . . 400.00 Bank Acct 900.1031 .G
Payment Date. . . 03/11/03 Remark . . . 17731381 (Sales Order)
Deposit Date (G/L) 03/11/03 Currency Code CAD
Skip to Due Date . Exchange Rate
Remaining on Recpt
T AR Docmt Pay Amount Discount Account Do Net Due Applied
I Number Itm Applied Taken Number Ty Date Amount
U 4227350 001 400.00 7679079 RU 03/11/03
400.00
All items (the R6 items add to 400) where the original payment was applied:
03103 Receipts Entry Prev Recpt:
Mode (F) . . D Display Acct XXXXX
CAD
Action Code. . . . I xxxxxxxxxxxx Co
00001
Cheque/Ref.#. . . 789 Batch Number 1731267
Payment Amount . . 400.00 Bank Acct 900.1031 .G
Payment Date. . . 03/11/03 Remark . . . 17731381 (Sales Order)
Deposit Date (G/L) 03/11/03 Currency Code CAD
Skip to Due Date . Exchange Rate
Remaining on Recpt
T AR Docmt Pay Amount Discount Account Do Net Due Gross
I Number Itm Applied Taken Number Ty Date Amount
4227350 001 400.00- 7679079 RU 03/11/03
400.00-
2663038 000 118.00 7679079 R6 03/11/14
118.00
2663038 001 50.00 7679079 R6 03/11/14
50.00
2663038 002 10.00 7679079 R6 03/11/14
10.00
2663038 003 222.00 7679079 R6 03/11/14
222.00
F4=Detail F15=Acct Inq F16=Ledger Inq F17=NSF F18=Parent Inq F19=Inv Inq
This video shows the wrong 'Last Paid' amount:
03203 Account Status Summary Mode - "As Of"
As of 03/10/31 Co
00001
Parent Number.
Customer Nmbr. 7679079 Credit Message . . .
xxxxxxx Temp Credit Message.
XXXXX
XXXXXXXXXXXXXXXXXX Future
CANADA Current
610.14
1 - 30
31 - 60
61 - 90
91 - 120
121 - 150
(450) 632-6567 151 - 999
Contact: Over 999
Total Open Amount. .
610.14
Average Days Late. . Credit Limit . . . .
1,500
First Invoice. . . . 03/10/30 Over Credit Limit. .
Invoiced This Year .
610.14
Last Paid. . . . . . 03/11/03 Invoiced Prior Year.
Last Invoice Date. . Last Paid Amount . .
800.00
Last Message . . . .
Amount Currency Code CAD Canadian
Dollars
F5=Contact Info F6=Memo F8=Cust Mast F16=Ledg Inq F24=More
Thanks!
Sharron
Superior Propane, Calgary
World, Cume13
To view this thread, visit the JDEList forum at:
http://www.jdelist.com/ubb/showflat.php?Cat=
&Board=W&Number=63562
This is the JDELIST World* Mailing List. To stop receiving these messages,
login to http://www.jdelist.com/forums <http://www.jdelist.com/forums> ,
click Control Panel, then click Edit by "Subscribe / Unsubscribe from
receiving board posts by email, change message notifications, etc." and
adjust your subscription preferences. JDEList is not affiliated with
JDEdwards®
Has anyone run into this? JDE tells me they have 'heard' of it happening,
but can't recreate it, although it happens to us consistently:
The issue is this: When the users enter a payment (example $400.00) and
then reverse the payment F13 function (again for $400) using P03103 Receipts
and Adjustment processing, instead of showing a 'Last paid amount of 0.00 or
even $400.00' in F0301 (Last Paid Amount A5ALP), it shows $800.00.
Here are some screen views:
Reversal of a paid item:
03103 Receipts Entry Prev Recpt:
Mode (F) . . D Display Acct 7679079
CAD
Action Code. . . . I xxxxxxxxxxxxxxxxxx Co 00001
Cheque/Ref.#. . . 789 Batch Number 1731267
Payment Amount . . 400.00 Bank Acct 900.1031 .G
Payment Date. . . 03/11/03 Remark . . . 17731381 (Sales Order)
Deposit Date (G/L) 03/11/03 Currency Code CAD
Skip to Due Date . Exchange Rate
Remaining on Recpt
T AR Docmt Pay Amount Discount Account Do Net Due Applied
I Number Itm Applied Taken Number Ty Date Amount
U 4227350 001 400.00 7679079 RU 03/11/03
400.00
All items (the R6 items add to 400) where the original payment was applied:
03103 Receipts Entry Prev Recpt:
Mode (F) . . D Display Acct XXXXX
CAD
Action Code. . . . I xxxxxxxxxxxx Co
00001
Cheque/Ref.#. . . 789 Batch Number 1731267
Payment Amount . . 400.00 Bank Acct 900.1031 .G
Payment Date. . . 03/11/03 Remark . . . 17731381 (Sales Order)
Deposit Date (G/L) 03/11/03 Currency Code CAD
Skip to Due Date . Exchange Rate
Remaining on Recpt
T AR Docmt Pay Amount Discount Account Do Net Due Gross
I Number Itm Applied Taken Number Ty Date Amount
4227350 001 400.00- 7679079 RU 03/11/03
400.00-
2663038 000 118.00 7679079 R6 03/11/14
118.00
2663038 001 50.00 7679079 R6 03/11/14
50.00
2663038 002 10.00 7679079 R6 03/11/14
10.00
2663038 003 222.00 7679079 R6 03/11/14
222.00
F4=Detail F15=Acct Inq F16=Ledger Inq F17=NSF F18=Parent Inq F19=Inv Inq
This video shows the wrong 'Last Paid' amount:
03203 Account Status Summary Mode - "As Of"
As of 03/10/31 Co
00001
Parent Number.
Customer Nmbr. 7679079 Credit Message . . .
xxxxxxx Temp Credit Message.
XXXXX
XXXXXXXXXXXXXXXXXX Future
CANADA Current
610.14
1 - 30
31 - 60
61 - 90
91 - 120
121 - 150
(450) 632-6567 151 - 999
Contact: Over 999
Total Open Amount. .
610.14
Average Days Late. . Credit Limit . . . .
1,500
First Invoice. . . . 03/10/30 Over Credit Limit. .
Invoiced This Year .
610.14
Last Paid. . . . . . 03/11/03 Invoiced Prior Year.
Last Invoice Date. . Last Paid Amount . .
800.00
Last Message . . . .
Amount Currency Code CAD Canadian
Dollars
F5=Contact Info F6=Memo F8=Cust Mast F16=Ledg Inq F24=More
Thanks!
Sharron
Superior Propane, Calgary
World, Cume13
To view this thread, visit the JDEList forum at:
http://www.jdelist.com/ubb/showflat.php?Cat=
&Board=W&Number=63562
This is the JDELIST World* Mailing List. To stop receiving these messages,
login to http://www.jdelist.com/forums <http://www.jdelist.com/forums> ,
click Control Panel, then click Edit by "Subscribe / Unsubscribe from
receiving board posts by email, change message notifications, etc." and
adjust your subscription preferences. JDEList is not affiliated with
JDEdwards®