Is the a way to summarize the invoice totals to a customer or suppress the detail from the view?

I am a new controller to the company, and I have very little experience with Sage 100. We need a solution to send a customer one invoice (containing multiple jobs), and only show a summary as if it were one job.

Our business is in manufacturing, and management wants to maintain transparency throughout the manufacturing process for each component. We receive a Purchase Order from a customer for a particular job. We then break that single job into multiple jobs (Example: Paint, Labor, Material, Quality Testing). This allows us to track the P&L per process. When we bill the customer, we would like to bill them as if it were one job, instead of them seeing how we broke out their job.

Our current work around has been setting up a separate company inside the Sage 100 system to specifically create invoices with one line item, and duplicate the data entry in the actual company with the detail breakout. This duplication of data entry led to unrecorded transactions and a longer monthly close. Is there any other way to have the same result on the final customer invoice?

  • Create a custom Invoice Form in your existing company to consolidate the line items into the way your customer want's to see their invoice.  This can be done with the help of your Sage 100 Reseller.  

  • A custom invoice form is the way to go.  This requires knowledge of Crystal Reports, which can be set up to group information on the invoice to only show what you want.  I've done if many times for clients.  If your Sage Reseller is not available to help you, PM me and we can connect. 

    Hollie

  • Designing a summarized invoice form is a good idea, but things would be complicated when doing a Cash Receipt, with multiple invoices being paid, but without out the customer sending those details with their payment.  Two thoughts:

    • DSD has an enhancement to combine multiple invoices together, fully functional to pay the master invoice #.
    • Do a zero $ cash receipt against a group of invoices, offset to a suspense account.  Then create your consolidated invoice against the suspense account with whatever line comments you wish.

    The biggest complication I see would be how you might need to show the taxes.

  • Quick question Hunter, are you using Job Cost or Work Order in your process.

  • in reply to BigLouie

    We are currently using Job Cost.

  • Hi Hunter,

    I was reading this old post today. We have a similar situation where we need to invoice multiple jobs on one invoice. We use Job Cost module and currently Sage will only allow one job per invoice. Did you ever find a solution to your situation?