Solved

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

  • 8 April 2024
  • 3 replies
  • 25 views
G
Rank
Badge +1
  • gbc
  • Do Gooder (Customer)
  • 1 reply

Hi all,

 

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

 

Thank you very much,

Gabriel

icon

Best answer by Marcel.Ausan 8 April 2024, 16:15

View original

3 replies

Marcel.Ausan
Rank
Userlevel 6
Badge +15

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

 

https://www.linkedin.com/in/marcelausan/
G
Rank
Badge +1

@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
Rank
Userlevel 6
Badge +15

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

https://www.linkedin.com/in/marcelausan/

Reply


Terms & ConditionsCookie settings