Muziri, Amber Road,Silk,Spice, Incense route to Modern Global Trade – Series IV

The objective of this article series is to understand the complications in running global trade business and how GTM software can help to run smoothly.

We will see Compliance, Preference, Content, documentary letter of credit and Customs Management

First, we see how Restricted Party Screening Framework can be constructed as part of Compliance policy for a company :-

Develop RPS Framework

Define scope of screening : Identifying which are the Business partners need to be screened is the first step to construct  a RPS framework.Business partners means not only customers alone. Customers, Suppliers, Financial Institutions like banks through which your customer making payments to you , there is a need to verify the background of the bank which issues Letter of credit on your customer behalf . It may have a branch in Sudan or Syria or may deal with banks of embargo countries. Also it is required to verify  service providers like customs brokers, forwarding agent and transporters to stay complaint.Companies also should start RPS Screening within inside. HR departments should start using RPS software for background check as part of pre-employment screening. Employers need to ensure they are not recruiting a candidate who are in denied party list.As part of GRC Framework,visitors also should be screened when they visited company offices and production sites. It is the responsibility of  export controlled technology products manufacturing companies to protect trade secrets for purposes of national security, foreign policy and counter-terrorism under the export control rules of the State, Commerce, and Treasury Departments. So maintaining trade secrets is not only for staying competitive and also it is part of export compliance. Companies planning to  do acquisition also has to do proper scrutiny for compliance history and verify  any violation history exists for selling company. All enforcement agencies impose successor liability so it is the responsibility of buying  company to check antecedent of company which decided to  sell.It is better to keep   philanthropy activities of company also under the lens of compliance. It is necessary for company to do background verification check before granting money as part of charity work.It is imperative to implement a good RPS  software solutions to verify the charity organisation history before providing aid. It is the responsibility of the company make sure your financial grant is not distributed to wrong parties  . Screening is necessary to be part of Governance, Risk and Compliance policy framework, and it is also  required to extend to brokers, commission agents, dealers, insurance companies, hotels, car dealers ,as a whole name any partners your company dealing with. If your company conducts business with a black listed party, or if  found to be associated with a denied party due to poor internal security in IT infrastructure, improper pre-employment screening, supplied to denied party, distributed donations to parties who are blacklisted  may result in revoking of trade privileges, fine and loss of reputation of company. A well-defined GRC Framework policy is crucial to prevent lapses

Fully automated :

What is fully automated means is, how system has to decide block or not to block a transaction when there is a match or a possibily positive match detected in  feeder order management system..RPS Software solution should be capable to do screening large volume of data  with less  intervention manually, compliance manager’s responsibilities  should be confined with verifying the resultant value is positive or  false positive . How we decide automated system and how much to automate and what are the criteria’s has to be set, is the big question in front of us before deciding a solution :-

- Average volume of international transactions created in year

- Average volume of transactions relevant to check means there is no need to verify stock transport order, inter company shipments under one company code

but end user (or) ultiimate consignee is third party then it is necessary to check

- How master data for Trade or Business partners maintained

- When and how RPL master data updated in your system


Volume, timing and control are the key factors to decide how you are going to construct a solution for your RPL Screening requirements. Third party service providers for compliance check like MK Denial and Choice point sharing data of Restricted Parties from various sources. Sources is listed and supplied to companies in XML format or directly uploaded in server if interface is there. Compliance manager (or) clerk can can keep RPL Master data as spreadsheet and verify whether any match is there before creating sales order in order management system. But,this is time-consuming process and it will be very difficult to do when you have large volume,say 4,000 transactions in a year. An ideal solution should be have an option to check real-time and in batch, hundreds and thousands of partners at one time. Both batch processes and real-time verification is very critical when you are maintaining list from various sources with different validity dates. Currently, an average US exporter must screen twelve different government lists to stay compliant, if your company is doing business from other countries additional lists also needs to be verified to maintain compliance. If the volume is very high it will be very difficult to maintain accuracy

 Timing is when to perform screening.

- When any new master data created for Business partner, for which screening is required

- When master data modified in system

- When new content of RPL master data updated in system.

- When address is changed in transaction level. This is possible for drop shipment scenario’s

- Phoenetical check of name and contact when attention details  updated  in transaction level


Control is the standard of comparison for checking results of screening processes. You can have either synchronous (or) asynchronous screening. When document  or master data created (or) modified in order management system, if RPS software runs automatically screening generates results then it is synchrnous check. The displayed result in screen can have blocked and released documents. To block or to release decided by system based on RPL master data available in RPS Software. This process is completely system driven. In asynchronous mode, RPL Check run as background processing through batch job or in dialog . When you run screening as batch job, the check results will be displayed blocked and released documents same as synchronous. if you run screening  as dialog , system generates results directly.Asynchronous is advantageous when you have large number of back end system system documents as it is not performance intensive. We see next what SPL specialist has to do when there is a block. How list prepared by third party service providers. How we control false positive block.

Muziri, Amber Road,Silk,Spice, Incense route to Modern Global Trade – Series III

This is continuity of my previous article about developments in Global Trade business and also how evolving regulations by individual governments in customs posing  how many challenges for International Trade managers and compliance to run export and import operations successfully. We have seen so far the customs declaration of US. Now we see customs declaration formalities in European Union.


New Computerized Transit System (NCTS) is a European wide system for electronic declaration, it controls both community and common transit. It involves all European Union and EFTA. NCTS  connected with 3000 customs offices in European Union and its central domain exists in Brussels.

In the EU customs declarations are mostly submitted electronically. However, every member state has its own system. For the Netherlands this is SAGITTA, for Germany it is ATLAS (Automatisiertes Tarif- und Lokales Zoll-Abwicklungs-System ), United Kingdom has CHIEF
(Customs Handling of Import and Export Freight  )and for Belgium it is PLDA (Paper Less Douane en Accijnzen) Austria has e-ZOLL France has DELTA and EFTA country Switzerland has e-Dec

How Global Trade Management software’s available in market, supports declaration to customs authorities we see later in this article series..

We first analyse compliance issues  faced by exporters and importers in the form of screening requirements. Restricted Party List (RPL) screening is one of requirements of a company as part of  trade compliance when there is a inward or outward movement of goods,services or human across borders.

Why RPL Screening is required

