I'm currently working an issue where I'm trying to to limit the OE "type" for our billing clerk to C=Crdt Memo and I=Invoice for Sarbannes compliance. The OE0101 screenset is used for both order entry and billing entry so I cannot simply modify OE0101 screenset values for the "Type" omitting O=Order, as it is necessary for the billing entry.
This user previously did not have any flex mods for OE. I've added some code for this user to simply check the value of the Type field when I get focus on the order number field as follows:
Private Sub No_GotFocus()
If Me.Type1.Text = "O=Order" Then
MsgBox "Order entry not allowed. Please select another option.", vbExclamation
macForm.Cancel
End If
End Sub
Very simple and seems to do the trick until I process through a credit memo and select to print the invoice immediately. Once I print the invoice and tell Macola that it has printed correctly the order entry screen disappears and the status bar on the Progression screen states "Starting Application...". Task manager shows that VBA Connect is still running however OE appears to be hung. If I choose not to print the invoice immediately, all is well and once submitted the refreshed OE screen is open and active.
As mentioned this user did not have any previous flex mods for OE, but I do use flex for OE with our CSR group. Further credit memo testing with the CSR code applied to my account returns the same result. The CSR flex has been in place for a few years and works great for normal OE. I only see the issue where the type is C=Crdt Memo and I print immediately and a flex mod is applied.
Other than "Don't print the invoice immediately" Any Thoughts?
7.6.300C MSSQL 2000
Sorry for the long post and thanks for any input.
This user previously did not have any flex mods for OE. I've added some code for this user to simply check the value of the Type field when I get focus on the order number field as follows:
Private Sub No_GotFocus()
If Me.Type1.Text = "O=Order" Then
MsgBox "Order entry not allowed. Please select another option.", vbExclamation
macForm.Cancel
End If
End Sub
Very simple and seems to do the trick until I process through a credit memo and select to print the invoice immediately. Once I print the invoice and tell Macola that it has printed correctly the order entry screen disappears and the status bar on the Progression screen states "Starting Application...". Task manager shows that VBA Connect is still running however OE appears to be hung. If I choose not to print the invoice immediately, all is well and once submitted the refreshed OE screen is open and active.
As mentioned this user did not have any previous flex mods for OE, but I do use flex for OE with our CSR group. Further credit memo testing with the CSR code applied to my account returns the same result. The CSR flex has been in place for a few years and works great for normal OE. I only see the issue where the type is C=Crdt Memo and I print immediately and a flex mod is applied.
Other than "Don't print the invoice immediately" Any Thoughts?
7.6.300C MSSQL 2000
Sorry for the long post and thanks for any input.