Does X3 allow you to put different deliveries from the same customer on one invoices?
Does X3 allow you to put different deliveries from the same customer on one invoices?
Yes. This is controlled by the Invoicing Mode on the Sales Order (and this defaults in from the Invoicing Mode on the Customer). If you read the Field Help for this field it should clear up your question. You will use this in conjunction with the function Sales > Invoices > Delivery Invoice generation
We tried to do this, but I have to caution you about two things:
1. We have some very large customers that don't mind making demands of their suppliers. Consequently, they were completely unhappy with having one sales invoice with multiple customer Purchase Orders on it. It is difficult to control this and in the end, multiple PO's get combined onto one invoice. Your business scenarios may be different though.
2. Have someone carefully review your sales invoicing elements. Ours worked perfectly when we were doing 1 invoice per 1 delivery. Once we changed that, the system wasn't passing over freight charges on the additional deliveries and we missed charging freight to our customer. It wasn't caught for a while and was painful to correct with our customers.
No, it will not work on deliveries that have already been created. You will need to change this at either the SO or customer level (but if you change at the customer level, create a NEW sales order for the customer after you make the mode change). Then when you do another delivery it will be tagged for the new invoicing mode.
There are numerous ways to accomplish what you're asking for, and it just depends on exactly what your end goal is:
1. If you want multiple deliveries FOR ONE SALES ORDER on one invoice, select One/Closed Order. This means everything has to be shipped on this SO before it's billed.
2. If you want multiple deliveries for MULTIPLE sales orders on one invoice, selecting One/Ship To would likely work for you. However, this is still looking at pending deliveries at the time that you run the Delivery Invoice Generation function. So if you have one delivery for customer A on Tuesday and another for customer A on Wednesday, if the Delivery Invoice Generation function is ran every night, it's still going to put it on separate invoices. In the example I gave, it would group onto one invoice if the function is ran on Wednesday, but not Tuesday.
I hope that made sense!!
And yet another way to do this is to select One invoice per period. In that case, you could put all deliveries that occur, say in a month, on one invoice at the end of the month. I have seen this used in companies who make daily deliveries to customers, but the customer only wants one monthly invoice. And it does not have to be a month, you could set the period to weekly as well.
Off hand I believe that when you create the Order it sames the invoicing mode in the SORDER.IME field. Again, I did test now but I believe that if you change that value it should work.
*Community Hub is the new name for Sage City