general purchase pricelist

[norber...@multimageweb.com]

hi,

i want to create purchase price-list including all "best known purchase prices". We storing Purchase Prices on Product PO (if-available) and/or in costing subsystem as Average PO cost type. We have not implemented Product PO import - in my estimation most prices coming with Invoice into costing subsystem. IMHO we need combine prices into 1 PL.

So, Our goal is get all purchase prices to a common price-list and update frequently. With this new purchase pricelist we will able to calculate leading sales prices also for items never been in the warehouse.

i know details how pricing, pl schema works, but can't find the best way how to achieve above scenario.

welcome ideas. :)

norbert

[Marco Longo]

Hi Norbert , 

not sure to have understood the whole  

do an example with a product  ..maybe could help (me) 

anyway...  

a) we implemented a plugin that create/save the price on the vendor pricelist when price is entered in the purchase order  ( depending on some parameter  as example only if the Vendor is flag as "updatepricelistfrompurchaseorder"   (should work in different way ) 

bye

Marco

[norber...@multimageweb.com]

thanks Marco,

we have done this. so we enter lot of prices but we have 200 vendor pricelists. and wants to get all item into 1 pricelist

i.)combine multiple pricelists into 1.

ii.)take prices from costing and others from purchase PO.

or any other suggested way. norbert

[Syed Vaisul Karne M (SyvaSoft)]

Hi Norbert,

So, Our goal is get all purchase prices to a common price-list and update frequently. With this new purchase pricelist we will able to calculate leading sales prices also for items never been in the warehouse.

Why don't you create a DB View for purchase price-list including all "best known purchase prices"? 

Then write a process which will use the "best known purchase prices" View  to populate the "common price-list" rather than using existing "Create Price List" process.

Regards,

Syed.

[Marco Longo]

Hi,

Another approach ... starting from files of price list from the vendor  

from another side we created an external table/window(infowindow where we upload all external price list ( from xls,csv... ) from different vendor  so you can upload a lot of product without loadin in the final product table  

Example

Internal Code    ExternalCode  Barcode Description     Vendor       VendorPrice Minqty 

123                    V1abc              777777  samsung s7    mediaworld     99 €            1                    

Internal Code    ExternalCode  Barcode Description     Vendor       VendorPrice Minqty 

123                    V2zzz              777777  samsung s7    amazon           109 €            1        

So you can view filter and select from : product and check the best price 

then you can run a process to import the product in the real product table

if select both code you will have the same product with 2 record in the purchase with vendor info and the 2 prices

This is good to avoid to load a lot of code but is flexible to be able to compare price directly into idempiere 

Something more close to your needs ?

Marco

 

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/0MOZcrjtaFo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/85e4d5dc-1f6f-4a96-88c7-7b06bdbc4d7b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.