Tax Exempt Field Null

[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

[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