[Liz McQuiston]

Is there an easy way (non developer involvement) that I as an end user can change the “No. Printed” on a handful of Posted Sales Invoices?  These invoices are all from 2016, they were final invoicing after a prepayment (so a zero balance invoice).  We use Zetadocs to batch send our invoices at the end of the day and these always come up as needing to be sent, but won’t send because of some tax issue, which we can’t correct now that it’s posted.  I can’t delete them as they haven’t been printed.  We are on NAV 2016.

——————————
Liz McQuiston
Corporate Controller
Superior Walls of America
New Holland PA
Running NAV 2016
——————————

[Cynthia Priebe]

Liz,

If I understand you correctly, getting these documents to indicate they are printed would solve your issues, correct?  If so, go to the Posted Sales Invoice List, filter to No. Printed = 0, and a date range targeting these older invoices. Highlight the filtered records on the list page. Go to Send in the Ribbon, select Print and a PDF printer, save the document. 

When I did this all the documents in my filtered were gone. All these documents now indicate they have printed.

Please confirm I understood the issue and that this resolves the problem.

——————————
Cynthia Priebe MCP, ACP
Senior Analyst and Project Manager
Liberty Grove Software
——————————
——————————————-

[Liz McQuiston]

Thank you you did understand my issue, and I have tried what you suggested – unfortunately it? won’t work as I have the added tax issue.  I get an error “Tax Group Code must have a value in sales invoice line: {reference to document number and line number}. It cannot be zero or empty.”  The line it references is the prepayment line where the tax group code did not populate, I can’t change this as its a posted document.

——————————
Liz McQuiston
Corporate Controller
Superior Walls of America
New Holland PA
Running NAV 2016
——————————
——————————————-

[Cynthia Priebe]

Very odd that it would be validating this on printing.  Sorry I missed this big part of your post when I responded.

——————————
Cynthia Priebe MCP, ACP
Senior Analyst and Project Manager
Liberty Grove Software
——————————
——————————————-

[Lewis Rosenberg]

I’m afraid you’ll need a Solution Developer license to update that.

I tried creating a simple process report using an Application Builder license, but since they are posted documents, they cannot be changed.  With the right license, you can probably go right into the object designer to update the records.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

———————————————–

BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

@RosenbergL
https://www.linkedin.com/in/rosenbergl/
——————————
——————————————-

[Geovanny Fuentes]

What I see is you need to add a value to a posted header/line table?

If this is the issue and without a developers license, you may go to the SQL table directly and add the correct value to the Header/Line records.

Then you should be ok. Always avoid going to the backend tables doing things is my suggestion. 

But I understand your situation, or you can contact your VAR to do the same thing within NAV.

Good luck.

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-