Stock inventory costing to job, workarounds or ways to track

SUGGESTED

We are a service company, we buy parts to install with labor to our customers.  In the past we havent tracked inventory very well if at all, and rarely used a purchase order or properly received, inventory purchases would just go straight to bill and get added to cost of the job or to inventory cost.  This worked ok as every part we bought for a job was easily seen as it was applied to the job as a lump sum as soon as the bill arrived and when it came time to invoice it was easy to find the transactions.  Now, we would like to use sage if possible to track our inventory and inventory costs but have ran into a brick wall it seems.  

I realize you cannot cost a line item on a purchase order to a job if the item is a inventory item.  Ive learned that the idea is to add the inventory purchases to your inventory and then cost them to jobs through inventory adjustments or similar.  

However, if we start using purchase orders and proper receipts, there is no way to enter these inventory item purchases to job cost at least not until the point of invoicing right?.  How do you track or remember these transactions that were made for individual jobs and make certain or document that these transactions ever hit the job?  I assuming someone has a similar business model, I must be missing something?  

  • 0
    SUGGESTED

    When you invoice the customer for an inventory item, you will enter the job number for that line. At that time Sage will remove the item from inventory and post the cost and sale to the job at that time. In reality, this works best if you invoice close to the time you pull the item from stock to install on the job.

  • 0 in reply to KimClement

    Thank you for the reply.  I hoped maybe there was a shortcut used by some to keep track of the items sold.  Being in a service industry, it may be a week or so from the point we sent the parts and the service guy and his work order is entered, so there is a delay there that makes allocating a purchase to an invoice difficult.  I guess if I could somehow use the purchase order number or other field to represent or tie to the invoice for the job, that would allow us to buy the parts, then later have a purchase order to copy the line items to the invoice.  Just seems like alot of movements?  Id like to know what was bought for the service job and not depend solely on the service guys work order to inform us.  Give us a bit of oversight of the parts.

  • 0 in reply to BillS

    You can create your invoice when you start the job and build on it as items are issued -- this removes items from inventory at that time and shows you what's been allocated to the job.  When the completed work order is received it should match what's already on the invoice and then you'd add your labor, change the invoice date and complete the invoicing process.