Is Invoice tagging possible in NAV 2013?

(0) Share

Report

Posted on by Community Member

Hi All,

This blog is amazingly helpful and have been always informative. I need some help to resolve this query, I am working in NAV 2013.

Query:

Is there a way to "tag" a posted invoice/credit memo so that we can track which ones have been included in a VAT return?

We have approximately 700 invoices/credit memos posted for one of our clients over the last several months. These invoices/credit memos have now been included in a VAT return and we want to be able to "tag" them so that when the next VAT return is due we can tell which invoices/credit memos have already been included in the previous VAT return.

This "tag" could be as simple as a tick in a box.

Obviously we have the ability to add notes to items in NAV, which could meet this need, but doing this manually for hundreds of invoices is too impractical (unless this could be done via a mass import), Do we have any such functionality in NAV which could meet such requirement.

Many Thanks,

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

It depends how you process VAT returns in the system - manually or automatically. Which localization do you use? Normally, standard NAV has a functionality of VAT returns that transfer the unrealized VAT to realized VAT and later on those invoices are no longer appear in the next session of return.

One option to know quickly which invoices are still not VAT-returned is to take the turnover over debit and credit of VAT account for the period to Excel and plot a Pivot-table by Document No. and Amount. Those invoice numbers for which the VAT return has been applied, would eliminate each other and give zero; other non-zero result would give you the list of invoices which were not yet processed for VAT return.

Otherwise, you can utilize any of the unused checkboxes or create your own if you have access to development environment.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Alexander,

Thank you so much for replying. It's UK localization I am talking about, I will try the option you have mentioned above however I was also trying to find if there are any checkboxes/options in Navision 2013 which could be utilized for this purpose (just to tag those invoices )

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (1)

Report

If you talk about more or less safe option for e.g. posted sales invoices, there is a Comment boolean field which you might make editable on the page with Posted Sales Invoices list (the field by default is not present on the page) for Sales Invoice Header table. However for that particular purpose I would recommend to add a new boolean field to Sales invoice header table and not use existing ones.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Alexander, this was indeed helpful to know there are possible ways to do so.

Was this reply helpful? Yes No

Community site session details

Is Invoice tagging possible in NAV 2013?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates

Community site session details

Is Invoice tagging possible in NAV 2013?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates