What is the Document Pay Item field in Customer Ledger F03B11

Jeremy Biros

Well Known Member
My apologies if this is a dumb question, but can anyone briefly explain to me what the "Document Pay Item" field (RPSFX) means in the Customer Ledger table F03B11? I haven't worked with this before. Thanks, Jeremy.
 
Is it just the number of payments that are made based on split payments value in the Payment Terms Code table?
 
A invoice issue to a customer can be made up of a number of billing
lines
each line is assigned a different pay item, it is possible to treat the
individual line within an invoice differently

e.g. you have the option to receive payments at different times against

individual billing lines, if a billing line represents different good,
or different service periods

you can use the summarise option in invoice entry to view the data
without pay lines


Regards

Jason Kearns

Corporate Support (Operations)
Extn: 2773
 
No, the RPSFX are coming from invoices that generated from sales, not
payment related. payment information are kept in F03B13 and F03B14. F03B11
is majorly for invoices information, it uses RPSFX to identify different
lines in one invoice to make it unique.
Thanks,
Jennifer Qiu





"Jeremy Biros"
<JBiros@woodard-fur To: [email protected]
niture.com> cc:
Sent by: Subject: Re: What is the Document Pay Item field in Customer Ledger F03B11
jdelist-bounces@jde
list.com


04/06/2005 09:56 AM
Please respond to
"JD Edwards®
EnterpriseOne"






Is it just the number of payments that are made based on split payments
value in the Payment Terms Code table?


OneWorld XE, NT, SQL Server 2000
 
Re: RE: What is the Document Pay Item field in Customer Ledger F03B11

[ QUOTE ]
A invoice issue to a customer can be made up of a number of billing<br>lines<br>each line is assigned a different pay item, it is possible to treat the<br>individual line within an invoice differently<br><br>e.g. you have the option to receive payments at different times against<br><br>individual billing lines, if a billing line represents different good,<br>or different service periods<br><br>you can use the summarise option in invoice entry to view the data<br>without pay lines <br><br><br>Regards<br><br>Jason Kearns<br><br>Corporate Support (Operations)<br>Extn: 2773<br><br>

[/ QUOTE ]

So, when we have Payment Terms that allow for 3 split payments, we see 3 customer ledger records, with RPSFX of 001, 002, & 003 respectively. If the Payment Terms allow for 2 split payments, we see 2 customer ledge records with RPSFX of 001 & 002. The reason I am asking is, we are way behind on SARS and updates, and for Pay Terms allowing multiple/split payments, our version of XE is not automatically generating the correct number of Customer Ledger records (only one record is generated). We created a simple UBE that checks for this problem, updates the existing Cust Ledg record and inserts one or two more depending on the number of Split Payments allowed for that Pay Terms Code. I just noticed that it was inserting 002 and 003 by default for these extra records and wondered if it was suppposed to actually be based on a line number or something else other than just always using 002 and 003. Hope this explains my question better. Thanks again, Jeremy.
 
Re: RE: What is the Document Pay Item field in Customer Ledger F03B11

I think it's fine to assign a sequence number like 002, 003 to this field.
The main purpose for setting up this field is to make the different invoice
line unique, so no need to make a more complicate logic here.

Just my two cents.
Jennifer Qiu
SC NAIT
(847) 948-2535




"Jeremy Biros"
<JBiros@woodard-fur To: [email protected]
niture.com> cc:
Sent by: Subject: Re: RE: What is the Document Pay Item field in Customer Ledger F03B11
jdelist-bounces@jde
list.com


04/06/2005 10:30 AM
Please respond to
"JD Edwards®
EnterpriseOne"






Quote:
A invoice issue to a customer can be made up of a number of
billing
lines
each line is assigned a different pay item, it is
possible to treat the
individual line within an invoice
differently

e.g. you have the option to receive payments at
different times against

individual billing lines, if a billing
line represents different good,
or different service
periods

you can use the summarise option in invoice entry to
view the data
without pay lines


Regards

Jason
Kearns

Corporate Support (Operations)
Extn: 2773






So, when we have Payment Terms that allow for 3 split payments, we see 3
customer ledger records, with RPSFX of 001, 002, & 003 respectivel! y. If
the Payment Terms allow for 2 split payments, we see 2 customer ledge
records with RPSFX of 001 & 002. The reason I am asking is, we are way
behind on SARS and updates, and for Pay Terms allowing multiple/split
payments, our version of XE is not automatically generating the correct
number of Customer Ledger records (only one record is generated). We
created a simple UBE that checks for this problem, updates the existing
Cust Ledg record and inserts one or two more depending on the number of
Split Payments allowed for that Pay Terms Code. I just noticed that it was
inserting 002 and 003 by default for these extra records and wondered if it
was suppposed to actually be based on a line number or something else other
than just always using 002 and 003. Hope this explains my question better.
Thanks again, Jeremy.


OneWorld XE, NT, SQL Server 2000



The entire JDELIST thread! is available for viewing.



Looking for a job? Check out the Job Opportunites forum

This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing
list are available here.
JDELIST is not affiliated with JDEdwards®.







The information transmitted is intended only for the person(s)or entity
to which it is addressed and may contain confidential and/or legally
privileged material. Delivery of this message to any person other than
the intended recipient(s) is not intended in any way to waive privilege
or confidentiality. Any review, retransmission, dissemination or other
use of , or taking of any action in reliance upon, this information by
entities other than the intended recipient is prohibited. If you
receive this in error, please contact the sender and delete the
material from any computer.

For Translation:

http://www.baxter.com/email_disclaimer
 
RE: RE: What is the Document Pay Item field in Customer Ledger F03B11

Quote
So, when we have Payment Terms that allow for 3 split payments, we see 3
customer ledger records, with RPSFX of 001, 002, & 003 respectivel! y.
If the Payment Terms allow for 2 split payments, we see 2 customer ledge
records with RPSFX of 001 & 002.

Yes this is the way it should work, so that when you receive 3 different
payments for the same invoice
at 3 different times you have 3 AR lines with open AR amounts to match
against them, normally the reason for this is that you have different
due
dates on the invoice lines, so you have a more accurate picture of
overdue and outstanding debtors.



Regards

Jason Kearns

Corporate Support (Operations)
Extn: 2773
 
Re: RE: RE: What is the Document Pay Item field in Customer Ledger F03B11

Thank you everyone for clearing this up for me. Jeremy
 
A invoice issue to a customer can be made up of a number of billing
lines
each line is assigned a different pay item, it is possible to treat the
individual line within an invoice differently

e.g. you have the option to receive payments at different times against

individual billing lines, if a billing line represents different good,
or different service periods

you can use the summarise option in invoice entry to view the data
without pay lines


Regards

Jason Kearns

Corporate Support (Operations)
Extn: 2773

Hello Jason,
Is there any other option (other that summarise) to view the data without pay lines?
Thanks
 
Back
Top