Screening is required as part of Export Management program for a company involved in International Trade to meet full compliance of  foreign trade law of a country

When RPL screening is not done

If an exporter fails to do screening and done shipments to a party which is sanctioned by government it can results in Sanctions or fines, even loss of export privileges.

What do i need to understand about Sanctioned Party List  or Restricted  Party List Screening

-No product can be shipped to any party on a denial list

– End user / Install site information necessary to know for all restricted product orders. (What is restricted product orders we can see in license requirements).

– Distributors, Freight forwarders, and depots are not end users.

– Ultimate consignee is the final party  receives the product. Ultimate consignee is not end user in all instances.

-End user may be different from consignee, if products falls under restricted it is necessary to do screening. Where are they? who are they? what business they are in?

– Screening is not intended to check credit capability of buyer. It is intended to check whether the user is sanctioned by any government agencies

What information require to do RPL Screening ?

-List of denied parties : Master data with list of parties forbid by government to receive goods or not to  receive goods from them

–  Source : Government authorities interacting with various agencies publish information about restricted parties. Source is a important element in screening that is the base for denial of exports to particular buyer which has to be stored in database for audit purpose

– Starting period : From which date on wards particular party falling under the category of restricted. Starting period is nothing but validity start date of sanctioned party published by government agencies. When government agencies publish lists, they include validity period starting from and to. Status reviewed periodically and updated as  Restricted party again or exclude  from lists.

Who can provide information ?

– Government websites like, and individual countries government websites

– The companies supplying Global Trade Management software like Amber road, Choice point , Integration point also provides this information

– MK Denial is the service provider generally supports for SAP GTS.

How this information can be provided by service provider ?

– Service provider can send this classified information as XML format either through email or directly uploaded in your server with a middle ware support. Individual customers also verified and replied by service providers via email. Those communications require to store it for audit review

Alternatively this information can be downloaded directly from government websites as spreadsheets and verify it with your customer database.

How companies are managing this today?

Many companies are downloading this information from government websites and storing it as spreadsheets and comparing with prospective customer / existing customer master data in their system. The problem with this approach is, it  is very difficult to keep a track of source of information and when that  party declared as restricted.Also very difficult to maintain consolidated list of restricted parties with source information and validity period. Screening your customer base manually is not only inefficient but also impossible in many cases. So there is a need of defined criteria to find out optimal Restricted Party Screening Solution (RPS) software which helps compliance manager to perform screen/monitor/audit of customer and vendor details both in master data level and in order / PO creation level . Below criteria’s can be considered to identify suitable software for your   needs :-

– Screening scope with flexibility to expand

– Fully automated

– Integrate with Order management system

– On Demand Solution

-Matching accuracy with less false positives

-Well defined workflow and escalation support

Based on this criteria’s we will  construct a RPS Framework to develop compliance program suitable for company’s needs…

(To be continued)











Muziri, Amber Road,Silk,Spice, Incense route to Modern Global Trade – Series II

This is continuation of my previous blog about history of Global Trade business. In this article we see how institutional development brought many progress in International Trading worldwide. Customs formalities and government regulations changed over the years prompt companies to develop infrastructure to meet timely execution of their global supply chain. The history of modern global trade can be considered to start with Global Agreement of Tariff and Trade (GATT).

 After World War II, the United Kingdom and the United States submitted proposals to the Economic and Social Council (ECOSOC) of the United Nations regarding the establishment of an international trade body that was to be named the International Trade Organization (ITO).ECOSOC convened a conference, the United Nations Conference on Trade and Employment in 1946 to consider the UK and U.S. proposals. A Preparatory Committee drafted the ITO Charter and it was approved in 1948 at the conference in Havana, Cuba. The Charter is often referred to as the Havana Charter or the ITO Charter.The first round of trade negotiations took place while the Preparatory Committee was still working on drafting the Charter because the participants were anxious to begin the process of trade liberalization as soon as possible. Their results were incorporated into the General Agreement, which was signed in 1947.Since the original signatory nations expected the Agreement to become part of the more permanent ITO Charter, the text of the GATT contains very little “institutional” structure. This lack of detail within the agreement has created increasing difficulties as the GATT membership and roles governing trade between so many of the world’s nations have grown. The GATT has functioned as an international organization for many years even though it has never been formalized as such. 

ECOSOC established an Interim Commission for the ITO that is referred to as ICITO. Unfortunately, when it came time for the members to ratify the ITO Charter, the Congress of the United States refused and the ITO never became a reality. The GATT survived, but remained intact only due to the Protocol of Provisional Application of the General Agreement on Tariffs and Trade which was concluded in 1947 and which entered into force in 1948.The GATT completed 8 rounds of multilateral trade negotiations (MTNs). The Uruguay Round (the 8th round) concluded with the signing of the Final Act on April 15, 1994, in Marrakesh, and produced the World Trade Agreement (WTO) and its annexes. 

During the GATT period from 1947, there were lots of development happened in International Trade front. Bretton woods significant one in International trade, the agreements sowed the seeds of International Bank for Reconstruction and Development (IBRD, which is part of today’s World Bank Group) and the International Monetary Fund (IMF). These development started after end of Great Depression and world war II. The countries realised the fact there  is a need of change in economic climate which is able to achieve only by trade co-operation. This article intended to explain development of customs activities and in turn cause complications of business so i don’t want to digress from my core topic. But people who wants to know more in this area can search for Euro currency market and Oil shock . These two major developments happened between 60’s and 70’s.

Institutional infrastructure to support international trading are

  • Customs regulations of individual government- AES (US),ATLAS(Germany),CHIEF(UK), ATLAS / NCTS / CHIEF / SAGITTA
  • Hassle free formalities for Export and Import activity in a country
  • Information flow between individual company to customs of every country
  • Inter country communication flow between customs of various activities
  • Institutional support of ICC, WTO, WCO and UNCTAD
  • Regional Trade Agreement (RTA’s)

 AERP and AES in US Customs. 

The Bureau of the Census, responsible for collecting US export statistics, introduced the Automated Export Reporting Program (AERP) to the US in 1970. This program permitted exporters and forwarding agents to declare their export transactions each month directly to the Bureau of the Census by using electronic media. Consequently, creating a paper Shipper’s Export Declaration (SED) was no longer necessary. The Bureau of the Census combines data received electronically and on paper to produce official US foreign trade statistics.

