Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
I buy some items to sell as is, and other items that are components that are not sold directly. They are differentiated by the "I sell this item" checkbox on the Profile tab of the item information page.
I would like to produce a csv that includes exactly these fields:
In an even more perfect world, I would be able to use the I sell this item flag as a filter so I can report on the "I sell" and "I don't sell" items separately.
Is any of this possible? I cannot see anything that looks like "I sell this item" on the Report Fields tab of the report deluxifier.
(I tried to ask the telephone support people about this but no luck - the phone answerer took 5 minutes to tell me that the wait for second tier support was an hour an a half. Why do I pay for support when the answers are here?)
Thank you all, as always, for your help.
Solved! Go to Solution.
I would run the Reports>>Inventoruy>>Item>>Item List Summary report. In the Customise>>Advanced Filters of this report is the option Include Items. You can select Only Sold and it will give you all the items that you have indicated that "I Sell this item" being enabled.
If you wanted a CSV format of that report data you can select Send>>>Comma Separated Values or Send>>Excel before saving it as a CSV file format.
Note: The "Only Sold" filter on all items where you have enabled "I Sell this item". This would include items where you have selected "I Inventory this item" and "I Sell this item". The basic rule of thumb if it the Item does have "I Sell this item" enabled of the item it will appear when Only Sold is selected.
Thanks for your help. This is quite useful. Thank you. The CSV side of it I had under control but I had missed the Advanced Filters option.
One thing AE really needs is a data dictionary that shows the correlation between fields on the input forms ("I sell this product") and subsequent usages (such as the "Only sold" selection filter.) The change in language masks the relationships between the underlying data field in the database and the places where it is entered, consumed and used as a filter.
This filter allows me to list all the items I sell, but it does not allow me to list all the items that I don't sell. This assymetry is pervasive in AE and quite annoying. The three flags Buy/Sell/Inventory are independent of each other and really should be availabe in the same way as the Web Store option, allowing, for example, Sold, Not Sold and Don't Care.
After close inspection, it looks like there is no way to list the values of any of these flags, other than the Web Store flag, in a report. Even the Item Detail report doesn't show them.
I am doing a consistency check of my items list and missing fields such as these mean I have to drill into each of my 300+ products individually.
Anyhow, thanks for your help. I can, at least, list all products, then list the three individual Buy/Sell/Inventory lists and get Excel to fake up the report I need. More fun then 300+ drill-downs.