Include List Price in Purchase Order Report

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.

Reply to
RicoTowers
Loading thread data ...

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

Reply to
Andy Miller - R

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.

Reply to
RicoTowers

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

Reply to
Matt Hurst

Exellent!

Worked perfectly ...Thanx Lots!!!

"Matt Hurst" wrote:

Reply to
RicoTowers

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.