Commercial Invoice
Posted: 25 Feb 2021, 13:30
Hi
Over the last 6 weeks I have compiled a list of data necessary to get shipments collected in europe, and brought across the border to the UK now we're post brexit. This has been an exhausting time with shipments being turned away repeatedly with "Commercial Invoice Missing xxxxxxxx" as the resason.
I've customised a normal invoice (picture attached), so that it will contain everything needed to get goods moving. At the moment I'm using a spreadsheet layout to tide me over, but this is time consuming.
I've attached a picture of my report adjustment so far, but just a couple of issues.
1) I need to get the customers email address onto the sheet. Shipping companies refuse to collect pallets without it being present.
2) I need the weight and the commodity code as you can see, which I have achieved, but when I create a text line using the Stock Code of "M" whatever I type is followed by those two lines. I want stock items to be followed by weight and commodity code, but not text lines.
Is there an easy solution?
Thanks.
Over the last 6 weeks I have compiled a list of data necessary to get shipments collected in europe, and brought across the border to the UK now we're post brexit. This has been an exhausting time with shipments being turned away repeatedly with "Commercial Invoice Missing xxxxxxxx" as the resason.
I've customised a normal invoice (picture attached), so that it will contain everything needed to get goods moving. At the moment I'm using a spreadsheet layout to tide me over, but this is time consuming.
I've attached a picture of my report adjustment so far, but just a couple of issues.
1) I need to get the customers email address onto the sheet. Shipping companies refuse to collect pallets without it being present.
2) I need the weight and the commodity code as you can see, which I have achieved, but when I create a text line using the Stock Code of "M" whatever I type is followed by those two lines. I want stock items to be followed by weight and commodity code, but not text lines.
Is there an easy solution?
Thanks.