Edit Posted Invoice?

slmaluwa

Hi again
We ran into a trouble when we posted an order. By OUR mistake, NAV took the wrong invoice number and we are trying to find a way to EDIT the number of posted invoice?

The developer says it is NOT possible? but, our management insists on changing it otherwise we may have to answer lot of unnecessary questions from Auditors and TAX people.

Anyway to do this?

upasanisandip

Hi,

I knows some tables which affects after posting.

Sales Invoice Header
Sales Invoice Line
Customer Ledger Entry
Detailed Customer Ledger Entry
Tax Entry
Value Entry
G/L Entry

You have to make change in these tables.

slmaluwa

hi

I tried opening the table in Designer and try to make the change. It gives the following error:

The fild below must be included in the table's primary key.

Field: Sell-to Customer Name
Table: Sales Invoice header

Any idea? I am not a NAV developer :shock:

Maarten_Gerritsen

'funny' how auditors 'force' you to mess with data.

The error is caused by someone who messed with the objects before you try to 'fix' the data. Get a developer to solve this.

Tip: to be sure which records to adjust, run the Navigate function with the Invoice number you want to change: you will get an overview of all entities (ledgers).

diptish.naskar

Changing the No. is not going to be an easy task, but yes it is possible to do the same.

First you need to find out where the reference of the same are present in the system. To some extent yes, navigate function is going to tell you where the Invoice has hit, but not all the tables are displayed, there are some other table also which you need to consider like, posted document dimension.

Maarten_Gerritsen

You are right. Not all tables are covered with the Navigate function, eg. the Document Dimension. Also the Invoice lines are not displayed directly by the Navigate function. It just gives you a rough idea of which tables are 'touched'.