• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

URGENTish HELP NEEDED

Euroboy

Active Member
Can anyone tell me if it is possible to track entries in the F0311 file (A/R ledger) to the sales details made / invoiced.

If you can track it back, can you tell me what the link is (fields??)

Thanks


None
 

scott_parker

Reputable Poster
You can use the F42119 (sales History Detail file) the fields SDDOC and SDDCT should be your Invoice Number and Type. (RPDOC and RPDCT)

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
 

sdollard

Active Member
If I am not mistaken the orignal sales order number is in RPODOC/RPODCT and
you can use that to retreive sale information from the F42119 sales history
or the F4211.

Steve
 

dale_draper

Well Known Member
If there is only one item per invoice, it would be possible by linking to
the sales detail file (F42119). But if you have more than one item on an
invoice, it become useless as the cash cannot be applied by line # against
the invoice. And besides, the customer is not paying off item X or Y when
partial payments are made. (usually) And it certainly is not notated on the
payment.


>
 

Euroboy

Active Member
Thanks people for the help ...

But the situation is that I may have more than one order line for the invoice, which i suppose could relate to the same sales order. So if i wanted to get to the actual sales order line that the F0311 relates to, am I right in thinking that I cannot do it ---- Well looking at the answers??

TIA

None
 

sdollard

Active Member
You could use the Item number RPNUMB and line number RPLNID to get to the
exact line on the sales order number. If i remember correctly, my current
client is using One world A/R so its a little fuzzy!! Hope this helps

Steve
 

scott_parker

Reputable Poster
I just looked in our F0311 and RPNUMB as well as RPLNID is never filled in.
I am not very good with the F0311 but it does make me wonder WHY.

To answer the threads question.
I can not see any way to relate it back to a specific LINE on a sales order.

As was said before, When an invoice is created it is not usually Item Specific so that information is not tracked in the F0311.

(even though the fields to track it are there.)

Perhaps someone else can say Why those fields are not populated?? (a question for JDE Support??)

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
 

hiranmoy

Member
In Sales Update Program - P42800 , processing option 10 controls whether
F0311 will be populated with detail (i.e SO line detail) or summarized. If
you want detail record to be written in F0311.

Hiran


>From: euroboy <sabirpatankar@excite.co.uk>
>Reply-To: jdeworld@jdelist.com
>To: jdeworldml@jdelist.com
>Subject: Re: URGENTish HELP NEEDED ~~1417:1427
>Date: Mon, 20 Nov 2000 08:41:53 -0800 (PST)
>
>Thanks people for the help ...
>
>But the situation is that I may have more than one order line for the
>invoice, which i suppose could relate to the same sales order. So if i
>wanted to get to the actual sales order line that the F0311 relates to, am
>I right in thinking that I cannot do it ---- Well looking at the answers??
>
>TIA
>
>None
>--------------------------
>Visit the forum to view this thread at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=1427
>*************************************************************
>This is the JDEList World Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.
 

scott_parker

Reputable Poster
AHhhhh theres where the link is.

If you are doing "Detail" then I guess Many more records are written to the F0311????

Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R4 (soon to be V4R5)
 

zuccoa

Active Member
R:URGENTish HELP NEEDED

It seems to me that you could get your goal by linking F0311/RPSDCT+RPSDOC
to F4211/SDDCTO+SDDOCO; these fields contain the Sales Order Number + Type.

Besides, you can get a further confirmation by comparing (or joining)
F0311/RPDCT+RPDOC to F4211/SDDCT+SDDOC; these will show you the Invoice
Number + Type.

If your system is set up in way that you don't keep your closed order into
F4211, then move your attention to F42199 and change the field names from
SDxxxx to SLxxxx; in this last case if you've purged your F42199 history
... sorry, but I don't know how to help you !!!

A.Zucconi
TUBILUX PHARMA Spa
IS Manager

----------
Da: euroboy[SMTP:sabirpatankar@excite.co.uk]
Risposta a: jdeworld@jdelist.com
Inviato: lunedi 20 novembre 2000 16.57
A: jdeworldml@jdelist.com
Oggetto: URGENTish HELP NEEDED ~~0:1417

Can anyone tell me if it is possible to track entries in the F0311 file
(A/R ledger) to the sales details made / invoiced.

If you can track it back, can you tell me what the link is (fields??)

Thanks


None
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Numbe
r=1417
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

zuccoa

Active Member
R:URGENTish HELP NEEDED

I'm not sure about that : if you start your process from the Sales side
(F4211 or F42199) you should ALWAYS be able to get the most detailed point
of view, i.e. you will find more than one record in those files with the
same values in their SDDCT+SDDOC fields (Invoice number); in this case
summarize these records and you can match to F0311 once again.

Did I miss something in your question ?

Andrea

----------
Da: euroboy[SMTP:sabirpatankar@excite.co.uk]
Risposta a: jdeworld@jdelist.com
Inviato: lunedi 20 novembre 2000 17.41
A: jdeworldml@jdelist.com
Oggetto: Re: URGENTish HELP NEEDED ~~1417:1427

Thanks people for the help ...

But the situation is that I may have more than one order line for the
invoice, which i suppose could relate to the same sales order. So if i
wanted to get to the actual sales order line that the F0311 relates to, am
I right in thinking that I cannot do it ---- Well looking at the answers??

TIA

None
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Numbe
r=1427
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Top