Purchase order and purchase invoice numbers

Calvin

Is there anyway, short of rewriting the whole background code, to link the purchase order and purchase invoice numbers to be the same.

stamen

You can enter one Number Series for both documents

horrigan

Using the same no. series would not be enough: in this case, the invoice would have the next unused no. in the series NOT the same no. as the invoice.

You wouldn't have to rewrite the posting routine in this case: just a few lines in a few codeunits. This is not a huge project, though frankly I don't see what the point of it is :-)

The hard part would be figuring out what to do if an invoice already has the invoice no. you want the order to use. (This could happen if someone creates an invoice without creating an order first.) Using a common no. series for both type of sales documents is one way to avoid this problem.

---

Tim Horrigan, NCSD
<Horrigan@AOL.com>

Currently in search of new employment!

Certified as a Solution Developer and an HR/Payroll Specialist!

Dave_Cox

Navisions Purchase Order System allows for Part Invoicing what would happen in this Case navision would Issue a second Invoice Number for the second Invoice.

You can use the same number series for all 3 Order,Invoice & Posted Invoice the only code you would need to write would be at Table Level Assign the "Posting No Series" the Same as the "No Series" and populate the "Posting No." with the "Order No.".

When Navision Posts it will use the "Posting No." if it is pre assigned, if it is a partial invoice it will empty the field and re-assign a new "Posting No." when you post the remaining Invoice values.

What you may have noticed that if your lines cause an error on posting the "Posting No." and "Shipping No." or "Receipt No." has already been assigned in codeunit 80/90 which does a COMMIT before processing the lines.

If it is a week later you post the Order yu will find it will use the old Document Numbers.

Jesse_Rogers

A problem with populating the Posting No. field from code on the table is Navision will ask if you want to keep the document when you delete it (so your posted tables could easily fill with junk deleted docs). Better to populate the field in the posting code unit.

---

Project Manager
Deloitte Touche Tohmatsu
Sydney, Australia

Dave_Cox

Quote:
A problem with populating the Posting No. field from code on the table is Navision will ask if you want to keep the document when you delete it

Jesse

That is exactly right, for reasons of audit trail (no missing Invoice numbers)that you should populate the fields as in my previous answer!

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk