Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supplier Performance Report

Status
Not open for further replies.
niallo32

niallo32

IS-IT--Management
Apr 29, 2004
404
IE
I am trying to run a Supplier Performance Report from JDE to Access. I am using two tables - F43090 - Supplier Item Relationship & F43121 - Purchase Order Receivers. I require the following fields on the Report - Supplier, Item Code, Order No, Order Date, Qty Ordered etc etc.

I am having a problem with the date fields when I run I link the tables into Access. Promised Delivery Date, Actual Delivery Date & Order Date are all displaying in Julian Date format. Does anyone know how I can get these fields to display as DDMMYY?

Thanks,
 
Status
Not open for further replies.

Similar threads

Heather Rich
  • Locked
  • Question
"Expiring" Inventory Reports Using Sell By/Ship By
Replies
0
Views
264
Heather Rich
Heather Rich
jdemike
  • Locked
  • Question
Introducing A Levy Against Suppliers Via Accounts Payable
Replies
1
Views
254
jmd0252
jmd0252
ceil32
  • Locked
  • Question
How to change a field in a report
Replies
2
Views
202
ceil32
ceil32
bkatoch
  • Locked
  • Question
J D Edwards World FASTR Consoldated Balance Sheet Report
Replies
1
Views
184
jmd0252
jmd0252
Arthur1
  • Locked
  • Question
JD Edwards Performance Monitoring and Archiving
Replies
2
Views
155
cglass
cglass

Part and Inventory Search

Sponsor

Back
Top