Feature - Added PO by Comment Code List to the Schedule Receipts Reports
Release date: 5/16/2018
Added PO by Comment Code List to the Schedule Receipts Reports.
Go to Purchase Order -> Reports -> Schedule Receipts Reports -> List -> PO by Comment Code List
The select criteria is very similar to PO Edit List except:
(a) The “Show Headers Only?” prompt is replaced by "Show Pending Receiving Only?.” Default is N.
If “Y,” we only show those PO line items that have pending ATP receiving.
(b) Selection by comment code.
User can select up to 5 comment codes. Each comment code is 2 digits.
User can also hit Enter for the first comment code to make it “All.”
User can select up to 5 comment codes. Each comment code is 2 digits.
User can also hit Enter for the first comment code to make it “All.”
The report will have the following columns:
PO#
Vendo#
Ship-To
PODate
Line#
Item#
Qty
UOM
Unit Price exp-unit-cost
Request Date
Promise date
Job-No
Sts
Vendo#
Ship-To
PODate
Line#
Item#
Qty
UOM
Unit Price exp-unit-cost
Request Date
Promise date
Job-No
Sts
The optional CSV file will have the following columns:
Item#
PO#
Line#
Cat – Product Category
P/M – Show P for Purchase, M/MP/MM for Manufacturing, K for Kit
Sts – PO Header/Line Item Status – it could be Unreleased, Released, Printed,
Change Pending, Canceled, Canceled Pending, Closed (line item status can override header)
Buyer
PODate
ReqDate - POORDLIN request date
PromDate - POORDLIN promise date
OrigProm - POORDLIN original promise date
ETA - Calculated based on PO lead time
Qty
UnitPrice
ExtAmt - = Qty * UnitPrice
Change? The value here could be blank, “Price Changed,” “Qty Changed” or
“Price/Qty Changed”
Cancel? Will be “Y” if either PO header or line item is canceled
JobNo
UserDefCd - POORDLIN – ORD-LINE-USER-DEFINED-CODE
Vessel - If has a pending ATP (R record), will contain vessel#
PO#
Line#
Cat – Product Category
P/M – Show P for Purchase, M/MP/MM for Manufacturing, K for Kit
Sts – PO Header/Line Item Status – it could be Unreleased, Released, Printed,
Change Pending, Canceled, Canceled Pending, Closed (line item status can override header)
Buyer
PODate
ReqDate - POORDLIN request date
PromDate - POORDLIN promise date
OrigProm - POORDLIN original promise date
ETA - Calculated based on PO lead time
Qty
UnitPrice
ExtAmt - = Qty * UnitPrice
Change? The value here could be blank, “Price Changed,” “Qty Changed” or
“Price/Qty Changed”
Cancel? Will be “Y” if either PO header or line item is canceled
JobNo
UserDefCd - POORDLIN – ORD-LINE-USER-DEFINED-CODE
Vessel - If has a pending ATP (R record), will contain vessel#
HdComment1 Export the data as “CD: Text” where CD is the comment code and Text
is the text from the comment code file.
HdComment2 "
HdComment3 "
HdAddCmt1
HdAddCmt2
HdAddCmt3
LineComment1 Export the data as “CD: Text” where CD is the comment code and
Text is the text from the comment code file.
LineComment2 "
LineAddCmt1
LineAddCmt2
CommodityCd
Notify
MoveTo
ItemDesc1
ItemDesc2
VendItem#
AcctNo
is the text from the comment code file.
HdComment2 "
HdComment3 "
HdAddCmt1
HdAddCmt2
HdAddCmt3
LineComment1 Export the data as “CD: Text” where CD is the comment code and
Text is the text from the comment code file.
LineComment2 "
LineAddCmt1
LineAddCmt2
CommodityCd
Notify
MoveTo
ItemDesc1
ItemDesc2
VendItem#
AcctNo
Programs modified:
PO0400, POCMTLST (NEW), POCMTSCN (NEW)
DLM