and how we can simplify that aspect of your business for you. I'm Regina Meyer, Product Solutions Engineer here at SYSPRO. Through my 19 plus years of SYSPRO, I've had the pleasure of meeting a lot of you and very happy to see you here today. So thank you for joining us. For those that I haven't met, allow me to welcome you to our webinar and it's a pleasure meeting you today. All right. We have some alerts popping up on my screen. Forgive me for that. We're going to go ahead and start since we only have 30 minutes to begin and we'll take you through this. I think I just need to move this over here and forgive all the alerts that pop up. I'll figure out a way to remove them from my screen eventually. Okay. So what we've seen through the past is let me move this as well. You know, customers begin that process of purchasing goods outside of their country, right? And start to manage that through spreadsheets. And it's simple. But as they start to increase their purchases of imports and want to track additional cost elements, it starts to become more of a burden, right? Or actually just not efficient as it could be. So we'd like to introduce you to the tools that SYSPRO has to increase that efficiency and make visibility to all that a lot easier for you. So hopefully you are able to see my screen. Confirmation that you can would be great, please. All right. And let's just begin. All right. Again, welcome to all of you. Today's goals that we hope to accomplish. So we want to introduce you to those tools that are available to assist with managing the various costs. All right. So we'll be right back to the cost elements that you do incur when you are importing goods into your warehouse, right? This could also be used for receiving goods across country. So, excuse me, interest aid as well, right? If you have additional cost elements that you may incur above and beyond freight, you can also utilize this tool for that purpose as well. All right. The goal is to increase visibility to cost and the estimated times of arrival on all imports. So we know that shipments coming in from foreign countries may vary on their estimated time of arrival. And then the ability to easily update all those purchase orders that are attached to that shipment is available within our line of cost tracking. We want to recognize the true cost of purchasing goods. So not only the merchandise costs, but all those cost elements that you're incurring. Okay. So the agenda for today, we'll just kind of overview what land and cost tracking is. We'll take a look at the setup options required to enable that process for you. We'll process some shipments, take a look at what that looks like, look at the reporting tools and the tools for managing export costs. We'll take a little glimpse into that, what that looks like. So on the sales side, shipping goods out as well. And then throughout the session, there's going to be a Q and A option. You'll see it in your meeting window there available for you. Please feel free to enter questions as they come up and then we'll reply to those following the webinar. All right. All right. First off, what is landed costs, right? So the landed costs basically, essentially as it represents the true cost of requiring inventory from a supplier to a requested warehouse, right? So these costs can include, you have your merchandise price, your shipping costs. You can have insurance costs as well as your duties, of course, through customs, maybe storage, intermittent storage in between the transit period and any additional that you could think of, right? These are user defined cost elements that you want to incorporate and recognize as a part of purchasing those goods, right? First, we'll take a look at some setup options, very simple setup options that would be enabled when you proceed with using landed cost tracking. The first will reside against the stock code. So against the item itself, you'll be selecting the option to manage the landed cost tracking facility. And you'll also capture tariff code information. Related to the type of item related to the type of item that's being imported. Within the tariff code, you have the ability to track three duty rates, right? So tariff rates incorporated there. We'll use those as part of the calculation of the cost of those tariffs. Okay. Next, we'll take a look at the supplier master, right? So in the supplier master, I'm basically just enabling that supplier as a landed cost tracking required supplier. And what this does, it opens up the facility to register invoices against shipments for the supplier, right? So it gives you the ability to record actual cost against that particular shipment for a certain cost element that the supplier provides to you. Okay. Then thirdly, there's a supplier stock reference table that we would maintain your LCD merchandise price to be used as part of that landed cost calculation as well. All right. So now I'm going to go into the system quickly here. All right. We talked about the supplier setup, stock code setup, as well as that cross reference. So now we're going to go into the system. So we're going to go into the system here. And we're going to show you how that all comes together in a bill of landed cost. All right. So bring that item forward. Let's turn on my caps here. And let's expand this. All right. So I may purchase the same item from different suppliers around the world, right? So I design a specific route. So I design a specific route for that. That duty rate, insurance, shipping, and additional storage prior to receipt, right? So each item may have several routes associated with it. And each route may have unique cost elements associated with it as well. All right. To the right over here, you're going to see the merchandise costs represented here. And then what that calculated landed costs is going to reflect, which includes all the cost elements that you've included for the item, for that route, and all the cost elements. Right? So that being said, in defining these here, we took a look at the tariff side, we took a look at the tariff side already. But bringing those details up again, just going to show you where they are. So we have our tariff and we'll maintain those duties within that tariff right here. All right. So once I've defined basically what my bill of landed cost is, I'm going to take you into the elements themselves. And we'll just, and we will look at that duty element. Let me browse out here. I'm going to go ahead and select that. So then here, we're looking at the element type. It's a tariff type and the duty rate. So the duty rate that's being used as part of that calculation is duty rate one. Remember, there are three duty rates against a tariff code itself. Okay? Then we have the calculation. So basically, we give you the tools to calculate how you want to apportion the cost across the receipt of those goods. So if I bring in the duty, I will take a look at what that looks like. You see here, it's basically looking at that landed cost, foreign price. I'm multiplying it by that duty one filled, a rate that sits against the tariff, which is within the item master. And we're dividing it by 100 there. Okay? So it's basically calculating that out for you. The same will apply with, let's say freight. Maybe I want to use mass as the method of calculation. So it'll portion it against the mass of the item. Et cetera. So you'll set up the cost elements. And then how you'd like those elements values apportioned across the receipt of the goods that are being received in. All right? Now, that basically covers the setup portion of it all. We're going to go in to look at what it looks like to enter a shipment. Right? And the benefit, again, of this is we're basically creating a shipment. We're going to be associating all the purchase orders that are going to be shipped as part of that shipment. And then we will manage that as it's in route. Okay? So here, I have different vessels identified. Okay? So different vessels that I would use to add a vessel. All right? I just would key in different vessel criteria here. So here, let's do two, three. For example, what's my expected date of departure? What's the vessel name? So if you have common carriers that you use, we'll just give it a term here. And then now we're associating the routes that are defined. Okay? So we'll bring this over the Eastern Sea Route, for example. All right? The actual date of arrival is going to be populated when the goods are received in. And we're saying, where is the place of shipment? And where is the place of destination? So here, we're going to say, Port of Hong Kong here. And we're going to receive it into the Port of Long Beach. Okay? You can attach additional notes as well, if needed. And then we would just save that. All right? So now I've identified a vessel. Okay? From within here, now I can come. And basically, I'm creating the advice. So once the supplier notifies you of all the goods that are ready to ship, you're going to create that shipment. Okay? And you give it a shipment number. And you give it a shipment number, whatever that may be. Okay? And now we're going to begin attaching the purchase orders to this shipment. All right? So I can key in purchase order here. I could pick and choose which purchase order lines need to be attached. Right? And I could mix and match purchase orders and purchase order lines within a shipment, of course. I'll just add all outstanding lines. Just confirming that. Right? And now it's added all the line items on that existing PO. And you go add another PO and do the same. Right? And handpick lines as needed. Okay? I can also come in and update the quantities that the suppliers confirmed they are going to ship. If it's different than what the purchase order line was set to. Right? And let me just introduce you to the screen a little bit. So I'm going to expand it so you can actually see. So we've got the shipment details here, the actual vessel that the goods are going to be shipped on, the purchase order lines that will be shipped as well. And the first line is highlighted. As I look over to the right here, I see all the expected costs that I should be willing to recognize when these goods are received in. Okay? You also see an actual cost field here. Right? What this says is it allows us throughout, well, this vessel has, when this vessel has departed. Right? Now I have the ability while it's in route to actually register these additional cost elements to this shipment. Okay? Meaning that if I get any invoices in for any of these cost elements, whether it be the duty, a brokerage fee, a brokerage fee, a brokerage fee, a brokerage fee, etc., whatever the case may be, freight, right? Of course. I can, through AP, a registered invoice posting, register that value against the shipment. And I'll show you that. Just to point out here, if I don't have the capability of registering any of these costs via the actual invoice from the supplier of these costs, elements, I will assume that expected costs upon receipt. Okay? When I actually do register those values, the actual cost will replace the expected cost. Okay? So I'm going to close out of here and we'll go into one that... We'll bring one up here. I'm just selecting a vessel that already exists. I'm going to bring in that shipment 2025-06. All right? And you'll see over to the right that some of those cost elements have been registered. And we'll go in and we'll show you how that's done next. All right? So it's basically going to... For insurance, instead of the expected 1174 that I had calculated based on my bill of landed cost, the actual invoice came in at $606. So this is the cost that will replace that expected cost upon receipt. All right? So let's take a look at how registering those invoices takes place. So let's take a look at how registering those invoices takes place. Let's put them over here. AP invoice registration. And then... I'm going to register... Let's see my containers. We'll take those in. Enter in my invoice number. And the value of that invoice. $150 here. And then this is where I would come in and actually start associating with my... Shipment. Okay? So I enter my shipment reference, which is that shipment number. Okay? What cost element does this invoice apply to? And I'm going to say it's the containers. Okay? And that's the value. And I'll go ahead and save that. So now it's gone ahead and registered that value against the AP invoice. And I can post that invoice. Again, this is just the registration process of the invoice. Eventually, I will have to go in and approve this AP invoice in AP invoice posting in order for it to actually be processed and paid. All right? It's just giving me that ability now to take that value of that cost element and associate it with the shipment itself. Okay? All right. Now, to visualize this, we have a land of cost shipment tracking report that is there for you. It actually gives you a recap of all the shipments in process. So you'll always know values that are due to come in. Right? Items and values. You'll see I have the expected cost identified, which was represented by that bill of lended cost. And then we have the actual cost. So any registered invoices that have been processed through are now associated. Again, replacing that expected cost at the time of receipt. All right? So in this case, I didn't receive, let's say, a freight invoice for shipping. So the system is going to assume that $65.62, $6,562.50 as the cost of freight. If I was able to register it, of course, I would take that actual cost into play there. All right? So now, if I come in and do the shipment receipt. Instead of having to come in and do each individual line as you would on the purchase order and receive it in, we're basically receiving the entire shipment in one swoop here. Okay? So any changes to quantities that need to be received in need to be maintained back in the actual shipment tracking itself. And then you come into the receipt process and receive that in. Right? So just by posting this here, we'll get that. We'll process the receipt. All right? Do we use the expected cost on those items that didn't have any invoices posted to them? Or do we leave the cost as zero? So it gives you that option. I'm going to use the expected cost. I'll go ahead and receive those in. All right? So you see it's PO 40714. Adding those details in. And the reason is, it's basically asking for additional information because I have been information that I need to track. All right? If it was a lot controlled item or serialized item, I'd be capturing those details as well. My lot number and my serial number. And then I just save. Okay? And these are just printing those in those online documents if needed here. Bin location. Enter that bin location. Save it. We could set default bins against items, too. That makes that easier. If we receipt everything to a doc first, that makes this process go quicker as well. All right? There we go. Just printing those online documents if we need it. Receive a GRN. Right? And we go ahead and close that. Okay? So now that shipment has been received. And inventory. Right? So that being said, we've gone through the process of, first of all, understanding what set of options need to be enabled in order to utilize land and cost tracking, as well as building that bill of land and cost, understanding your cost elements, taking that history of what they are, using those as your expected costs, and then offering you that ability to actually post real cost when those invoices are received and the goods are in transit. Right? So I'm going to jump back into my view here. Just kind of take a look at what we went through. So we understand the key benefits of the CISPRO's landed cost tracking system. They'll calculate a landed cost estimate for you based on those cost elements. It provides a facility to capture actual costs for each cost elements. It provides visibility to the ETA of purchase orders. And it's easily updated. So if I would have gone into, got notification that the vessel was delayed, I could have went into that vessel estimated due date, change that date, and it would update all the purchase order due dates, all the purchase order line due dates, I should say. I'm enabling visibility to MRP and purchasers or buyers across the company as well. So it keeps that consistent. So you know when goods are truly expected to arrive. We want to maintain visibility to the non-merchandise costs. So it can keep those separated in inventory queries to have visibility to what the cost of the receipt is. But then the non-merchandise costs can be separated out for visibility. So that allows you to have visibility as well. That allows you to refine your bill of landed costs and bring that closer to what the true cost would be. Okay? And then we receive an items at their estimated or actual landed cost. So you have that flexibility to make that decision as well. All right? Now, that is purchasing imported goods, right? So of course, there's the other side of the business that is the sale of goods to the sale of goods. So the foreign countries, right? So the export of goods. And we just want to introduce you to some tools that are available to assist you with that. Right? So our partner, Avalara, actually does manage or assist you in managing those duty rates, right? So they simplify the compliance process with flexible, unified platform that helps calculate or estimate customs duties up front with great accuracy. So your customers now can be aware, you can help them be aware of what the true cost would be, on their side of receiving those goods. It helps with the tariff classifications, excuse me. So it's harmonized system codes that are established. So it provides the tools to ensure that you're always utilizing the correct code classification, as well as those values associated with them. And then there are trade restriction management. So you learn about applicable government restrictions on selling goods across borders, prior to shipment, to alleviate products being denied at the border, to alleviate products being denied at the border, as well. All right? So something to consider. I just wanted to let you know that that facility was available to you. And if you're interested in that side of the business, you want to contact your CISPRO account manager for more information. Okay? So if we have any questions, please feel free to contact your account manager, as usual, your CISPRO partner, as well, or visit us at our website located here. All right? That being said, I just want to thank you all for joining us today to review landing cost tracking. I hope we found it beneficial. And if there's anything that we can do to assist you in managing this part of your business, please don't hesitate to ask. All right? You have a wonderful day. Again, thank you for your attendance today.