Page 1 of 1

Tax Exempt Field Null

PostPosted: Mon Sep 07, 2015 2:42 pm
by in2solutions
Jiwa 6.513
I require assistance with Breakout Code for the following:
On a Sales Quote.
On Save.
If Tax Exempt field is not null then have a message appear on save. Message is “Please include bank fees on quote”.

Will need to know the breakout to use and also the code to use.
Thanbks
George

Re: Tax Exempt Field Null

PostPosted: Fri Sep 11, 2015 7:54 pm
by aegean66
Try this under SalesQuoteSaved event

varFlag = 0
For Each SalesQuoteLineObject In SalesQuoteObject.SalesQuoteLines
If SalesQuoteLineObject.GSTID = "GST02000000000000000" Then
varFlag = 1
End If
Next

If varFlag = 1 Then
MsgBox("Please include bank fees on quote.")
End If

Use either <> or = to test
GSTID will be the ID value in the SQL table of whatever GST Code you want to test