SOP ORDER NUMBER EQUALS INVOICE NUMBER

[KGakhal]

List we are investigating the possibility of making the invoice number equal the sales order number. Is anyone aware of the settings required to enforce this? Is this possible?

Thanks in advance,

 

[malaia]

Out of the box, JDE has different sequence. Best practice is to seperate this two. The reason is, there could be invoices without sales orders i.e. straight invoices from G03B11.

I have been in clients, where they wanted sales order number to be equal to invoice and the only reason for this was, that was how their legacy system worked... and easy from them to have one number.. those are not good enough reason to mod the system... SO # is linked to Invoice number in F4211 (SO detail) so the cross referance is maintained.

Answer to your question is - it can be done... but you have to very careful

steps:

1. In next numbers bump invoice (03B system) sequence to high number - probably 1,000,000

2. Have SO sequence low - probably 100

3. Mod the invoice program - R42565 and assign invoice number to be same as SO number

Things to watch out is - once the SO number sequence starts to overlap invoice sequence you have to rethink this and probably do another mod.

I would strongly recommend not to do this mod.

Malai Annamalai
Deloitte & Touche
San Francisco

 

[Mike Dupaix]

As F03B11 is a multi-keyed table (CO, DOC, Date),
there is little chance of numbers ever duplicating.
It is possible to assign invoice numbers to Sales
Order lines before shipping and invoicing. The end of
day processing evaluates the invoice number field. If
it is blank, a number is retrieved from NN 03(B). If
an invoice number is filled, F03B11 is evaluated to
see if an invoice number exists. If there is an
invoice with the same SO number, a suffix number is
added (001, 002) to create a differentiator from the
first invoice instance.
--- malaia <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=Apps&Number=48724


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



World, OW B733X and Xe