Hello,

I need a report for Customs now that we have left the EU within Sage 50 Accounts

I need to add the weights per commodity codes imported to a Purchase order. I have an individual weight of a qty line shown shown as POP_ITEM.QTY_ORDER*STOCK.UNIT_WEIGHT, the individual commodity code STOCK.COMMODITY_CODE, and a total for all items in the report shown. But now I need to split it down by the commodity codes.

Example 48 lines of product each with 1 of 4 different commodity codes. Can i create a look up so that I can get a total for each commodity code shown for all the product lines listed?

Appreciate any help. I tried support and they pushed me towards linked help pages on the site, but I could see how to do this.

Jason