Supplier's item number - no report

The_Doc

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

Steven_M

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.