lastPrice field on SupplierProduct
Locked
lastPrice field on SupplierProduct
 
|
Hi,
I am working on ReceiveInventory screen for AssetMaint component. How and When is lastPrice field on SupplierProduct table gets updated? I'll like to update this information if user provides when they ReceivingInventory of Parts. Can somebody Please help with this. Thanks and Regards Anil Patel |
|
|
Anil,
Many companies do not want this to happen. Anil Patel wrote: > Hi, > I am working on ReceiveInventory screen for AssetMaint component. How and > When is lastPrice field on SupplierProduct table gets updated? > > I'll like to update this information if user provides when they > ReceivingInventory of Parts. > > Can somebody Please help with this. > > Thanks and Regards > Anil Patel > |
Re: lastPrice field on SupplierProduct
|
|
Si, Thanks for your Response, Little more info will help to move further.
So, can we say this field is not in so much use any more. Also so to Keep track of this data do we have to use PO. Regards Anil On 3/21/07, Si Chen <[hidden email]> wrote: > > Anil, > > Many companies do not want this to happen. > > Anil Patel wrote: > > Hi, > > I am working on ReceiveInventory screen for AssetMaint component. How > and > > When is lastPrice field on SupplierProduct table gets updated? > > > > I'll like to update this information if user provides when they > > ReceivingInventory of Parts. > > > > Can somebody Please help with this. > > > > Thanks and Regards > > Anil Patel > > > |
Re: lastPrice field on SupplierProduct
|
|
Anil, I think what Si is saying is that many companies might not want the process to work as you described below:
"update this information if user provides when they ReceivingInventory of Parts"
Cheers, Tim -- Tim Ruppert HotWax Media o:801.649.6594 f:801.649.6595 On Mar 21, 2007, at 3:50 PM, Anil Patel wrote:
|
smime.p7s (3K)
Re: lastPrice field on SupplierProduct
|
|
In reply to this post by Anil Patel
Si, One more thing here,
So when I search on lastPrice and updateSupplierProduct in the source code, I am unable to find enough information where I can see how and when this information gets updated. Can you Please give some more information on How and when this information is updated. Or is this something very specific to Implementation and so its not part of Ofbiz. Thanks for your time. Regards Anil On 3/21/07, Si Chen <[hidden email]> wrote: > > What I meant was that many companies do not want their purchasing price > to change when they are received at a different price. Some companies do, > many do not, some want it to change with their vendor invoices, some don't > want their warehouse people to be responsible for entering the price to > receive products at. The field supplierproduct.lastprice is though very > much in use and very important. > > Anil Patel wrote: > > Si, Thanks for your Response, Little more info will help to move further. > > So, can we say this field is not in so much use any more. Also so to Keep > track of this data do we have to use PO. > > Regards > Anil > > On 3/21/07, Si Chen <[hidden email]> wrote: > > > > Anil, > > > > Many companies do not want this to happen. > > > > Anil Patel wrote: > > > Hi, > > > I am working on ReceiveInventory screen for AssetMaint component. How > > and > > > When is lastPrice field on SupplierProduct table gets updated? > > > > > > I'll like to update this information if user provides when they > > > ReceivingInventory of Parts. > > > > > > Can somebody Please help with this. > > > > > > Thanks and Regards > > > Anil Patel > > > > > > > |
|
|
In reply to this post by Anil Patel
Anil,
> What I meant was that many companies do not want their purchasing > price to change when they are received at a different price. Some > companies do, many do not, some want it to change with their vendor > invoices, some don't want their warehouse people to be responsible for > entering the price to receive products at. The field > supplierproduct.lastprice is though very much in use and very important. > > Anil Patel wrote: >> Si, Thanks for your Response, Little more info will help to move further. >> >> So, can we say this field is not in so much use any more. Also so to >> Keep track of this data do we have to use PO. >> >> Regards >> Anil >> >> On 3/21/07, *Si Chen* <[hidden email] >> <mailto:[hidden email]>> wrote: >> >> Anil, >> >> Many companies do not want this to happen. >> >> Anil Patel wrote: >> > Hi, >> > I am working on ReceiveInventory screen for AssetMaint >> component. How and >> > When is lastPrice field on SupplierProduct table gets updated? >> > >> > I'll like to update this information if user provides when they >> > ReceivingInventory of Parts. >> > >> > Can somebody Please help with this. >> > >> > Thanks and Regards >> > Anil Patel >> > >> >> |
|
|
In reply to this post by Anil Patel
Anil (and Si),
Actually, I'd like to have the ability to provide an updated price when receiving inventory. As Si suggests many companies wouldn't want to do this, wouldn't they simply leave the prepopulated field alone, and when the items are received, the last_price update is a NOP (sort of). Alternatively, could we provide a checkbox that flags whether a last_price update is to take place (default to no)? Cheers, Iain Anil Patel wrote: > Si, Thanks for your Response, Little more info will help to move further. > > So, can we say this field is not in so much use any more. Also so to Keep > track of this data do we have to use PO. > > Regards > Anil > > On 3/21/07, Si Chen <[hidden email]> wrote: >> >> Anil, >> >> Many companies do not want this to happen. >> >> Anil Patel wrote: >> > Hi, >> > I am working on ReceiveInventory screen for AssetMaint component. How >> and >> > When is lastPrice field on SupplierProduct table gets updated? >> > >> > I'll like to update this information if user provides when they >> > ReceivingInventory of Parts. >> > >> > Can somebody Please help with this. >> > >> > Thanks and Regards >> > Anil Patel >> > >> > > ------------------------------------------------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 21/03/2007 7:52 AM > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 21/03/2007 7:52 AM |
|
|
This really should not be done during inventory receiving because in an
organization of any size, the warehouse person would not be the one to be setting purchasing prices. Sometimes (and only sometimes) this is done in Accounts Payables when the vendor's invoice is approved. Iain Fogg wrote: > Anil (and Si), > > Actually, I'd like to have the ability to provide an updated price > when receiving inventory. As Si suggests many companies wouldn't want > to do this, wouldn't they simply leave the prepopulated field alone, > and when the items are received, the last_price update is a NOP (sort > of). Alternatively, could we provide a checkbox that flags whether a > last_price update is to take place (default to no)? > > Cheers, Iain > > Anil Patel wrote: >> Si, Thanks for your Response, Little more info will help to move >> further. >> >> So, can we say this field is not in so much use any more. Also so to >> Keep >> track of this data do we have to use PO. >> >> Regards >> Anil >> >> On 3/21/07, Si Chen <[hidden email]> wrote: >>> >>> Anil, >>> >>> Many companies do not want this to happen. >>> >>> Anil Patel wrote: >>> > Hi, >>> > I am working on ReceiveInventory screen for AssetMaint component. How >>> and >>> > When is lastPrice field on SupplierProduct table gets updated? >>> > >>> > I'll like to update this information if user provides when they >>> > ReceivingInventory of Parts. >>> > >>> > Can somebody Please help with this. >>> > >>> > Thanks and Regards >>> > Anil Patel >>> > >>> >> >> ------------------------------------------------------------------------ >> >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: >> 21/03/2007 7:52 AM >> > > > |
Re: lastPrice field on SupplierProduct
|
|
Maybe Iain meant receiving a PO - at which time you could update the cost.
Si Chen wrote: > This really should not be done during inventory receiving because in an > organization of any size, the warehouse person would not be the one to > be setting purchasing prices. > > Sometimes (and only sometimes) this is done in Accounts Payables when > the vendor's invoice is approved. > > Iain Fogg wrote: > >> Anil (and Si), >> >> Actually, I'd like to have the ability to provide an updated price >> when receiving inventory. As Si suggests many companies wouldn't want >> to do this, wouldn't they simply leave the prepopulated field alone, >> and when the items are received, the last_price update is a NOP (sort >> of). Alternatively, could we provide a checkbox that flags whether a >> last_price update is to take place (default to no)? >> >> Cheers, Iain >> >> Anil Patel wrote: >> >>> Si, Thanks for your Response, Little more info will help to move >>> further. >>> >>> So, can we say this field is not in so much use any more. Also so to >>> Keep >>> track of this data do we have to use PO. >>> >>> Regards >>> Anil >>> >>> On 3/21/07, Si Chen <[hidden email]> wrote: >>> >>>> >>>> Anil, >>>> >>>> Many companies do not want this to happen. >>>> >>>> Anil Patel wrote: >>>> > Hi, >>>> > I am working on ReceiveInventory screen for AssetMaint component. How >>>> and >>>> > When is lastPrice field on SupplierProduct table gets updated? >>>> > >>>> > I'll like to update this information if user provides when they >>>> > ReceivingInventory of Parts. >>>> > >>>> > Can somebody Please help with this. >>>> > >>>> > Thanks and Regards >>>> > Anil Patel >>>> > >>>> >>> >>> ------------------------------------------------------------------------ >>> >>> No virus found in this incoming message. >>> Checked by AVG Free Edition. >>> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: >>> 21/03/2007 7:52 AM >>> >> >> >> >> > |
Re: lastPrice field on SupplierProduct
|
|
"lastPrice" To me it implies that it will be price I paid in the most recent
Purchase. I don't see this happening. Is this something we should add, This field should be update should be triggered when a PO is received or Invoice is approved or something. Regards Anil On 3/22/07, Adrian Crum <[hidden email]> wrote: > > Maybe Iain meant receiving a PO - at which time you could update the cost. > > Si Chen wrote: > > This really should not be done during inventory receiving because in an > > organization of any size, the warehouse person would not be the one to > > be setting purchasing prices. > > > > Sometimes (and only sometimes) this is done in Accounts Payables when > > the vendor's invoice is approved. > > > > Iain Fogg wrote: > > > >> Anil (and Si), > >> > >> Actually, I'd like to have the ability to provide an updated price > >> when receiving inventory. As Si suggests many companies wouldn't want > >> to do this, wouldn't they simply leave the prepopulated field alone, > >> and when the items are received, the last_price update is a NOP (sort > >> of). Alternatively, could we provide a checkbox that flags whether a > >> last_price update is to take place (default to no)? > >> > >> Cheers, Iain > >> > >> Anil Patel wrote: > >> > >>> Si, Thanks for your Response, Little more info will help to move > >>> further. > >>> > >>> So, can we say this field is not in so much use any more. Also so to > >>> Keep > >>> track of this data do we have to use PO. > >>> > >>> Regards > >>> Anil > >>> > >>> On 3/21/07, Si Chen <[hidden email]> wrote: > >>> > >>>> > >>>> Anil, > >>>> > >>>> Many companies do not want this to happen. > >>>> > >>>> Anil Patel wrote: > >>>> > Hi, > >>>> > I am working on ReceiveInventory screen for AssetMaint component. > How > >>>> and > >>>> > When is lastPrice field on SupplierProduct table gets updated? > >>>> > > >>>> > I'll like to update this information if user provides when they > >>>> > ReceivingInventory of Parts. > >>>> > > >>>> > Can somebody Please help with this. > >>>> > > >>>> > Thanks and Regards > >>>> > Anil Patel > >>>> > > >>>> > >>> > >>> > ------------------------------------------------------------------------ > >>> > >>> No virus found in this incoming message. > >>> Checked by AVG Free Edition. > >>> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: > >>> 21/03/2007 7:52 AM > >>> > >> > >> > >> > >> > > > |
|
|
Anil,
When I originally wrote the purchasing order feature, I did wonder about what meaning the "lastPrice" field should have. Here is what I think we should do: 1. Add a new field to PartyAcctgPreference "autoUpdatePurchasePrice" 2. Create a new service which runs as system user login when a Purchase Invoice is marked as INVOICE_READY. This invoice will check the Invoice.partyIdTo for PartyAcctgPreference, and if it exists and if autoUpdatePurchasePrice = "Y", then do the following (a) For each product item on the list, look for the current SupplierProduct with the same supplier partyId as the Invoice.partyIdFrom, whose minOrderQty is immediately below InvoiceItem.quantity (b) Update the SupplierProduct Note that (a) is pretty tricky if there are many different SupplierProduct with different quantities. Anil Patel wrote: > "lastPrice" To me it implies that it will be price I paid in the most > recent > Purchase. I don't see this happening. Is this something we should add, > This > field should be update should be triggered when a PO is received or > Invoice > is approved or something. > > Regards > > Anil > > On 3/22/07, Adrian Crum <[hidden email]> wrote: >> >> Maybe Iain meant receiving a PO - at which time you could update the >> cost. >> >> Si Chen wrote: >> > This really should not be done during inventory receiving because >> in an >> > organization of any size, the warehouse person would not be the one to >> > be setting purchasing prices. >> > >> > Sometimes (and only sometimes) this is done in Accounts Payables when >> > the vendor's invoice is approved. >> > >> > Iain Fogg wrote: >> > >> >> Anil (and Si), >> >> >> >> Actually, I'd like to have the ability to provide an updated price >> >> when receiving inventory. As Si suggests many companies wouldn't want >> >> to do this, wouldn't they simply leave the prepopulated field alone, >> >> and when the items are received, the last_price update is a NOP (sort >> >> of). Alternatively, could we provide a checkbox that flags whether a >> >> last_price update is to take place (default to no)? >> >> >> >> Cheers, Iain >> >> >> >> Anil Patel wrote: >> >> >> >>> Si, Thanks for your Response, Little more info will help to move >> >>> further. >> >>> >> >>> So, can we say this field is not in so much use any more. Also so to >> >>> Keep >> >>> track of this data do we have to use PO. >> >>> >> >>> Regards >> >>> Anil >> >>> >> >>> On 3/21/07, Si Chen <[hidden email]> wrote: >> >>> >> >>>> >> >>>> Anil, >> >>>> >> >>>> Many companies do not want this to happen. >> >>>> >> >>>> Anil Patel wrote: >> >>>> > Hi, >> >>>> > I am working on ReceiveInventory screen for AssetMaint component. >> How >> >>>> and >> >>>> > When is lastPrice field on SupplierProduct table gets updated? >> >>>> > >> >>>> > I'll like to update this information if user provides when they >> >>>> > ReceivingInventory of Parts. >> >>>> > >> >>>> > Can somebody Please help with this. >> >>>> > >> >>>> > Thanks and Regards >> >>>> > Anil Patel >> >>>> > >> >>>> >> >>> >> >>> >> ------------------------------------------------------------------------ >> >>> >> >>> No virus found in this incoming message. >> >>> Checked by AVG Free Edition. >> >>> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: >> >>> 21/03/2007 7:52 AM >> >>> >> >> >> >> >> >> >> >> >> > >> > |
Re: lastPrice field on SupplierProduct
|
|
Si,
I think it is a good plan. A few thoughts on this: 1) should we consider to add a new "price" field? to store the price and just update the lastPrice field as you have described 2) instead of updating the record, should we expire it and clone it into a new one? 3) I still think, but I don't have a clear picture of the model right now, that the AgreementProductAppl entity should play a role in the definition of the supplier's price list See my last last comment below: Si Chen wrote: > Anil, > > When I originally wrote the purchasing order feature, I did wonder about > what meaning the "lastPrice" field should have. > Here is what I think we should do: > > 1. Add a new field to PartyAcctgPreference "autoUpdatePurchasePrice" > 2. Create a new service which runs as system user login when a Purchase > Invoice is marked as INVOICE_READY. This invoice will check the > Invoice.partyIdTo for PartyAcctgPreference, and if it exists and if > autoUpdatePurchasePrice = "Y", then do the following > (a) For each product item on the list, look for the current > SupplierProduct with the same supplier partyId as the > Invoice.partyIdFrom, whose minOrderQty is immediately below > InvoiceItem.quantity > (b) Update the SupplierProduct > > Note that (a) is pretty tricky if there are many different > SupplierProduct with different quantities. I think that the trick is by getting a list of records where minOrderQty is less than the ordered quantity, sort them by desc minOrderQty, and selecting the first record. Jacopo > > Anil Patel wrote: >> "lastPrice" To me it implies that it will be price I paid in the most >> recent >> Purchase. I don't see this happening. Is this something we should add, >> This >> field should be update should be triggered when a PO is received or >> Invoice >> is approved or something. >> >> Regards >> >> Anil >> >> On 3/22/07, Adrian Crum <[hidden email]> wrote: >>> >>> Maybe Iain meant receiving a PO - at which time you could update the >>> cost. >>> >>> Si Chen wrote: >>> > This really should not be done during inventory receiving because >>> in an >>> > organization of any size, the warehouse person would not be the one to >>> > be setting purchasing prices. >>> > >>> > Sometimes (and only sometimes) this is done in Accounts Payables when >>> > the vendor's invoice is approved. >>> > >>> > Iain Fogg wrote: >>> > >>> >> Anil (and Si), >>> >> >>> >> Actually, I'd like to have the ability to provide an updated price >>> >> when receiving inventory. As Si suggests many companies wouldn't want >>> >> to do this, wouldn't they simply leave the prepopulated field alone, >>> >> and when the items are received, the last_price update is a NOP (sort >>> >> of). Alternatively, could we provide a checkbox that flags whether a >>> >> last_price update is to take place (default to no)? >>> >> >>> >> Cheers, Iain >>> >> >>> >> Anil Patel wrote: >>> >> >>> >>> Si, Thanks for your Response, Little more info will help to move >>> >>> further. >>> >>> >>> >>> So, can we say this field is not in so much use any more. Also so to >>> >>> Keep >>> >>> track of this data do we have to use PO. >>> >>> >>> >>> Regards >>> >>> Anil >>> >>> >>> >>> On 3/21/07, Si Chen <[hidden email]> wrote: >>> >>> >>> >>>> >>> >>>> Anil, >>> >>>> >>> >>>> Many companies do not want this to happen. >>> >>>> >>> >>>> Anil Patel wrote: >>> >>>> > Hi, >>> >>>> > I am working on ReceiveInventory screen for AssetMaint component. >>> How >>> >>>> and >>> >>>> > When is lastPrice field on SupplierProduct table gets updated? >>> >>>> > >>> >>>> > I'll like to update this information if user provides when they >>> >>>> > ReceivingInventory of Parts. >>> >>>> > >>> >>>> > Can somebody Please help with this. >>> >>>> > >>> >>>> > Thanks and Regards >>> >>>> > Anil Patel >>> >>>> > >>> >>>> >>> >>> >>> >>> >>> ------------------------------------------------------------------------ >>> >>> >>> >>> No virus found in this incoming message. >>> >>> Checked by AVG Free Edition. >>> >>> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: >>> >>> 21/03/2007 7:52 AM >>> >>> >>> >> >>> >> >>> >> >>> >> >>> > >>> >> |
Re: lastPrice field on SupplierProduct
|
|
In reply to this post by Si Chen-2
On Mar 22, 2007, at 4:03 PM, Si Chen wrote: > When I originally wrote the purchasing order feature, I did wonder > about what meaning the "lastPrice" field should have. If I remember right the original definition of this was to be the "last known price" from the supplier, generally pulled from a price list and either maintained as POs are submitted and the supplier replies, or when updated price lists are received. -David |
|
|
In reply to this post by Iain Fogg
REMOVE ME
REMOVE ME --------------------------------- All New Yahoo! Mail Tired of unwanted email come-ons? Let our SpamGuard protect you. |
|
|
UNSUBCRIBE
--------------------------------- The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. |
|
|
Send a blank email to here: [hidden email]
On 25/03/07, PhantomsHorridC <[hidden email]> wrote: > > UNSUBCRIBE > > --------------------------------- > The all-new Yahoo! Mail goes wherever you go - free your email address > from your Internet provider. |
|
|
In reply to this post by Jacopo Cappellato
Anil,
Are you planning to implement this? Jacopo Cappellato wrote: > Si, > > I think it is a good plan. A few thoughts on this: > > 1) should we consider to add a new "price" field? to store the price > and just update the lastPrice field as you have described > 2) instead of updating the record, should we expire it and clone it > into a new one? > 3) I still think, but I don't have a clear picture of the model right > now, that the AgreementProductAppl entity should play a role in the > definition of the supplier's price list > > See my last last comment below: > > Si Chen wrote: >> Anil, >> >> When I originally wrote the purchasing order feature, I did wonder >> about what meaning the "lastPrice" field should have. >> Here is what I think we should do: >> >> 1. Add a new field to PartyAcctgPreference "autoUpdatePurchasePrice" >> 2. Create a new service which runs as system user login when a >> Purchase Invoice is marked as INVOICE_READY. This invoice will check >> the Invoice.partyIdTo for PartyAcctgPreference, and if it exists and >> if autoUpdatePurchasePrice = "Y", then do the following >> (a) For each product item on the list, look for the current >> SupplierProduct with the same supplier partyId as the >> Invoice.partyIdFrom, whose minOrderQty is immediately below >> InvoiceItem.quantity >> (b) Update the SupplierProduct >> >> Note that (a) is pretty tricky if there are many different >> SupplierProduct with different quantities. > > I think that the trick is by getting a list of records where > minOrderQty is less than the ordered quantity, sort them by desc > minOrderQty, and selecting the first record. > > Jacopo > >> >> Anil Patel wrote: >>> "lastPrice" To me it implies that it will be price I paid in the >>> most recent >>> Purchase. I don't see this happening. Is this something we should >>> add, This >>> field should be update should be triggered when a PO is received or >>> Invoice >>> is approved or something. >>> >>> Regards >>> >>> Anil >>> >>> On 3/22/07, Adrian Crum <[hidden email]> wrote: >>>> >>>> Maybe Iain meant receiving a PO - at which time you could update >>>> the cost. >>>> >>>> Si Chen wrote: >>>> > This really should not be done during inventory receiving because >>>> in an >>>> > organization of any size, the warehouse person would not be the >>>> one to >>>> > be setting purchasing prices. >>>> > >>>> > Sometimes (and only sometimes) this is done in Accounts Payables >>>> when >>>> > the vendor's invoice is approved. >>>> > >>>> > Iain Fogg wrote: >>>> > >>>> >> Anil (and Si), >>>> >> >>>> >> Actually, I'd like to have the ability to provide an updated price >>>> >> when receiving inventory. As Si suggests many companies wouldn't >>>> want >>>> >> to do this, wouldn't they simply leave the prepopulated field >>>> alone, >>>> >> and when the items are received, the last_price update is a NOP >>>> (sort >>>> >> of). Alternatively, could we provide a checkbox that flags >>>> whether a >>>> >> last_price update is to take place (default to no)? >>>> >> >>>> >> Cheers, Iain >>>> >> >>>> >> Anil Patel wrote: >>>> >> >>>> >>> Si, Thanks for your Response, Little more info will help to move >>>> >>> further. >>>> >>> >>>> >>> So, can we say this field is not in so much use any more. Also >>>> so to >>>> >>> Keep >>>> >>> track of this data do we have to use PO. >>>> >>> >>>> >>> Regards >>>> >>> Anil >>>> >>> >>>> >>> On 3/21/07, Si Chen <[hidden email]> wrote: >>>> >>> >>>> >>>> >>>> >>>> Anil, >>>> >>>> >>>> >>>> Many companies do not want this to happen. >>>> >>>> >>>> >>>> Anil Patel wrote: >>>> >>>> > Hi, >>>> >>>> > I am working on ReceiveInventory screen for AssetMaint >>>> component. >>>> How >>>> >>>> and >>>> >>>> > When is lastPrice field on SupplierProduct table gets updated? >>>> >>>> > >>>> >>>> > I'll like to update this information if user provides when they >>>> >>>> > ReceivingInventory of Parts. >>>> >>>> > >>>> >>>> > Can somebody Please help with this. >>>> >>>> > >>>> >>>> > Thanks and Regards >>>> >>>> > Anil Patel >>>> >>>> > >>>> >>>> >>>> >>> >>>> >>> >>>> ------------------------------------------------------------------------ >>>> >>>> >>> >>>> >>> No virus found in this incoming message. >>>> >>> Checked by AVG Free Edition. >>>> >>> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: >>>> >>> 21/03/2007 7:52 AM >>>> >>> >>>> >> >>>> >> >>>> >> >>>> >> >>>> > >>>> >>> > > |
Re: lastPrice field on SupplierProduct
|
|
After David's mail, I am not sure what we want to do with this. Can we have
a final word on requirements, I'll take up the implementation. Regards Anil On 3/26/07, Si Chen <[hidden email]> wrote: > > Anil, > > Are you planning to implement this? > > Jacopo Cappellato wrote: > > Si, > > > > I think it is a good plan. A few thoughts on this: > > > > 1) should we consider to add a new "price" field? to store the price > > and just update the lastPrice field as you have described > > 2) instead of updating the record, should we expire it and clone it > > into a new one? > > 3) I still think, but I don't have a clear picture of the model right > > now, that the AgreementProductAppl entity should play a role in the > > definition of the supplier's price list > > > > See my last last comment below: > > > > Si Chen wrote: > >> Anil, > >> > >> When I originally wrote the purchasing order feature, I did wonder > >> about what meaning the "lastPrice" field should have. > >> Here is what I think we should do: > >> > >> 1. Add a new field to PartyAcctgPreference "autoUpdatePurchasePrice" > >> 2. Create a new service which runs as system user login when a > >> Purchase Invoice is marked as INVOICE_READY. This invoice will check > >> the Invoice.partyIdTo for PartyAcctgPreference, and if it exists and > >> if autoUpdatePurchasePrice = "Y", then do the following > >> (a) For each product item on the list, look for the current > >> SupplierProduct with the same supplier partyId as the > >> Invoice.partyIdFrom, whose minOrderQty is immediately below > >> InvoiceItem.quantity > >> (b) Update the SupplierProduct > >> > >> Note that (a) is pretty tricky if there are many different > >> SupplierProduct with different quantities. > > > > I think that the trick is by getting a list of records where > > minOrderQty is less than the ordered quantity, sort them by desc > > minOrderQty, and selecting the first record. > > > > Jacopo > > > >> > >> Anil Patel wrote: > >>> "lastPrice" To me it implies that it will be price I paid in the > >>> most recent > >>> Purchase. I don't see this happening. Is this something we should > >>> add, This > >>> field should be update should be triggered when a PO is received or > >>> Invoice > >>> is approved or something. > >>> > >>> Regards > >>> > >>> Anil > >>> > >>> On 3/22/07, Adrian Crum <[hidden email]> wrote: > >>>> > >>>> Maybe Iain meant receiving a PO - at which time you could update > >>>> the cost. > >>>> > >>>> Si Chen wrote: > >>>> > This really should not be done during inventory receiving because > >>>> in an > >>>> > organization of any size, the warehouse person would not be the > >>>> one to > >>>> > be setting purchasing prices. > >>>> > > >>>> > Sometimes (and only sometimes) this is done in Accounts Payables > >>>> when > >>>> > the vendor's invoice is approved. > >>>> > > >>>> > Iain Fogg wrote: > >>>> > > >>>> >> Anil (and Si), > >>>> >> > >>>> >> Actually, I'd like to have the ability to provide an updated price > >>>> >> when receiving inventory. As Si suggests many companies wouldn't > >>>> want > >>>> >> to do this, wouldn't they simply leave the prepopulated field > >>>> alone, > >>>> >> and when the items are received, the last_price update is a NOP > >>>> (sort > >>>> >> of). Alternatively, could we provide a checkbox that flags > >>>> whether a > >>>> >> last_price update is to take place (default to no)? > >>>> >> > >>>> >> Cheers, Iain > >>>> >> > >>>> >> Anil Patel wrote: > >>>> >> > >>>> >>> Si, Thanks for your Response, Little more info will help to move > >>>> >>> further. > >>>> >>> > >>>> >>> So, can we say this field is not in so much use any more. Also > >>>> so to > >>>> >>> Keep > >>>> >>> track of this data do we have to use PO. > >>>> >>> > >>>> >>> Regards > >>>> >>> Anil > >>>> >>> > >>>> >>> On 3/21/07, Si Chen <[hidden email]> wrote: > >>>> >>> > >>>> >>>> > >>>> >>>> Anil, > >>>> >>>> > >>>> >>>> Many companies do not want this to happen. > >>>> >>>> > >>>> >>>> Anil Patel wrote: > >>>> >>>> > Hi, > >>>> >>>> > I am working on ReceiveInventory screen for AssetMaint > >>>> component. > >>>> How > >>>> >>>> and > >>>> >>>> > When is lastPrice field on SupplierProduct table gets updated? > >>>> >>>> > > >>>> >>>> > I'll like to update this information if user provides when > they > >>>> >>>> > ReceivingInventory of Parts. > >>>> >>>> > > >>>> >>>> > Can somebody Please help with this. > >>>> >>>> > > >>>> >>>> > Thanks and Regards > >>>> >>>> > Anil Patel > >>>> >>>> > > >>>> >>>> > >>>> >>> > >>>> >>> > >>>> > ------------------------------------------------------------------------ > >>>> > >>>> >>> > >>>> >>> No virus found in this incoming message. > >>>> >>> Checked by AVG Free Edition. > >>>> >>> Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: > >>>> >>> 21/03/2007 7:52 AM > >>>> >>> > >>>> >> > >>>> >> > >>>> >> > >>>> >> > >>>> > > >>>> > >>> > > > > > |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |