Supplier's item number - no report
Hi Folks/MYOB I may be missing it - but - I cannot find a report that lists inventory items - supplier - "Suppliers item number"!!
Why would I want it?
Company XYZ purchases from either an external supplier - or Company XYZ ( a branch of a major division where the supplying arm is a different entity) - XYZ suppplier and
Company XYZ - sales needs to order from XYZ - supplies and we need to export all the items for which XYZ - supplies is the major supplier and provides "suppliers item numbers" in the MYOB inventory that are different from the actual item in MYOB.
I want to export from XYZ - Sales - EXPORT from XYZ - supplier and compare to ensure they match 100%.
Because is I run an API automation program to grab PO out of XYZ - Sales and post them to XYZ supplier - and the item number is wrong - the POST will likely be rejected.
Like I can get this info through the API but would be nice to be able to through a report.
Am I missing a report - I went through them all - filters - hide/unhide and the field is just not there.
The Doc
Hi The_Doc
The Supplier Item number report is not a field that I have seen on a report. However, others in the Community may have some ideas on what report to get it onto.
In saying that, it is an exportable field so you could use the Import/Export Assistant to show that information. Alternatively, it is a column that can be added to the Item List window -- right-click on the column headers and select Column Chooser. If you wanted that data, you could then right-click on the table and select Copy list to clipboard to obtain that information on-screen to paste into Excel or a similar product.