The advantages of issuing the AERP declaration instead of the paper SED included reduced costs, reduced administration, and faster generation of trade statistics. Until December 31, 1999, you could transfer the AERP declaration to the Bureau of the Census in three ways:

  • Direct computer transmission
  • Magnetic tape
  • Diskette

The system selects data from the intermediate database VESED, creates the information relevant to the declaration, and writes the information in a special file. This file forms the basis for creating a magnetic tape or diskette for the AERP.

The Automated Export System (AES) is a joint venture between the U.S. Customs Service, the Foreign Trade Division of the Bureau of the Census (Commerce), the Bureau of Export Administration (Commerce), the Office of Defense Trade Controls (State), other Federal agencies, and the export trade community.It is the central point through which export shipment data required by multiple agencies is filed electronically to Customs, using the efficiency of Electronic Data Interchange (EDI).

From 2001 US customs has brought in Focus Based Risk Assessment in Customs audit. In March 2003, the U.S. Customs Service became part of the U.S. Customs and Border Protection. The auditing pattern changed from Transaction to process validation. It means earlier before 2001 it was Compliance Assessment and after 2001 it was Focused Assessment . Focused Assessment starts with Internal Control Review , Test only area at risk, Transparent – on the Web AND Includes Models for Compliance,Can Result in Enforcement Action and Uses a Team Approach. The Focused Assessment Program was developed to guide the audit team through the examination process.

Development of AES system in EU, Australia and in New zealand we see in the next article …. 2nd Week of Feb 


Muziri, Amber Road,Silk,Spice, Incense route to Modern Global Trade – Series I

