{"id":30110,"date":"2024-10-14T07:05:51","date_gmt":"2024-10-14T07:05:51","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=30110"},"modified":"2024-10-14T07:06:33","modified_gmt":"2024-10-14T07:06:33","slug":"simple-way-to-implement-container-tracking-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/10\/14\/simple-way-to-implement-container-tracking-in-sage-x3\/","title":{"rendered":"Simple way to Implement Container tracking in Sage X3"},"content":{"rendered":"\n<p>There is an existing module in Sage X3 as Container Management. This module contains multiple setup and accounting impacts in Sage X3.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<p>The container management module in Sage X3, will help us to track the containers and vessel. This tracking will provide the details costing involved in the shipping of the product.<\/p>\n\n\n\n<p>Below are the key feature of Container tracking in Sage X3:<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Key Features and Benefits:<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Tracking<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>The module will grant users to functionality to track containers and vessels, statuses, locations. This will help for better shipment management and reduces delays.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Cost Management:<\/strong><\/h2>\n\n\n\n<p>For the cost incurred on containers being transported, businesses will be able to see all costs involved with the cost related to the shipment of container and other costs associated with it.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Setup and Configuration:<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Container Management module includes contains setup options, like Port, Duty Rate master, Automatic Journal Posting setup, this will help users to setup there required business process as per the requirements.<\/li>\n\n\n\n<li>This setup will holds the rate from the Source Port to Destination Port.<gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. Accounting Integration:<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>The module integrates with the accounting functions within Sage X3, ensuring that all costs related to container management are managed and reported in accounting books.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. Enhanced Efficiency:<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>This automated tracking and management of containers, businesses can reduce manual errors and save time, resulting to error free data entry by user.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>6. Reporting and Analytics:<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>The process will provide reporting capabilities, allowing users to analyze shipping data. This information will help to make the decision for future growth<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Components Involved:<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h1>\n\n\n\n<p><em><strong>Setup:<\/strong><\/em><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Port Setup<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>We need to setup the ports which we are planning to use. Only this port will be available for drop down when we are making the vessel. Then we can use this port for further setup, This port setup contains the data such as name of Port, Country, Location.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Time Setup<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>After the ports are defined, we need to define the time to reach the ports.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Travel Time Definition:<\/strong> This involves calculation the average travel time based on various factors, such as distance, weather conditions.<\/li>\n\n\n\n<li><strong>Port to Shipping location<\/strong>: We are allowed to setup the data, for travel time needed from Port to destination warehouse.<gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Duty Rate Setup<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>MPF Fee Percentage:<\/strong> Merchandise Processing Fee is charged by the U.S. Customs Department to do clearance for imported goods. The percentage here should be set according to the protocol, but it should be customizable for future concerns. Hence there is the existing setup.<\/li>\n\n\n\n<li><strong>Harbor Maintenance Fee Percentage:<\/strong> We need to set Harbor Maintenance Fee Percentage, which is a charge for maintaining U.S. ports assessed on imported goods. This percentage will need to conform to the newest rules released by the government and cane be setup in Sage X3.<\/li>\n\n\n\n<li><strong>Excessive Rate:<\/strong> Come up with any excessive rates that might apply in a specific case. For instance, additional charges applied for expedited shipping or unusual types of cargo.<\/li>\n\n\n\n<li><strong>Additional Setup Needed:<\/strong> Determine any additional fees or charges specific to its shipping operations, such as charges for special handling, warehousing charges, or surcharges for the type of cargo.<gwmw style=\"display:none;\"><\/gwmw><\/li>\n\n\n\n<li><strong>Accounting setup:<\/strong> We will setup the automatic journal.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Transaction Overview for Container Management Module<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. Vessel Creation<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>The first step in the transaction process is to create a vessel in Sage X3.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Defining Ports:<\/strong> At the time of vessel Creation, users should define the <strong>Port of Discharge<\/strong> and the <strong>Port of Arrival<\/strong>. This information will help in planning and setting up the expectation.<\/li>\n\n\n\n<li><strong>Automated Calculations:<\/strong> According to the setup parameters, the system will calculate the estimated <strong>Arrival Dates<\/strong> as per <strong>Discharge Date <\/strong>entered.<gwmw style=\"display:none;\"><\/gwmw><\/li>\n\n\n\n<li><strong>Modifying Arrival Dates:<\/strong><gwmw style=\"display:none;\"><\/gwmw>In case of delays due to any reasons, users have the modify the Arrival Dates manually. This feature ensures that the system remains useful to real-world challenges.<gwmw style=\"display:none;\"><\/gwmw><\/li>\n\n\n\n<li><strong>Actual Arrival:<\/strong> The actual Arrival values are filled at the time of Vessel creation, but where as actual arrival dates are manually entered by user when the Vessel is actually arrived at Port.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Container Creation<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>After the vessel is created, we need to create the containers attached with that vessel.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Mandatory Vessel Selection:<\/strong> When we create the Container, we will be having the Vessel Number for selection, hence we need to Link the container to Vessel. The Vessel selection is mandatory to create the linking.<\/li>\n\n\n\n<li><strong>Multiple Purchase Orders:<\/strong> Users can select multiple <strong>Purchase Orders<\/strong> when creating a container. This feature will be consolidating shipments for calculation of shipping charges. The Purchase order line level selection is available to enable the costing according to line level in Sage X3.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Costs Involved in Container Management<\/strong><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Landed Cost at Header Level:<\/strong> The system will allow the user for the attachment of up to two different <strong>Landed Costs<\/strong> at the header level for the entire container. This could include any shipping cost as per the business requirement.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n\n\n\n<li><strong>Landed Cost at Line Level:<\/strong>The Container tracking helps users to track up to five different <strong>Landed Costs<\/strong> at the line level for specific items within the container. This approach helps businesses to track costs effectively.<\/li>\n\n\n\n<li><strong>HMF and MPF Costs:<\/strong> Both the <strong>Harbor Maintenance Fee (HMF)<\/strong> and the <strong>Merchandise Processing Fee (MPF)<\/strong> are calculated at the line level, ensuring that these regulatory costs are factored into the pricing of individual items. This helps for details line level calculation according to custom and Porter authority.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. Multiple Containers per Vessel<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Scalability and Efficiency:<\/strong> This functionality helps businesses to maximize their shipping capabilities by merging shipments on one vessel, thereby optimizing logistics and reducing costs. This facilities helps process to consolidate the Container in a Vessel.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>In-Transit Ownership Transfer and Purchase Transactions Overview<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>&nbsp;1. In-Transit Ownership Transfer<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>Once a container is received the financial implications of the associated shipping costs is also mandatory to impact the costing.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Journal Creation:<\/strong> To account for the additional shipping costs incurred during transit, a journal entry must be created. This entry reflects the financial impact.<\/li>\n\n\n\n<li><strong>Executing In-Transit Ownership Transfer: <\/strong><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw>The process will be executed by <strong>In-Transit Ownership Transfer<\/strong> for the specific container. This process will create the accounting impact of all the cost involved for that particular Container<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. Purchase Receipt<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Container Tracking:<\/strong> Instead of linking to purchase orders, the system will allow users to track the container using the left list in Sage X3. This approach will skip the purchase Order tracking as the purchase order is tracked in the Container.<\/li>\n\n\n\n<li><strong>Dropdown of Line Level Purchase Orders:<\/strong> Since purchase orders are linked to the container, the left list will allow a dropdown that displays line-level details of the linked container and Purchase Order. This functionality helps users quickly access information about the goods being received from the container against the Purchase Order.<gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Purchase Invoice<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/h2>\n\n\n\n<p>Two distinct transactions are involved in managing purchase invoices:<gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display: none; background-color: transparent;\"><\/gwmw><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Purchase Invoice (Stock):<\/strong> This transaction is specific on tracking the purchase receipt for goods that have been received. It ensures that the items are accurately reflected in the inventory providing a clear accounting of stock levels and costs of goods.<\/li>\n\n\n\n<li><strong>Purchase Invoice (Complimentary Invoice):<\/strong><\/li>\n\n\n\n<li>The second transaction involves creating invoices for different service providers related to the shipping process that are attached on container landed cost and other charges. This includes suppliers such as U.S. Customs Ports, freight forwarders, and shippers. The system calculates the necessary costs associated with these services based on the additional expenses incurred during shipping.                                                                                        <gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/li>\n\n\n\n<li>By generating these complimentary invoices, businesses can get that all costs are accounted for, allowing for cash flow management and financial reporting.<gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>There is an existing module in Sage X3 as Container Management. This module contains multiple setup and accounting impacts in Sage X3. The container management module in Sage X3, will help us to track the containers and vessel. This tracking will provide the details costing involved in the shipping of the product. Below are the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/10\/14\/simple-way-to-implement-container-tracking-in-sage-x3\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4,5,3162,6,13,7,8,3642,9,10,2796,11,12],"tags":[2805,4306,1240,1822,3211,1945,4090,4307,3735],"class_list":["post-30110","post","type-post","status-publish","format-standard","hentry","category-configuration","category-debug","category-faq","category-features","category-greytrix","category-installation","category-integration","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","category-sage-x3-upgrade","tag-container","tag-implement-container-tracking-in-sage-x3","tag-management","tag-sage-x3","tag-sage-x3-functional-blog","tag-sage-x3-technical-blogs","tag-tracking","tag-vessel","tag-x3-blogs"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=30110"}],"version-history":[{"count":9,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30110\/revisions"}],"predecessor-version":[{"id":30119,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30110\/revisions\/30119"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=30110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=30110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=30110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}