Exporting Invoices from GTS to Excel, Or Consolidated Invoice

[Former Member]

Hello SAP Community!

I am trying to find a way to either export invoice data from GTS, or consolidate information from multiple invoices onto one invoice. I have a situation where I'm loading a truck with multiple customer orders, each with their own invoice. We will be making one cross border customs entry for the entire truck, sometimes with 15-20 different customer orders. I was hoping to find a way to export the data to an excel spreadsheet, so I can easily tally part #'s, values and quantities. Is this function possible within GTS? Or, even better, is it possible to create a consolidated invoice in GTS, showing a summary of the 15-20 customer orders?

[Former Member]

Hi Amanda,

As Dave mentioned if you are using an ERP system as a feeder system, I'm assuming based on the scenario you quoted, you are using the same carrier which will ship all of 15-20 customer orders to the same location before the smaller shipments make it to the final destination (customer destination). My 2 cents in such a situation would be to create a consolidated proforma through the use of Shipment Consolidation and have it transferred to SAP GTS. Additionally, if there is a still a need to export all of the items to an excel to gather the part numbers, quantity, values and tariff , there is a small icon called "Export" at the item level of the declaration which could be used by selecting all the items of the declaration. FYI, The export to excel will not have details around the address or the legal language.

Hope it helps!

-Shrini

[former_member215181]

Hi Amanda,

Assuming you are using SAP ERP as the "feeder system" for GTS; if you model the truck as an Outbound Shipment, you can very easily transfer all of the delivery details and create a single Export Declaration in GTS, using the "Shipment Consolidation" transaction /SAPSLL/CUS_INV_R3. That Declaration can be sent directly to the Customs Authority, with no need for a spreadsheet.

Does that help?

Regards,
Dave