Deleting a Posted Invoice from Navision Database

Farukca

Hi,
I have to write an add-on to delete a posted invoice from navision database. I don't know how can I do that. In fact I could not find out which tables will affect while deleting.
If you have any idea or have document; please send it to me.
Here is my mail : "farukca2000@yahoo.com"
Thanks...

Savatage

Why would you want to do something like that?

It wouldn't be good accounting. If you accidentally posted an invoice in error i would create a cedit memo "copy document" & be done with it.

Actually erasing all item entries, customer ledger entries, general ledger entries, sales invoice header, sales invoice line, posted packages, etc is a huge deal.

Savatage

----continued (sorry)

That's even if you could do it. You mention you don't even know how to - even the most seasoned navision pro would not look forward to attempting this.

......but maybe i'm wrong

alberto

I think that in many countries it's illegal. :shock:
You CAN'T delete posted invoice! :shock:
You can only do a Credit Memo (agreeing with Savatage).

Regards
Alberto

Farukca

Hi,
Deleting a Posted Invoice is not illegal in here.
I must do this because the company don't want see " the cancelled invoices " in its endorsement. You know if we make a Credit Memo for a cancelled Invoice, The endorsement of the company will rise.
Thats the main idea.

Thanks for the answers;
Bye

navi-man

Faruk,

You a in the dangerous position.

If you tell the customer that you do not know how to do it, they will answer that you are bad IT, and Navision is crap, they could do it easily in the old software, and so on...

It is their problem when they make data entry mistake and there is standard navision procedure for correcting it.

Do not believe them when they want to hide heir mistake . Is should be visible.

Company will not improve "goodwill" by irregular procedures, but with standardized business procedures.


It is not a problem to find the right tables and to delete posted invoice, but bad things will happen later, and you will be in the deep sh....

Suddenly you will notice stock value discrepanies, missing dimension values, and etc..

You are just not experienced enought to deal with this issue.

If you just want to delete invoice in past and closed year, it is not a problem, and I can teach you how.

ajayjain

Hi,

You can delete Posted Invoice if you want to but whenever you delete a posted document , you will need a developer license. I have made a small function to delete posted entries/documents. if you need let me know

RobertMo

I agree with all who are saying that posted invoice should not be deleted.
I know all the tables where to delete "evidence", but this is just not the right way.

That's way we have Invoices (before posting) and Credit Memos.
Our SI localization has 2 types of Credit Memos. One is for regular Credit Memos and the other is for "Internal Correction" (boolean).
As name suggest the socond is used not to show on some printouts for authorities, and is also used to post on the same side of GLEntry as invoices are posted but with negative values...

oleschjoeth

I completely agree with everybody opposing the idea of deleting a posted invoice. In fact you should never delete any posted transaction but instead always balance them up. E.g. invoice with credit memo and so on.
If you just delete a posted invoice then you will end up with a ledger deficit. Do that several times and some might even use the term embezzlement.
I truly hope that it is not legal in Turkey to just delete an Invoice. Otherwise I shall not do my shopping there

Robi - why would it be a problem for you in Slovenia if the authorities should se that you made a few mistaken invoices and balanced them up with equal credit memos?

Regards,
Ole

RobertMo

oleschjoeth wrote:

Robi - why would it be a problem for you in Slovenia if the authorities should se that you made a few mistaken invoices and balanced them up with equal credit memos?

:? You should ask our authorities :x I also believe that is obsolete, but we must obey the law...

I think this originates from SFRJ times, when we had different economic system. When we became independent in 1990, we had to rewrite a lot of laws and some of them were based on that time's thinking (how to prevent corruption and black market). We introduced VAT system in 1999, so the laws were changing in fundaments... Now we are in EU and everything will be simplified...

I heard last time that in Romania they cannot have different VAT rates on same Invoice?!? Not in all cases, but strange thing, isn't it?

RobertMo

One more sweetie about Credit Memos...

If we issue a credit memo to customer it means we pay less VAT at the end of the month. But if the customer doesn't book this credit memo he has more incoming VAT to subtract, so he also pays less.
That's why we are not allowed to subtract VAT for issued Credit Memo unless we recieve customer's formal document on which day he has booked our CrMe... Imagine the "papersflow"

oleschjoeth

Wow, it sure sounds like you have a lot of challenges simplyfying the laws regading sales tax / VAT etc.

Thanks for the info Robi - it is always very interesting to know how things are done in different countries

Ole

Savatage

must do this because the company don't want see " the cancelled invoices " in its endorsement.

maybe you can look at this another way.
Are cancelled invoices something that is very common for you?
Maybe the order can be verified that it's good before you ever invoice it?
therefore eliminating the need to delete an invoice.

--just a thought

craigbarbs

Hi All,

In the standard world version of Navision, you can delete a Posted Sales Invoice provided it's been printed.

When doing this, only the document itself is deleted - the Customer Ledger entries, etc. are obviously not deleted. This clearly does not reverse the invoice. Note that you do not require a solution developer's license to do so either.

At the end of the day, the implication of deleting the posted document is only that you would not be able to re-print it. One really should not be using these tables for reporting since the costs, etc are not accurate.

If the intention is to reverse the Sales Invoice, then I agree that one should create a Credit Memo.

Savatage

If this is the case couldn't you then just create a check box called
"cancelled order" on the Sales Invoice Header. Then just filter these off your reports