Dynamics 365 Business Central - Price update
Budget: $30 – $250 AUD
manufactor part nr. and our salesprice
We have an external database with our purchase prices and our competitors prices
We need an application that will go through our part nr. and purchase prices and then change the sales prices every day, when our purchase prices changes - Or if our competitors prices change.
So we need to be able to set % on each part nr.
So part nr. A is maybe 10% and Part nr. B is 8% But if our competitor lower their salesprice, then we in decrease our price automatic.
https://leverandorpriser.avd.dk/api/97d23226-2dc0/items/U6-PRO/listall?pc=Ja
https://leverandorpriser.avd.dk/api/97d23226-2dc0/items/U6-PRO/listall?pc=Ja
So we need somekind of interface like this - Where we can set "Sell cheaper than Vendor XX" or calulate Sales price from cheaper vendor or only cheapst vendor with stock.
And then we need to be able to set the percentage or sales price on each product.
The first time we need to run an import, so all product prices get into this "application" and then we can read the purchase price from the database and then calculate the percentage on alle producs - So we dont have to set sales price on all procuts manually.
Afterwards there need to be a daily price update - Looking on the newest purchace price and then calculate the new sales price.
And by the way... if the vendor price is 0 it need to choose the next vendor... We cant sell to 0.00 ?
I see that. This is the database where all the inventory prices and product prices are updated right?
yes - Only purchase price... and stock... sales prices are from BC...
I would ask for only fixed price cost.
We have an external database with our purchase prices and our competitors prices
We need an application that will go through our part nr. and purchase prices and then change the sales prices every day, when our purchase prices changes - Or if our competitors prices change.
So we need to be able to set % on each part nr.
So part nr. A is maybe 10% and Part nr. B is 8% But if our competitor lower their salesprice, then we in decrease our price automatic.
https://leverandorpriser.avd.dk/api/97d23226-2dc0/items/U6-PRO/listall?pc=Ja
https://leverandorpriser.avd.dk/api/97d23226-2dc0/items/U6-PRO/listall?pc=Ja
So we need somekind of interface like this - Where we can set "Sell cheaper than Vendor XX" or calulate Sales price from cheaper vendor or only cheapst vendor with stock.
And then we need to be able to set the percentage or sales price on each product.
The first time we need to run an import, so all product prices get into this "application" and then we can read the purchase price from the database and then calculate the percentage on alle producs - So we dont have to set sales price on all procuts manually.
Afterwards there need to be a daily price update - Looking on the newest purchace price and then calculate the new sales price.
And by the way... if the vendor price is 0 it need to choose the next vendor... We cant sell to 0.00 ?
I see that. This is the database where all the inventory prices and product prices are updated right?
yes - Only purchase price... and stock... sales prices are from BC...
I would ask for only fixed price cost.