BPM to control GL Chart used in a PO

Yahoo Archive
1
I've being trying to do something like this for some time now and
I've finally figured it out!

I've created the BPM using the "PO.ChangeApproveSwitch" method and
created a Pre-Processing directive.

The condition is "number of rows in the (below) query in not less
than 1" and the query I used is:

for each ttPOHeader where (ttPOHeader.RowMod='A' or
ttPOHeader.RowMod='U') , each PORel where PORel.Company =
ttPOHeader.Company and PORel.PONum = ttPOHeader.PONum and
PORel.ExpChart = '8202'

(I want to stop users approving POs where the default GL Chart is
unchanged.)

Ok, it only checks the codes used at time of approval - not on each
line - but it'll do for my purposes.

Hope it helps,

Nigel.




--- In vantage@yahoogroups.com, "brendan_butterworth"
<brendan_butterworth@...> wrote:
>
> I would like to use BPM to check the GL Chart account entered (or
not
> entered) by a user on the PO release when the user tries to approve
a
> purchase order.
>
> The problem I am having is that the approve field is in the header
> table and the chart value is in the release table. Therefore by the
> time the user approves the order the temporary tables (ttPORel)
have
> already been cleared.
>
> Furthermore if the order has more than one line i need to loop
through
> the lines and check each one and pop up a message box to remind the
> user.
>
> Any ideas? Is there a better way to do this perhaps?
>
2
I would like to use BPM to check the GL Chart account entered (or not
entered) by a user on the PO release when the user tries to approve a
purchase order.

The problem I am having is that the approve field is in the header
table and the chart value is in the release table. Therefore by the
time the user approves the order the temporary tables (ttPORel) have
already been cleared.

Furthermore if the order has more than one line i need to loop through
the lines and check each one and pop up a message box to remind the
user.

Any ideas? Is there a better way to do this perhaps?
3
What if you set up a process to verify each newly created release had a non-null chart reference & then force the user to enter one if null?

Then you wouldn't need the approval multi-release check (as your release entry process already enforced entry of a chart ref).

Rob

--- On Wed, 11/5/08, brendan_butterworth <brendan_butterworth@...> wrote:
From: brendan_butterworth <brendan_butterworth@...>
Subject: [Vantage] BPM to control GL Chart used in a PO
To: vantage@yahoogroups.com
Date: Wednesday, November 5, 2008, 12:09 AM











I would like to use BPM to check the GL Chart account entered (or not

entered) by a user on the PO release when the user tries to approve a

purchase order.



The problem I am having is that the approve field is in the header

table and the chart value is in the release table. Therefore by the

time the user approves the order the temporary tables (ttPORel) have

already been cleared.



Furthermore if the order has more than one line i need to loop through

the lines and check each one and pop up a message box to remind the

user.



Any ideas? Is there a better way to do this perhaps?