Forum Discussion

Verdant's avatar
Verdant
Experienced Cover User
9 days ago
Solved

Inventory Categories and Value subtotals

I want to create a report that tells me not just what my total inventory value is, but what particular product type subtotals there are.    For example, I sell cushions from varying brands. I just ...
  • gavin12345's avatar
    gavin12345
    9 days ago

    Hi Verdant 

     

    The only way to reliably do this in MYOB is as you had it before - utilise separate Inventory Asset accounts - The Inventory Value Reconciliation (IVR) Reports will give you correct totals - provided you manage inventory properly. You need to understand that using 'I Inventory' in MYOB requires regular monitoring and adjusting to ensure the IVR stays 'balanced' otherwise the data becomes meaningless, and any value reports generated will likewise be meaningless. Get an inventory specialist to guide you.

     

    Regards

    Gavin

Genreve_S's avatar
Genreve_S
MYOB Moderator
9 days ago

Hi Verdant,

 

I understand how helpful it would be to have a report that shows your stock values more clearly. Currently, our application doesn't have a built-in feature to group items under subcategories like you've described. The best workaround for now is running the Item Summary report in batches, selecting the items you need for each batch. I know this isn't ideal and can be time-consuming. I suggest sharing your suggestion on the Ideas Exchange board for our team to consider in future updates.

 

If there's anything else you need assistance with, feel free to start a new thread.

 

Thanks,
Genreve