Hi All,
I have been fighting a loosing battle with this so any help appreciated, I am trying to set net vat and gross to be negative when a Credit Note is detected, this is as the end point of delivery requires them in this manner.
So Far every time I script this to either insert a "-" symbol or deduct the value by itself twice i get errors that the script clashes with other scripts, i.e chains.
My code is as below:
If me.Field("TotalNetAmount").Value > 0 Then
me.Field("TotalNetAmount").Value = me.Field("TotalNetAmount").Value - me.Field("TotalNetAmount").Value - me.Field("TotalNetAmount").Value
End If
If me.Field("TotalTaxAmount").Value > 0 Then
me.Field("TotalTaxAmount").Value = me.Field("TotalTaxAmount").Value - me.Field("TotalTaxAmount").Value - me.Field("TotalTaxAmount").Value
End If
If me.Field("Total").Value > 0 Then
me.Field("Total").Value = me.Field("Total").Value - me.Field("Total").Value - me.Field("Total").Value
End If
Thanks in Advance
コメント
2件のコメント
Hello,
Could you please send us the project and some sample images?
Hi Katerina,
Thanks for the reply, I opted to write these values out to new fields entirely for export in the end and hide on Validation.
Much appreciated.
Martin
サインインしてコメントを残してください。