Difference between revisions of "PO Data Report"

From Adjutant Wiki

m (Tcampbell moved page Openpo to PO Data Report)
 
Line 1: Line 1:
 +
__NOTOC__
  
 +
===General Information===
 +
 +
'''Default Menu Location''' Reports >> Purchase Order >> Open PO Report
 +
 +
'''URL''' Reports/OpenPo_S.htm
 +
 +
'''Function''' Purchase Order Data shows users a list of orders with various filters and the status of those purchase orders.
 +
 +
 +
[[image:POdatareport.png]]
 +
 +
 +
===Report Filters===
 +
 +
'''Vendorno:''' Vendor number
 +
 +
'''Vendor:''' Vendor name
 +
 +
'''PO Date:''' Purchase Order date range for the report
 +
 +
'''Required Date:''' Required date range for the report (Req date field on the PO)
 +
 +
'''Department:'''  Report for specific department
 +
 +
'''PO Type:''' Purchase Order type
 +
 +
'''Whse:''' Warehouse location
 +
 +
'''Order Status:''' Options to choose for order status for the report
 +
 +
'''Line Items Status:''' Options to choose for items status for the report
 +
 +
===Standard Report Fields (Page Header)===
 +
 +
'''Company:'''
 +
 +
* lc_company
 +
 +
'''Report Type:'''
 +
 +
* lc_filter
 +
 +
===Group Header===
 +
 +
'''Purchase Order'''
 +
 +
* pono
 +
 +
'''Vendor'''
 +
 +
* company + " : " + custno
 +
 +
'''Department'''
 +
 +
* dept
 +
 +
'''PO Date'''
 +
 +
* podate
 +
 +
'''ReqDate'''
 +
 +
* reqdateh
 +
 +
'''Remarks'''
 +
 +
* remarks
 +
 +
===Detail===
 +
 +
'''Purchase Order'''
 +
 +
* pono
 +
 +
'''Subtotal'''
 +
 +
* qtyord * cost
 +
 +
* (qtyord - qtyrec) * cost
 +
 +
===Summary===
 +
 +
'''Total'''
 +
 +
* qtyord * cost
 +
 +
* (qtyord - qtyrec) * cost
 +
 +
[[Category:Purchasing]]

Latest revision as of 11:58, 15 December 2022


General Information

Default Menu Location Reports >> Purchase Order >> Open PO Report

URL Reports/OpenPo_S.htm

Function Purchase Order Data shows users a list of orders with various filters and the status of those purchase orders.


POdatareport.png


Report Filters

Vendorno: Vendor number

Vendor: Vendor name

PO Date: Purchase Order date range for the report

Required Date: Required date range for the report (Req date field on the PO)

Department: Report for specific department

PO Type: Purchase Order type

Whse: Warehouse location

Order Status: Options to choose for order status for the report

Line Items Status: Options to choose for items status for the report

Standard Report Fields (Page Header)

Company:

  • lc_company

Report Type:

  • lc_filter

Group Header

Purchase Order

  • pono

Vendor

  • company + " : " + custno

Department

  • dept

PO Date

  • podate

ReqDate

  • reqdateh

Remarks

  • remarks

Detail

Purchase Order

  • pono

Subtotal

  • qtyord * cost
  • (qtyord - qtyrec) * cost

Summary

Total

  • qtyord * cost
  • (qtyord - qtyrec) * cost
Retrieved from "http://www.abiscorp.com/faq/index.php?title=PO_Data_Report&oldid=4377"