Could someone please answer the following query?
I need a descriptive vb code that for one country ie germany where vat number is supplied but vat is not charged hence vat is not added to the subtotal. Another where vat is not supplied ie Argentina and vat is not added to the subtotal and a third where vat number is supplied and charged ie US hence added to the subtotal. They should therefore be charged for instance 200 USD, as the subtotal and vat added = total. the first 2 would be 200 USD and zero vat added = total.
Meanwhile I've hard coded everything at the moment to check for 200 subtotal and vat added @ 42 USD etc to the subtotal
Could you also please put the values for subtotal vat and total into a test data spreadsheet as I'm really struggling.
but what i understood is you need to create a function which calculates the values and then you have to get the values from the local/global sheet and send them to the function which in turn calculates based on the logic and
returns the value then you can compare in your application if the value is returns correct/wrong
Select Case Country
when things gets harder ,the harder gets going