Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

(0) Share

Report

Posted on by Alex A

2,453

Hello Expert Problem Solvers,

We have a need to print a lot of old invoices. I was able to produce a list of the Posted Sales Invoice numbers to print (that have all the Items of interest for the date range requested). The issue is there are too many invoices to print manually, and the invoice numbers will not be in a sequential range.

*I need a clever way to batch print all these invoices from the list of invoice numbers.

An idea I've entertained for the solution so far is to use a windows macro to copy one invoice number off the top of the list into NAV and print, delete the top row off the list and repeat... but I'm not sure yet.

If you've done this before or have a clever idea please let me know.

Thank you very much.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Andrea Antoniazzi 285 on at

Like (1)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

Hi Alex A,

when you print a document you can click on Print - Schedule in order to insert a new record in the job queue.

Maybe you can try to use an XmlPort for insert in the job queue one record for each invoice.

Was this reply helpful? Yes No
Alex A 2,453 on at

Like (0)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

Thank you all. I was hoping for a non C/AL development type solution, but there seems to be a consensus of doing this by developing a code unit that loops through the invoice numbers stored in a table and prints. This is a good idea.

There will be too many invoices for the alternate options. We are currently looking at using a windows macro to copy each invoice number from the list and print it from NAV, but we have not done anything yet. I was also considering scripting this in VB and trying to hook into NAV, but perhaps a custom C/AL code unit is the straightforward solution. Thank you Rabindra for making the suggestion first. I will be considering this as an option if we do not find another way.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

I guess you are as usual searching for a non-developer, but a good user solution :-).

There is one option to create a longer filter of invoice numbers using "|" and put it in the No. field before printing in the report selection window. You can create such filter easily by copypasting it from Excel into notepad and replacing the spaces by "|".

So, you can copy numerous invoice numbers and put them in the No. field - it can speedup the manual printing process significantly.

Was this reply helpful? Yes No
Andrea Antoniazzi 285 on at

Like (0)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

Hi Alex A,

the list of the invoices is in Nav or out of the system (notepad, excel...)? How many documents do you have to print?

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,330 Super User 2025 Season 2 on at

Like (0)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

Hi,

If I understand you correctly you want to print a Report for posted invoices which are lets says before 01/01/2009. (just an example).

IF that is the case then you can just run the report and filter on request page as posting date <=01/01/2009

But if you even the selected invoices then the best way is -

1. Create a table with one field Invoice No.

2. Insert all invoice no in that table, using xmlport / rapid start.

3. Once import Run a codeunit which takes the no from it and applies that as a filter to report and print it.

If you want to do it automatic make sure you specify the printer for the report in Printer selection so it automatically takes that.

Let us know if any issues.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

You need to write a program/report to print all the document in batch.

You can look at the new version of Navision where in navision provided batch posting of Invoices .This will give you an idea.

Was this reply helpful? Yes No
Verified answer

Rabin 2,976 on at

Like (1)

Report

RE: Batch Print Old Invoices from a List of Posted Sales Invoice Numbers

Hi Alex,

You can use Job Queue. Write a function that keeps the loop until all the listed documents are printed out.

you can hardcode the list or create a table temporarily with all the invoice numbers.

I had once worked on a similar case where, each invoice had to be sent to its respective assigned contact email address.

But here in your case you do not need to worry about the order or recipient., just print in a loop...

Was this reply helpful? Yes No