price lists without inventory

SOLVED

Is it possible to set up price lists from vendors without treating it like inventory?   I have a client who purchases supplies from a few regular vendors and he'd like to be able to have a price list so when the purchase invoices are created he can just select them from the list rather than typing in the prices.  He does not keep any inventory rather the purchases are used right away on job sites.    I have not really used the inventory feature before, but as I understand it's really designed for companies who purchase items for resale.   He had another person doing the books for a few months and she doesn't really know bookkeeping.  She created, with his help, a whole bunch of inventory items.  When she created the purchase invoices it was debiting the inventory account and crediting accounts payable.  However, when he creates his sales invoices he does not touch the inventory accounts as his price to his clients is usually a figure that includes all labour and materials and is allocated to a sales revenue account.   As a result the inventory account balance keeps increasing and none of the items he purchased for jobs is ending up in an expense account.  

From what I know about inventory, he would have to break down his sales invoices into labour and materials and list each item from inventory he used on that job in order to credit the inventory account would he not?

he is using premium 2012.

Parents
  • 0

    swissmrs59 said:
    have to break down his sales invoices into labour and materials and list each item from inventory he used on that job in order to credit the inventory account

    Yes.

    To clear out the existing inventory and correct the books without doing that, they would have to adjust all inventory on hand out, over-riding the G/L account to the appropriate COGS account.

    Then, any open purchase orders would have to be printed out and cleared / deleted.

    Once that's done, in Single-User mode they will be able to change the existing items to 'Service' items.

    swissmrs59 said:
    I have not really used the inventory feature before, but as I understand it's really designed for companies who purchase items for resale.

    It's appropriate for use when converting a list of inventory items into finished goods as well.  But it requires a lot of patient setup, and if the company is at the stage where there is no accounting or other need to know what work-in-progress or inventory on hand is, it would be also be pointless.

    swissmrs59 said:
    However, when he creates his sales invoices he does not touch the inventory accounts as his price to his clients is usually a figure that includes all labour and materials and is allocated to a sales revenue account.

    Even if the client doesn't really want or need exact costs, using Service Items will allow them to collect data on all purchases, by item.  It will become invaluable when building detailed quotes. 

  • 0 in reply to RandyW

    Thanks Randy

    I did notice that several of the inventory items will not allow me to change them to service.  I assume this is because they have been used on a purchase order or invoice?

  • 0 in reply to swissmrs59
    verified answer

    Inventory Items can only be changed to Service items if (in the Quantity tab)

    There is zero on hand at all locations for:

    Quantity:

    - on Hand

    - on Order

    - on Sales Order

    - Minimum Level

    Dollar Value:

    - On Hand

    If the inventory module is still in 'history mode', and there is an opening value, it also may balk at changing the item.

  • 0 in reply to RandyW
    verified answer

    unfortunately most of them are not zero quantity on hand as the items were never taken out of inventory to invoice anyone.  If worst comes to worst I'll just have to go into each purchase invoice she created and change the account to an expense one instead of inventory.  Then at least the expense gets claimed.  The way she did the entries the inventory just sits there forever and makes it appear on the balance sheet as if the company has all these inventory assets but in reality they were all used on jobs.

Reply
  • 0 in reply to RandyW
    verified answer

    unfortunately most of them are not zero quantity on hand as the items were never taken out of inventory to invoice anyone.  If worst comes to worst I'll just have to go into each purchase invoice she created and change the account to an expense one instead of inventory.  Then at least the expense gets claimed.  The way she did the entries the inventory just sits there forever and makes it appear on the balance sheet as if the company has all these inventory assets but in reality they were all used on jobs.

Children
No Data