International trade has got a long history there are evidences Romans trade with India in 1st century CE. Pattanam , a small village in Kerala once was a busy port town called Muziri visited by foreigners for trade.There are evidences of export and import happened in this place. (Source . Amber Road is the ancient trade route for transfer of amber from Baltic to Mediterranean sea. Silk route is a china silk traded between china and other Mediterranean regions. The incense route was a network of trade routes extending over Arabian peninsula and Mediterranean region. Traders created the demand for the commodity they brought along with them to another country where it is not available. Historically international trade has many challenges, traders moved to unknown countries where the acceptance of their commodity is a big challenge. Colonial trade of North Atlantic ocean and establishment of British colonies in different parts of Asia, given an impression trade is an entry to make the country slavery.

History of Foreign Trade Law

I have come across one web site which gives details list of export and imports of different parts of the world in ancient period

If we try to explain  international trade history we have to go way back Greek period. Classical Athens known for trading activities as early as fifth or fourth century BC. Athens was said to have imported grain from South Russia, Sicily and Egypt; Salt fish from Spain or the Black sea. From Mediterranean region they imported Spices , Textiles and luxurious goods . Basically, the Greeks import what is necessary for them can call it as “Corn and Grain Trade” There was no rules and regulation mostly people involved were foreigners who supplied what required for locals. But there was a primitive form of customs and commercial rules set mostly by foreigners. There was so called ‘Emporial Laws’ . These laws dealt with import and export supply of goods mainly corn and grain. Litigation under emporial law heard before a special court Nautodikai  and from middle of fourth century onwards before Thesmothetal. Commercial self interest driven those laws, in detail information not available. I want to highlight one more interesting point here ,Athens and other countries had commercial treaties for imports we have seen. For example the treaty between Athens and Leucon I of Bosporous merchants in 4th century. It exempted the import duty the ships of Bosporous merchants. There was some kind of Preferential agreement exists in those days itself

Reference :

Periplus of the Erythraean Sea – Wikipedia, the free encyclopedia

Romans also has done exports and imports. Unlike Greeks, Romans trade and commerce largely regulated by state legislation and the customs of the trade. Trade and commerce governed by ancient codes (Refer ) .What is interesting to note here Roman kings had commercial treaties with foreigners to safe guard interest of their own merchants. Since Rome then was strongest countries in the world treaties were favorable to their interest. But this was organised one and had treaties with many nations in the world.

Ancient India has good trade relations with Romans. You can refer to understand Indo Roman trade. There is a book available in Internet “Foreign Trade and Commerce in Ancient India” by Prakash Charan Prasad has more insights how trade and commerce exist in ancient India.

The value of Indian trade may be estimated from the well-known passage of Pliny, in which he recorded that India drained the Roman empire of fifty million sesterces every year. The wealth of early India is confirmed by the lament of Pliny the Elder in Historica Naturalis (Natural History), completed in 77 AD that all of Rome’s coffers were being emptied into India to satisfy Roman demand for transulent Indian muslins. Pliny’s statement is corroborated by the discovery, in India, of innumerable gold coins of the Roman emperors, which must have come here in course of trade. Most of the coins have been found. Most of these coins have been found in South India, and their evidence is corroborated by many passages in classic Tamil literature. We read of ‘Yavanas of harsh speech’ with many wares; of foreign merchants thronging sea-port towns like Mamallapuram, Puhar, and Korkai; or busy customs officials, and those engaged in loading and unloading vessels in the harbor. The wealth of the Roman Empire reached India through the ports of Kalyan, Chaul, Broach, and Cambay in Western India. Tamralipti was an important port in Bengal. It carried on trade with China, Lanka, Java and Sumatra. In the Andhra region, the ports were Kadura and Ghantasala, Kaveripattanam (Puhar) and Tondail were the ports of the Pandya region. The ports of Kottayam and Muziris were on the Malabar coast. There was a great maritime trade between India and Southeast Asia and China. The rulers of India facilitated trade by building and maintaining lighthouses at the necessary points and by keeping sea routes free and safe from pirates. (source: India: A Country Study 1985)

Refer to know about list of commodities export and import from India

The earliest form of body of rules and customs which we now call it as a International commercial law was found in rules and customs governing merchants and maritime matters which were then broadly called as maritime law. The Lex Rhodia de jactu was body of law developed in the island of Rhodes two or three centuries before Christ. The rules and customs laws varied in each European state based on local law and customs as a result maritime law also varied. After fifteenth and sixteenth century sea borne trade internationalized, moving from Mediterranean to Atlantic this create a demand for uniformity for international and customs law. It was interesting fact that English were late entrants in European Union .Lex Mercatoria one of the early forms of international commercial law or international trade law

Ancient china was one of the world’s oldest civilization. Silk road was the recognized trade which refers to route of trade in the north west of china linking china with central Asia, the middle east and Europe. For centuries, Japanese , Koreans, Iranians , Arabians and Vietnamese and merchants from south east asia arrived in china by sea. Chinese textiles, porcelain, and crafts exported out of china by sea. Gold, Indian and Iranian gems, Soybeans and grapevines Chinese generally imported. This was happened through silk road and ships too.There was license system exist in china,during han dynasty trading with foreigners without license was punishable by death penalty . There were references about Bills of exchange during Tang dynasty period, one of the flourishing period in Chinese history. They were named feiqian named flying money. Also there were references of Tang code which describe about Foreign Trade and customs law.

Japan was mainly traded with china and Korea. Japanese mainly purchase copper coins, porcelians, books, paintings perfumes and medicines. Inline with Tang code Japanese also had ritsuryo (legal code). Japanese also has Bills of Exchange called Kaisen,Saifu or Warifu to facilitate commercial transactions

The Incense trade route or the Incense Road of Antiquity (see also the spice trade) comprised a network of major ancient land and sea trading routes linking the Mediterranean world with Eastern and Southern sources of incense, spices and other luxury goods, stretching from Mediterranean ports across the Levant and Egypt through eastern Africa and Arabia to India and beyond. The incense land trade from South Arabia to the Mediterranean flourished between roughly the 7th century BCE to the 2nd century CE. The Incense Route served as a channel for trading of goods such as Arabian frankincense and myrrh Indian spices, precious stones, pearls, ebony, silk and fine textiles;and East African rare woods, feathers, animal skins and gold. (Reference : Wikipedia)

I am not going in detail about the development of Foreign Trade between Seventeenth, Eighteenth and Nineteenth century.It will be more academic research which is not the objective for me. Also, there are so many articles and detail available in Internet to know about it. When i do research about Foreign Trade in historic period i am surprised to find out what we call it as present day development exists more than thousand years back. We will see development in Foreign trade in terms of institutional and regulations in next article. ….

Sourcing challenges and benefits from Landed cost calculation software

Selling the quality products cheaper is the challenge of every entity throughout the world. In the coming years the requirement is going to augment when the demand and expectations of the customer manifold. How the companies are going to meet these challenges? Product should be manufactured cheaply, input cost should be economical. Purchasing worldwide helps the company to achieve economies of scale and give competitive advantage in terms of pricing and profit margins. The biggest challenge in product (or) raw material sourcing is identify potential manufacturers or distributors from around the world. We realize we gained or lost, when we compare the true or total landed cost calculated prior to making purchasing decisions. Without understanding of total landed cost it is impossible to make informed decisions on product sourcing and profitability. Many occasions we may end up in paying high than actually planned or cost calculated. Also the important point here is the inventory value needs to be arrived based on the total value incurred for purchase of that product.
Take the following example, a company in New york , US purchasing a widget from a supplier from Ahrnesburg , Germany :
purchase price – 100 widgets @ $ 20 each
shipment from Ahrnesburg to New york – $ 1500
Customs, Duties, and other Processing Fees are $500
Domestic transportation cost $ 400
If you value inventory your just vendor price $ 2000 then keep the margin and sell it you have lost additional values $2400 in your COGS. Based on the calculation above, the value of inventory will be $ 4400 for 100 widgets (or) $ 44 each . What it means … The increased cost will affect my Cost of Goods Sold in my sales side, impacting my margin accordingly
In a typical trading business, you are quoting the price to the customer based on price quoted by vendor. If the value is wrong then you incur loss. Now you can appreciate the significance of Estimated Landed Cost and Actual Landed Cost. Estimated landed cost decides from which vendor you are going to source the material and actual landed cost

Figure 1 : Total Landed Cost Calculation

Purchase price
This is the base price you are paying for the materials or goods you are sourcing. Keep in mind that not even the purchase price remains completely static – it may change due to exchange rates or under certain conditions outlined in the payment terms you agree to. Various banking fees also apply. Banking fees may vary based on payment terms.

Shipping & Transportation
Transportation costs include both foreign and domestic inland shipping fees, as well as the direct line haul cost. Exchange rate fluctuations need to be considered while calculating landed cost
When you receive a quote from prospective vendor you will come to know what type of contract, vendor proposed. Based on the contract you can do your planned Landed cost and decide on from which vendor to procure. Need to consider all the parameters before awarding contract to a seller.


Figure 2 – Incoterms 2010


Customs inspections, broker fees, tariff rates, harbor fees, and the merchandise processing fee (MPF). If your imported goods are going to be re-exported or used in the manufacture of exported goods, you may be able to save money through duty drawback.

Overhead and administration.

Overhead and administration costs are often overlooked or unaccounted for when calculating total landed cost. Overhead also includes things such as paying staff members to oversee transactions and research potential suppliers (due diligence cost)

Risk and compliance

Complying with various regulations and trade policies also costs your operation money. In addition to these compliance costs, it’s a good idea to account for the risk of supply chain disruption, especially when working with new offshore partners

SAP Global Trade Services

When you decide to go for procurement globally. You may be landed with two or three quotes to choose. At that point of time SAP GTS software helps you to take decision diligently and also helps you to make profits by making you to procure cheaply.

SAP GTS has a feature simulate calculation of customs duty . Simulation will not update the database. But you can save as report for future reference. Duty type conditions needs to be added in the feeder R/3 system , those condition types needs to be mapped in to GTS.

Estimated Landed Cost: Estimated Landed Cost is the item landed cost calculated based on the estimated amounts of the item price, the taxes, and the charge amounts.

Actual Landed Cost: Actual Landed Cost is the item landed cost calculated based on the actual amounts of the item price, the taxes, and the charge amounts. The actual amounts are provided by the related documents, as item invoices, freight invoices and charges.

What are the factors we need to take to evaluate estimated landed cost :-

1) Check inco terms quoted by supplier. Verify the cost includes shipment (or) not
2) Check vendor country for verifying preferential agreement
3) Product classification – HS & ECCN
4) If supplier bears shipment cost then you need to take only duties and inland transportation cost
5) No of cartons / CBM Calculation. The biggest challenge is calculating CBM without knowing this not able to get the rate from forwarder for sea (or) air shipment cost


Figure 3 : Estimated Landed Cost

Actual landed cost

Before we discuss about landed cost calculation after the goods received to your ware house we will understand about valuation of goods by customs
How customs dept apprise the value of customs, Article VII of GATT laid down the general principles for an international valuation system of valuation.

Method 1 — Transaction value
Method 2 — Transaction value of identical goods
Method 3 — Transaction value of similar goods
Method 4 — Deductive method
Method 5 — Computed method
Method 6 — Fall-back method

Actual landed cost needs to be calculated after goods received to ware house and you received all invoices from forwarder, you may have some demurrage cost

There are some calculation methods available for landed cost
1) Weight rate
For example, landed cost of a product is $ 100, the duty is 1% and the $ rate is defined as $ 3.00
Master carton weight is 9 lbs
weight * $ rate = Weight’s rate value
9 * 3 = 27 (in US $)
The Additional Cost to be added to the Landed Cost is calculated as:
Weight’s Rate Value * Exchange Rate = Domestic Weight’s Rate
27 * 0.75 ( 1USD = 0.75 EUR) = 20.25 US $
(you must convert to Domestic currency because Duty is calculated on Domestic value )
The Weight’s Rate is calculated as:
[(Domestic Weight’s Rate * Duty) + (Domestic Weight’s Rate)] / Quantity of the Master Carton (Actual)
[(20.25 * 0.01 ) +20.25]/1 = 20.4525

To determine the new Landed Cost:
Original Landed Cost + Weight’s Rate Calculation
100 $ + 20.4525 = 120.4525 $
The new landed cost is 120.46 $
2) Cube’s Rate
Here is an example, the landed cost of a product is 100 $ , the duty is 1% and the $ rate is defined as $ 2.50. Volume is 72.33 CuFt
Volume * $Rate = Cube’s Rate Value
100 * 2.50 = 250 $
The Additional Cost to be added to the Landed Cost is calculated as:
Cube’s Rate Value * Exchange Rate = Domestic Cube’s Rate
250 * 0.75 = 187.50 $

The Cube’s Rate is calculated as:
[(Domestic Cube’s Rate * Duty) + Domestic Cube’s Rate] / SKU Quantity (for the Master Carton (Actual)
[(187.50 * 0.01) + 187.50] /1 = 189.375

To determine the new Landed Cost:
Original Landed Cost + Cube’s Rate Calculation
100+ 189.375 = 289.375
The actual landed cost is 289.38 $

Unit amount

Unit’s Amount Calculation Method ,the Landed Cost based on the Quantities entered in the ‘From Purchasing Unit’ and ‘To Stock Keeping Unit’ in the Conversion Factor section on the Purchasing folder.

The landed cost of a product is 100 $ , the duty is 1% and the $ Rate defined as $ 3.00. The quantity entered in the purchase unit is 1 and the stock keeping unit are set to 12. If you select a Factor that has a calculation method of unit’s amount, the following calculation is used to determine the new Landed cost
Purchasing Unit * $Rate = Unit’s Amount Value
1 * 3 = 3

The Additional Cost to be added to the Landed Cost is calculated as:
Unit’s Amount Value * Exchange Rate = Domestic Unit Amount

3 * 0.75 = 2.25 $ (you must convert to Domestic currency because Duty is calculated on Domestic value)

The Unit’s Amount is calculated as:
[(Domestic Unit’s Amount * Duty) + Domestic Unit’s Amount] / To Stock Keeping Units
[(2.25*.01) +2.25 ]/12 = 0.1893

To determine the new Landed Cost:
Original Landed Cost + Unit’s Amount Calculation
100.00$ + 0.1893 $ = 100.0189 $

The new landed cost is 100.0189 $

Value %
Example 1: Cost Base selected is ‘Purchase Price’
The current Landed Cost is $ 100 and the Percentage Rate entered is 3%. If you select a Factor based on Value’s % and use the Purchase Price as the Cost Base, the following calculation is used to determine the new Landed Cost:
Current Landed Cost * Percentage Rate = Purchase Price Value
99 * 0.03 = 2.97
Purchase Price Value + Original Landed Cost = new Landed Cost
2.97 + 100 = $102.97
The new Landed Cost is $102.97
Example 2: Cost Base selected is ‘Value for Duty’
The Duty selected on the Pricing Info folder will increase by the percentage entered in the $Rate/Pct field. If you select a Factor based on Value’s % and use Value for Duty as the Cost Base, the following calculation is used to determine the new Landed Cost:
Current Duty + Percentage Rate = Value for Duty Factor
0.03 + 0.03 = 0.06 or 6%
To determine the new Landed Cost:
(Purchase Price – Discount) * Exchange Rate = Domestic Price
(100 – 0) * 0.75 = 75
[(Domestic Price * Value for Duty Factor) + Domestic Price] = New Landed Cost
[(100 * 0.06) + 100] = 106
Example 3: Cost Base selected is ‘Duty Paid Value’
The Landed Cost is increased by the percentage entered in the $Rate/Pct field. If the Landed Cost is $100 and a 3% is entered, the following calculation is used to determine the new Landed Cost:
Current Landed Cost * $Rate/Pct = Duty Paid Value Factor
99 * 0.03 = 2.97
To determine the new Landed Cost:
Current Landed Cost + Duty Paid Value Factor = new Landed Cost
99 + 2.97 = 101.97
The new Landed Cost is $ 101.97
Landed cost software available in Market
SAP R/3-SD-Foreign Trade Module,GTS and GTM
Oracle -Global Trade Management
Amber Road – Landed cost calculator
GT Nexus
Integration Point
I prepared one excel based landed cost calculator for my requirements, based on Indian customs perspective. You can find screen shot below


Figure 4 : Landed Cost Calculator

In the next article, I want to share the significance of software in running a Global Trade Business

License and Letter of credit management through SAP GTS

Company needs to get licenses for exports or imports. Many products require licenses. Licenses can be maintained in SAP GTS as a master and track its validity period and residual quantity and value. There is no single licenses available in all the countries. I discuss this topic keeping US requirement into consideration. SAP GTS allows you to determine the license and if at all missed in Sales order (or) delivery created in feeder system, block it for further processing.

Step 1 :-

Product you are planning to export needs to be classified for Export Control Classification Number (ECCN). If you need to import the product then you need to classify for Import Control Classification Number (ICCN). What is ECCN. This is just five character codes, what basis classification happening we saw it in previous articles.

Let me explain to you again by taking one ECCN as an example : 3A001

we divide these into three parts :-

Chapter 3 – Product Category   (Electronics)

Validity A – Product Group (System, Equipment and Component)

ECCN 001 – Reason for control


0 = Nuclear materials, facilities and equipment (and miscellaneous items)
1 = Materials, Chemicals, Microorganisms and Toxins
2 = Materials Processing
3 = Electronics
4 = Computers
5 = Telecommunications and Information Security
6 = Sensors and Lasers
7 = Navigation and Avionics
8 = Marine
9 = Propulsion Systems, Space Vehicles, and Related Equipment

Product Group

A. Systems, Equipment and Components
B. Test, Inspection and Production Equipment
C. Material
D. Software
E. Technology


  • Encryption
    • Symmetrical  Algorithms
    • Asymmetrical Algorithms
    • Hash Algorithm
  • EU or US

Hardware (Computer)

  • Performance (APP)
  • Encryption
  • EU or US

Reason for control

000 – 999

If Your Item is Not on the Commerce Control List – EAR99

If your item falls under the jurisdiction of the U.S. Department of Commerce and is not listed on the CCL, it is designated as EAR99. The majority of commercial products are designated EAR99 and generally will not require a license to be exported or reexported. However, if you plan to export an EAR99 item to an embargoed country like iran, to a party of concern like Denied person list , or in support of a  prohibited end use can be used as a nuclear product, you may be required to obtain a license.

Three factors important to determine whether license is required or not  :-

1) Destination country / Country groups

