Orders to Shipments - Table Links?

Yahoo Archive
1
These table links are right-on. Thanks!

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...> wrote:
>
>
> (From memory - so forgive me if I err in a few spots) -
>
> Link OrderHead to OrderDetail thru company & OrderNum.
>
> Link OrderDetail to OrderRelease thru company, ordernum and orderline.
>
> Link SHipDetail to OrderRelease thru company, ordernum, orderline & orderrelease. (Outer left join if you want all order line releases whether shipped or pending shipped in Pack ID or not).
>
> Link ShipHead to ShipDetail thru company and PackNum.
>
> If you do Make Direct Jobs (and want to see all they way down to procution details), also link in JobHead to JobProd, JobProd to Orderrelease (outer-left join) add any job detail level stuff (JobOpr & JobMtl) you might want by linking thru JobHead.
>
> WHAT you display out of all that is up to you.
>
> Note: ShipHead.ShipDate is unreliable prior to 405. (Null values posted under certain conditions). I can't recall if Shipdate is duplicated in the ShipDetail table - or if we quickly customized to populate a date## field in shiphead to cover ourselves during the sporadic failures to populate shiphead.shipdate.
>
> Good luck.
>
> Rob Brown
>
>
>
>
> --- On Thu, 4/23/09, brucewbrannan <bruce.brannan@...> wrote:
> From: brucewbrannan <bruce.brannan@...>
> Subject: [Vantage] Orders to Shipments - Table Links?
> To: vantage@yahoogroups.com
> Date: Thursday, April 23, 2009, 3:53 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ. I want to use several fields from the two but I want to add (per order line) the shipped quantity. I've found the ShipHead and ShipDtl tables and they contain the rest of the data I need. What I can't figure out is how to link the Orders to the Shipments. I've looked through the data dictionary viewer and can't find the link. I miss the 6.1 data dictionary, it was much easier to use.
>
>
>
> Many thanks for help!
>
>
>
> Bruce
>
2
This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ. I want to use several fields from the two but I want to add (per order line) the shipped quantity. I've found the ShipHead and ShipDtl tables and they contain the rest of the data I need. What I can't figure out is how to link the Orders to the Shipments. I've looked through the data dictionary viewer and can't find the link. I miss the 6.1 data dictionary, it was much easier to use.

Many thanks for help!

Bruce
3
(From memory - so forgive me if I err in a few spots) -

Link OrderHead to OrderDetail thru company & OrderNum.

Link OrderDetail to OrderRelease thru company, ordernum and orderline.

Link SHipDetail to OrderRelease thru company, ordernum, orderline & orderrelease. (Outer left join if you want all order line releases whether shipped or pending shipped in Pack ID or not).

Link ShipHead to ShipDetail thru company and PackNum.

If you do Make Direct Jobs (and want to see all they way down to procution details), also link in JobHead to JobProd, JobProd to Orderrelease (outer-left join) add any job detail level stuff (JobOpr & JobMtl) you might want by linking thru JobHead.

WHAT you display out of all that is up to you.

Note: ShipHead.ShipDate is unreliable prior to 405. (Null values posted under certain conditions). I can't recall if Shipdate is duplicated in the ShipDetail table - or if we quickly customized to populate a date## field in shiphead to cover ourselves during the sporadic failures to populate shiphead.shipdate.

Good luck.

Rob Brown




--- On Thu, 4/23/09, brucewbrannan <bruce.brannan@...> wrote:
From: brucewbrannan <bruce.brannan@...>
Subject: [Vantage] Orders to Shipments - Table Links?
To: vantage@yahoogroups.com
Date: Thursday, April 23, 2009, 3:53 PM

















This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ. I want to use several fields from the two but I want to add (per order line) the shipped quantity. I've found the ShipHead and ShipDtl tables and they contain the rest of the data I need. What I can't figure out is how to link the Orders to the Shipments. I've looked through the data dictionary viewer and can't find the link. I miss the 6.1 data dictionary, it was much easier to use.



Many thanks for help!



Bruce
4
ShipDtl is where the Order Information is. In ShipDtl there is Order Number,
Order Line and Order Release.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
brucewbrannan
Sent: Thursday, April 23, 2009 2:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Orders to Shipments - Table Links?

This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ.
I want to use several fields from the two but I want to add (per order line)
the shipped quantity. I've found the ShipHead and ShipDtl tables and they
contain the rest of the data I need. What I can't figure out is how to link
the Orders to the Shipments. I've looked through the data dictionary viewer
and can't find the link. I miss the 6.1 data dictionary, it was much easier
to use.

Many thanks for help!

