Sales Orders with Multiple Prepayments

(0) Share

Report

Posted on by rweatherman

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 have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

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!

Was this reply helpful? Yes No
rweatherman 645 on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

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?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

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

Was this reply helpful? Yes No
Verified answer

Jens Glathe 6,092 on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

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.

Was this reply helpful? Yes No
rweatherman 645 on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

Thanks for the help, I know its a unique situation. I appreciate the input.

Was this reply helpful? Yes No
ArunGarg 3,924 on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

Have you able to resolve this ?

Regards

Arun

Was this reply helpful? Yes No
rweatherman 645 on at

Like (0)

Report

RE: Sales Orders with Multiple Prepayments

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.

Was this reply helpful? Yes No