HELP! I am struggling with a BPM

Ok, I think that without access to the other method, it's going to be hard
to get a perfect solution.

That said,
FOR EACH RcvDtl WHERE
(RcvDtl.InvoiceNum = InvoiceNum)
AND
(RcvDtl.Character10 = '')
NO-LOCK

As a pre-processing on ApInvoice.getbyid will fire the exception. Make sure
to change 'character10' to the relevant field. We don't do inspection so I
just grabbed a random field.
However, this does not stop the invoice from being produced, only loaded.
The group will still load (without showing the invoice) and can be posted.

I fear that's the best I can do without spending an inordinate amount of
time on this. Perhaps you can change the exception to a message and teach
your users not to post when the receive it?

If that won't meet your needs, I would suggest writing a BPM that fires on
apinvgroup.getbyid or apinvgroup.update that will delete any invoices that
haven't been inspected. A bit more involved, but it should work.


On Mon, Oct 18, 2010 at 1:14 PM, Brian Turner <bturner101@...>wrote:

>
>
> The exception message wasn't displaying at all. The closest I have come to
> getting it to work is using a .rowmod on update and add. But the BPM would
> only kick in when the apinvdtl was being updated. It wouldn't do anything on
> the record add.
>
> I really appreciate your help on this problem. This BPM has been driving me
> insane for two weeks.
>
> On Oct 18, 2010, at 11:55 AM, Waffqle Driggers <waffqle@...<waffqle%40gmail.com>>
> wrote:
>
> > I'm testing it on my end, I'll shoot you the code when I get it running.
> >
> > Is your exception being displayed? If so, it may a bug in the program. If
> > not, it's likely an error in the query.
> >
> > On Mon, Oct 18, 2010 at 11:37 AM, Brian Turner <bturner101@...<bturner101%40sbcglobal.net>
> >wrote:
> >
> >>
> >>
> >> I used the GetByID with the below query in the conditions but it still
> >> allowed
> >> me to post and create the invoice. Am I missing something?
> >>
> >> For Each RcvDtl Where (RcvDtl.InspectionPending = TRUE) no-lock ,
> >>
> >> Each ttAPInvDtl where (ttAPInvDtl.Company = RcvDtl.Company) and
> >> (ttAPInvDtl.PONum = RcvDtl.PONum)
> >> and
> >> (ttAPInvDtl.POLine = RcvDtl.POLine)
> >> and
> >> (ttAPInvDtl.PORelNum =
> >> RcvDtl.PORelNum)
> >>
> >>
> >> ________________________________
> >> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com>>
> >> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> >> Sent: Mon, October 18, 2010 9:24:29 AM
> >>
> >> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >>
> >> We're on 9.04/9.05.
> >> As best I can think, there are two ways you could handle this.
> >> 1. You could replace the Base Method on 'GetAPUninvoicedReceipts'. I
> >> wouldn't really recommend it though. Replacing the Base Method is best
> left
> >> as a last-resort. Too many potential problems.
> >>
> >> 2. Grab APInvoice.GetByID. use the same query/exception setup I outlined
> >> earlier. This isn't ideal, as the invoice will still be created, and
> this
> >> method will fire every time someone looks up an AP invoice.
> >> However, they will not be able to open/post the invoice until the
> receipt
> >> has been inspected. It is also probably the easiest solution to
> implement,
> >> by a wide margin. As long as you stick with a simple query/exception
> setup,
> >> the performance hit should be pretty minimal. If you start using complex
> >> queries or 4gl actions, all bets are off.
> >> Since you are just using a little query instead of 4gl code or a UI
> >> customization, odds are you won't have to worry about reworking this BPM
> >> when updates get applied.
> >>
> >> Hope this helps. Let me know if you have other trouble.
> >>
> >> On Mon, Oct 18, 2010 at 9:51 AM, Brian Turner <bturner101@...<bturner101%40sbcglobal.net>
> <bturner101%40sbcglobal.net>
> >>> wrote:
> >>
> >>>
> >>>
> >>> The methods available to me within APInvoice are listed below. What
> >> version
> >>> are
> >>> you currently running?
> >>>
> >>> AddPOMiscChrgToInvoiceHead
> >>> AddPOMiscChrgToInvoiceLine
> >>> ChangeAdvancePayAmt
> >>> ChangeAssemblySeq
> >>> ChangeCostPerCode
> >>> ChangeCurrency
> >>> ChangeDistributionAccount
> >>> ChangeExtCompanyID
> >>> ChangeExtCost
> >>> ChangeExtGLAcct
> >>> ChangeExtGLRefCode
> >>> ChangeGLRefCode
> >>> ChangeInvoiceDate
> >>> ChangeInvoiceRef
> >>> ChangeInvoiceVendorAmt
> >>> ChangeJobNum
> >>> ChangeLineDiscAmt
> >>> ChangeLockRate
> >>> ChangeManualTaxCalculation
> >>> ChangeMiscAmt
> >>> ChangeMiscCode
> >>> ChangeMiscPercent
> >>> ChangeMtlSeq
> >>> ChangeMultiCompany
> >>> ChangeOverrideRevCharge
> >>> ChangePartNum
> >>> ChangePOLine
> >>> ChangePONum
> >>> ChangePORelNum
> >>> ChangeRefPONum
> >>> ChangeReportableAmt
> >>> ChangeRevChargeMethod
> >>> ChangeTaxableAmt
> >>> ChangeTaxAmt
> >>> ChangeTaxCode
> >>> ChangeTaxPercent
> >>> ChangeTermsCode
> >>> ChangeUnitCost
> >>> ChangeVendorID
> >>> ChangeVendorQty
> >>> CheckCPayBeforeUpdate
> >>> CheckLegalNumsDisplay
> >>> CheckRevChrgBeforeUpdate
> >>> DeleteByID
> >>> GenerateRebateInv
> >>> GetAPInvPaySched
> >>> GetAPInvPOMisc
> >>> GetAPUninvoicedReceipts
> >>> GetByID
> >>> GetDMRDebitMemos
> >>> GetLegalNumforDebitMemo
> >>> GetList
> >>> GetNewAPIHAPInvExp
> >>> GetNewAPIHAPInvMsc
> >>> GetNewAPInvDtl
> >>> GetNewAPInvDtlAdvance
> >>> GetNewAPInvDtlAttch
> >>> GetNewAPInvDtlJobMiscellaneous
> >>> GetNewAPInvDtlMiscellaneous
> >>> GetNewAPInvDtlUnreceived
> >>> GetNewAPInvExp
> >>> GetNewAPInvHed
> >>> GetNewAPInvHedAttch
> >>> GetNewAPInvHedDebitMemo
> >>> GetNewAPInvHedInvoice
> >>> GetNewAPInvJob
> >>> GetNewAPInvMsc
> >>> GetNewAPInvTax
> >>> GetRebateInvList
> >>> GetRows
> >>> GLAllocation
> >>> PreUpdate
> >>> TransferInvoiceToGroup
> >>> Update
> >>> UpdateAPInvPaySched
> >>> UsePurchaseCode
> >>>
> >>>
> >>> ________________________________
> >>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> >> 40gmail.com>>
> >>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> >> 40yahoogroups.com>
> >>> Sent: Mon, October 18, 2010 8:42:22 AM
> >>>
> >>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >>>
> >>> Ok, I don't have that version available; let's just assume that method
> >>> isn't
> >>> available. Can copy/paste me a list of the methods you have available?
> >> I'm
> >>> sure we can work something out.
> >>>
> >>> On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner
> >>> <bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net><bturner101%
>
> >> 40sbcglobal.net>
> >>
> >>>> wrote:
> >>>
> >>>>
> >>>>
> >>>> I'm running version 8.03.409A
> >>>>
> >>>>
> >>>> ________________________________
> >>>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> >> 40gmail.com><waffqle%
> >>> 40gmail.com>>
> >>>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> >> 40yahoogroups.com> <vantage%
> >>> 40yahoogroups.com>
> >>>> Sent: Mon, October 18, 2010 8:30:37 AM
> >>>>
> >>>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >>>>
> >>>> I've got it over here. What version are you on?
> >>>>
> >>>> On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner
> >>>> <bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
> >> 40sbcglobal.net><bturner101%
> >>
> >>> 40sbcglobal.net>
> >>>>> wrote:
> >>>>
> >>>>>
> >>>>>
> >>>
> >>>>> The InvoiceSelectedLines method directive is not available in the
> >>> search
> >>>>> list
> >>>>> within the APInvoice business object.
> >>>>>
> >>>>> I see it in the trace log while I enter a new invoice and receipt
> >> line.
> >>>>>
> >>>>> Do you happen to know why EPICOR would make some method directives
> >>>>> unavailable
> >>>>> within the corresponding business object?
> >>>>>
> >>>>> ________________________________
> >>>>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> >> 40gmail.com><waffqle%
> >>> 40gmail.com><waffqle%
> >>>> 40gmail.com>>
> >>>>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> >> 40yahoogroups.com> <vantage%
> >>> 40yahoogroups.com> <vantage%
> >>>
> >>>> 40yahoogroups.com>
> >>>>
> >>>>> Sent: Fri, October 15, 2010 4:24:21 PM
> >>>>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >>>>>
> >>>>>
> >>>>> Easiest way I can think of would be to put a pre-processing directive
> >>> on
> >>>>> "APInvoice.InvoiceSelectedLines".
> >>>>>
> >>>>> Set the action to "Raise an exception" and give it the message you
> >>> would
> >>>>> like to have displayed.
> >>>>>
> >>>>> Set the condition to "number of rows in the designed query is more
> >> than
> >>>> 0".
> >>>>> Give it a query that will return all the RcvDtl's where
> >>>>> PendingInspection=true and the receipt/line numbers match the ones
> >>> you're
> >>>>> trying to invoice.
> >>>>>
> >>>>> You should be all set.
> >>>>>
> >>>>> If you have trouble with the query let me know and I'll see if I
> >> can't
> >>>> help
> >>>>> you out in the morning. But it's after 5 now and I'm heading home for
> >>> the
> >>>>> day.
> >>>>>
> >>>>> On Fri, Oct 15, 2010 at 4:53 PM,
> >>>>> bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
> >> 40sbcglobal.net> <bturner101%
> >>> 40sbcglobal.net><bturner101%
> >>>> 40sbcglobal.net><
> >>>>
> >>>>> bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
> >> 40sbcglobal.net> <bturner101%
> >>> 40sbcglobal.net> <bturner101%
> >>>
> >>>> 40sbcglobal.net>> wrote:
> >>>>>
> >>>>>>
> >>>>>>
> >>>>>> The RcvDtl.InspectionPending field is True False. When ever a PO is
> >>>>> marked
> >>>>>> as inspection required, the receipt detail defaults to
> >>>>>> RcvDtl.InspectionPending = True. Once QC is processed, the
> >> inspection
> >>>>>> pending field reverts to False.
> >>>>>>
> >>>>>> I would like to trigger on the inspection pending field to halt an
> >>>>> invoice
> >>>>>> line entry when inspection pending = TRUE.
> >>>>>>
> >>>>>> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com><vantage%
> >> 40yahoogroups.com> <vantage%
> >>> 40yahoogroups.com> <vantage%
> >>>> 40yahoogroups.com> <vantage%
> >>>>
> >>>>> 40yahoogroups.com>, Waffqle
> >>>>>
> >>>>>> Driggers <waffqle@...> wrote:
> >>>>>>>
> >>>>>>> We should be able to get this working no sweat.
> >>>>>>>
> >>>>>>> However, we don't do inspection here. Can you give me a little
> >> more
> >>>>>>> explanation? How do we know something is in inspection? Is it
> >> just
> >>> a
> >>>>>> field
> >>>>>>> on the receipt?
> >>>>>>>
> >>>>>>> If that's the case, it should be a trivial thing to either add an
> >>>> alert
> >>>>>> at
> >>>>>>> invoice time or prevent the receipt from being invoiced.
> >>>>>>>
> >>>>>>> On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> >>>>>>> bturner101@...> wrote:
> >>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> I am struggling with a BPM and hoping someone can point me in
> >> the
> >>>>> right
> >>>>>>>> direction.
> >>>>>>>>
> >>>>>>>> I am attempting to create a BPM that will alert, stop, or hide
> >> PO
> >>>>>> receipts
> >>>>>>>> that are pending inspection. Bottom line I need to make sure
> >> the
> >>> AP
> >>>>>> clerk
> >>>>>>>> knows an invoice line is pending inspection when a new receipt
> >>> line
> >>>>> is
> >>>>>>>> entered.
> >>>>>>>>
> >>>>>>>> I have been asked to add this functionality because management
> >>> does
> >>>>> not
> >>>>>>>> want to pay supplier invoices until materials have been
> >>> inspected.
> >>>>>>>>
> >>>>>>>> I am open for any and all suggestions. Most of the data for the
> >>>>>> APInvDtl
> >>>>>>>> table is populated by the RcvDtl table including the pending
> >>>>> inspection
> >>>>>> TRUE
> >>>>>>>> / FALSE field.
> >>>>>>>>
> >>>>>>>> I have been struggling with this even with EPICOR tech support
> >>> and
> >>>>> have
> >>>>>> not
> >>>>>>>> been able to get very far.
> >>>>>>>>
> >>>>>>>> I am running Vantage 8.03.409A
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> [Non-text portions of this message have been removed]
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>> [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/linksYahoo! Groups Links
> >>>>>
> >>>>>
> >>>>> [Non-text portions of this message have been removed]
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>> [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/linksYahoo! Groups Links
> >>>>
> >>>> [Non-text portions of this message have been removed]
> >>>>
> >>>>
> >>>>
> >>>
> >>> [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/linksYahoo! Groups Links
> >>>
> >>> [Non-text portions of this message have been removed]
> >>>
> >>>
> >>>
> >>
> >> [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/linksYahoo! Groups Links
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >>
> >>
> >
> >
> > [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/linksYahoo! Groups Links
> >
> >
> >
>
>
>


[Non-text portions of this message have been removed]
I am struggling with a BPM and hoping someone can point me in the right direction.

I am attempting to create a BPM that will alert, stop, or hide PO receipts that are pending inspection. Bottom line I need to make sure the AP clerk knows an invoice line is pending inspection when a new receipt line is entered.

I have been asked to add this functionality because management does not want to pay supplier invoices until materials have been inspected.

I am open for any and all suggestions. Most of the data for the APInvDtl table is populated by the RcvDtl table including the pending inspection TRUE / FALSE field.

I have been struggling with this even with EPICOR tech support and have not been able to get very far.

I am running Vantage 8.03.409A
We should be able to get this working no sweat.

However, we don't do inspection here. Can you give me a little more
explanation? How do we know something is in inspection? Is it just a field
on the receipt?

If that's the case, it should be a trivial thing to either add an alert at
invoice time or prevent the receipt from being invoiced.

On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
bturner101@...> wrote:

>
>
> I am struggling with a BPM and hoping someone can point me in the right
> direction.
>
> I am attempting to create a BPM that will alert, stop, or hide PO receipts
> that are pending inspection. Bottom line I need to make sure the AP clerk
> knows an invoice line is pending inspection when a new receipt line is
> entered.
>
> I have been asked to add this functionality because management does not
> want to pay supplier invoices until materials have been inspected.
>
> I am open for any and all suggestions. Most of the data for the APInvDtl
> table is populated by the RcvDtl table including the pending inspection TRUE
> / FALSE field.
>
> I have been struggling with this even with EPICOR tech support and have not
> been able to get very far.
>
> I am running Vantage 8.03.409A
>
>
>


[Non-text portions of this message have been removed]
The RcvDtl.InspectionPending field is True False. When ever a PO is marked as inspection required, the receipt detail defaults to RcvDtl.InspectionPending = True. Once QC is processed, the inspection pending field reverts to False.

I would like to trigger on the inspection pending field to halt an invoice line entry when inspection pending = TRUE.

--- In vantage@yahoogroups.com, Waffqle Driggers <waffqle@...> wrote:
>
> We should be able to get this working no sweat.
>
> However, we don't do inspection here. Can you give me a little more
> explanation? How do we know something is in inspection? Is it just a field
> on the receipt?
>
> If that's the case, it should be a trivial thing to either add an alert at
> invoice time or prevent the receipt from being invoiced.
>
> On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> bturner101@...> wrote:
>
> >
> >
> > I am struggling with a BPM and hoping someone can point me in the right
> > direction.
> >
> > I am attempting to create a BPM that will alert, stop, or hide PO receipts
> > that are pending inspection. Bottom line I need to make sure the AP clerk
> > knows an invoice line is pending inspection when a new receipt line is
> > entered.
> >
> > I have been asked to add this functionality because management does not
> > want to pay supplier invoices until materials have been inspected.
> >
> > I am open for any and all suggestions. Most of the data for the APInvDtl
> > table is populated by the RcvDtl table including the pending inspection TRUE
> > / FALSE field.
> >
> > I have been struggling with this even with EPICOR tech support and have not
> > been able to get very far.
> >
> > I am running Vantage 8.03.409A
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Easiest way I can think of would be to put a pre-processing directive on
"APInvoice.InvoiceSelectedLines".

Set the action to "Raise an exception" and give it the message you would
like to have displayed.

Set the condition to "number of rows in the designed query is more than 0".
Give it a query that will return all the RcvDtl's where
PendingInspection=true and the receipt/line numbers match the ones you're
trying to invoice.

You should be all set.

If you have trouble with the query let me know and I'll see if I can't help
you out in the morning. But it's after 5 now and I'm heading home for the
day.

On Fri, Oct 15, 2010 at 4:53 PM, bturner101@... <
bturner101@...> wrote:

>
>
> The RcvDtl.InspectionPending field is True False. When ever a PO is marked
> as inspection required, the receipt detail defaults to
> RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> pending field reverts to False.
>
> I would like to trigger on the inspection pending field to halt an invoice
> line entry when inspection pending = TRUE.
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Waffqle
> Driggers <waffqle@...> wrote:
> >
> > We should be able to get this working no sweat.
> >
> > However, we don't do inspection here. Can you give me a little more
> > explanation? How do we know something is in inspection? Is it just a
> field
> > on the receipt?
> >
> > If that's the case, it should be a trivial thing to either add an alert
> at
> > invoice time or prevent the receipt from being invoiced.
> >
> > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > bturner101@...> wrote:
> >
> > >
> > >
> > > I am struggling with a BPM and hoping someone can point me in the right
> > > direction.
> > >
> > > I am attempting to create a BPM that will alert, stop, or hide PO
> receipts
> > > that are pending inspection. Bottom line I need to make sure the AP
> clerk
> > > knows an invoice line is pending inspection when a new receipt line is
> > > entered.
> > >
> > > I have been asked to add this functionality because management does not
> > > want to pay supplier invoices until materials have been inspected.
> > >
> > > I am open for any and all suggestions. Most of the data for the
> APInvDtl
> > > table is populated by the RcvDtl table including the pending inspection
> TRUE
> > > / FALSE field.
> > >
> > > I have been struggling with this even with EPICOR tech support and have
> not
> > > been able to get very far.
> > >
> > > I am running Vantage 8.03.409A
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
The InvoiceSelectedLines method directive is not available in the search list
within the APInvoice business object.


I see it in the trace log while I enter a new invoice and receipt line.

Do you happen to know why EPICOR would make some method directives unavailable
within the corresponding business object?





________________________________
From: Waffqle Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Fri, October 15, 2010 4:24:21 PM
Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM

Easiest way I can think of would be to put a pre-processing directive on
"APInvoice.InvoiceSelectedLines".

Set the action to "Raise an exception" and give it the message you would
like to have displayed.

Set the condition to "number of rows in the designed query is more than 0".
Give it a query that will return all the RcvDtl's where
PendingInspection=true and the receipt/line numbers match the ones you're
trying to invoice.

You should be all set.

If you have trouble with the query let me know and I'll see if I can't help
you out in the morning. But it's after 5 now and I'm heading home for the
day.

On Fri, Oct 15, 2010 at 4:53 PM, bturner101@... <
bturner101@...> wrote:

>
>
> The RcvDtl.InspectionPending field is True False. When ever a PO is marked
> as inspection required, the receipt detail defaults to
> RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> pending field reverts to False.
>
> I would like to trigger on the inspection pending field to halt an invoice
> line entry when inspection pending = TRUE.
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Waffqle
> Driggers <waffqle@...> wrote:
> >
> > We should be able to get this working no sweat.
> >
> > However, we don't do inspection here. Can you give me a little more
> > explanation? How do we know something is in inspection? Is it just a
> field
> > on the receipt?
> >
> > If that's the case, it should be a trivial thing to either add an alert
> at
> > invoice time or prevent the receipt from being invoiced.
> >
> > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > bturner101@...> wrote:
> >
> > >
> > >
> > > I am struggling with a BPM and hoping someone can point me in the right
> > > direction.
> > >
> > > I am attempting to create a BPM that will alert, stop, or hide PO
> receipts
> > > that are pending inspection. Bottom line I need to make sure the AP
> clerk
> > > knows an invoice line is pending inspection when a new receipt line is
> > > entered.
> > >
> > > I have been asked to add this functionality because management does not
> > > want to pay supplier invoices until materials have been inspected.
> > >
> > > I am open for any and all suggestions. Most of the data for the
> APInvDtl
> > > table is populated by the RcvDtl table including the pending inspection
> TRUE
> > > / FALSE field.
> > >
> > > I have been struggling with this even with EPICOR tech support and have
> not
> > > been able to get very far.
> > >
> > > I am running Vantage 8.03.409A
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[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/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
Sheer spite I'm sure. :-)

I suspect that it's a situation similar to the reason why some reports
are still in Progress -- either there's a lot of complexity and the
development team hasn't decided how to deal with it, or they just
haven't gotten to it yet.

Despite the appearances, V8/E9 was not designed with exposing the guts
of the application to the developer/end-customer in mind. Things are
too inconsistent for that claim to have much merit. I mean, its great
that they *do* give you some hooks to work with, but sometimes it just
turns out you can't do what you want.

We ran into this with the AR module: Epicor sales and consulting
*though* you could cook up a centralized AR capability similar to the AP
module, but it turns out that the hooks simply weren't accessible.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Turner
Sent: Monday, October 18, 2010 9:09 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM

The InvoiceSelectedLines method directive is not available in the search
list
within the APInvoice business object.


I see it in the trace log while I enter a new invoice and receipt line.

Do you happen to know why EPICOR would make some method directives
unavailable
within the corresponding business object?





________________________________
From: Waffqle Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Fri, October 15, 2010 4:24:21 PM
Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM

Easiest way I can think of would be to put a pre-processing directive on
"APInvoice.InvoiceSelectedLines".

Set the action to "Raise an exception" and give it the message you would
like to have displayed.

Set the condition to "number of rows in the designed query is more than
0".
Give it a query that will return all the RcvDtl's where
PendingInspection=true and the receipt/line numbers match the ones
you're
trying to invoice.

You should be all set.

If you have trouble with the query let me know and I'll see if I can't
help
you out in the morning. But it's after 5 now and I'm heading home for
the
day.

On Fri, Oct 15, 2010 at 4:53 PM, bturner101@... <
bturner101@...> wrote:

>
>
> The RcvDtl.InspectionPending field is True False. When ever a PO is
marked
> as inspection required, the receipt detail defaults to
> RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> pending field reverts to False.
>
> I would like to trigger on the inspection pending field to halt an
invoice
> line entry when inspection pending = TRUE.
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Waffqle
> Driggers <waffqle@...> wrote:
> >
> > We should be able to get this working no sweat.
> >
> > However, we don't do inspection here. Can you give me a little more
> > explanation? How do we know something is in inspection? Is it just a
> field
> > on the receipt?
> >
> > If that's the case, it should be a trivial thing to either add an
alert
> at
> > invoice time or prevent the receipt from being invoiced.
> >
> > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > bturner101@...> wrote:
> >
> > >
> > >
> > > I am struggling with a BPM and hoping someone can point me in the
right
> > > direction.
> > >
> > > I am attempting to create a BPM that will alert, stop, or hide PO
> receipts
> > > that are pending inspection. Bottom line I need to make sure the
AP
> clerk
> > > knows an invoice line is pending inspection when a new receipt
line is
> > > entered.
> > >
> > > I have been asked to add this functionality because management
does not
> > > want to pay supplier invoices until materials have been inspected.
> > >
> > > I am open for any and all suggestions. Most of the data for the
> APInvDtl
> > > table is populated by the RcvDtl table including the pending
inspection
> TRUE
> > > / FALSE field.
> > >
> > > I have been struggling with this even with EPICOR tech support and
have
> not
> > > been able to get very far.
> > >
> > > I am running Vantage 8.03.409A
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[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/linksYahoo! Groups Links



[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/linksYahoo! Groups Links
I've got it over here. What version are you on?

On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner <bturner101@...>wrote:

>
>
> The InvoiceSelectedLines method directive is not available in the search
> list
> within the APInvoice business object.
>
> I see it in the trace log while I enter a new invoice and receipt line.
>
> Do you happen to know why EPICOR would make some method directives
> unavailable
> within the corresponding business object?
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Fri, October 15, 2010 4:24:21 PM
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
>
> Easiest way I can think of would be to put a pre-processing directive on
> "APInvoice.InvoiceSelectedLines".
>
> Set the action to "Raise an exception" and give it the message you would
> like to have displayed.
>
> Set the condition to "number of rows in the designed query is more than 0".
> Give it a query that will return all the RcvDtl's where
> PendingInspection=true and the receipt/line numbers match the ones you're
> trying to invoice.
>
> You should be all set.
>
> If you have trouble with the query let me know and I'll see if I can't help
> you out in the morning. But it's after 5 now and I'm heading home for the
> day.
>
> On Fri, Oct 15, 2010 at 4:53 PM, bturner101@...<bturner101%40sbcglobal.net><
> bturner101@... <bturner101%40sbcglobal.net>> wrote:
>
> >
> >
> > The RcvDtl.InspectionPending field is True False. When ever a PO is
> marked
> > as inspection required, the receipt detail defaults to
> > RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> > pending field reverts to False.
> >
> > I would like to trigger on the inspection pending field to halt an
> invoice
> > line entry when inspection pending = TRUE.
> >
> > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>, Waffqle
>
> > Driggers <waffqle@...> wrote:
> > >
> > > We should be able to get this working no sweat.
> > >
> > > However, we don't do inspection here. Can you give me a little more
> > > explanation? How do we know something is in inspection? Is it just a
> > field
> > > on the receipt?
> > >
> > > If that's the case, it should be a trivial thing to either add an alert
> > at
> > > invoice time or prevent the receipt from being invoiced.
> > >
> > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > bturner101@...> wrote:
> > >
> > > >
> > > >
> > > > I am struggling with a BPM and hoping someone can point me in the
> right
> > > > direction.
> > > >
> > > > I am attempting to create a BPM that will alert, stop, or hide PO
> > receipts
> > > > that are pending inspection. Bottom line I need to make sure the AP
> > clerk
> > > > knows an invoice line is pending inspection when a new receipt line
> is
> > > > entered.
> > > >
> > > > I have been asked to add this functionality because management does
> not
> > > > want to pay supplier invoices until materials have been inspected.
> > > >
> > > > I am open for any and all suggestions. Most of the data for the
> > APInvDtl
> > > > table is populated by the RcvDtl table including the pending
> inspection
> > TRUE
> > > > / FALSE field.
> > > >
> > > > I have been struggling with this even with EPICOR tech support and
> have
> > not
> > > > been able to get very far.
> > > >
> > > > I am running Vantage 8.03.409A
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
I'm running version 8.03.409A




________________________________
From: Waffqle Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Mon, October 18, 2010 8:30:37 AM
Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM

I've got it over here. What version are you on?

On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner <bturner101@...>wrote:

>
>
> The InvoiceSelectedLines method directive is not available in the search
> list
> within the APInvoice business object.
>
> I see it in the trace log while I enter a new invoice and receipt line.
>
> Do you happen to know why EPICOR would make some method directives
> unavailable
> within the corresponding business object?
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Fri, October 15, 2010 4:24:21 PM
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
>
> Easiest way I can think of would be to put a pre-processing directive on
> "APInvoice.InvoiceSelectedLines".
>
> Set the action to "Raise an exception" and give it the message you would
> like to have displayed.
>
> Set the condition to "number of rows in the designed query is more than 0".
> Give it a query that will return all the RcvDtl's where
> PendingInspection=true and the receipt/line numbers match the ones you're
> trying to invoice.
>
> You should be all set.
>
> If you have trouble with the query let me know and I'll see if I can't help
> you out in the morning. But it's after 5 now and I'm heading home for the
> day.
>
> On Fri, Oct 15, 2010 at 4:53 PM,
>bturner101@...<bturner101%40sbcglobal.net><
> bturner101@... <bturner101%40sbcglobal.net>> wrote:
>
> >
> >
> > The RcvDtl.InspectionPending field is True False. When ever a PO is
> marked
> > as inspection required, the receipt detail defaults to
> > RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> > pending field reverts to False.
> >
> > I would like to trigger on the inspection pending field to halt an
> invoice
> > line entry when inspection pending = TRUE.
> >
> > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>, Waffqle
>
> > Driggers <waffqle@...> wrote:
> > >
> > > We should be able to get this working no sweat.
> > >
> > > However, we don't do inspection here. Can you give me a little more
> > > explanation? How do we know something is in inspection? Is it just a
> > field
> > > on the receipt?
> > >
> > > If that's the case, it should be a trivial thing to either add an alert
> > at
> > > invoice time or prevent the receipt from being invoiced.
> > >
> > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > bturner101@...> wrote:
> > >
> > > >
> > > >
> > > > I am struggling with a BPM and hoping someone can point me in the
> right
> > > > direction.
> > > >
> > > > I am attempting to create a BPM that will alert, stop, or hide PO
> > receipts
> > > > that are pending inspection. Bottom line I need to make sure the AP
> > clerk
> > > > knows an invoice line is pending inspection when a new receipt line
> is
> > > > entered.
> > > >
> > > > I have been asked to add this functionality because management does
> not
> > > > want to pay supplier invoices until materials have been inspected.
> > > >
> > > > I am open for any and all suggestions. Most of the data for the
> > APInvDtl
> > > > table is populated by the RcvDtl table including the pending
> inspection
> > TRUE
> > > > / FALSE field.
> > > >
> > > > I have been struggling with this even with EPICOR tech support and
> have
> > not
> > > > been able to get very far.
> > > >
> > > > I am running Vantage 8.03.409A
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>
>
>


[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/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
Ok, I don't have that version available; let's just assume that method isn't
available. Can copy/paste me a list of the methods you have available? I'm
sure we can work something out.

On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner <bturner101@...>wrote:

>
>
> I'm running version 8.03.409A
>
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, October 18, 2010 8:30:37 AM
>
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
> I've got it over here. What version are you on?
>
> On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner <bturner101@...<bturner101%40sbcglobal.net>
> >wrote:
>
> >
> >
> > The InvoiceSelectedLines method directive is not available in the search
> > list
> > within the APInvoice business object.
> >
> > I see it in the trace log while I enter a new invoice and receipt line.
> >
> > Do you happen to know why EPICOR would make some method directives
> > unavailable
> > within the corresponding business object?
> >
> > ________________________________
> > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Fri, October 15, 2010 4:24:21 PM
> > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >
> >
> > Easiest way I can think of would be to put a pre-processing directive on
> > "APInvoice.InvoiceSelectedLines".
> >
> > Set the action to "Raise an exception" and give it the message you would
> > like to have displayed.
> >
> > Set the condition to "number of rows in the designed query is more than
> 0".
> > Give it a query that will return all the RcvDtl's where
> > PendingInspection=true and the receipt/line numbers match the ones you're
> > trying to invoice.
> >
> > You should be all set.
> >
> > If you have trouble with the query let me know and I'll see if I can't
> help
> > you out in the morning. But it's after 5 now and I'm heading home for the
> > day.
> >
> > On Fri, Oct 15, 2010 at 4:53 PM,
> >bturner101@... <bturner101%40sbcglobal.net><bturner101%
> 40sbcglobal.net><
>
> > bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net>> wrote:
> >
> > >
> > >
> > > The RcvDtl.InspectionPending field is True False. When ever a PO is
> > marked
> > > as inspection required, the receipt detail defaults to
> > > RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> > > pending field reverts to False.
> > >
> > > I would like to trigger on the inspection pending field to halt an
> > invoice
> > > line entry when inspection pending = TRUE.
> > >
> > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>, Waffqle
> >
> > > Driggers <waffqle@...> wrote:
> > > >
> > > > We should be able to get this working no sweat.
> > > >
> > > > However, we don't do inspection here. Can you give me a little more
> > > > explanation? How do we know something is in inspection? Is it just a
> > > field
> > > > on the receipt?
> > > >
> > > > If that's the case, it should be a trivial thing to either add an
> alert
> > > at
> > > > invoice time or prevent the receipt from being invoiced.
> > > >
> > > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > > bturner101@...> wrote:
> > > >
> > > > >
> > > > >
> > > > > I am struggling with a BPM and hoping someone can point me in the
> > right
> > > > > direction.
> > > > >
> > > > > I am attempting to create a BPM that will alert, stop, or hide PO
> > > receipts
> > > > > that are pending inspection. Bottom line I need to make sure the AP
> > > clerk
> > > > > knows an invoice line is pending inspection when a new receipt line
> > is
> > > > > entered.
> > > > >
> > > > > I have been asked to add this functionality because management does
> > not
> > > > > want to pay supplier invoices until materials have been inspected.
> > > > >
> > > > > I am open for any and all suggestions. Most of the data for the
> > > APInvDtl
> > > > > table is populated by the RcvDtl table including the pending
> > inspection
> > > TRUE
> > > > > / FALSE field.
> > > > >
> > > > > I have been struggling with this even with EPICOR tech support and
> > have
> > > not
> > > > > been able to get very far.
> > > > >
> > > > > I am running Vantage 8.03.409A
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> > [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/linksYahoo! Groups Links
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
The methods available to me within APInvoice are listed below. What version are
you currently running?

AddPOMiscChrgToInvoiceHead
AddPOMiscChrgToInvoiceLine
ChangeAdvancePayAmt
ChangeAssemblySeq
ChangeCostPerCode
ChangeCurrency
ChangeDistributionAccount
ChangeExtCompanyID
ChangeExtCost
ChangeExtGLAcct
ChangeExtGLRefCode
ChangeGLRefCode
ChangeInvoiceDate
ChangeInvoiceRef
ChangeInvoiceVendorAmt
ChangeJobNum
ChangeLineDiscAmt
ChangeLockRate
ChangeManualTaxCalculation
ChangeMiscAmt
ChangeMiscCode
ChangeMiscPercent
ChangeMtlSeq
ChangeMultiCompany
ChangeOverrideRevCharge
ChangePartNum
ChangePOLine
ChangePONum
ChangePORelNum
ChangeRefPONum
ChangeReportableAmt
ChangeRevChargeMethod
ChangeTaxableAmt
ChangeTaxAmt
ChangeTaxCode
ChangeTaxPercent
ChangeTermsCode
ChangeUnitCost
ChangeVendorID
ChangeVendorQty
CheckCPayBeforeUpdate
CheckLegalNumsDisplay
CheckRevChrgBeforeUpdate
DeleteByID
GenerateRebateInv
GetAPInvPaySched
GetAPInvPOMisc
GetAPUninvoicedReceipts
GetByID
GetDMRDebitMemos
GetLegalNumforDebitMemo
GetList
GetNewAPIHAPInvExp
GetNewAPIHAPInvMsc
GetNewAPInvDtl
GetNewAPInvDtlAdvance
GetNewAPInvDtlAttch
GetNewAPInvDtlJobMiscellaneous
GetNewAPInvDtlMiscellaneous
GetNewAPInvDtlUnreceived
GetNewAPInvExp
GetNewAPInvHed
GetNewAPInvHedAttch
GetNewAPInvHedDebitMemo
GetNewAPInvHedInvoice
GetNewAPInvJob
GetNewAPInvMsc
GetNewAPInvTax
GetRebateInvList
GetRows
GLAllocation
PreUpdate
TransferInvoiceToGroup
Update
UpdateAPInvPaySched
UsePurchaseCode





________________________________
From: Waffqle Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Mon, October 18, 2010 8:42:22 AM
Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM

Ok, I don't have that version available; let's just assume that method isn't
available. Can copy/paste me a list of the methods you have available? I'm
sure we can work something out.

On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner <bturner101@...>wrote:

>
>
> I'm running version 8.03.409A
>
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, October 18, 2010 8:30:37 AM
>
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
> I've got it over here. What version are you on?
>
> On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner
><bturner101@...<bturner101%40sbcglobal.net>
> >wrote:
>
> >
> >
> > The InvoiceSelectedLines method directive is not available in the search
> > list
> > within the APInvoice business object.
> >
> > I see it in the trace log while I enter a new invoice and receipt line.
> >
> > Do you happen to know why EPICOR would make some method directives
> > unavailable
> > within the corresponding business object?
> >
> > ________________________________
> > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Fri, October 15, 2010 4:24:21 PM
> > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >
> >
> > Easiest way I can think of would be to put a pre-processing directive on
> > "APInvoice.InvoiceSelectedLines".
> >
> > Set the action to "Raise an exception" and give it the message you would
> > like to have displayed.
> >
> > Set the condition to "number of rows in the designed query is more than
> 0".
> > Give it a query that will return all the RcvDtl's where
> > PendingInspection=true and the receipt/line numbers match the ones you're
> > trying to invoice.
> >
> > You should be all set.
> >
> > If you have trouble with the query let me know and I'll see if I can't
> help
> > you out in the morning. But it's after 5 now and I'm heading home for the
> > day.
> >
> > On Fri, Oct 15, 2010 at 4:53 PM,
> >bturner101@... <bturner101%40sbcglobal.net><bturner101%
> 40sbcglobal.net><
>
> > bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net>> wrote:
> >
> > >
> > >
> > > The RcvDtl.InspectionPending field is True False. When ever a PO is
> > marked
> > > as inspection required, the receipt detail defaults to
> > > RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> > > pending field reverts to False.
> > >
> > > I would like to trigger on the inspection pending field to halt an
> > invoice
> > > line entry when inspection pending = TRUE.
> > >
> > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>, Waffqle
> >
> > > Driggers <waffqle@...> wrote:
> > > >
> > > > We should be able to get this working no sweat.
> > > >
> > > > However, we don't do inspection here. Can you give me a little more
> > > > explanation? How do we know something is in inspection? Is it just a
> > > field
> > > > on the receipt?
> > > >
> > > > If that's the case, it should be a trivial thing to either add an
> alert
> > > at
> > > > invoice time or prevent the receipt from being invoiced.
> > > >
> > > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > > bturner101@...> wrote:
> > > >
> > > > >
> > > > >
> > > > > I am struggling with a BPM and hoping someone can point me in the
> > right
> > > > > direction.
> > > > >
> > > > > I am attempting to create a BPM that will alert, stop, or hide PO
> > > receipts
> > > > > that are pending inspection. Bottom line I need to make sure the AP
> > > clerk
> > > > > knows an invoice line is pending inspection when a new receipt line
> > is
> > > > > entered.
> > > > >
> > > > > I have been asked to add this functionality because management does
> > not
> > > > > want to pay supplier invoices until materials have been inspected.
> > > > >
> > > > > I am open for any and all suggestions. Most of the data for the
> > > APInvDtl
> > > > > table is populated by the RcvDtl table including the pending
> > inspection
> > > TRUE
> > > > > / FALSE field.
> > > > >
> > > > > I have been struggling with this even with EPICOR tech support and
> > have
> > > not
> > > > > been able to get very far.
> > > > >
> > > > > I am running Vantage 8.03.409A
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> > [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/linksYahoo! Groups Links
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>


[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/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
The ability to send HTML formatted email is available in .NET.

Has anyone been able to send HTML formatted emails from a BPM?



[Non-text portions of this message have been removed]
We're on 9.04/9.05.
As best I can think, there are two ways you could handle this.
1. You could replace the Base Method on 'GetAPUninvoicedReceipts'. I
wouldn't really recommend it though. Replacing the Base Method is best left
as a last-resort. Too many potential problems.

2. Grab APInvoice.GetByID. use the same query/exception setup I outlined
earlier. This isn't ideal, as the invoice will still be created, and this
method will fire every time someone looks up an AP invoice.
However, they will not be able to open/post the invoice until the receipt
has been inspected. It is also probably the easiest solution to implement,
by a wide margin. As long as you stick with a simple query/exception setup,
the performance hit should be pretty minimal. If you start using complex
queries or 4gl actions, all bets are off.
Since you are just using a little query instead of 4gl code or a UI
customization, odds are you won't have to worry about reworking this BPM
when updates get applied.


Hope this helps. Let me know if you have other trouble.

On Mon, Oct 18, 2010 at 9:51 AM, Brian Turner <bturner101@...>wrote:

>
>
> The methods available to me within APInvoice are listed below. What version
> are
> you currently running?
>
> AddPOMiscChrgToInvoiceHead
> AddPOMiscChrgToInvoiceLine
> ChangeAdvancePayAmt
> ChangeAssemblySeq
> ChangeCostPerCode
> ChangeCurrency
> ChangeDistributionAccount
> ChangeExtCompanyID
> ChangeExtCost
> ChangeExtGLAcct
> ChangeExtGLRefCode
> ChangeGLRefCode
> ChangeInvoiceDate
> ChangeInvoiceRef
> ChangeInvoiceVendorAmt
> ChangeJobNum
> ChangeLineDiscAmt
> ChangeLockRate
> ChangeManualTaxCalculation
> ChangeMiscAmt
> ChangeMiscCode
> ChangeMiscPercent
> ChangeMtlSeq
> ChangeMultiCompany
> ChangeOverrideRevCharge
> ChangePartNum
> ChangePOLine
> ChangePONum
> ChangePORelNum
> ChangeRefPONum
> ChangeReportableAmt
> ChangeRevChargeMethod
> ChangeTaxableAmt
> ChangeTaxAmt
> ChangeTaxCode
> ChangeTaxPercent
> ChangeTermsCode
> ChangeUnitCost
> ChangeVendorID
> ChangeVendorQty
> CheckCPayBeforeUpdate
> CheckLegalNumsDisplay
> CheckRevChrgBeforeUpdate
> DeleteByID
> GenerateRebateInv
> GetAPInvPaySched
> GetAPInvPOMisc
> GetAPUninvoicedReceipts
> GetByID
> GetDMRDebitMemos
> GetLegalNumforDebitMemo
> GetList
> GetNewAPIHAPInvExp
> GetNewAPIHAPInvMsc
> GetNewAPInvDtl
> GetNewAPInvDtlAdvance
> GetNewAPInvDtlAttch
> GetNewAPInvDtlJobMiscellaneous
> GetNewAPInvDtlMiscellaneous
> GetNewAPInvDtlUnreceived
> GetNewAPInvExp
> GetNewAPInvHed
> GetNewAPInvHedAttch
> GetNewAPInvHedDebitMemo
> GetNewAPInvHedInvoice
> GetNewAPInvJob
> GetNewAPInvMsc
> GetNewAPInvTax
> GetRebateInvList
> GetRows
> GLAllocation
> PreUpdate
> TransferInvoiceToGroup
> Update
> UpdateAPInvPaySched
> UsePurchaseCode
>
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, October 18, 2010 8:42:22 AM
>
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
> Ok, I don't have that version available; let's just assume that method
> isn't
> available. Can copy/paste me a list of the methods you have available? I'm
> sure we can work something out.
>
> On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner <bturner101@...<bturner101%40sbcglobal.net>
> >wrote:
>
> >
> >
> > I'm running version 8.03.409A
> >
> >
> > ________________________________
> > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > Sent: Mon, October 18, 2010 8:30:37 AM
> >
> > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >
> > I've got it over here. What version are you on?
> >
> > On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner
> ><bturner101@... <bturner101%40sbcglobal.net><bturner101%
> 40sbcglobal.net>
> > >wrote:
> >
> > >
> > >
>
> > > The InvoiceSelectedLines method directive is not available in the
> search
> > > list
> > > within the APInvoice business object.
> > >
> > > I see it in the trace log while I enter a new invoice and receipt line.
> > >
> > > Do you happen to know why EPICOR would make some method directives
> > > unavailable
> > > within the corresponding business object?
> > >
> > > ________________________________
> > > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> > 40gmail.com>>
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>
> >
> > > Sent: Fri, October 15, 2010 4:24:21 PM
> > > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> > >
> > >
> > > Easiest way I can think of would be to put a pre-processing directive
> on
> > > "APInvoice.InvoiceSelectedLines".
> > >
> > > Set the action to "Raise an exception" and give it the message you
> would
> > > like to have displayed.
> > >
> > > Set the condition to "number of rows in the designed query is more than
> > 0".
> > > Give it a query that will return all the RcvDtl's where
> > > PendingInspection=true and the receipt/line numbers match the ones
> you're
> > > trying to invoice.
> > >
> > > You should be all set.
> > >
> > > If you have trouble with the query let me know and I'll see if I can't
> > help
> > > you out in the morning. But it's after 5 now and I'm heading home for
> the
> > > day.
> > >
> > > On Fri, Oct 15, 2010 at 4:53 PM,
> > >bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net><bturner101%
> > 40sbcglobal.net><
> >
> > > bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
>
> > 40sbcglobal.net>> wrote:
> > >
> > > >
> > > >
> > > > The RcvDtl.InspectionPending field is True False. When ever a PO is
> > > marked
> > > > as inspection required, the receipt detail defaults to
> > > > RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> > > > pending field reverts to False.
> > > >
> > > > I would like to trigger on the inspection pending field to halt an
> > > invoice
> > > > line entry when inspection pending = TRUE.
> > > >
> > > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> > 40yahoogroups.com> <vantage%
> >
> > > 40yahoogroups.com>, Waffqle
> > >
> > > > Driggers <waffqle@...> wrote:
> > > > >
> > > > > We should be able to get this working no sweat.
> > > > >
> > > > > However, we don't do inspection here. Can you give me a little more
> > > > > explanation? How do we know something is in inspection? Is it just
> a
> > > > field
> > > > > on the receipt?
> > > > >
> > > > > If that's the case, it should be a trivial thing to either add an
> > alert
> > > > at
> > > > > invoice time or prevent the receipt from being invoiced.
> > > > >
> > > > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > > > bturner101@...> wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > I am struggling with a BPM and hoping someone can point me in the
> > > right
> > > > > > direction.
> > > > > >
> > > > > > I am attempting to create a BPM that will alert, stop, or hide PO
> > > > receipts
> > > > > > that are pending inspection. Bottom line I need to make sure the
> AP
> > > > clerk
> > > > > > knows an invoice line is pending inspection when a new receipt
> line
> > > is
> > > > > > entered.
> > > > > >
> > > > > > I have been asked to add this functionality because management
> does
> > > not
> > > > > > want to pay supplier invoices until materials have been
> inspected.
> > > > > >
> > > > > > I am open for any and all suggestions. Most of the data for the
> > > > APInvDtl
> > > > > > table is populated by the RcvDtl table including the pending
> > > inspection
> > > > TRUE
> > > > > > / FALSE field.
> > > > > >
> > > > > > I have been struggling with this even with EPICOR tech support
> and
> > > have
> > > > not
> > > > > > been able to get very far.
> > > > > >
> > > > > > I am running Vantage 8.03.409A
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > > [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/linksYahoo! Groups Links
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [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/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
I used the GetByID with the below query in the conditions but it still allowed
me to post and create the invoice. Am I missing something?

For Each RcvDtl Where (RcvDtl.InspectionPending = TRUE) no-lock ,

Each ttAPInvDtl where (ttAPInvDtl.Company = RcvDtl.Company) and
(ttAPInvDtl.PONum = RcvDtl.PONum)
and
(ttAPInvDtl.POLine = RcvDtl.POLine)
and
(ttAPInvDtl.PORelNum =
RcvDtl.PORelNum)




________________________________
From: Waffqle Driggers <waffqle@...>
To: vantage@yahoogroups.com
Sent: Mon, October 18, 2010 9:24:29 AM
Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM

We're on 9.04/9.05.
As best I can think, there are two ways you could handle this.
1. You could replace the Base Method on 'GetAPUninvoicedReceipts'. I
wouldn't really recommend it though. Replacing the Base Method is best left
as a last-resort. Too many potential problems.

2. Grab APInvoice.GetByID. use the same query/exception setup I outlined
earlier. This isn't ideal, as the invoice will still be created, and this
method will fire every time someone looks up an AP invoice.
However, they will not be able to open/post the invoice until the receipt
has been inspected. It is also probably the easiest solution to implement,
by a wide margin. As long as you stick with a simple query/exception setup,
the performance hit should be pretty minimal. If you start using complex
queries or 4gl actions, all bets are off.
Since you are just using a little query instead of 4gl code or a UI
customization, odds are you won't have to worry about reworking this BPM
when updates get applied.


Hope this helps. Let me know if you have other trouble.

On Mon, Oct 18, 2010 at 9:51 AM, Brian Turner <bturner101@...>wrote:

>
>
> The methods available to me within APInvoice are listed below. What version
> are
> you currently running?
>
> AddPOMiscChrgToInvoiceHead
> AddPOMiscChrgToInvoiceLine
> ChangeAdvancePayAmt
> ChangeAssemblySeq
> ChangeCostPerCode
> ChangeCurrency
> ChangeDistributionAccount
> ChangeExtCompanyID
> ChangeExtCost
> ChangeExtGLAcct
> ChangeExtGLRefCode
> ChangeGLRefCode
> ChangeInvoiceDate
> ChangeInvoiceRef
> ChangeInvoiceVendorAmt
> ChangeJobNum
> ChangeLineDiscAmt
> ChangeLockRate
> ChangeManualTaxCalculation
> ChangeMiscAmt
> ChangeMiscCode
> ChangeMiscPercent
> ChangeMtlSeq
> ChangeMultiCompany
> ChangeOverrideRevCharge
> ChangePartNum
> ChangePOLine
> ChangePONum
> ChangePORelNum
> ChangeRefPONum
> ChangeReportableAmt
> ChangeRevChargeMethod
> ChangeTaxableAmt
> ChangeTaxAmt
> ChangeTaxCode
> ChangeTaxPercent
> ChangeTermsCode
> ChangeUnitCost
> ChangeVendorID
> ChangeVendorQty
> CheckCPayBeforeUpdate
> CheckLegalNumsDisplay
> CheckRevChrgBeforeUpdate
> DeleteByID
> GenerateRebateInv
> GetAPInvPaySched
> GetAPInvPOMisc
> GetAPUninvoicedReceipts
> GetByID
> GetDMRDebitMemos
> GetLegalNumforDebitMemo
> GetList
> GetNewAPIHAPInvExp
> GetNewAPIHAPInvMsc
> GetNewAPInvDtl
> GetNewAPInvDtlAdvance
> GetNewAPInvDtlAttch
> GetNewAPInvDtlJobMiscellaneous
> GetNewAPInvDtlMiscellaneous
> GetNewAPInvDtlUnreceived
> GetNewAPInvExp
> GetNewAPInvHed
> GetNewAPInvHedAttch
> GetNewAPInvHedDebitMemo
> GetNewAPInvHedInvoice
> GetNewAPInvJob
> GetNewAPInvMsc
> GetNewAPInvTax
> GetRebateInvList
> GetRows
> GLAllocation
> PreUpdate
> TransferInvoiceToGroup
> Update
> UpdateAPInvPaySched
> UsePurchaseCode
>
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, October 18, 2010 8:42:22 AM
>
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
> Ok, I don't have that version available; let's just assume that method
> isn't
> available. Can copy/paste me a list of the methods you have available? I'm
> sure we can work something out.
>
> On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner
><bturner101@...<bturner101%40sbcglobal.net>
> >wrote:
>
> >
> >
> > I'm running version 8.03.409A
> >
> >
> > ________________________________
> > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > Sent: Mon, October 18, 2010 8:30:37 AM
> >
> > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >
> > I've got it over here. What version are you on?
> >
> > On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner
> ><bturner101@... <bturner101%40sbcglobal.net><bturner101%
> 40sbcglobal.net>
> > >wrote:
> >
> > >
> > >
>
> > > The InvoiceSelectedLines method directive is not available in the
> search
> > > list
> > > within the APInvoice business object.
> > >
> > > I see it in the trace log while I enter a new invoice and receipt line.
> > >
> > > Do you happen to know why EPICOR would make some method directives
> > > unavailable
> > > within the corresponding business object?
> > >
> > > ________________________________
> > > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> > 40gmail.com>>
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>
> >
> > > Sent: Fri, October 15, 2010 4:24:21 PM
> > > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> > >
> > >
> > > Easiest way I can think of would be to put a pre-processing directive
> on
> > > "APInvoice.InvoiceSelectedLines".
> > >
> > > Set the action to "Raise an exception" and give it the message you
> would
> > > like to have displayed.
> > >
> > > Set the condition to "number of rows in the designed query is more than
> > 0".
> > > Give it a query that will return all the RcvDtl's where
> > > PendingInspection=true and the receipt/line numbers match the ones
> you're
> > > trying to invoice.
> > >
> > > You should be all set.
> > >
> > > If you have trouble with the query let me know and I'll see if I can't
> > help
> > > you out in the morning. But it's after 5 now and I'm heading home for
> the
> > > day.
> > >
> > > On Fri, Oct 15, 2010 at 4:53 PM,
> > >bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net><bturner101%
> > 40sbcglobal.net><
> >
> > > bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
>
> > 40sbcglobal.net>> wrote:
> > >
> > > >
> > > >
> > > > The RcvDtl.InspectionPending field is True False. When ever a PO is
> > > marked
> > > > as inspection required, the receipt detail defaults to
> > > > RcvDtl.InspectionPending = True. Once QC is processed, the inspection
> > > > pending field reverts to False.
> > > >
> > > > I would like to trigger on the inspection pending field to halt an
> > > invoice
> > > > line entry when inspection pending = TRUE.
> > > >
> > > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> > 40yahoogroups.com> <vantage%
> >
> > > 40yahoogroups.com>, Waffqle
> > >
> > > > Driggers <waffqle@...> wrote:
> > > > >
> > > > > We should be able to get this working no sweat.
> > > > >
> > > > > However, we don't do inspection here. Can you give me a little more
> > > > > explanation? How do we know something is in inspection? Is it just
> a
> > > > field
> > > > > on the receipt?
> > > > >
> > > > > If that's the case, it should be a trivial thing to either add an
> > alert
> > > > at
> > > > > invoice time or prevent the receipt from being invoiced.
> > > > >
> > > > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > > > bturner101@...> wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > I am struggling with a BPM and hoping someone can point me in the
> > > right
> > > > > > direction.
> > > > > >
> > > > > > I am attempting to create a BPM that will alert, stop, or hide PO
> > > > receipts
> > > > > > that are pending inspection. Bottom line I need to make sure the
> AP
> > > > clerk
> > > > > > knows an invoice line is pending inspection when a new receipt
> line
> > > is
> > > > > > entered.
> > > > > >
> > > > > > I have been asked to add this functionality because management
> does
> > > not
> > > > > > want to pay supplier invoices until materials have been
> inspected.
> > > > > >
> > > > > > I am open for any and all suggestions. Most of the data for the
> > > > APInvDtl
> > > > > > table is populated by the RcvDtl table including the pending
> > > inspection
> > > > TRUE
> > > > > > / FALSE field.
> > > > > >
> > > > > > I have been struggling with this even with EPICOR tech support
> and
> > > have
> > > > not
> > > > > > been able to get very far.
> > > > > >
> > > > > > I am running Vantage 8.03.409A
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > > [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/linksYahoo! Groups Links
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [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/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>


[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/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
I'm testing it on my end, I'll shoot you the code when I get it running.

Is your exception being displayed? If so, it may a bug in the program. If
not, it's likely an error in the query.

On Mon, Oct 18, 2010 at 11:37 AM, Brian Turner <bturner101@...>wrote:

>
>
> I used the GetByID with the below query in the conditions but it still
> allowed
> me to post and create the invoice. Am I missing something?
>
> For Each RcvDtl Where (RcvDtl.InspectionPending = TRUE) no-lock ,
>
> Each ttAPInvDtl where (ttAPInvDtl.Company = RcvDtl.Company) and
> (ttAPInvDtl.PONum = RcvDtl.PONum)
> and
> (ttAPInvDtl.POLine = RcvDtl.POLine)
> and
> (ttAPInvDtl.PORelNum =
> RcvDtl.PORelNum)
>
>
> ________________________________
> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, October 18, 2010 9:24:29 AM
>
> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>
> We're on 9.04/9.05.
> As best I can think, there are two ways you could handle this.
> 1. You could replace the Base Method on 'GetAPUninvoicedReceipts'. I
> wouldn't really recommend it though. Replacing the Base Method is best left
> as a last-resort. Too many potential problems.
>
> 2. Grab APInvoice.GetByID. use the same query/exception setup I outlined
> earlier. This isn't ideal, as the invoice will still be created, and this
> method will fire every time someone looks up an AP invoice.
> However, they will not be able to open/post the invoice until the receipt
> has been inspected. It is also probably the easiest solution to implement,
> by a wide margin. As long as you stick with a simple query/exception setup,
> the performance hit should be pretty minimal. If you start using complex
> queries or 4gl actions, all bets are off.
> Since you are just using a little query instead of 4gl code or a UI
> customization, odds are you won't have to worry about reworking this BPM
> when updates get applied.
>
> Hope this helps. Let me know if you have other trouble.
>
> On Mon, Oct 18, 2010 at 9:51 AM, Brian Turner <bturner101@...<bturner101%40sbcglobal.net>
> >wrote:
>
> >
> >
> > The methods available to me within APInvoice are listed below. What
> version
> > are
> > you currently running?
> >
> > AddPOMiscChrgToInvoiceHead
> > AddPOMiscChrgToInvoiceLine
> > ChangeAdvancePayAmt
> > ChangeAssemblySeq
> > ChangeCostPerCode
> > ChangeCurrency
> > ChangeDistributionAccount
> > ChangeExtCompanyID
> > ChangeExtCost
> > ChangeExtGLAcct
> > ChangeExtGLRefCode
> > ChangeGLRefCode
> > ChangeInvoiceDate
> > ChangeInvoiceRef
> > ChangeInvoiceVendorAmt
> > ChangeJobNum
> > ChangeLineDiscAmt
> > ChangeLockRate
> > ChangeManualTaxCalculation
> > ChangeMiscAmt
> > ChangeMiscCode
> > ChangeMiscPercent
> > ChangeMtlSeq
> > ChangeMultiCompany
> > ChangeOverrideRevCharge
> > ChangePartNum
> > ChangePOLine
> > ChangePONum
> > ChangePORelNum
> > ChangeRefPONum
> > ChangeReportableAmt
> > ChangeRevChargeMethod
> > ChangeTaxableAmt
> > ChangeTaxAmt
> > ChangeTaxCode
> > ChangeTaxPercent
> > ChangeTermsCode
> > ChangeUnitCost
> > ChangeVendorID
> > ChangeVendorQty
> > CheckCPayBeforeUpdate
> > CheckLegalNumsDisplay
> > CheckRevChrgBeforeUpdate
> > DeleteByID
> > GenerateRebateInv
> > GetAPInvPaySched
> > GetAPInvPOMisc
> > GetAPUninvoicedReceipts
> > GetByID
> > GetDMRDebitMemos
> > GetLegalNumforDebitMemo
> > GetList
> > GetNewAPIHAPInvExp
> > GetNewAPIHAPInvMsc
> > GetNewAPInvDtl
> > GetNewAPInvDtlAdvance
> > GetNewAPInvDtlAttch
> > GetNewAPInvDtlJobMiscellaneous
> > GetNewAPInvDtlMiscellaneous
> > GetNewAPInvDtlUnreceived
> > GetNewAPInvExp
> > GetNewAPInvHed
> > GetNewAPInvHedAttch
> > GetNewAPInvHedDebitMemo
> > GetNewAPInvHedInvoice
> > GetNewAPInvJob
> > GetNewAPInvMsc
> > GetNewAPInvTax
> > GetRebateInvList
> > GetRows
> > GLAllocation
> > PreUpdate
> > TransferInvoiceToGroup
> > Update
> > UpdateAPInvPaySched
> > UsePurchaseCode
> >
> >
> > ________________________________
> > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > Sent: Mon, October 18, 2010 8:42:22 AM
> >
> > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> >
> > Ok, I don't have that version available; let's just assume that method
> > isn't
> > available. Can copy/paste me a list of the methods you have available?
> I'm
> > sure we can work something out.
> >
> > On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner
> ><bturner101@... <bturner101%40sbcglobal.net><bturner101%
> 40sbcglobal.net>
>
> > >wrote:
> >
> > >
> > >
> > > I'm running version 8.03.409A
> > >
> > >
> > > ________________________________
> > > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> > 40gmail.com>>
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> > 40yahoogroups.com>
> > > Sent: Mon, October 18, 2010 8:30:37 AM
> > >
> > > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> > >
> > > I've got it over here. What version are you on?
> > >
> > > On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner
> > ><bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net><bturner101%
>
> > 40sbcglobal.net>
> > > >wrote:
> > >
> > > >
> > > >
> >
> > > > The InvoiceSelectedLines method directive is not available in the
> > search
> > > > list
> > > > within the APInvoice business object.
> > > >
> > > > I see it in the trace log while I enter a new invoice and receipt
> line.
> > > >
> > > > Do you happen to know why EPICOR would make some method directives
> > > > unavailable
> > > > within the corresponding business object?
> > > >
> > > > ________________________________
> > > > From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
> 40gmail.com><waffqle%
> > 40gmail.com><waffqle%
> > > 40gmail.com>>
> > > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
> > 40yahoogroups.com> <vantage%
> >
> > > 40yahoogroups.com>
> > >
> > > > Sent: Fri, October 15, 2010 4:24:21 PM
> > > > Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
> > > >
> > > >
> > > > Easiest way I can think of would be to put a pre-processing directive
> > on
> > > > "APInvoice.InvoiceSelectedLines".
> > > >
> > > > Set the action to "Raise an exception" and give it the message you
> > would
> > > > like to have displayed.
> > > >
> > > > Set the condition to "number of rows in the designed query is more
> than
> > > 0".
> > > > Give it a query that will return all the RcvDtl's where
> > > > PendingInspection=true and the receipt/line numbers match the ones
> > you're
> > > > trying to invoice.
> > > >
> > > > You should be all set.
> > > >
> > > > If you have trouble with the query let me know and I'll see if I
> can't
> > > help
> > > > you out in the morning. But it's after 5 now and I'm heading home for
> > the
> > > > day.
> > > >
> > > > On Fri, Oct 15, 2010 at 4:53 PM,
> > > >bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
> > 40sbcglobal.net><bturner101%
> > > 40sbcglobal.net><
> > >
> > > > bturner101@... <bturner101%40sbcglobal.net> <bturner101%
> 40sbcglobal.net> <bturner101%
> > 40sbcglobal.net> <bturner101%
> >
> > > 40sbcglobal.net>> wrote:
> > > >
> > > > >
> > > > >
> > > > > The RcvDtl.InspectionPending field is True False. When ever a PO is
> > > > marked
> > > > > as inspection required, the receipt detail defaults to
> > > > > RcvDtl.InspectionPending = True. Once QC is processed, the
> inspection
> > > > > pending field reverts to False.
> > > > >
> > > > > I would like to trigger on the inspection pending field to halt an
> > > > invoice
> > > > > line entry when inspection pending = TRUE.
> > > > >
> > > > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com> <vantage%
> > 40yahoogroups.com> <vantage%
> > > 40yahoogroups.com> <vantage%
> > >
> > > > 40yahoogroups.com>, Waffqle
> > > >
> > > > > Driggers <waffqle@...> wrote:
> > > > > >
> > > > > > We should be able to get this working no sweat.
> > > > > >
> > > > > > However, we don't do inspection here. Can you give me a little
> more
> > > > > > explanation? How do we know something is in inspection? Is it
> just
> > a
> > > > > field
> > > > > > on the receipt?
> > > > > >
> > > > > > If that's the case, it should be a trivial thing to either add an
> > > alert
> > > > > at
> > > > > > invoice time or prevent the receipt from being invoiced.
> > > > > >
> > > > > > On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
> > > > > > bturner101@...> wrote:
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I am struggling with a BPM and hoping someone can point me in
> the
> > > > right
> > > > > > > direction.
> > > > > > >
> > > > > > > I am attempting to create a BPM that will alert, stop, or hide
> PO
> > > > > receipts
> > > > > > > that are pending inspection. Bottom line I need to make sure
> the
> > AP
> > > > > clerk
> > > > > > > knows an invoice line is pending inspection when a new receipt
> > line
> > > > is
> > > > > > > entered.
> > > > > > >
> > > > > > > I have been asked to add this functionality because management
> > does
> > > > not
> > > > > > > want to pay supplier invoices until materials have been
> > inspected.
> > > > > > >
> > > > > > > I am open for any and all suggestions. Most of the data for the
> > > > > APInvDtl
> > > > > > > table is populated by the RcvDtl table including the pending
> > > > inspection
> > > > > TRUE
> > > > > > > / FALSE field.
> > > > > > >
> > > > > > > I have been struggling with this even with EPICOR tech support
> > and
> > > > have
> > > > > not
> > > > > > > been able to get very far.
> > > > > > >
> > > > > > > I am running Vantage 8.03.409A
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > > [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/linksYahoo! Groups Links
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > > [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/linksYahoo! Groups Links
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [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/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
The exception message wasn't displaying at all. The closest I have come to getting it to work is using a .rowmod on update and add. But the BPM would only kick in when the apinvdtl was being updated. It wouldn't do anything on the record add.

I really appreciate your help on this problem. This BPM has been driving me insane for two weeks.

On Oct 18, 2010, at 11:55 AM, Waffqle Driggers <waffqle@...> wrote:

> I'm testing it on my end, I'll shoot you the code when I get it running.
>
> Is your exception being displayed? If so, it may a bug in the program. If
> not, it's likely an error in the query.
>
> On Mon, Oct 18, 2010 at 11:37 AM, Brian Turner <bturner101@...>wrote:
>
>>
>>
>> I used the GetByID with the below query in the conditions but it still
>> allowed
>> me to post and create the invoice. Am I missing something?
>>
>> For Each RcvDtl Where (RcvDtl.InspectionPending = TRUE) no-lock ,
>>
>> Each ttAPInvDtl where (ttAPInvDtl.Company = RcvDtl.Company) and
>> (ttAPInvDtl.PONum = RcvDtl.PONum)
>> and
>> (ttAPInvDtl.POLine = RcvDtl.POLine)
>> and
>> (ttAPInvDtl.PORelNum =
>> RcvDtl.PORelNum)
>>
>>
>> ________________________________
>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com>>
>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
>> Sent: Mon, October 18, 2010 9:24:29 AM
>>
>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>>
>> We're on 9.04/9.05.
>> As best I can think, there are two ways you could handle this.
>> 1. You could replace the Base Method on 'GetAPUninvoicedReceipts'. I
>> wouldn't really recommend it though. Replacing the Base Method is best left
>> as a last-resort. Too many potential problems.
>>
>> 2. Grab APInvoice.GetByID. use the same query/exception setup I outlined
>> earlier. This isn't ideal, as the invoice will still be created, and this
>> method will fire every time someone looks up an AP invoice.
>> However, they will not be able to open/post the invoice until the receipt
>> has been inspected. It is also probably the easiest solution to implement,
>> by a wide margin. As long as you stick with a simple query/exception setup,
>> the performance hit should be pretty minimal. If you start using complex
>> queries or 4gl actions, all bets are off.
>> Since you are just using a little query instead of 4gl code or a UI
>> customization, odds are you won't have to worry about reworking this BPM
>> when updates get applied.
>>
>> Hope this helps. Let me know if you have other trouble.
>>
>> On Mon, Oct 18, 2010 at 9:51 AM, Brian Turner <bturner101@...<bturner101%40sbcglobal.net>
>>> wrote:
>>
>>>
>>>
>>> The methods available to me within APInvoice are listed below. What
>> version
>>> are
>>> you currently running?
>>>
>>> AddPOMiscChrgToInvoiceHead
>>> AddPOMiscChrgToInvoiceLine
>>> ChangeAdvancePayAmt
>>> ChangeAssemblySeq
>>> ChangeCostPerCode
>>> ChangeCurrency
>>> ChangeDistributionAccount
>>> ChangeExtCompanyID
>>> ChangeExtCost
>>> ChangeExtGLAcct
>>> ChangeExtGLRefCode
>>> ChangeGLRefCode
>>> ChangeInvoiceDate
>>> ChangeInvoiceRef
>>> ChangeInvoiceVendorAmt
>>> ChangeJobNum
>>> ChangeLineDiscAmt
>>> ChangeLockRate
>>> ChangeManualTaxCalculation
>>> ChangeMiscAmt
>>> ChangeMiscCode
>>> ChangeMiscPercent
>>> ChangeMtlSeq
>>> ChangeMultiCompany
>>> ChangeOverrideRevCharge
>>> ChangePartNum
>>> ChangePOLine
>>> ChangePONum
>>> ChangePORelNum
>>> ChangeRefPONum
>>> ChangeReportableAmt
>>> ChangeRevChargeMethod
>>> ChangeTaxableAmt
>>> ChangeTaxAmt
>>> ChangeTaxCode
>>> ChangeTaxPercent
>>> ChangeTermsCode
>>> ChangeUnitCost
>>> ChangeVendorID
>>> ChangeVendorQty
>>> CheckCPayBeforeUpdate
>>> CheckLegalNumsDisplay
>>> CheckRevChrgBeforeUpdate
>>> DeleteByID
>>> GenerateRebateInv
>>> GetAPInvPaySched
>>> GetAPInvPOMisc
>>> GetAPUninvoicedReceipts
>>> GetByID
>>> GetDMRDebitMemos
>>> GetLegalNumforDebitMemo
>>> GetList
>>> GetNewAPIHAPInvExp
>>> GetNewAPIHAPInvMsc
>>> GetNewAPInvDtl
>>> GetNewAPInvDtlAdvance
>>> GetNewAPInvDtlAttch
>>> GetNewAPInvDtlJobMiscellaneous
>>> GetNewAPInvDtlMiscellaneous
>>> GetNewAPInvDtlUnreceived
>>> GetNewAPInvExp
>>> GetNewAPInvHed
>>> GetNewAPInvHedAttch
>>> GetNewAPInvHedDebitMemo
>>> GetNewAPInvHedInvoice
>>> GetNewAPInvJob
>>> GetNewAPInvMsc
>>> GetNewAPInvTax
>>> GetRebateInvList
>>> GetRows
>>> GLAllocation
>>> PreUpdate
>>> TransferInvoiceToGroup
>>> Update
>>> UpdateAPInvPaySched
>>> UsePurchaseCode
>>>
>>>
>>> ________________________________
>>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
>> 40gmail.com>>
>>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
>> 40yahoogroups.com>
>>> Sent: Mon, October 18, 2010 8:42:22 AM
>>>
>>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>>>
>>> Ok, I don't have that version available; let's just assume that method
>>> isn't
>>> available. Can copy/paste me a list of the methods you have available?
>> I'm
>>> sure we can work something out.
>>>
>>> On Mon, Oct 18, 2010 at 9:39 AM, Brian Turner
>>> <bturner101@... <bturner101%40sbcglobal.net><bturner101%
>> 40sbcglobal.net>
>>
>>>> wrote:
>>>
>>>>
>>>>
>>>> I'm running version 8.03.409A
>>>>
>>>>
>>>> ________________________________
>>>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
>> 40gmail.com><waffqle%
>>> 40gmail.com>>
>>>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
>> 40yahoogroups.com> <vantage%
>>> 40yahoogroups.com>
>>>> Sent: Mon, October 18, 2010 8:30:37 AM
>>>>
>>>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>>>>
>>>> I've got it over here. What version are you on?
>>>>
>>>> On Mon, Oct 18, 2010 at 9:08 AM, Brian Turner
>>>> <bturner101@... <bturner101%40sbcglobal.net> <bturner101%
>> 40sbcglobal.net><bturner101%
>>
>>> 40sbcglobal.net>
>>>>> wrote:
>>>>
>>>>>
>>>>>
>>>
>>>>> The InvoiceSelectedLines method directive is not available in the
>>> search
>>>>> list
>>>>> within the APInvoice business object.
>>>>>
>>>>> I see it in the trace log while I enter a new invoice and receipt
>> line.
>>>>>
>>>>> Do you happen to know why EPICOR would make some method directives
>>>>> unavailable
>>>>> within the corresponding business object?
>>>>>
>>>>> ________________________________
>>>>> From: Waffqle Driggers <waffqle@... <waffqle%40gmail.com><waffqle%
>> 40gmail.com><waffqle%
>>> 40gmail.com><waffqle%
>>>> 40gmail.com>>
>>>>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
>> 40yahoogroups.com> <vantage%
>>> 40yahoogroups.com> <vantage%
>>>
>>>> 40yahoogroups.com>
>>>>
>>>>> Sent: Fri, October 15, 2010 4:24:21 PM
>>>>> Subject: Re: [Vantage] Re: HELP! I am struggling with a BPM
>>>>>
>>>>>
>>>>> Easiest way I can think of would be to put a pre-processing directive
>>> on
>>>>> "APInvoice.InvoiceSelectedLines".
>>>>>
>>>>> Set the action to "Raise an exception" and give it the message you
>>> would
>>>>> like to have displayed.
>>>>>
>>>>> Set the condition to "number of rows in the designed query is more
>> than
>>>> 0".
>>>>> Give it a query that will return all the RcvDtl's where
>>>>> PendingInspection=true and the receipt/line numbers match the ones
>>> you're
>>>>> trying to invoice.
>>>>>
>>>>> You should be all set.
>>>>>
>>>>> If you have trouble with the query let me know and I'll see if I
>> can't
>>>> help
>>>>> you out in the morning. But it's after 5 now and I'm heading home for
>>> the
>>>>> day.
>>>>>
>>>>> On Fri, Oct 15, 2010 at 4:53 PM,
>>>>> bturner101@... <bturner101%40sbcglobal.net> <bturner101%
>> 40sbcglobal.net> <bturner101%
>>> 40sbcglobal.net><bturner101%
>>>> 40sbcglobal.net><
>>>>
>>>>> bturner101@... <bturner101%40sbcglobal.net> <bturner101%
>> 40sbcglobal.net> <bturner101%
>>> 40sbcglobal.net> <bturner101%
>>>
>>>> 40sbcglobal.net>> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> The RcvDtl.InspectionPending field is True False. When ever a PO is
>>>>> marked
>>>>>> as inspection required, the receipt detail defaults to
>>>>>> RcvDtl.InspectionPending = True. Once QC is processed, the
>> inspection
>>>>>> pending field reverts to False.
>>>>>>
>>>>>> I would like to trigger on the inspection pending field to halt an
>>>>> invoice
>>>>>> line entry when inspection pending = TRUE.
>>>>>>
>>>>>> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
>> 40yahoogroups.com> <vantage%
>>> 40yahoogroups.com> <vantage%
>>>> 40yahoogroups.com> <vantage%
>>>>
>>>>> 40yahoogroups.com>, Waffqle
>>>>>
>>>>>> Driggers <waffqle@...> wrote:
>>>>>>>
>>>>>>> We should be able to get this working no sweat.
>>>>>>>
>>>>>>> However, we don't do inspection here. Can you give me a little
>> more
>>>>>>> explanation? How do we know something is in inspection? Is it
>> just
>>> a
>>>>>> field
>>>>>>> on the receipt?
>>>>>>>
>>>>>>> If that's the case, it should be a trivial thing to either add an
>>>> alert
>>>>>> at
>>>>>>> invoice time or prevent the receipt from being invoiced.
>>>>>>>
>>>>>>> On Fri, Oct 15, 2010 at 2:11 PM, bturner101@... <
>>>>>>> bturner101@...> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> I am struggling with a BPM and hoping someone can point me in
>> the
>>>>> right
>>>>>>>> direction.
>>>>>>>>
>>>>>>>> I am attempting to create a BPM that will alert, stop, or hide
>> PO
>>>>>> receipts
>>>>>>>> that are pending inspection. Bottom line I need to make sure
>> the
>>> AP
>>>>>> clerk
>>>>>>>> knows an invoice line is pending inspection when a new receipt
>>> line
>>>>> is
>>>>>>>> entered.
>>>>>>>>
>>>>>>>> I have been asked to add this functionality because management
>>> does
>>>>> not
>>>>>>>> want to pay supplier invoices until materials have been
>>> inspected.
>>>>>>>>
>>>>>>>> I am open for any and all suggestions. Most of the data for the
>>>>>> APInvDtl
>>>>>>>> table is populated by the RcvDtl table including the pending
>>>>> inspection
>>>>>> TRUE
>>>>>>>> / FALSE field.
>>>>>>>>
>>>>>>>> I have been struggling with this even with EPICOR tech support
>>> and
>>>>> have
>>>>>> not
>>>>>>>> been able to get very far.
>>>>>>>>
>>>>>>>> I am running Vantage 8.03.409A
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> [Non-text portions of this message have been removed]
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> [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/linksYahoo! Groups Links
>>>>>
>>>>>
>>>>> [Non-text portions of this message have been removed]
>>>>>
>>>>>
>>>>>
>>>>
>>>> [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/linksYahoo! Groups Links
>>>>
>>>> [Non-text portions of this message have been removed]
>>>>
>>>>
>>>>
>>>
>>> [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/linksYahoo! Groups Links
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>>
>>
>> [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/linksYahoo! Groups Links
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>
>
> [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/linksYahoo! Groups Links
>
>
>