Bruce



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
5
OrderRel - contains two fields - OURJOBSHIPPEDQTY and OURSTOCKSHIPPEDQTY - can't you just use those? I do and it is accurate....

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...> wrote:
>
>
> (From memory - so forgive me if I err in a few spots) -
>
> Link OrderHead to OrderDetail thru company & OrderNum.
>
> Link OrderDetail to OrderRelease thru company, ordernum and orderline.
>
> Link SHipDetail to OrderRelease thru company, ordernum, orderline & orderrelease. (Outer left join if you want all order line releases whether shipped or pending shipped in Pack ID or not).
>
> Link ShipHead to ShipDetail thru company and PackNum.
>
> If you do Make Direct Jobs (and want to see all they way down to procution details), also link in JobHead to JobProd, JobProd to Orderrelease (outer-left join) add any job detail level stuff (JobOpr & JobMtl) you might want by linking thru JobHead.
>
> WHAT you display out of all that is up to you.
>
> Note: ShipHead.ShipDate is unreliable prior to 405. (Null values posted under certain conditions). I can't recall if Shipdate is duplicated in the ShipDetail table - or if we quickly customized to populate a date## field in shiphead to cover ourselves during the sporadic failures to populate shiphead.shipdate.
>
> Good luck.
>
> Rob Brown
>
>
>
>
> --- On Thu, 4/23/09, brucewbrannan <bruce.brannan@...> wrote:
> From: brucewbrannan <bruce.brannan@...>
> Subject: [Vantage] Orders to Shipments - Table Links?
> To: vantage@yahoogroups.com
> Date: Thursday, April 23, 2009, 3:53 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ. I want to use several fields from the two but I want to add (per order line) the shipped quantity. I've found the ShipHead and ShipDtl tables and they contain the rest of the data I need. What I can't figure out is how to link the Orders to the Shipments. I've looked through the data dictionary viewer and can't find the link. I miss the 6.1 data dictionary, it was much easier to use.
>
>
>
> Many thanks for help!
>
>
>
> Bruce
>
6
Sure (if all you need is qty info & general source as to whether it was make direct from job or from stock).

Doesn't help during the 'limbo' stage though when make direct jobs are pre entered into Pack IDs for pending shipment (OURJOBSHIPPEDQTY is not updated until the actual shipment transaction occurs).

...All depends upon the level of detailed status tracking desired. I also find sometimes it is better to create underlying support for MORE detail than initially requested as the requests tend to creep and expand as people begin to use the solution (and realize more detail is needed).

Rob
--- On Fri, 4/24/09, richter_clements <richter_clements@...> wrote:

From: richter_clements <richter_clements@...>
Subject: [Vantage] Re: Orders to Shipments - Table Links?
To: vantage@yahoogroups.com
Date: Friday, April 24, 2009, 8:29 AM








OrderRel - contains two fields - OURJOBSHIPPEDQTY and OURSTOCKSHIPPEDQTY - can't you just use those? I do and it is accurate....

--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...> wrote:
>
>
> (From memory - so forgive me if I err in a few spots) -
>
> Link OrderHead to OrderDetail thru company & OrderNum.
>
> Link OrderDetail to OrderRelease thru company, ordernum and orderline.
>
> Link SHipDetail to OrderRelease thru company, ordernum, orderline & orderrelease. (Outer left join if you want all order line releases whether shipped or pending shipped in Pack ID or not).
>
> Link ShipHead to ShipDetail thru company and PackNum.
>
> If you do Make Direct Jobs (and want to see all they way down to procution details), also link in JobHead to JobProd, JobProd to Orderrelease (outer-left join) add any job detail level stuff (JobOpr & JobMtl) you might want by linking thru JobHead.
>
> WHAT you display out of all that is up to you.
>
> Note: ShipHead.ShipDate is unreliable prior to 405. (Null values posted under certain conditions). I can't recall if Shipdate is duplicated in the ShipDetail table - or if we quickly customized to populate a date## field in shiphead to cover ourselves during the sporadic failures to populate shiphead.shipdate.
>
> Good luck.
>
> Rob Brown
>
>
>
>
> --- On Thu, 4/23/09, brucewbrannan <bruce.brannan@ ...> wrote:
> From: brucewbrannan <bruce.brannan@ ...>
> Subject: [Vantage] Orders to Shipments - Table Links?
> To: vantage@yahoogroups .com
> Date: Thursday, April 23, 2009, 3:53 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ. I want to use several fields from the two but I want to add (per order line) the shipped quantity. I've found the ShipHead and ShipDtl tables and they contain the rest of the data I need. What I can't figure out is how to link the Orders to the Shipments. I've looked through the data dictionary viewer and can't find the link. I miss the 6.1 data dictionary, it was much easier to use.
>
>
>
> Many thanks for help!
>
>
>
> Bruce
>
7
FYI...this was a change on 8.03.40Xx.

Prior to the 400 release, you could link the ShipHead to OrderDtl.

After the 400 release, you must use ShipDtl to OrderDtl.
The caveat is order to get the Ship Date you must then link ShipDtl to ShipHead.

Epicor's purpose for this change is to allow you to create one packing slip covering multiple orders. Before...you were limited to one packing slip per order.

Hope this helps.
Thanks
Patty Buechler

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> ShipDtl is where the Order Information is. In ShipDtl there is Order Number,
> Order Line and Order Release.
>
> Scott Litzau, MCP
> Olympus Flag & Banner
> Information Systems Manager
> scott.litzau@...
> P: 414-365-9732
> F: 414-355-1931
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> brucewbrannan
> Sent: Thursday, April 23, 2009 2:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Orders to Shipments - Table Links?
>
> This should be easy but... I've got OrderHead and OrderDtl linked for a BAQ.
> I want to use several fields from the two but I want to add (per order line)
> the shipped quantity. I've found the ShipHead and ShipDtl tables and they
> contain the rest of the data I need. What I can't figure out is how to link
> the Orders to the Shipments. I've looked through the data dictionary viewer
> and can't find the link. I miss the 6.1 data dictionary, it was much easier
> to use.
>
> Many thanks for help!
>
> Bruce
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>