Negative total amount on Sales Invoice

tinoruijs · 2008-04-25

Hi,

Has anyone ever created the possibility to use a negative total amount on a sales invoice?

I know: "Don't do it!" [-X That's what credit memos are for...
I couldn't agree more...

Joeri · 2008-04-25

Hi Tino,

by accident i had this exact same question only a few weeks ago for a customer that sells cell phone subscriptions. Because they only use negative amounts for the subscriptions, but positive for the hardware they wanted to put it all on the same order and invoice, but that wasn't possible.

The changes you have to make aren't very big and easy to trace, so yes, it is possible to do this. His accountant also looked over the posts, and everything was ok.

tinoruijs · 2008-04-25

Hi Joeri,

Thanks for your reaction.

All right. And did you not run into reports that now show the wrong amount?

Joeri · 2008-04-25

Not yet

Marije_Brummel · 2008-04-25

I have had an issue with the payment discount not being calculated for a credit memo when copying a document.

An other advise is to change the document into a credit memo and then post the document. This way the customer can work from one screen but you keep Navision in tact.

David_Singleton · 2008-04-25

I think that for Invoices, Mark's suggestion is definitely the best, you will have to write some code, BUT all the debugging is in creating the UNPOSTED document, so once it works you are finished. Playing with posted documents could go on for ever.

Having said that, I have done this not for invoices, but for Orders, I have done it for a couple of different clients for different reasons. The case begin where an order goes positive and negative through its life. But in the case of an invoice there is only one posting, so its not the same issue.

tinoruijs · 2008-04-26

Hi guys,

Thanks for the reactions and suggestions!

Negative total amount on Sales Invoice

Answers

Categories