Include List Price in Purchase Order Report


R

RicoTowers

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

Advertisements

A

Andy Miller - RVP Business Systems

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.)
--
Regards,
Andy Miller
RVP Business Systems - Boise, Idaho
(208) 376-8121
www.rvpsystems.com
 
R

RicoTowers

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

Ok so how do I go about it.
 
M

Matt Hurst

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:

Begin Column
FieldName = "Retail"
DrillDownFieldName = ""
Title = "Retail Total"
VBDataType = vbCurrency
Formula = "SUM(Item.Price * PurchaseOrderEntry.QuantityOrdered)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1335
GroupMethod = groupmethodSum
ColFormat = ""
End Column
 
Ad

Advertisements

R

RicoTowers

Exellent!

Worked perfectly ...Thanx Lots!!!


Matt Hurst said:
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:

Begin Column
FieldName = "Retail"
DrillDownFieldName = ""
Title = "Retail Total"
VBDataType = vbCurrency
Formula = "SUM(Item.Price * PurchaseOrderEntry.QuantityOrdered)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1335
GroupMethod = groupmethodSum
ColFormat = ""
End Column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top