2) End user (or) Ultimate consignee


What is important to understand here is License determination is transaction specific not Product specific

Step 2 :-

You have to define number scheme in the export list. You can define it as US ECC

It comprises of :- Structure of Export list / Coding Schemes / External unit of measures

This configuration settings is the basis for building up ECCN master data in GTS side.

Step 3:-

Assigning the defined number scheme with a Legal Regulation. Legal Regulation is nothing but governing rule needs to be set either to meet requirement of particular country or country groups. In this case we take EAR Legal Regulation . Need to assign EAR with USECC.

Step 4 :-

Number scheme needs to maintain as master data in GTS. We will see how we can maintain in our example USECC

Dual use items which has ten categories as we have seen in Step 1 ;

For example , Category 5 related to Telecommunication

5A002.a.2 – equipment designed or modified to perform cryptanalytic functions.

5D002.c.1 – only “software” having the characteristics, or performing or simulating the functions, of equipment specified in 5A002.a.2

Control grouping

This function enables you to define, under specific legal regulations, different groupings of products with a description for each grouping. You can then assign individual products to the groupings. These groupings reduce the workload for import and export legal control and the license determination service. The system uses control groupings, for example, to determine which license types can be used for importing and exporting specific products that belong to a specific control grouping.

 In the Area menu, you need to create groupings as master data. The grouping controls the legal control process and the assignment of licenses to a product depending on the legal regulation. You can group products with different control classes into one group if they require the same export or import management process. As the export and import regulations for a product are not based directly on the product or the assigned control class, the grouping you assign to the product in the product master is used in legal control to determine the type of license.

 But this activity need to do carefully, but this exercise helps definitely for client in terms of workload.

Sometimes Products having same Export Control Classification number have different controls, in those cases we can take advantage of Peculiarity code and grouping in conjunction with license determination

Step 5:

Determination strategy decides how active legal regulation needs to be determined :-

-Country level

-Country / Country level

-Country/Country group level

-Country group level

-Country group / Country level

-Country group / Country group level

Step 6 :-

License type needs to be created for determination purpose. For example if you need to create Individual Validate license for EAR US LR. You can create EARUS+IVL

Foreign trade organization

Legal unit

Business partner

Partner function

Product number

Control class (export control classification number)

Document number from feeder system

Country of departure/destination

Peculiarity code

Import code number

Check first doc flow

Country of Dest / Dept

Business Transaction type

License can be decrement value and Quantity update. Again this feature depends on the requirement. You can have only Quantity update as well. 


Visio Flow – License determination flow

License can be maintained as created, applied, active and expiry. The license will get detected only when it is in the active state.

Licenses will get decrements quantity and value, when it is utilized against a transaction. Licenses acquired against volume of shipment

decrements only quality. Value based licenses deducts value against shipment. The user can see residual value against total value in the

license master

Letter of credit management

In SAP GTS system, License and letter of credit management shares same processes. The tables also shared between licenses and LoC


Letter of credit process

The above process flow is a simple Letter of credit transaction. We can see step by step business flow

- Received inquiry from the customer

- Submitted Quotation . Inform SWIFT details of your bank

- Agreed for Letter of credit

- Buyer (Importer) opens a letter of credit with his relationship bank. The relationship bank here is issuing bank.

- The advising bank of you receive L/C through SWIFT

- Now you have to create a master data for LoC in GTS side. Update values like Maximum value, Date of expiry, Presentation date,Last date of shipment and any other additional clauses you require to adhere while submitting the document for negotiation to bank. If the partial shipment is allowed you can see residual value if it is not allowed you have to complete by one shipment. This settings you can do it R/3 side itself to disallow partial shipment.

Letter of credit determination you can have following strategy

Country level / country group level / partner group level . you can develop combination of these three. Ideally keeping partner group level in search is better and will give flexibility for change .

Since license and letter of credit sharing the same table, there is a problem if any changes you are trying to do in the letter of credit that impacts license as well. I am not able to understand why SAP has developed logic sharing and licence and LoC though both are conceptually different

You can expect regular updates from me ….

Next topic …. Customs Duty Calculation …..

Sanctioned party list screening in SAP GTS

Governance, Risk and Compliance (GRC) automate controls to facilitate compliance with financial, environmental, health and safety and trade regulations, enforce internal controls, increase the efficiency of audits, identify risks and employ proper governance procedures to keep all these activities up to date and effective

A sanctioned party list contains a list of persons and companies with whom trade is prohibited by law. These boycott lists are issued by government agencies and can be obtained from data providers. All traders must comply with these lists.

The Sanctioned Party List (SPL) Screening service in SAP GRC Global Trade Services (SAP GRC GTS) lets you check business partners’addresses (such as the consignee) automatically against the sanctioned party lists before goods are exported. It is a system-independent solution that performs and logs the SPL check and is fully integrated into the complete business process.


