Add field to Printed PO

try to add PurchaseOrderEntry.Entry.Item.Quantity .. but I think that will be not possible (in the COM object the PurchaseOrder are only methods to get/put data in database).

cod

HI Laura, Please rate me as I am attaching you the list of variable can be used in PO.xml or PORcv.xml

Purchase Orders and Inventory Transfers Template Variables The following receipt template variables contain information about purchase orders and inventory transfers. Variables that reference a collection must be passed a key to the desired entry.

Variable Description Purchaseorder.Mode Mode of the purchase order. This is one of the following values:

PurchaseOrderModeEdit

PurchaseOrderModeIssue

PurchaseOrderModeReceive Purchaseorder.Type Type of the purchase order. This is one of the following values:

PurchaseOrderTypeLocal

PurchaseOrderTypeLocalIssue

PurchaseOrderTypeLocalReceive

PurchaseOrderTypeHQ

PurchaseOrderTypeHQIssue

PurchaseOrderTypeHQReceive Purchaseorder.Number Number of the purchase order. Purchaseorder.Title Title of the purchase order. Purchaseorder.Supplier Name of the supplier for the purchase order. Purchaseorder.Supplier.AccountNumber Account number of the supplier for the purchase order. Purchaseorder.ShipTo Address to which the purchase order will be shipped. Purchaseorder.Recipient Name of the recipient for the purchase order. Purchaseorder.DateCreated Date on which the purchase order was created. Purchaseorder.DateRequired Date by which the purchase order must be received. Purchaseorder.Requisitioner Name of the person that requisitioned the purchase order. Purchaseorder.Remarks Comments for the purchase order. Purchaseorder.ShipVia Method by which the order will be shipped. Purchaseorder.FOBpoint Free-on-board point at which the receiver assumes responsibility for payment of shipping costs. Purchaseorder.Terms Terms of the shipment. Purchaseorder.Freight Additional information about the shipping method. Purchaseorder.ConfirmingTo Name of the person responsible for filling the purchase order. Purchaseorder.TaxRate Tax rate for the purchase order. Purchaseorder.ShipRate Shipping rate for the purchase order. Purchaseorder.SubTotal Sum of the prices of all quantities of all items on the purchase order. Purchaseorder.TaxTotal Total tax for the purchase order. Purchaseorder.Total Total for the order. This is the sum of the subtotal, total tax, and shipping charge. Purchaseorder.SubTotalRTD Subtotal for all items received to date on the purchase order. Purchaseorder.TaxTotalRTD Total tax for all items received to date on the purchase order. Purchaseorder.TotalRTD Total for all items received to date on the purchase order. This is the sum of SubTotalRTD, TaxTotalRTD, and the shipping charge. Purchaseorder.SubTotalReceived Subtotal for all items received on the purchase order. Purchaseorder.TaxTotalReceived Total tax for all items received on the purchase order. Purchaseorder.TotalReceived Total for all items received on the purchase order. This is the sum of SubTotalReceived, TaxTotalReceived, and the shipping charge. Purchaseorder.TotalQuantityRTD Total number of items on the purchase order received to date. Purchaseorder.TotalQuantityOrdered Total number of items ordered on the purchase order. Purchaseorder.TotalQuantityReceived Total number of items received on the purchase order. Purchaseorder.TotalUnitPrice Sum of the prices for a single unit of each item on the purchase order. Purchaseorder.TotalExtendedPrice Total price for all quantities of items received on the purchase order. Purchaseorder.TotalExtendedPriceRTD Subtotal for all items received to date on the purchase order. Purchaseorder.Entries.Count Number of entries on the purchase order. Purchaseorder.Entry.QuantityOrdered Number of items ordered in the specified purchase order entry. Purchaseorder.Entry.QuantityReceived Number of items received in the specified purchase order entry. Purchaseorder.Entry.QuantityRTD Number of items received to date in the specified purchase order entry. PurchaseOrder.Entry.QuantityOnHand Number of items in stock for the item in the specified purchase order entry. Purchaseorder.Entry.OrderNumber Order number of the specified purchase order entry. Purchaseorder.Entry.Lookupcode Item lookup code for the specified purchase order entry. Purchaseorder.Entry.Description Description of the specified purchase order entry. Purchaseorder.Entry.SubDescription1

Purchaseorder.Entry.SubDescription2

Purchaseorder.Entry.SubDescription3 Item subdescriptions for the specified purchase order entry. Purchaseorder.Entry.ExtendedDescription Extended description for the specified purchase order entry. Purchaseorder.Entry.BinLocation Bin location for the specified purchase order entry. Purchaseorder.Entry.UnitWeight Unit of weight for the item in the specified purchase order entry. Purchaseorder.Entry.UnitsOfMeasure Units of measure for the item in the specified purchase order entry. PurchaseOrder.Entry.ItemPrice Price at which the store sells the item in the specified purchase order entry. PurchaseOrder.Entry.MPQ Supplier?s master pack quantity for the item in the specified purchase order entry. PurchaseOrder.Entry.MinimumOrder Supplier?s minimum order for the item in the specified purchase order entry. PurchaseOrder.Entry.SerialEntry.Number1 PurchaseOrder.Entry.SerialEntry.Number2 PurchaseOrder.Entry.SerialEntry.Number3 Serial numbers for serialized items on purchase and transfer orders. These variables are only valid when an order is received, and must be used inside a FOR element with an each attribute of "PurchaseOrderEntrySerialEntry". Purchaseorder.Entry.UnitPrice Supplier's price for a single unit of the item in the specified purchase order entry. Purchaseorder.Entry.ExtendedPriceOrdered Supplier's price for all ordered quantities of the item in the specified purchase order entry. Purchaseorder.Entry.ExtendedPriceReceived Supplier's price for all received quantities of the item in the specified purchase order entry. Purchaseorder.Entry.ExtendedPriceRTD Supplier's price for all quantities received to date of the item in the specified purchase order entry. Purchaseorder.Entry.ExtendedTaxOrdered Total tax for all ordered quantities of the item in the specified purchase order entry. Purchaseorder.Entry.ExtendedTaxReceived Total tax for all received quantities of the item in the specified purchase order entry. Purchaseorder.Entry.ExtendedTaxRTD Total tax for all quantities received to date of the item in the specified purchase order entry. Purchaseorder.Entry.TaxRate Tax rate for the item in the specified purchase order entry. Purchaseorder.Entry.TotalOrdered Total for all ordered quantities of the item in the specified purchase order entry, including tax. Purchaseorder.Entry.TotalReceived Total for all received quantities of the item in the specified purchase order entry, including tax. Purchaseorder.Entry.TotalRTD Total for all quantities received to date of the item in the specified purchase order entry, including tax. Configuration.Logofilename File name of the logo image printed on the order.

"Laura" wrote:

Hi,

I would like to add the Quantity on Hand to the printed PO. I looked in customer source and did not find a new PO report that would work so I need to make the changes myself. Has any one added this to thier PO and is willing to share or could someone make a recommendation on how to change a copy of the original PO report to add the Quanitiy on Hand (and they haven't asked for it yet but I would be willing to bet that they will be asking for Qty committed next).

Thanks, Laura

Akber,

This is great! How did you create this list? I would like to be able to do it for other reports I tweak.

Laura

"Akber Alwani" wrote:

Jeff,

I th> Laura,

Laura, You need to be using a newsreader to see and download attached reports. The one he attached is 'Custom - Orders - Purchase Order.qrp'. It should give you what you need. Craig