Difference between revisions of "PO Data Report"
From Adjutant Wiki
(Created blank page) |
|||
(One intermediate revision by the same user not shown) | |||
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.
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