Hello All,
Hope you are all keeping well and staying safe….
Currently, I am trying to create a table on an AR Invoice to calculate the total weight of an HS Code on an SSRS Report….
For example:
Product Name - Qty Invoiced - HS Code - UOM
Product A 10 230660606 10kg
Product B 15 230660606 0.5kg
Product C 20 230660607 1kg
What is needed on the table on the SSRS Report is:
HS Code Weight
230660606 107.5
230660607 20
New to Epicor so it’s being a great learning curve……