Skip to Content

Price List based on Item Cost


Is there any way to create a price list based on 'Item cost' (value shown in 'Gross Profit (...)' window eg on A/R Invoice? Or is there any workaround?

The point is that there is a need to create a price list where the price will be purchase price (by FIFO) increased by 10%.

SAP Business One 9.2 PL: 03


sap-item-cost.jpg (57.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jun 26, 2017 at 06:19 AM

    Hi Krzysztof,

    That is going to be difficult and not very reliable. First of all, cost price is warehouse specific, so you can have as many prices as you have warehouses. However, you could circumvent that by using only the cost price in the default warehouse.

    Second though, as you use FIFO, the price would only be correct for the oldest batch. Now let's say that the price for the oldest batch is 1,20 €, the price of the next batch is 1,50 €, and there is only a single piece left in the oldest batch. You would get a list price of 1,20 €, although for all intents and purposes the price is as good as 1,50 €

    All that said, one way of doing it, is to create an empty price list, and a query that gets you the current cost prices of all items, and then regularly running the query, and updating the price list using the DTW, or the client's Excel import tool.

    The only method that would be more "live" is to write a small console program using the DI API, that runs the query and updates the price list for you, on some schedule.



    Add comment
    10|10000 characters needed characters exceeded