8,161
Dear Friends ,
I need to show , Purchase order Number and attached Misc Charge Details (Markup Code, Txt and Amount) in Form Grid and should able to filter by PurchId .I'm thinking of using MarkupTrans Table but It's seems to it's doesn't include all the transactions .
can any one able to guide me how to do this.
thanks in Advance,
Amith Prasanna
you can try this:
select sum (Value) from markupTrans where markupTrans.TransRecId == vendInvoiceInfoTable.RecId &&
markupTrans.TransTableId == vendInvoiceInfoTable.TableId
|| ( markupTrans.TransRecId == vendInvoiceInfoLine.RecId && markupTrans.TransTableId == vendInvoiceInfoLine.TableId);
Hi Amith Prasanna,
Just a side question here:
In the Header you write that you want to show misc. charges attached to your PO lines. If the charges already sit at the line level, what do you want to distribute?
Best regards,
Ludwig
thanks for the suggestion.will you able to guide me to get MarkupTrans by PurchId to Form or Report?.I have issue with Building query .
thanks!,
Amith Prasanna
It sounds obvious but to see not allocated trans you need to allocate them. If you don't want you probably have to copy logic behind allocation to create your own allocation to temp table to be able to display this data on the form.
I can't see charges already added and Not allocated .
thanks,
Amith Prasanna
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,263
Super User 2024 Season 2
#2
Martin Dráb
228,112
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (