Adempiere Version 3.53A
IF
< there is more than one Vendor/Supplier exist for a product in the PURCHASING tab of PRODUCT window >
THEN
<Purchase Order is generated for all the Suppliers in the PURCHASING tab of PRODUCT window for that product>
STILL
<Purticular a vendor is specified in the GENERATE_PURCHASE_ORDER dialog window>
WHY?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Again, Sorry to disturb you all!
I had 3 PRODUCTS in SALES_ORDER. I generated PURCHASE_ORDER.
All the 3 PRODUCTS got listed PURCHASE_ORDER_LINE tab
But i want to order only 2 PRODUCTS now.
I had the other-one (3rd) already in the stock or want to order later.
BUT:
---
When i tried to delete the third PRODUCT from PURCHASE_ORDER_LINE tab(which i don't want to order) it gives me ERROR as follow
Database Error.
ERROR: update or delete on table "c_orderline" violates foreign key constraint "linkorderline_corderline" on table "c_orderline"
Detail: Key (c_orderline_id)=(1000275) is still referenced from table "c_orderline".
What is the right thing to do ? please help!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After reading this howto you should be able to build trunk version to test if this functionality now works as you need it.
Maybe it's an option for you to hire one of the developers or implementors for the technical stuff.
Regards,
Dominik
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As instructed when tested with Postgres db on http://www.testadempiere.com/
GENERATE PO was working satisfactorily.
In GENERATE PO dialog when VENDOR was left blank it generated only one PO
to the "FIRST VENDOR" in the PRODUCT -> PURCHASING tab.
The price selected was from the PURCHASE_PRICE_LIST (in the PRODUCT -> PRICE_LIST tab) and not the PO_PRICE associated with the VENDOR (in the PRODUCT -> PURCHASING tab).
The criteria of selecting the VENDOR is not transparent (to me)
when VENDOR was left blank in GENERATE PO dialog
(though it is not so important as we can either change the vendor once the PO is generated or specify a vendor during generation).
In PRODUCT -> PURCHASING the column CURRENT_VENDOR check box is not unique
(More than one VENDOR records can marked as CURRENT_VENDOR at same time)
Its effects, usage and under-currents within db & process's should be brought to light
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Adempiere Version 3.53A
IF
< there is more than one Vendor/Supplier exist for a product in the PURCHASING tab of PRODUCT window >
THEN
<Purchase Order is generated for all the Suppliers in the PURCHASING tab of PRODUCT window for that product>
STILL
<Purticular a vendor is specified in the GENERATE_PURCHASE_ORDER dialog window>
WHY?
Hi Shiju,
Please test this in trunk - I think it was solved.
Regards,
Carlos Ruiz
>> Please test this in trunk - I think it was solved.
Can you please shed light little more
I am using Adempiere Version 3.53A. what am supposed to do ?
Again, Sorry to disturb you all!
I had 3 PRODUCTS in SALES_ORDER. I generated PURCHASE_ORDER.
All the 3 PRODUCTS got listed PURCHASE_ORDER_LINE tab
But i want to order only 2 PRODUCTS now.
I had the other-one (3rd) already in the stock or want to order later.
BUT:
---
When i tried to delete the third PRODUCT from PURCHASE_ORDER_LINE tab(which i don't want to order) it gives me ERROR as follow
Database Error.
ERROR: update or delete on table "c_orderline" violates foreign key constraint "linkorderline_corderline" on table "c_orderline"
Detail: Key (c_orderline_id)=(1000275) is still referenced from table "c_orderline".
What is the right thing to do ? please help!
Hi,
Trunk version is aviaible using Eclipse EDI for more information please read:
http://adempiere.com/index.php/Create_your_ADempiere_development_environment
After reading this howto you should be able to build trunk version to test if this functionality now works as you need it.
Maybe it's an option for you to hire one of the developers or implementors for the technical stuff.
Regards,
Dominik
Hi Shiju,
If you don't know how to use eclipse but you still want to contribute with trunk testings, then you can download and install the nightly build from:
http://www.testadempiere.com/
Regards,
Carlos Ruiz
As instructed when tested with Postgres db on http://www.testadempiere.com/
GENERATE PO was working satisfactorily.
In GENERATE PO dialog when VENDOR was left blank it generated only one PO
to the "FIRST VENDOR" in the PRODUCT -> PURCHASING tab.
The price selected was from the PURCHASE_PRICE_LIST (in the PRODUCT -> PRICE_LIST tab) and not the PO_PRICE associated with the VENDOR (in the PRODUCT -> PURCHASING tab).
The criteria of selecting the VENDOR is not transparent (to me)
when VENDOR was left blank in GENERATE PO dialog
(though it is not so important as we can either change the vendor once the PO is generated or specify a vendor during generation).
In PRODUCT -> PURCHASING the column CURRENT_VENDOR check box is not unique
(More than one VENDOR records can marked as CURRENT_VENDOR at same time)
Its effects, usage and under-currents within db & process's should be brought to light
Hi Shiju, you found a bug, thanks for reporting.
I opened corresponding bug tracker here:
Bug [2797787] - Cannot delete line on PO generated from SO
https://sourceforge.net/tracker/?func=detail&aid=2797787&group_id=176962&atid=879332
Regards,
Carlos Ruiz