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
Until next post!
Mariano Gomez, MIS, MVP, MCP, PMP
Maximum Global Business, LLC