Hi again!
managed to create a data directive (the messages wasn't showing but the code was working, stupied me) on the InvcHead.
Now I'm having a new problem, I want the directive only to run if there is no invoice reminders left on the customer (so that this directive is only triggered when the last reminder invoice is payed, and no other reminders is left on that customer). Right now it's releasing the holds for the customers open orders for every invoice reminder that is fully payed..
I'm new at abl-code, so please forgive my poor programming.
Data Directive, In-transaction.
for each ttInvcHead where ttInvcHead.Company = Cur-Comp
and ttInvcHead.DocInvoiceBal = 0 no-lock,
each CashHead where CashHead.Posted = true
and CashHead.CustNum = ttInvcHead.CustNum.
for each InvcReminder where InvcReminder.Company = ttInvcHead.Company
and InvcReminder.InvoiceNum = ttInvcHead.InvoiceNum
and InvcReminder.Sequence > 1.
For each OrderHed where Orderhed.Company = ttInvcHead.Company
and OrderHed.CustNum = ttInvcHead.CustNum.
Assign OrderHed.orderheld = false.
end.
end.
end.
How can i count the invoices on the customers that has got an invoice reminder with sequence > 2 ??
Kind regards,
Lisa
managed to create a data directive (the messages wasn't showing but the code was working, stupied me) on the InvcHead.
Now I'm having a new problem, I want the directive only to run if there is no invoice reminders left on the customer (so that this directive is only triggered when the last reminder invoice is payed, and no other reminders is left on that customer). Right now it's releasing the holds for the customers open orders for every invoice reminder that is fully payed..
I'm new at abl-code, so please forgive my poor programming.
Data Directive, In-transaction.
for each ttInvcHead where ttInvcHead.Company = Cur-Comp
and ttInvcHead.DocInvoiceBal = 0 no-lock,
each CashHead where CashHead.Posted = true
and CashHead.CustNum = ttInvcHead.CustNum.
for each InvcReminder where InvcReminder.Company = ttInvcHead.Company
and InvcReminder.InvoiceNum = ttInvcHead.InvoiceNum
and InvcReminder.Sequence > 1.
For each OrderHed where Orderhed.Company = ttInvcHead.Company
and OrderHed.CustNum = ttInvcHead.CustNum.
Assign OrderHed.orderheld = false.
end.
end.
end.
How can i count the invoices on the customers that has got an invoice reminder with sequence > 2 ??
Kind regards,
Lisa
--- In vantage@yahoogroups.com, "lisassar" <lisa.saren@...> wrote:
>
> Hi,
>
> Thanks for the reply!
>
> The data Directive on InvcHead (In-transaction) only raises when i create the invoice, not when i finally post it (or does it? my message doesn't seem to popup when posting). I want my BPM to change the Hold from false to true when the invoice is posted and fully payed (the balance on should be 0 on the order).
>
> Any ideas what to do here?
>
> Kind regards
> //Lisa
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> >
> > There is a Brief method called PrePost or something like that that you can
> > use on the BPM
> > Otherwise A data Directive on InvcHead should set the "Posted" flag to true
> > I believe. Though since its Async maybe not.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Thu, Feb 21, 2013 at 4:01 PM, lisassar <lisa.saren@> wrote:
> >
> > > **
> > >
> > >
> > > Hi Everybody!
> > >
> > > I've created a method directive that put a hold on all open sales order
> > > for a customer, if the customer has got more than 1 InvcReminder (Sequence
> > > > 1).
> > > I've also created one method directive that puts a hold on the sales order
> > > if it has a specific payment terms (advanced payment). Nothing strange with
> > > that.
> > >
> > > Now I want to create two method directive that releases the holds:
> > > 1. To all the customers orders when all invoices with reminders are fully
> > > payed for the customer.. when the invoices are posted and the invoice
> > > balance = 0.
> > > 2. Releases the hold for the sales order when a advanced invoice or a
> > > deposit invoice is created and posted!
> > >
> > > When I try to track which BOs i'm going to use, it is a process that's
> > > being called: Epicor.Mfg.Proc.ARInvoicePost.. Is it possible for me to
> > > create a BPM here or what is a better way of doing it?
> > >
> > > Got a tips about a Data Directive instead, but on what table? InvcHead
> > > isn't triggered after the invoice is posted either..
> > >
> > > Anybody got any tips how to solve this?
> > >
> > > Thankful for all the help i can get!!
> > >
> > > //Lisa
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>