BAM - Credit Hold

Yahoo Archive
1
Butch -

Thanks, just tried that, it took me to the customer tracker for
the last child record processed.




-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Sunday, April 10, 2005 12:32 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM - Credit Hold



Have you tried activating the Credit Hold Global Alert to see how it
responds to the Parent/Child relationship? You won't get the detail in
the e-mail like below but it does pass along an alert.vdl file which
will take the recipient to the Customer Tracker.

Butch

________________________________

From: Calvin Dekker [mailto:calvin@...]
Sent: Sunday, April 10, 2005 10:21 AM
To: Vantage
Subject: [Vantage] BAM - Credit Hold


BAM/BAQ Users.......

Has anyone written a BAM routines regarding Customers being put on
Credit
Hold?
I have the following routine that works great for all instances BUT 1
(see
below):

/* Customer placed on credit hold routine. */
{ud/GlbAlert.i &TableName = "Customer"}
IF Customer.CreditHold = TRUE THEN DO:
ASSIGN Email-Subject = "Orders Affected by Credit Status Change"
Email-To = "calvin@..."
Email-Text = "The following orders will be affected by the
credit
status change: ~n ~n".
FOR EACH OrderHed
WHERE OrderHed.Company = "AEI" AND
OrderHed.CustNum = Customer.CustNum AND
OrderHed.OpenOrder = TRUE
BY OrderHed.OrderNum:
Email-Text = Email-Text + "Order Number: " +
STRING(OrderHed.OrderNum) + " ~n".
Email-Text = Email-Text + "Order Date: " +
STRING(OrderHed.OrderDate) + " ~n".
Email-Text = Email-Text + "PO Number: " + STRING(OrderHed.POnum)
+ "
~n".
Email-Text = Email-Text + "Requested Date: " +
STRING(OrderHed.RequestDate) + " ~n".
Email-Text = Email-Text + "~n ~n".
END.
END.
ELSE DO:
RETURN "Cancel Send":U.
END.


The BIG BUTT sticks out if the there is a parent/child customer
relationship. If I put the parent on credit hold, Vantage updates all
the
orders on hold for the parent and then all the orders for the children.
The
last customer number passed to the BAM is one of the children not the
parent. How do I know if all accounts were just put on credit hold with
this event or just the child? The credit hold event for the parent
isn't
triggering the BAM routine for that customer number, only the LAST child
processed.

I think I can add a query to pull the parent/child relationships and
review
all the memo logs to verify which customer numbers were put on credit
hold -
which is going to induce much FLAT FOREHEAD ON WALL PAIN !!

Just hoping someone might have a MORE SIMPLE idea.
PLEASE HELP before the self beatings commence.



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/links



________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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



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/links
Yahoo! Groups Links
2
BAM/BAQ Users.......

Has anyone written a BAM routines regarding Customers being put on Credit
Hold?
I have the following routine that works great for all instances BUT 1 (see
below):

/* Customer placed on credit hold routine. */
{ud/GlbAlert.i &TableName = "Customer"}
IF Customer.CreditHold = TRUE THEN DO:
ASSIGN Email-Subject = "Orders Affected by Credit Status Change"
Email-To = "calvin@..."
Email-Text = "The following orders will be affected by the credit
status change: ~n ~n".
FOR EACH OrderHed
WHERE OrderHed.Company = "AEI" AND
OrderHed.CustNum = Customer.CustNum AND
OrderHed.OpenOrder = TRUE
BY OrderHed.OrderNum:
Email-Text = Email-Text + "Order Number: " +
STRING(OrderHed.OrderNum) + " ~n".
Email-Text = Email-Text + "Order Date: " +
STRING(OrderHed.OrderDate) + " ~n".
Email-Text = Email-Text + "PO Number: " + STRING(OrderHed.POnum) + "
~n".
Email-Text = Email-Text + "Requested Date: " +
STRING(OrderHed.RequestDate) + " ~n".
Email-Text = Email-Text + "~n ~n".
END.
END.
ELSE DO:
RETURN "Cancel Send":U.
END.


The BIG BUTT sticks out if the there is a parent/child customer
relationship. If I put the parent on credit hold, Vantage updates all the
orders on hold for the parent and then all the orders for the children. The
last customer number passed to the BAM is one of the children not the
parent. How do I know if all accounts were just put on credit hold with
this event or just the child? The credit hold event for the parent isn't
triggering the BAM routine for that customer number, only the LAST child
processed.

I think I can add a query to pull the parent/child relationships and review
all the memo logs to verify which customer numbers were put on credit hold -
which is going to induce much FLAT FOREHEAD ON WALL PAIN !!

Just hoping someone might have a MORE SIMPLE idea.
PLEASE HELP before the self beatings commence.
3
Have you tried activating the Credit Hold Global Alert to see how it
responds to the Parent/Child relationship? You won't get the detail in
the e-mail like below but it does pass along an alert.vdl file which
will take the recipient to the Customer Tracker.

Butch

________________________________

From: Calvin Dekker [mailto:calvin@...]
Sent: Sunday, April 10, 2005 10:21 AM
To: Vantage
Subject: [Vantage] BAM - Credit Hold


BAM/BAQ Users.......

Has anyone written a BAM routines regarding Customers being put on
Credit
Hold?
I have the following routine that works great for all instances BUT 1
(see
below):

/* Customer placed on credit hold routine. */
{ud/GlbAlert.i &TableName = "Customer"}
IF Customer.CreditHold = TRUE THEN DO:
ASSIGN Email-Subject = "Orders Affected by Credit Status Change"
Email-To = "calvin@..."
Email-Text = "The following orders will be affected by the
credit
status change: ~n ~n".
FOR EACH OrderHed
WHERE OrderHed.Company = "AEI" AND
OrderHed.CustNum = Customer.CustNum AND
OrderHed.OpenOrder = TRUE
BY OrderHed.OrderNum:
Email-Text = Email-Text + "Order Number: " +
STRING(OrderHed.OrderNum) + " ~n".
Email-Text = Email-Text + "Order Date: " +
STRING(OrderHed.OrderDate) + " ~n".
Email-Text = Email-Text + "PO Number: " + STRING(OrderHed.POnum)
+ "
~n".
Email-Text = Email-Text + "Requested Date: " +
STRING(OrderHed.RequestDate) + " ~n".
Email-Text = Email-Text + "~n ~n".
END.
END.
ELSE DO:
RETURN "Cancel Send":U.
END.


The BIG BUTT sticks out if the there is a parent/child customer
relationship. If I put the parent on credit hold, Vantage updates all
the
orders on hold for the parent and then all the orders for the children.
The
last customer number passed to the BAM is one of the children not the
parent. How do I know if all accounts were just put on credit hold with
this event or just the child? The credit hold event for the parent
isn't
triggering the BAM routine for that customer number, only the LAST child
processed.

I think I can add a query to pull the parent/child relationships and
review
all the memo logs to verify which customer numbers were put on credit
hold -
which is going to induce much FLAT FOREHEAD ON WALL PAIN !!

Just hoping someone might have a MORE SIMPLE idea.
PLEASE HELP before the self beatings commence.



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/links



________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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