Skip to main content
Solved

At supplier level, how to download list of active SKUs and price?

  • April 8, 2024
  • 3 replies
  • 109 views

Forum|alt.badge.img+1
  • Do Gooder (Customer)

Hi all,

 

I'd like to download the list of active SKUs and its price, at supplier level.

 

Thank you very much,

Gabriel

Best answer by Marcel.Ausan

@gbc I think you would need to go to Supplier for Purchase Part → filter for the desired supplier id/name and there you should have the results which could be exported in excel.

 

3 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • Answer
  • April 8, 2024

@gbc I think you would need to go to Supplier for Purchase Part → filter for the desired supplier id/name and there you should have the results which could be exported in excel.

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • April 8, 2024

@Marcel.Ausan thank you very much, following your advice, I could obtain the list of active SKUs. However, the field "price" says "0" for all SKUs.

I guess this is due to our company set up of IFS.


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • April 9, 2024

@gbc Normally pricing logic for purchase parts is the following:

prio 1 → Supplier Agreement

prio 2 → Price List → Supplier for Purchase Part / Price List tab

prio 3 → price in Supplier for Purchase Price

prio 4 → price is added manually in the PO Line

It could be the case that for some suppliers you have Supplier Agreement define, weheras for others you have a list price and then for some suppliers maybe your Purchasing dept adds the price manually in the PO Line.

If you have such scenario, I would suggest to ask your IT dept to create a quick report to get this data for you.