BPM 8.03.4xx for advance ship notice

Hi Dan,

You'll need to use a 4GL code Action to do this but you'll probably have to carry out the rest of the BPM in 4GL then. I would use a post-processing directive and this would be the start of the code:

find first ttShipHead where ttShipHead.ShipStatus="Shipped" no-lock no-error.
if available ttShipHead then do:
find first ShipDtl where ShipDtl.Company=ttShipHead.Company and ShipDtl.PackNum=ttShipHead.PackNum.
if available ShipDtl then do:
DEFINE VARIABLE OrdNum AS INTEGER NO-UNDO.
OrdNum = 0.
OrdNum = ShipDtl.OrderNum.
FOR EACH OrderDtl WHERE (OrderDtl.OrderNum = OrdNum) and (OrderDtl.Company = ttShipHead.Company) no-lock:
< Place code here >
end.


What exactly are you trying to do? You mentioned an alert template - are you trying to send an email if some criteria is breached? Let me know if I can help you with any of it.

Nigel.


--- In vantage@yahoogroups.com, "Dan Shallbetter" <dans@...> wrote:
>
> Hello Nigel,
>
>
>
> Yes, I meant to say selling price. Having only done 1 BPM, how do I link tables together in 1 BPM?
>
>
>
> Thanks,
>
>
>
> Dan
>
>
I created a BPM using the Custship.update method. I need to pull unit
cost from order detail into the alert template. How do I link the Ship
Head + order detail table together? Would a dependant post process
directive work?



Thanks,



Dan Shallbetter



[Non-text portions of this message have been removed]
Hi Dan,

You can't directly link the ShipHead and OrderDtl tables. From v8.03.### Vantage allows multiple SOs to be shipped on the one Customer Shipment so you'll have to look at the ShipDtl table to get the OrderNum field which you can then use to link in OrderDtl.

BTW, you said "pull cost". Did you mean selling price, as ShipDtl already contains cost fields?

HTH,

Nigel.

--- In vantage@yahoogroups.com, "Dan Shallbetter" <dans@...> wrote:
>
> I created a BPM using the Custship.update method. I need to pull unit
> cost from order detail into the alert template. How do I link the Ship
> Head + order detail table together? Would a dependant post process
> directive work?
>
>
>
> Thanks,
>
>
>
> Dan Shallbetter
>
>
>
> [Non-text portions of this message have been removed]
>
Hello Nigel,



Yes, I meant to say selling price. Having only done 1 BPM, how do I link tables together in 1 BPM?



Thanks,



Dan





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of NigelK
Sent: Thursday, April 08, 2010 11:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM 8.03.4xx for advance ship notice





Hi Dan,

You can't directly link the ShipHead and OrderDtl tables. From v8.03.### Vantage allows multiple SOs to be shipped on the one Customer Shipment so you'll have to look at the ShipDtl table to get the OrderNum field which you can then use to link in OrderDtl.

BTW, you said "pull cost". Did you mean selling price, as ShipDtl already contains cost fields?

HTH,

Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Dan Shallbetter" <dans@...> wrote:
>
> I created a BPM using the Custship.update method. I need to pull unit
> cost from order detail into the alert template. How do I link the Ship
> Head + order detail table together? Would a dependant post process
> directive work?
>
>
>
> Thanks,
>
>
>
> Dan Shallbetter
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]