Master Data

Master data including sanctioned party lists, business partners and comparison. You can also monitor lists that are due to expire soon and that can be archived


SPL Screening for Logistics


Sanctioned party list
A list of individuals and companies that have been formally denied export privileges or sanctioned by the US Government. It includes the US Commerce Department Denied Persons List, US Treasury Department Specially Designated Nationals List, US State Department Statutory Debarred Parties, and other parties subject to US Government trade sanctions.Under US ITAR regulations, person or firm ineligible to participate in transactions involving ITAR-controlled products and technology (military ruggedized products, TEMPEST, and wargaming software). Names of Debarred Parties are published by the US State Department and are included in the Company’s Denied Parties List (DPL). Debarred Parties may receive US Department of Commerce-controlled products and services.

With respect to US export regulations, a person or firm that has been formally denied export privileges by the US Commerce Department. The names and addresses of Denied Parties are published by the Commerce Department in the Denied Persons List and are listed in the Company’s Restricted Parties List (RPL).

Denied Persons List
A list, referenced in Supplement No. 2 to Part 764 of the US EAR, of specific persons that have been denied export privileges, in whole or in part. The full text of each order denying export privileges is published in the US Federal Register. Formerly known as the Table of Denial Orders (TDO).


SPL screening

–          SPL Screening while initiating the business with customer

–          SPL Screening when business partner change the address

–          SPL Screening when document partner change the address

–          Periodic check on business partners

–          Periodic check when document partner changes address

–          Simulated SPL screening of Business partners

–          Simulated SPL screening of document partners

–          Releasing blocked Business partners

–          Releasing blocked Documents

–          Monitoring Sanctioned party lists’

–          Monitoring positive / negative lists

–          Monitoring Blocked business partners

–          Monitoring Blocked documents

–          Audit trail


As defined by the United States, a country with which the US will not trade. It is US policy to deny license applications for exports and re-exports to these countries, with few exceptions. US License Exceptions cannot be used for deliveries to these countries, with few exceptions. The Embargoed Countries are:

Cuba Iran Myanmar Sudan


Antiboycott Laws/Regulations
The laws/regulations of the US and other countries which forbid compliance with unsanctioned economic boycotts, and which may require reporting to national governments requests for boycott-related certifications or statements.

What is Antiboycott Screening?

An “economic boycott” is a program under which a country (or group of countries) refuses to do business with another country, its companies, or citizens in an attempt to cause economic damage. Under U.S. law, an “unsanctioned economic boycott” is a boycott against a country friendly to the United States.

“Boycott-related requests” are requests to comply with a boycott, or to furnish information which will be used in support of a boycott. “Boycott-related requests” may be formal or informal, oral or written.

The US and other national governments prohibit direct or indirect participation in certain economic boycotts, for example, the League of Arab States Boycott of Israel. US law and regulations require that most requests received by US firms to enter into agreements, furnish information or take actions supportive of such boycotts be reported to the Government.

The primary boycott of Israel bars the importation of Israeli goods or services into the boycotting Arab State. There is also a secondary aspect of the Arab Boycott, which precludes dealings with firms or persons in third countries that have been blacklisted by the Central Boycott Office because of their relationship with Israel.

The countries which currently enforce the boycott of Israel and blacklisted parties are: Kuwait, Lebanon, Libya, Qatar, Saudi Arabia, Syria, the United Arab Emirates, and Yemen. Iraq is not included in this list, but its status with respect to future lists remains under review by the Department of Treasury.

The following boycott-related terms, phrases and conditions are illustrative only and not exhaustive.

A certificate of origin must be provided stating the products contain no {boycotted country} origin product.
A certificate must be provided stating that selling company does not have facilities in a {boycotted country}.
A certificate must be provided stating that company has no reason to be blacklisted by the Arab Boycott Office.
Negotiations by banks whose names are included in the Israeli Boycott blacklist are not acceptable.
A certificate must be provided that company has no facilities in a {boycotted country} nor does it employ persons of any particular origin or faith.
A certificate must be provided stating that company does not have any foreign partners or foreign ownership.
Instruction that no six-point star {or other religious or ethnic symbol} may be used on the goods, packing, or case.
Instruction that company agrees to abide by the laws of {boycotting country}, including the laws relating to the boycott of a {boycotted country}.
A certificate must be provided that the aircraft is otherwise eligible to enter the airports of {boycotted country}.

A bill of lading must be provided that states that the carrying vessel is allowed to enter {boycotting country}.
Contract clauses such as: “The Tenderer agrees to comply with all the laws of {boycotting country}” or “The Vendor shall abide by and comply in all respect with the rules of {boycotting country}”.

End user screening

Mandatory Trade due Diligence Screening of End-Users

Note: An End-User is defined as the company or person that ultimately receives and uses the products and/or services. An End-User cannot be a broker, freight forwarding agent, intermediary or a warehouse location.

US and other national government laws/regulations and Global Trade policies require end-user and ultimate consignee information made known to exporting company  to be screened in accordance with exporting company’s Restricted Parties List (RPL), Non-Proliferation (NPS), Trade Sanctions & Embargoes, and Diversion Risk screening policies.

The purpose of mandatory screening is to ensure that exporting company complies with US and other national government export regulations to neither directly nor indirectly conduct business with sanctioned/ embargoed parties, countries, or end-users engaged in prohibited activities without having obtained prior government authorization.

BOYCOTT OF ISRAEL The United States and other national governments consider the boycott of Israel to be an “unsanctioned economic boycott”. The following countries are known to or may participate in the boycott of Israel. Special care must be taken when processing transactions for these countries to ensure company does not comply with “boycott related requests”.

Kuwait, Lebanon, Libya, Qatar, Saudi Arabia, Syria, United Arab Emirates, Yemen.

Note: This list is for information purposes only. “Boycott-related requests” may originate from countries other than those listed above. Absence from this list does NOT mean company is relieved from responsibility for screening for “boycott related requests”.


“Diversion” is the transfer of products or services to individuals, companies, countries, or uses without appropriate government export authorization.

The exporting company must exercise due diligence in dealing with customers to ensure that exports and reexports of commodities and technologies are not used for or “diverted” to end-uses prohibited by applicable export regulations. “Diversion Risk Screening” helps ensure products and services will not be diverted to unauthorized parties or uses.

