Is it Possible to Combine multiple deliveries on one Invoice

SOLVED

Does X3 allow you to put different deliveries from the same customer on one invoices?

  • +1
    verified answer

    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.

  • 0 in reply to christycpa

    So I have deliveries that are already made in the system. I tried testing the different settings and it still did not work. Will it work on the deliveries that are made after the fact the changes have been made? Also, which option did you pick on the customer level for this to work?

  • 0 in reply to Ancient Nutrition

    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!!

  • FormerMember
    0 FormerMember
    SUGGESTED

    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.

  • 0 in reply to christycpa

    This is the message I get, if i try to pick different

    And I change the invoice mode as well.

    Hope this helps.

  • 0 in reply to FormerMember

    Will this work on the deliveries that currently exist in the system? I tried changing the settings and got the following errors.

  • 0 in reply to Ancient Nutrition

    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.