V8.03.407 BPM is causing Record has been modified by another us

Yahoo Archive
1
Thank you for the help Dale & Rob. I ended up moving the BPM out of ARInvoice.GetById and putting it into InvcGrp.Update because ARInvoice.GetById would fire every time someone clicked on the invoice number in the group list. I had to customize the Invoice Group screen to add a checkbox that will fire the BPM.



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dale Schuerman
Sent: Wednesday, November 18, 2009 11:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.





Linda,

The "tt" fields updated the database during the "Process", so any modifications in the Post-Process must be done to the database.

The following example is saving the content of t-new-jobnum into Project.PrimaryJob.

This UpdateTableBuffer.p program is supplied by Epicor.

Run lib\updatetablebuffer.p(Input BUFFER Project:HANDLE, 'PrimaryJob', t-new-jobnum).

Hope this helps

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@... <mailto:dale.schuerman%40ramsys.com> <BLOCKED::blocked::mailto:dale.schuerman@... <mailto:dale.schuerman%40ramsys.com> > (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/> (website)

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Linda Lowney
Sent: Wednesday, November 18, 2009 9:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.

Hi Rob,

The invoice number does not seem to be available during pre-processing. I added a message to display the ttInvcHead.InvoiceNum, but nothing shows up.

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On Behalf Of Rob Bucek
Sent: Wednesday, November 18, 2009 10:19 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.

Did you try this at a pre-processing?

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On Behalf Of Linda Lowney
Sent: Wednesday, November 18, 2009 8:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.

Hi Group,

I have this code as a Post-Processing action on ARInvoice.GetByID and it
is not allowing us to make any changes to the invoice. What I want to
happen is when an invoice is pulled into a batch I want a couple of
fields copied from order entry. What am I doing wrong?

/*Add source code that should be executed after the designed actions
here*/

for each ttInvcHead no-lock ,

each ttInvcDtl

where (ttInvcHead.Company =
ttInvcDtl.Company

and
ttInvcHead.InvoiceNum = ttInvcDtl.InvoiceNum) no-lock ,

each OrderDtl

where (ttInvcDtl.Company =
OrderDtl.Company

and ttInvcDtl.OrderNum =
OrderDtl.OrderNum

and ttInvcDtl.OrderLine
= OrderDtl.OrderLine) no-lock ,

each OrderHed

where (OrderDtl.Company =
OrderHed.Company

and OrderDtl.OrderNum =
OrderHed.OrderNum) no-lock .

if available OrderHed then do:

assign
ttInvcHead.CheckBox05 = OrderHed.CheckBox05.

end.

if available OrderDtl then do:

assign ttInvcDtl.Number01 =
OrderDtl.Number01.

end.

end.

Regards,

Linda Lowney

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Hi Group,



I have this code as a Post-Processing action on ARInvoice.GetByID and it
is not allowing us to make any changes to the invoice. What I want to
happen is when an invoice is pulled into a batch I want a couple of
fields copied from order entry. What am I doing wrong?



/*Add source code that should be executed after the designed actions
here*/

for each ttInvcHead no-lock ,

each ttInvcDtl

where (ttInvcHead.Company =
ttInvcDtl.Company

and
ttInvcHead.InvoiceNum = ttInvcDtl.InvoiceNum) no-lock ,

each OrderDtl

where (ttInvcDtl.Company =
OrderDtl.Company

and ttInvcDtl.OrderNum =
OrderDtl.OrderNum

and ttInvcDtl.OrderLine
= OrderDtl.OrderLine) no-lock ,

each OrderHed

where (OrderDtl.Company =
OrderHed.Company

and OrderDtl.OrderNum =
OrderHed.OrderNum) no-lock .



if available OrderHed then do:

assign
ttInvcHead.CheckBox05 = OrderHed.CheckBox05.

end.



if available OrderDtl then do:

assign ttInvcDtl.Number01 =
OrderDtl.Number01.

end.

end.



Regards,



Linda Lowney





[Non-text portions of this message have been removed]
3
Did you try this at a pre-processing?



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Linda Lowney
Sent: Wednesday, November 18, 2009 8:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.





Hi Group,

I have this code as a Post-Processing action on ARInvoice.GetByID and it
is not allowing us to make any changes to the invoice. What I want to
happen is when an invoice is pulled into a batch I want a couple of
fields copied from order entry. What am I doing wrong?

/*Add source code that should be executed after the designed actions
here*/

for each ttInvcHead no-lock ,

each ttInvcDtl

where (ttInvcHead.Company =
ttInvcDtl.Company

and
ttInvcHead.InvoiceNum = ttInvcDtl.InvoiceNum) no-lock ,

each OrderDtl

where (ttInvcDtl.Company =
OrderDtl.Company

and ttInvcDtl.OrderNum =
OrderDtl.OrderNum

and ttInvcDtl.OrderLine
= OrderDtl.OrderLine) no-lock ,

each OrderHed

where (OrderDtl.Company =
OrderHed.Company

and OrderDtl.OrderNum =
OrderHed.OrderNum) no-lock .

if available OrderHed then do:

assign
ttInvcHead.CheckBox05 = OrderHed.CheckBox05.

end.

if available OrderDtl then do:

assign ttInvcDtl.Number01 =
OrderDtl.Number01.

end.

end.

Regards,

Linda Lowney

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Hi Rob,



The invoice number does not seem to be available during pre-processing. I added a message to display the ttInvcHead.InvoiceNum, but nothing shows up.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Wednesday, November 18, 2009 10:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.





Did you try this at a pre-processing?

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Linda Lowney
Sent: Wednesday, November 18, 2009 8:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.

Hi Group,

I have this code as a Post-Processing action on ARInvoice.GetByID and it
is not allowing us to make any changes to the invoice. What I want to
happen is when an invoice is pulled into a batch I want a couple of
fields copied from order entry. What am I doing wrong?

/*Add source code that should be executed after the designed actions
here*/

for each ttInvcHead no-lock ,

each ttInvcDtl

where (ttInvcHead.Company =
ttInvcDtl.Company

and
ttInvcHead.InvoiceNum = ttInvcDtl.InvoiceNum) no-lock ,

each OrderDtl

where (ttInvcDtl.Company =
OrderDtl.Company

and ttInvcDtl.OrderNum =
OrderDtl.OrderNum

and ttInvcDtl.OrderLine
= OrderDtl.OrderLine) no-lock ,

each OrderHed

where (OrderDtl.Company =
OrderHed.Company

and OrderDtl.OrderNum =
OrderHed.OrderNum) no-lock .

if available OrderHed then do:

assign
ttInvcHead.CheckBox05 = OrderHed.CheckBox05.

end.

if available OrderDtl then do:

assign ttInvcDtl.Number01 =
OrderDtl.Number01.

end.

end.

Regards,

Linda Lowney

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
Linda,



The "tt" fields updated the database during the "Process", so any modifications in the Post-Process must be done to the database.

The following example is saving the content of t-new-jobnum into Project.PrimaryJob.



This UpdateTableBuffer.p program is supplied by Epicor.



Run lib\updatetablebuffer.p(Input BUFFER Project:HANDLE, 'PrimaryJob', t-new-jobnum).



Hope this helps



Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner



RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@... <BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/> (website)





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Linda Lowney
Sent: Wednesday, November 18, 2009 9:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.





Hi Rob,

The invoice number does not seem to be available during pre-processing. I added a message to display the ttInvcHead.InvoiceNum, but nothing shows up.

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Rob Bucek
Sent: Wednesday, November 18, 2009 10:19 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.

Did you try this at a pre-processing?

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On Behalf Of Linda Lowney
Sent: Wednesday, November 18, 2009 8:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8.03.407 BPM is causing Record has been modified by another user error.

Hi Group,

I have this code as a Post-Processing action on ARInvoice.GetByID and it
is not allowing us to make any changes to the invoice. What I want to
happen is when an invoice is pulled into a batch I want a couple of
fields copied from order entry. What am I doing wrong?

/*Add source code that should be executed after the designed actions
here*/

for each ttInvcHead no-lock ,

each ttInvcDtl

where (ttInvcHead.Company =
ttInvcDtl.Company

and
ttInvcHead.InvoiceNum = ttInvcDtl.InvoiceNum) no-lock ,

each OrderDtl

where (ttInvcDtl.Company =
OrderDtl.Company

and ttInvcDtl.OrderNum =
OrderDtl.OrderNum

and ttInvcDtl.OrderLine
= OrderDtl.OrderLine) no-lock ,

each OrderHed

where (OrderDtl.Company =
OrderHed.Company

and OrderDtl.OrderNum =
OrderHed.OrderNum) no-lock .

if available OrderHed then do:

assign
ttInvcHead.CheckBox05 = OrderHed.CheckBox05.

end.

if available OrderDtl then do:

assign ttInvcDtl.Number01 =
OrderDtl.Number01.

end.

end.

Regards,

Linda Lowney

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]