Examples of “diversions” include the delivery of products or services to a Restricted Party or sanctioned or embargoed country, or for proscribed uses such as the development of weapons of mass destruction. A “diversion” can take place without physical movement of a product if persons use the product for unauthorized activities. “Diverters” try to act as normal customers but often give themselves away by leaving signs or indications to their illegal intentions. These signs or indications are called “diversion risk indicators” or “red flag indicators”.

Diversion Risk Screening should be used at all phases of the order processing system.


Compliance manager must be alert for any unusual transactions, delivery instructions, or requests that are “out of the ordinary” and may signal a potential diversion. The Diversion Risk Indicators Checklist contains examples of “out of the ordinary” requests that may signal a potential diversion. This Checklist may be used for diversion risk awareness purposes, or to document Diversion Risk Screening for specific transactions where evidence of screening is required under national record retention requirements.

Diversion Risk Screening must occur at all phases of order processing and anytime the customer requests changes to the existing order. For non-revenue shipments, screening must be performedby the requestor of the shipment.

Any transaction indicating a potential diversion risk must be placed on export hold and escalated to Compliance Manager for advice and resolution in accordance with the Diversion Risk Escalation Procedure of the individual company. All records must be retained for audit purposes.

Check list for Diversion Risk
– Whether the customer is using Intermediate consignee, whether its location is incompatible with ultimate end user
– Whether the customer wants only Ex works , delivery terms
– Check whether the customer is suspected to have dealings with embargoed countries
– Whether the customer ask for only cash payment not interested in LoC payment
– want the document through non- banking channel only
– whether the products received by the imported can be diverted to embargoed country. Say for example the product export to Afghanistan can be easilTy reexported to Iran

SPL screening for Human Resources

SPL screening is also possible for your own employees due to integration of SAP HCM with SAP GTS. In fact, SPL screening is possible for the complete movement of humans within organization; this includes foreign travel by the employee for the business purpose, vendor visit  to  the organization for the purpose of business, and new employee recruit. This requires Governance, Risk and Compliance (GRC) policy framework for an organization to conduct check and monitor the human capital movement within or outside organization.

Embargoed National

A person who holds citizenship of an embargoed , has NO other citizenship, NO green card, NO permanent residency in another country, NO refugee or asylum seeker status in another country.

Embargoed Party As defined by the US, a person or firm acting on behalf of or as an agent of a country subject to US embargo. The US Department of Treasury Office of Foreign Assets Control (OFAC) publishes lists of these parties (the list of “Specially Designated Nationals & Blocked persons”). US firms are prohibited from doing business with any party on the list or with any other party owned by or acting on behalf of an embargoed country, with few exceptions. The names of Embargoed Parties published by OFAC  should be included on the SAP GTS Restricted Parties List (RPL)

SPL Screening for Financial Accounting

The incoming and outgoing payments are required to monitor for the companies doing transactions globally. These includes bank and insurance companies also need to be screened along with payer and consignee’s address. Financial institutions can insure that sanctioned persons, groups and organizations are recognized in advance of payment transactions taking place, and, as a result, freeze funds or financial resources to prevent transactions being performed. These sanctioned parties are published and updated on a regular basis in different countries and by different organizations, and may contain, in some cases, the same sanctioned parties.

The compliance policy needs to screen the bank from which company receives L/C if the organization involves in letter of credit payment transaction with customer.  For example, a U.S. bank would have to reject a wire transfer between two third-country companies (non-SDNs) involving an export to a non-SDN company in Sudan. Since there is no interest of the Government of Sudan or an SDN, there is no blockable interest in the funds. The U.S. bank cannot process the transaction because that would constitute a transaction in support of a commercial activity in Sudan, which is prohibited by the Sudanese Sanctions Regulations. Similarly, a U.S. bank could not be involved in the financing of a prohibited transaction. A U.S. bank cannot so much as advise a letter of credit if the underlying transaction is in violation of OFAC regulations. Please note that the Iranian Transactions Regulations contain no blocking provisions (refer: Insurance companies and banks are required by laws such as the Patriot Act (Providing Appropriate Tools Required to Intercept and Obstruct Terrorism) in the U.S. to prevent payment transactions taking place with people who appear on the sanctioned party lists

The “Sanctioned Party List Screening” service in SAP Compliance Management enables you to screen your business partners, thereby ensuring that you comply with national and international embargoes against countries and sanctioning of individuals and companies. To do so, you can perform compliance checks and legal controls at every stage in your logistics process, from quotation creation right through to billing document creation.

The integration of SAP GTS and Financial Accounting covers the following functions:

●      Creation of sanctioned party lists

●      Transfer and replication of the relevant FI business partners to SAP GTS

●      SPL screening of the relevant business partners

○       SPL checks against account holders

○       SPL checks against notes to payee

○       Synchronous checks of the business partners against SPL data during the payment transactions

●      Manual post processing of the checked business partners

The Sanctioned Party List Screening service can also be integrated with SAP for Insurance and SAP for Banking, among others.

To use SPL Screening for Financial Accounting, SAP Global Trade Services (SAP GTS) and Financial Accounting – Current Accounts (FI-CA), can either run on the same system or on different systems using Remote Function Calls (RFCs).

Cross Area Monitoring

The tab pages for the business areas Logistics, Human Resources, and Financials contain the following:

Asynchronous screening

Periodic Screening of business partners and document partners (in dialog and in the background)

Sanctioned party list screening of business partners with updated sanctioned party lists (in dialog and in the background)

Simulated sanctioned party list screening

With this function you can simulate the SPL screening for a business partner. This is very useful as a test SPL check to see whether a new partner address would be blocked by the system for business transactions in a live SPL check.

Analysis of audit trail data (SPL screening logs)

You have to log and save all sanctioned party list (SPL) screening activities to keep them accessible for official audits within the statutory retention period. SAP GRC Global Trade Services (SAP GRC GTS) logs the results at the legal regulation level. The logs enable you to keep a record of all the SPL screening your company has carried out, giving you an important source of documentation for legal purposes. You can archive these logs to reduce the load on your system and delete them from the tables once you have done this. The audit trail provides you with proof you need to present periodically to customs authorities, to demonstrate exactly which checks were performed, on which parties and when, and to show the results of these checks.

Monitoring of blocked business partners and documents