Suppressing "Credit Limit" Warning in Sales Order Processing

A few days aback, I was asked how to keep the “This transaction exceeds the customer’s credit limit” message box from popping up when entering a Sales Order. At first I thought it was a strange request, since the warning serves its purpose, but then the user explained that they had their own credit management system which takes into consideration a lot more information that GP does not manage beyond the aging buckets and the limit itself. In addition, they already had a customization in place to check the customer’s credit limit against their credit system and automatically set the order on hold if limit was exceeded. In summary, the message was an inconvenience since it appeared each time a line item was entered.

To resolve this issue, I created a small VBA script that would automatically respond to the modal dialog without the user even noticing a blink on the screen, as follows:

1) Add the Sales Transaction Entry window to Visual Basic.

2) Open the Visual Basic Editor and locate the SalesTransactionEntry (Window) object. Double-click on it to bring up the editor.

3) Copy/paste the following script to the editor


Private Sub Window_BeforeModalDialog(ByVal DlgType As DialogType, PromptString As String, Control1String As String, Control2String As String, Control3String As String, Answer As DialogCtrl)

If PromptString = "This transaction exceeds the customer's credit limit. Do you want to continue?" Then

'Click the first button, the Continue button
Answer = dcButton1
End If
End Sub

Until next post!

MG.-
Mariano Gomez, MIS, MVP, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Advertisements

One Response to Suppressing "Credit Limit" Warning in Sales Order Processing

  1. I thought this would have to be turned on to a specific User Class ID in Alternate/Modified Forms and Reports but it seems to be available to all. Is there a way to limit this change to one User Class?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: