Alert on Hold Invoice?

Yahoo Archive
1
Sorry everyone, that logic is wrong and will always fire (not more
than 0). I'll update when I get a solid solution.

Everyone have a good weekend, nothing to see here - please drive
through.

--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> Yeesh, once again I find the solution soon after I've asked for
help.
>
> In any case, for those that may want this feature, I'm using this
> method. This will create a pop-up alert when they attempt to post
the
> invoice.
>
> Add a Post-Process BPM on the InvcGrp.PrePostInvoices method.
>
> I added the condition of:
> number of rows in the query is not more than 0
>
> My query is:
> for each InvcHead where InvcHead.InvoiceHeld = 'true' AND
> InvcHead.GroupID = '%ttInvcGrp%'
>
> For my action, I simply raised an exception and put some wording in
> there that indicated that the user needs to resolve the hold status
and
> re-post.
>
> --- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@> wrote:
> >
> > When you have an order that's marked Time/Materials, it's by
default
> > held at the point of invoicing so that when you pull it into the
> > invoice group, you're supposed to update the costs.
> >
> > However, if you happen to miss the Hold Invoice checkmark and
simply
> > post the group, everything clears in AR Invoice Entry as it
normally
> > would and you'd assume it was posted when in fact it wasn't.
> >
> > I'm trying to create a BPM to prompt the user that there is an
> shipment
> > invoice entry that's marked Hold, has anyone done this yet? I
either
> > haven't got the right query or I'm on the wrong directive -
either
> way
> > I'm looking for some help if anyone has done this.
> >
>
2
When you have an order that's marked Time/Materials, it's by default
held at the point of invoicing so that when you pull it into the
invoice group, you're supposed to update the costs.

However, if you happen to miss the Hold Invoice checkmark and simply
post the group, everything clears in AR Invoice Entry as it normally
would and you'd assume it was posted when in fact it wasn't.

I'm trying to create a BPM to prompt the user that there is an shipment
invoice entry that's marked Hold, has anyone done this yet? I either
haven't got the right query or I'm on the wrong directive - either way
I'm looking for some help if anyone has done this.
3
Yeesh, once again I find the solution soon after I've asked for help.

In any case, for those that may want this feature, I'm using this
method. This will create a pop-up alert when they attempt to post the
invoice.

Add a Post-Process BPM on the InvcGrp.PrePostInvoices method.

I added the condition of:
number of rows in the query is not more than 0

My query is:
for each InvcHead where InvcHead.InvoiceHeld = 'true' AND
InvcHead.GroupID = '%ttInvcGrp%'

For my action, I simply raised an exception and put some wording in
there that indicated that the user needs to resolve the hold status and
re-post.

--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> When you have an order that's marked Time/Materials, it's by default
> held at the point of invoicing so that when you pull it into the
> invoice group, you're supposed to update the costs.
>
> However, if you happen to miss the Hold Invoice checkmark and simply
> post the group, everything clears in AR Invoice Entry as it normally
> would and you'd assume it was posted when in fact it wasn't.
>
> I'm trying to create a BPM to prompt the user that there is an
shipment
> invoice entry that's marked Hold, has anyone done this yet? I either
> haven't got the right query or I'm on the wrong directive - either
way
> I'm looking for some help if anyone has done this.
>