Include List Price in Purchase Order Report

Aug 11, 2009 4 Replies

How can I include the list price of the items in the "Purchase Order List Report". We need to include the prices so we can place the calculation for profit and have the Purchase Manager make accurate pricing decision.



Exactly what report are you referring too. Is this a report from the reports tab in manager (yes possible) Is this the purchase order that is printed? (yes i believe this could be possible) or are you refering the the purchase order screen on the monitor? (i don't believe this would be possible without some sort of add-on.)

The exact report is "Purchase Order List Report". Its in Reports >> Quotes/Orders >> Purchase Order.

Ok so how do I go about it.

"Andy Miller - RVP Bus> Exactly what report are you referring too.

memorize the report, then edit in notepad. Add this line to the bottom of your Query section:

LEFT JOIN Item WITH(NOLOCK) on item.id=itemid

Then add this column to the bottom of the report:

Beg> The exact report is "Purchase Order List Report". Its in Reports >>

Exellent!

Worked perfectly ...Thanx Lots!!!

"Matt Hurst" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required