I do this in a data directive in 905.702A. the fields are in the ComXRef table. the code below adds a record and sets the fields.
HTH
Greg
Condition:
there is at least one added row in the ttPORel table
Action :
ABL Code
/* set lock date and qty */
/* set lock flags */
For Each ttPORel where ttPORel.Company = CUR-COMP.
message "IN POREL DD " + STRING(ttPoRel.PONum).
Find ComXRef where ComXRef.Company = ttPORel.Company and ComXRef.File = "PORel_Mapping" and ComXRef.Key1 = string(ttPORel.PONum) and
ComXRef.Key2 = string(ttPORel.POLine) and ComXRef.Key3 = string(ttPORel.PORelNum) no-error.
If Not Avail ( ComXRef ) Then Do:
Create ComXRef.
ComXRef.Company = ttPORel.Company.
ComXRef.File = "PORel_Mapping".
ComXRef.Key1 = string(ttPORel.PONum).
ComXRef.Key2 = string(ttPORel.POLine).
ComXRef.Key3 = string(ttPORel.PORelNum).
End.
ComXRef.ForeignKey1 = "yes".
ComXRef.ForeignKey2 = "yes".
Release ComXRef.
End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, August 01, 2014 1:52 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] We want to automatically lock ALL our PO-Releases
Good Day:
There are check boxes to ‘lock’ the PO so that MRP Regen treats it as untouchable and will NOT try to re-schedule it or change qty.
So, I am trying to automatically check those boxes.
But I wonder if I could customize the form to make the box being checked be the default.
I have not done much with custom screens so I have no idea. I would assume changing a default would be doable.
Len
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, August 01, 2014 1:45 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] We want to automatically lock ALL our PO-Releases
You could create a customization for when the form loads make these fields readonly.
From: "Len Hartka
len.hartka@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, August 1, 2014 1:08 PM
Subject: [Vantage] We want to automatically lock ALL our PO-Releases
Good Day:
Re: We want to automatically lock ALL our PO-Releases
We want to automatically lock ALL our PO-Releases ( both date and Quantity).
Is there a setting that will cause that to happen automatically for all PO’s?
We create most of our PO's from PO-Suggestions, so it will have to work in that conversion process.
Len
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
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."