Show Misc Charges attached with Purchase Order Lines

(0) Share

Report

Posted on by A.Prasanna

8,221

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

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community member on at

Like (0)

Report

Show Misc Charges attached with Purchase Order Lines

I was wondering, is there someone who can assist me with an SQL query to remove charges from a purchase order?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

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);

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

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

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

Hi Amith Prasanna,

If you open "Maintain charges" form from header or line level you can right click on it -> Personalize. Then on "Query" tab you will see query and how it's joined to purchtable\purchline.

Was this reply helpful? Yes No
A.Prasanna 8,221 on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

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

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

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.

Was this reply helpful? Yes No
A.Prasanna 8,221 on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

I can't see charges already added and Not allocated .

thanks,

Amith Prasanna

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: Show Misc Charges attached with Purchase Order Lines

Hi Amith Prasanna,

What kind of information is missing in MarkupTrans ?

Was this reply helpful? Yes No