I am trying to bring the display fields to PriceDiscTable from the data PriceDiscAdmTrans Table but i could not find any common identifier to connect both. anyone please help me.
Please see the below screen print for the both tables, if i modify the price discadmtrans table no changes on originalPriceDiscAdmTransRecId. how can i connect the modified journal from PriceDiscAdmTrans Table
arafathandu said: i modify the price discadmtrans table no changes on originalPriceDiscAdmTransRecId.
What does that mean? Please elaborate.
i have modified the price by using released products/sell/sales price/edit selected lines, then a new journal has been created but the pricedisctable/OriginalPriceDiscAdmTransRecId field is not changing based on the new journal line of pricediscadmtrans table.
Every time you modify the price there will be a new PriceDiscAdmTrans and there will be only one PriceDiscTable record (this will be updated every the the price is modified). In this case the PriceDiscTable.OriginalPriceDiscAdmTransRecId == PriceDiscAdmTrans.RecId will not work as there are multiple PriceDiscAdmTrans records for a given PriceDiscTable record.
The initial record will have the PriceDiscAdmTrans.PriceDiscTableRef as zero. So in this case, you need to use PriceDiscTable.OriginalPriceDiscAdmTransRecId == PriceDiscAdmTrans.RecId.
Every time the price is modified a new record will be created in PriceDiscAdmTrans and PriceDiscTableRef will have the value.So in this case, you need to use PriceDiscAdmTrans.PriceDiscTableRef == PriceDiscTable .RecId.