Topic Options
#55446 - 10/25/17 10:32 AM GridView report from OE Ord Detail w/ Header
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Any reason the Bill to email and the Ship to email fields are not on the list of available fields to add to a View?

Or am I missing something?

Versions are GV 9.2B and OE 9.2A (170710).

Thanks

Steve

Top
#55448 - 10/25/17 10:45 AM Re: GridView report from OE Ord Detail w/ Header [Re: Steve Schwartz]
Softrak Support Online   happy

Adagio Action Team

Registered: 03/09/99
Posts: 11557
Loc: Vancouver, BC Canada
Hi Steve,

For some reason, the Billing Contact and Email address fields are named 'Invoices Contact' and 'Invoices Email' in the dictionary, specifically in the Sales Order Header Extension table.

The 'Shipto Email Address' field is also in the Extension table.

Use the Sales Order Header Master table to create the view with everything. In your case, it would be the composite table OE Order Detail /w Head, Head Ext.

In Order Entry 9.3A, you'll notice that the data layout will change, and there is no 'extension' data file any more - it has been merged with the 'standard' header. So the only table will be Sales Order Header, no Extension or Master tables.


Edited by Softrak Support (10/25/17 10:52 AM)
Edit Reason: composite table
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Softrak Support), 175 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14471 Topics
70674 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30