- Currency Code does not exist on sales invoice as a field (silly)
- We must use the TotalInclVatText field which includes the currency code
- Insert row inside the list detail group
- copy and paste the tax details tablix into this row
- Set the row visibility formula to hide or show the entire row because the tablix does not respond to visibility code as it cannot "see" the value of the TotalInclVAtText field
- =IIf(InStr(Max(Fields!TotalInclVATText.Value), "USD") > 0, False, True)
Wednesday, September 11, 2019
Business Central - Hide or show tax based on currency code on Sales Invoice
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment