Save data in InvcDtl after post

Yahoo Archive
1
I do execute ABL code and then the execute code below option. I understand that forward to produce is faster and or the code is not compiled each time, but I have not gotten that down yet.

Greg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bill Wu
Sent: Saturday, March 09, 2013 4:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Save data in InvcDtl after post



This is what I'm looking for. I will try this. The updatable BAQ might work, but I'm dealing with several thousand rows. I take you place this code in the .p file and run this on the server? I can probably figure this out.

Thank you very much.

Bill Wu

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Greg Payne
Sent: Saturday, March 09, 2013 11:54 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: Save data in InvcDtl after post

Bill:

I would use a data directive which is not dependent on the method. The code would look something like below depending on the data that you want to put in the InvcDtl table.

Greg Payne

For each ttInvcDtl FIELDS(Company PartNum) where ttInvcDtl.RowMod = "A" no-lock.

For Each PartPlant fields( number01 ) no-lock where
PartPlant.Company = ttInvcDtl.Company and
PartPlant.Plant = ttInvcDtl.Plant and
PartPlant.PartNum = ttInvcDtl.PartNum.

Assign ttInvcDtl.Number01 = PartPlant.Number01.

End.

End.
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 Bill Wu
Sent: Friday, March 08, 2013 11:52 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Save data in InvcDtl after post

Hi! group,
I have a need to save some data into user defined fields in InvcDtl table. We have Progress database. E9 700C. I tried Epicor's ARinvoice adapter. It won't allow me do the update method for all Canadian transactions. I don't know 4GL, can someone help with some sample 4GL code to update existing posted invoice detail record?

Thanks in advance.

Bill Wu

THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENT(S) NAMED ABOVE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR, AND THAT ANY REVIEW, DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS MESSAGE IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY RETURN E-MAIL OR TELEPHONE AT 585-494-1817.

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

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

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

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
2
Hi! group,
I have a need to save some data into user defined fields in InvcDtl table. We have Progress database. E9 700C. I tried Epicor's ARinvoice adapter. It won't allow me do the update method for all Canadian transactions. I don't know 4GL, can someone help with some sample 4GL code to update existing posted invoice detail record?

Thanks in advance.

Bill Wu

THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENT(S) NAMED ABOVE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR, AND THAT ANY REVIEW, DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS MESSAGE IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY RETURN E-MAIL OR TELEPHONE AT 585-494-1817.



[Non-text portions of this message have been removed]
3
You can use an Updatable ��Q

[Description: Description: Description: Description: cid:image002.png@01CDB5D2.96C69A10]

Stelios Zoumis <mailto:s.zoumis@...> | EBS - Enterprise Business Solutions | Sr Business Consultant |
Tel: +30 210 6874300 (ext. 314) | Fax: +30 210 6855564 | www.atc.gr<http://www.atc.gr/>





[Description: Description: Description: Description: cid:image009.jpg@01CDB5D2.96C69A10]<https://dunsregistered.dnb.com/DunsRegisteredProfileAnywhere.aspx?Key1=3100369&PaArea=email>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bill Wu
Sent: Saturday, March 09, 2013 6:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Save data in InvcDtl after post



Hi! group,
I have a need to save some data into user defined fields in InvcDtl table. We have Progress database. E9 700C. I tried Epicor's ARinvoice adapter. It won't allow me do the update method for all Canadian transactions. I don't know 4GL, can someone help with some sample 4GL code to update existing posted invoice detail record?

Thanks in advance.

Bill Wu

THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENT(S) NAMED ABOVE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR, AND THAT ANY REVIEW, DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS MESSAGE IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY RETURN E-MAIL OR TELEPHONE AT 585-494-1817.

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



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

I would use a data directive which is not dependent on the method. The code would look something like below depending on the data that you want to put in the InvcDtl table.

Greg Payne


For each ttInvcDtl FIELDS(Company PartNum) where ttInvcDtl.RowMod = "A" no-lock.

For Each PartPlant fields( number01 ) no-lock where
PartPlant.Company = ttInvcDtl.Company and
PartPlant.Plant = ttInvcDtl.Plant and
PartPlant.PartNum = ttInvcDtl.PartNum.

Assign ttInvcDtl.Number01 = PartPlant.Number01.

End.


End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bill Wu
Sent: Friday, March 08, 2013 11:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Save data in InvcDtl after post



Hi! group,
I have a need to save some data into user defined fields in InvcDtl table. We have Progress database. E9 700C. I tried Epicor's ARinvoice adapter. It won't allow me do the update method for all Canadian transactions. I don't know 4GL, can someone help with some sample 4GL code to update existing posted invoice detail record?

Thanks in advance.

Bill Wu

THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENT(S) NAMED ABOVE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR, AND THAT ANY REVIEW, DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS MESSAGE IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY RETURN E-MAIL OR TELEPHONE AT 585-494-1817.

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
5
This is what I'm looking for. I will try this. The updatable BAQ might work, but I'm dealing with several thousand rows. I take you place this code in the .p file and run this on the server? I can probably figure this out.

Thank you very much.

Bill Wu

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Saturday, March 09, 2013 11:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Save data in InvcDtl after post



Bill:

I would use a data directive which is not dependent on the method. The code would look something like below depending on the data that you want to put in the InvcDtl table.

Greg Payne

For each ttInvcDtl FIELDS(Company PartNum) where ttInvcDtl.RowMod = "A" no-lock.

For Each PartPlant fields( number01 ) no-lock where
PartPlant.Company = ttInvcDtl.Company and
PartPlant.Plant = ttInvcDtl.Plant and
PartPlant.PartNum = ttInvcDtl.PartNum.

Assign ttInvcDtl.Number01 = PartPlant.Number01.

End.

End.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Bill Wu
Sent: Friday, March 08, 2013 11:52 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Save data in InvcDtl after post

Hi! group,
I have a need to save some data into user defined fields in InvcDtl table. We have Progress database. E9 700C. I tried Epicor's ARinvoice adapter. It won't allow me do the update method for all Canadian transactions. I don't know 4GL, can someone help with some sample 4GL code to update existing posted invoice detail record?

Thanks in advance.

Bill Wu

THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE IS INTENDED ONLY FOR THE PERSONAL AND CONFIDENTIAL USE OF THE DESIGNATED RECIPIENT(S) NAMED ABOVE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT OR AN AGENT RESPONSIBLE FOR DELIVERING IT TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT YOU HAVE RECEIVED THIS DOCUMENT IN ERROR, AND THAT ANY REVIEW, DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS MESSAGE IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMMEDIATELY BY RETURN E-MAIL OR TELEPHONE AT 585-494-1817.

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

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

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



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