Forum Discussion

Enough's avatar
Enough
Experienced User
3 years ago

Inventory

Can I use inventory to keep track of our stock value in myob?  We purchase materials in bulk and use those materials in odd amounts as an 'ingredient' to manufacture custom products, each with a custom price. 

 

For example, we order 800 sheets with a total value of $40,000.  This week we may use 20 sheets to manufacture product 'A' and next week we may use 100 sheets to manufacture product 'B'.  Each finished product has custom modifications and therefore, a different sale price.  By week 3 we still have 680 sheets in stock with a value of $34K.

 

How do I enter the original $40K purchase so that it is shown on P&L as an expense and still have a record of the $34K worth of stock still on hand?

3 Replies

Replies have been turned off for this discussion
  • brunob's avatar
    brunob
    MYOB Product Manager
    3 years ago

    Hi Enough ,

    If you use Accountright, you can use the build item feature, to create a bill of materials that use the sheets to create a final product A (and B). Accountright can also accommodate different sales prices

    If you use MYOB Business + Premium Inventory, you would need to set a stock adjustment to decrease the raw materials and increase the final product A/B. Multiple price tiers are not supported on the browser version yet.

     

    Regards,

     

    Bruno

  • Enough's avatar
    Enough
    Experienced User
    3 years ago

    Thanks Bruno

    is there a step-by-step process to entering the purchase invoice and then entering the usage of portions of that stock? (What codes to use etc)

    I haven't been able to find anything on myob website.

  • brunob's avatar
    brunob
    MYOB Product Manager
    3 years ago

    We recommend talking to your accountant to see what is the best setting for you, but often, when setting up an item that you buy and sell at a profit, 3 accounts need to be set at the item level:

    - Under the "I track stock for this item" section, an asset account, ie inventory 1-1320
    - Under "I sell this item" section, an income account, ie 4-1400 Sales, and a COGS account, ie 5-0100. 

    Once you create a purchase order, the system will automatically allocate the purchase order line to its respective asset account. In the same way, when you process an invoice, the system will split the value automatically between your income and COGs account

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.