Report Design - Brexit Invoice

melissa

Hi All,

I have a customer who I am trying to create a Brexit invoice design with the unit weight, net weight etc.  For the net weight i have set up a variable which is basically Titran.it_quan*cname.cn_ntmass as the customer wanted to see the total net weight for the number of items. 

This appeared to be working ok however, I have noticed some of the stock items with particular profiles are not calculating correctly i.e. net weight is 50kg but my variable is showing 500kg - this is due to the stock profile having 1 decimal place (there is various decimals on different profiles) so the quantity shows as 1.0 but the variable thinks this is 10.  

Does anyone know what i am doing wrong?

Regards

Melissa

colin-avey

Hi Melissa,

You will also get a similar issue with factored items being multiplied by the factor. something like the below should help.

(Titran.it_quan*cname.cn_ntmass)/IIF(cfact.cf_factdp='F',cfact.cf_factor,(10^cfact.cf_dps))

HTH

Colin