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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 >>>> >>> >>>> >> >>>> >> >>>> >> >>>> >> >>>> > >>>> >>> > >
