Materials List to provide with Invoice

SUGGESTED

We need a report that will list all materials used on the job (estimate or T&M); there is a current report in the T&M Invoice screen: "T&M Parts Invoice Detail Addendum" but we need the ability to make a couple changes, but this report does not allow modifications. Any tips or ideas?

Parents
  • 0
    SUGGESTED

    You can customize a job cost journal so that you can select by invoice date and cost type 1.  However, the T&M invoice (if you are using the module), will automatically include ONLY those materials since the last T&M bill on that job.    If you only care about running it at the end of the job (as your inquiry implies), then use one of the system job cost journals to start.

  • 0 in reply to Char DeLange

    Char - do you know of a way to show the detail of the invoice that is listed on the job cost journal? That report would work great, but I only see it listing the vendor invocie in total.

  • 0 in reply to Carsten
    SUGGESTED

    Carsten,

    The reason the T&M invoice detail report is locked is because there are some very detailed SQL statements to make it work.  If you are looking for an AP invoice detail for costs that are on the T&M Billing, the report could be re-written but it would require doing it in an outside report writer because there is no direct correlation in the tables.

    If you would like to discuss it in more detail, let me know and we can step up a time to talk.

  • 0 in reply to kholtz

    We are also looking for this report - I'm not sure what clients would be happy to just see a cost summary - people need to see itemized details of what they purchased.  

    Our "consultant' has not been very helpful, and we even took it to an outside report writer who was unable to duplicate the report.

    Anyone find a consultant that is smart enough to duplicate this so we can add quantities to our invoices?  Thx!

  • 0 in reply to smaris

    Do you use PO's for those AP invoices?  There is a PO audit that gives you parts detail of PO vs Received/invoiced.  Or you could probably write a query in the PO entry screen.  

    Can you explain why with specifics that you need to know the individual parts info?

  • 0 in reply to Char DeLange

    We use both PO's and inventory allocations to put parts towards jobs.

    If you went to a grocery store, and your receipt just said:

    Vegetables - $120

    Meat - $40

    Pharmacy- $50

    then I'm pretty sure everyone would want a different receipt, so you could see exactly what you purchased, and how much it was.  

    That is exactly what our clients need to see. They want to know exactly what they bought.  I can find the info on other screens/reports, but I need to be able to add that to our invoice (not just staple an extra sheet to it).

    We are using T&M billing in Sage 100 b/c it is the only way for us to track that things have been billed out.  I could just manually type in the parts on another invoice, but then would have to triple my work b/c for some reason Sage does not pull items from inventory automatically if they are on an invoice, so I'd have to go and move that inventory, and then go back into the job costs and mark it as billed (am I wrong on that procedure?).  This is something that should be automatically done behind the scenes.

  • 0 in reply to smaris

    The easiest way to provide that to your customer is to given them copies of the invoices that total the amount on the T&M invoice.  Full disclosure.  If it is a T&M job, then your markup is clearly stated at the end of the invoice anyway.  I know several companies that do this.

  • 0 in reply to Char DeLange

    Absolutely not.

    We don't build houses, we build drilling rigs so things are very different.  There is not a chance I'd be showing our clients the markups we charge.  Can you imagine if you saw the markup from a retailer on your receipt?   You'd never buy anything again....  if you found out your plumbing company charges you $75 per hour and only pays the plumber $20??  Markups/profits will remain hidden, and I don't want to attach anything... just want a simple invoice with quantities.

    Is there anyone that has access to the detailed SQL queries in report 3-10-3-61?

  • 0 in reply to smaris

    Smaris - I hear exactly where you are coming from, to show markups is completely unheard of. We found a great consultant and custom developer to create the report we needed. In turn it cost us a lot of money but the detailed is required of our customers. Alliance Solutions Groups has the consultant that you should contact..

  • 0 in reply to Carsten

    Thanks Carsten!  So, are you able to run this report directly in Sage 100, or are you using a third party software for it?

  • 0 in reply to smaris

    A 3rd party app that sits inside of Sage. For the non-t&m, we use Liberty reports and paid to have a report created to pull those materials.

  • 0 in reply to Carsten

    K thanks!

    And just to clarify... by "pull those material", are you meaning just create a detailed itemized report again, or actually allocate the materials from inventory?

Reply Children
No Data