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.
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]