Here's the scenario: Most products we carry are supplied by multiple vendors. We're trying to automatically calculate the sales price based on a fixed margin from the lowest priced vendor. An example would be the following:
Automatically calculate sales price as $133.00, based on the lowest price vendor "A"
This way, we can fulfill an order if vendor "A" is out of inventory. We'll just have to eat the loss.
Does anyone know of a way to accomplish this? We've tried numerous routes to no avail, and are more than willing to pay for any custom work that needs to be completed.
I look foward to hearing from the forum, thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Our conditions are that we are allowed to publish back the codes as Open and Free. You allow your case to be used as our reference case.
You have to spell out the specifications openly here. We will do the solution and post it to http://compiere.red1.org/
There must also be a preview of the specs first by us whether your case is feasible or not.
regards
red1
p/s WE here means me as the solution mechanic, rhoo as the functional mentor, n2n as the accounts specialist. We don't mind alotting some time as the case may warrant future usefullness to many other users.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For multiple vendors, it's just an additional entry into the 'M_PRODUCT_PO' table, with the same 'M_PRODUCT_ID' number. This allows you to click the "purchasing tab" under "product info" for example, and see the multiple vendors.
As far as calulating the actual sales price based on a fixed margin from the lowest cost supplier, that's a piece of cake as well.
Just a quick update to 'M_PRODUCTPRICE' does the trick, specifically `PRICELIST, PRICESTD, and PRICELIMIT`
The price could easily be calculated by selecting the lowest positive integer greater than one (to avoid basing price off our standard $1 for vendors who negotiate on certain items).
Thank you, red1 for providing the case studies and example code, it's really refreshed my memory. Quite entertaining as well, I found your commentary turned a dry subject into a pleasure.
After not touching a database in nearly four years, it's amazing how much you can forget... thanks guys!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Here's the scenario: Most products we carry are supplied by multiple vendors. We're trying to automatically calculate the sales price based on a fixed margin from the lowest priced vendor. An example would be the following:
Purchase price
Vendor A: 100.00
Vendor B: 115.00
Vendor C: 120.00
Automatically calculate sales price as $133.00, based on the lowest price vendor "A"
This way, we can fulfill an order if vendor "A" is out of inventory. We'll just have to eat the loss.
Does anyone know of a way to accomplish this? We've tried numerous routes to no avail, and are more than willing to pay for any custom work that needs to be completed.
I look foward to hearing from the forum, thanks!
How about if we do it for you for free. With some conditions.
You have to visit our site to find out more.
http://red1.org/
Our conditions are that we are allowed to publish back the codes as Open and Free. You allow your case to be used as our reference case.
You have to spell out the specifications openly here. We will do the solution and post it to http://compiere.red1.org/
There must also be a preview of the specs first by us whether your case is feasible or not.
regards
red1
p/s WE here means me as the solution mechanic, rhoo as the functional mentor, n2n as the accounts specialist. We don't mind alotting some time as the case may warrant future usefullness to many other users.
For multiple vendors, it's just an additional entry into the 'M_PRODUCT_PO' table, with the same 'M_PRODUCT_ID' number. This allows you to click the "purchasing tab" under "product info" for example, and see the multiple vendors.
As far as calulating the actual sales price based on a fixed margin from the lowest cost supplier, that's a piece of cake as well.
Just a quick update to 'M_PRODUCTPRICE' does the trick, specifically `PRICELIST, PRICESTD, and PRICELIMIT`
The price could easily be calculated by selecting the lowest positive integer greater than one (to avoid basing price off our standard $1 for vendors who negotiate on certain items).
Thank you, red1 for providing the case studies and example code, it's really refreshed my memory. Quite entertaining as well, I found your commentary turned a dry subject into a pleasure.
After not touching a database in nearly four years, it's amazing how much you can forget... thanks guys!