Hi,
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.
Yasar
There is a realtion,
PriceDiscTable.OriginalPriceDiscAdmTransRecId == PriceDiscAdmTrans.RecId
thank you
Dear Kranthi,
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
What does that mean? Please elaborate.
Dear Kranthi,
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.
Dear Kranthi,
Still i have multiple record coming in PriceDiscAdmTrans.PriceDiscTableRef . Is there anymore connection for the final latest.
Please see the below screen shot for your kind references.
Will you be able to show your latest code?
I am trying to bring the Price agreement journal number to display in the price disc table. please see the below screen print as requested
I don’t see findTableRecId() in standard.
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.
Have you looked at this reply? It seems you haven’t aligned your code as per that comment.
Yes, this i have made with the relation “PriceDiscAdmTrans.PriceDiscTableRef == PriceDiscTable .RecId” which is not for the initial record and for the modified record. With this relation still multiple transactions are coming in the PriceDiscAdmTrans Table with the PriceDiscTable.RecId as i mentioned in the below screen print. this is coming when i am doing the two lines (for same item) together in one price agreement journal.
OK, you have two journals numbers for same priceDiscTable record in PriceDiscAdmTrans. In this case which one you want to show?
i want to show the latest
Then sort the selection on that field which you think will give you the latest record (in your case).
Example - Sort by RecId or journal number.