Question

Yearly Price List (Similar to Price Query but need one for all parts)

  • 4 January 2023
  • 2 replies
  • 55 views
N
Rank
Userlevel 5
Badge +8

Each year we provide our customers with a price list that includes:

  • Part #’s they can order
  • Base Price per part
  • Customer Discount per part
  • Net Price per part

Currently we have create a very complex query that provides all the logic from all the pricing logic to provide a list of all the parts. Ideally we would want to use the exact logic as Price Query but that is only one part at a time. Has anyone found a way to generate a price list for all parts for a customer that is using the price query logic? 

Our output is simply an excel file that has multiple rows of data for each part that customer can purchase from us. 

 

2 replies

A
Rank
Userlevel 6
Badge +11

Hi,

Does that mean when the price changes based on the no of items ordered, you will have multiple price detail lines generated in this query you sent to customers?

Or your prices do not change based on the ordered quantity?

Asanka

Asanka Garusinghe - https://www.linkedin.com/in/asanka-garusinghe-61634a64/
N
Rank
Userlevel 5
Badge +8

Some products have multiple prices based on the qty. ordered and others are just a flat discount. The struggle we have is that IFS provides no real report that provides a customer their price per product for all products they can order. Thus we have created our own logic to pull this data to provide to our customers, our customers than take that and load it into their ERPs to generate Purchase Orders with correct prices. 

I know other businesses do this so I am interested in understanding how other IFS customers are generating a price list for their customers, because the logic is complex to replicate. 

Reply


Terms & ConditionsCookie settings