Forum Discussion

The_Doc's avatar
The_Doc
Ultimate Cover User
3 years ago

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.

  • 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.

    • The_Doc's avatar
      The_Doc
      Ultimate Cover User

      Hi Steven_M 

       

      Thanks for the input. 

       

      I will look at your suggestions for a quick compare.

       

      However, wet cold weekend so am 3/4 through modifying an API call to both companies to enable an automatic comparison and auto-warning if Company A - supplier item number has an orphan in supplier Company B.

       

      Regards