35
We have a lot of old purchase orders that we need to invoice. They have all been received in. Each time you go and invoice the PO it requires a Vendor Invoice No.. I am trying to create a report that we can run and have it add the vendor invoice no into each PO and auto increment the no. I was able to get it to add a vendor invoice no but can't get to increment the number for each new PO that we need to invoice. Is there a way to do this?
Thank you in advance.
*This post is locked for comments
Hi Mjcjyk,
My vote for No. Series as suggestions of AJ Ansari and Amol Salvi.
Take a look at NoSeriesManagement codeunit, GetNextNo function will provide you more information.
Vendor Invoice No is Code Field and I would suggest create one no series for get it increment automatically .
Hi mjcjyk,
Just a quick comment (if you know this already, you can skip to the next paragraph): The Vendor Invoice No. field is meant to be populated with the invoice number provided by the vendor so that it can be referenced at a later time in the Vendor Ledger Entries, payments, etc.
Assuming you're writing a Processing Report in NAV with Purchase Header as a dataitem, it should be pretty easy to create a variable of type Integer (let's say we call this variable VendInvNo), set it to a starting value of something like 10000, and then use it in the OnAfterGetRecord trigger set the value of the Vendor Invoice No., and then have it self-increment with a statement like:
VendInvNo := VendInvNo + 1;
That way, when the report loops back in with the next record, the next PO will get Vendor Invoice No 10001, and the next one gets 10002 and so on.
If you wish to make it alphanumeric, then you can follow the same concept but concatenate this variable with an alphabetical prefix (defined as a constant) before filling in the value in the Vendor Invoice No. field.
Or, you could also create a No. Series in NAV for it, then use the No. Series Management codeunit to find the next available number and use it (and the codeunit is responsible for autoincrementing).
I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (