Welcome, Guest. Please Login.
05/10/25 at 00:55:38
News:
Home Help Search Login


Pages: 1
Send Topic Print
PO by Job Number Report (Read 341 times)
kerric
Member
**


I love YaBB 1G -
SP1!

Posts: 98
PO by Job Number Report
10/12/04 at 04:46:02
 
Good morning.  Our former purchasing agent had a report that he ran, it appears to be 'User Defined', but we are having difficulty recreating it.  
 
Open POs are listed, first by Job # (It groups all POs for a job, then goes to next job).  It has the vendor, PO#, Item#, Order Qty, Open, Qty, UM, Order Date and Est. Date fields.  
 
We don't use Crystal reports or any of that.  I tried PO-I-A, User Defined and I haven't gotten it to come out right yet.  Will someone help me try to recreate it?  I can fax a copy if it will help.  Thank you.
Back to top
 
 
Email   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: PO by Job Number Report
Reply #1 - 10/12/04 at 11:27:42
 
try PO-I-E
text format - "NO"
Details  "Yes"
Report type- "user defined"
Print filter   "N"
Short Form  "S"  
now hit the USER DEFINED button at the bottom,
F2 index 1 and scroll down and choose the 16th option JOB#
(you could F2 the other indexes, but leaving them blank will give you desired order)
hit RETURN button and you will return to top of page 1,  keep pressing enter, accepting the defaults until you get to the job# field in column two on page 1 and  enter your range.
You can F10 or continueing defuaulting until you are on page 2 and then you can F10.
 
You can later shorten the data retreival time by playing with variables such as dates, etc.
 
PLEASE NOTE:  I have never found a way to get a PO report to reflect both received and unreceived items.  I have to print 2 reports.    The same is true with job costing reports....even the ones which attempt to give you projections which should include unreceived PO items.
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print