645
I want to know how I can create multiple invoices for a sales order.
We have customers that have to make multiple payments on an order. 50% upon agreement, 40% upon shipping and 10% 30 days after delivery. Any ideas on how I can set this up. I tried the prepayments option in sales order but I am not sure how to make the remaining 50% in 2 separate invoices.
I am new to NAV so any advise is greatly appreciated.
Thanks!
*This post is locked for comments
I am going to use service invoices for the prepayments. I will create the contracts, set the next invoice date to the following year (we bill annually) and create 3 separate invoice for the deposits. The service invoices lets me link them to the service contact so its easily traceable. Since we lease/sell a fixed asset we do not need it to go through inventory.
Thanks for the help, I know its a unique situation. I appreciate the input.
Hi Rebekah,
sounds to me like looking for an AddOn would be a way to get what you require. The prepayment would be ok to be handled by the prepayments functionality, the rest would be either multiple due dates or a fully fledged payment plan with separate invoices (and payment terms) per stage. AddOns for construction and project management have this functionality, however they would be overkill for what you require. But maybe it's worth talking to AP Commerce.
Hello Rebekah.
I think the best way is to modify the prepayment functionality, so that you generate a prepayment invoice for 50% of the amount before the order will be released and a second prepayment invoice before the shipment posting. For that you have to change the functionality, so that the sales order can be released while the second prepayment is not payed.
Another solution could be to add new lines with the type "Charge (Item)" and a negative amount and then create new separate sales invoices. If you do not only use items in your orders, you cannot use the type "Charge (Item)", but types like "G/L Account" or a special resource which may be created for this purpose.
If you do not want to have additional lines you could use dicounts, but that may have some negative affects on your reportings.
All this could be done programmatically with a new activity buttons for the first 50% and during the sales order release for the 40%. The problem is, that you do not have control over the payments of these invoices. You must have disciplined users or you must add some extra code that checks the payment status of the first invoice during the order release and the payment status of the second invoice during shipment posting.
If you must have the possibility to credit the prepayment invoices because the customers cancel or modify their orders, you also must modify your new functionality, so that the invoices can be adjusted by credit memos and replaced by new prepayment invoices.
But here we are at my first solution again to modify the existing prepayment functionality.
Martin
The problem is I don't want to show anything shipping or back ordered. I have to generate the sales order so it can go into production. I don't want to do manual invoices that just post the the GL I want to automate the process. Any other ideas?
You can send and invoice 0,5 units the first time, 0,4 units the second time, and finally 0,1.
(Of course, leave the Quantity field with the total qty...and change the "Qty to Ship" and "Qty to Invoice".
Another solution is créate more lines...but maybe the first one is more "elegant".
Good luck!
#1
André Arnaud de Cal...
291,419
Super User 2024 Season 2
#2
Martin Dráb
230,492
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
