Is anyone having to track on hand inventory at a certain tariff % charge and then after that qty of on hand inventory is depleted the new on hand qty will go to a higher/lower tariff % charge? If yes, how are you tracking the on hand inventory to alert that qty is now depleted and the new on hand will have the new tariff charge?
Off the top of my head I think the easiest way would be through Lot Tracking.
It might be possible to do something if your costing method is FIFO but I don’t really know how I would setup such a thing. Assuming you are applying the tariff you are being charged as a part of the landed cost then it would show up as Mtl Burden IIRC and with FIFO you have the dates and inventory from each of the receipts that is left on hand that you could query off of.
Hello - we are actually set up as Avg costing method. Would lot tracking work with that?
Lot Tracking should with Avg Cost (I’ve never done it, we use FIFO) but it would be kind of a sledgehammer approach, moving all of your tariff effected parts to be lot tracked would add a lot of extra overhead so on second thought would probably not be a great idea.
That being said, without Lot/Serial Tracking or FIFO costing I’m not sure how you could achieve this and making the change to either of those potential routes would be a major change that is probably not worth it.
actually, you dont have to turn on lot control to do FIFO costing. with FIFO, the system creates “layers” of cost, and tracks them by quantity (not lot)… so you receive 10 pieces at $1, and then another 15 pieces at $1.50.. then as you consume them, the first 10 pieces you issue will be charged at $1 each, and then it will start consuming the parts at 1.50 each. This is all handled automatically, so if you use Landed Cost, or if you use Material Burden (which you would change as the tariffs change) then the cost at each receipt would automatically be adjusted for the next receipt.
One warning about FIFO… there is a hard and fast restriction on negative quantities.. they simply cannot exist. A fifo layer must exist in order to issue/ship inventory
1 Like
Tim we use Avg cost not FIFO. Is there a way to do this with Avg costing?
In site cost maintenance you can turn on FIFO layers even if you are not FIFO costed, but to @timshuwy’s point you now have to adhere to FIFO layer rules.
In Part Tracker do you have data under General > Costs > FIFO?
Field help
Enable FIFO Layers
Select this check box to enable the maintenance of FIFO costs (layers) as secondary costs for non-FIFO costed parts. Any issue or receipt of the part consumes or creates PartFIFOCost records to reflect the movement of FIFO quantities and costs, in the same manner in which the Epicor application updates/consumes FIFO costed parts.
The FIFO cost layers created for non-FIFO parts are not used in regular costing but more for tracking. If this check box is selected (enabled), the same validations apply to non-FIFO parts when issuing/consuming quantities (the Epicor application prevents the FIFO costs/quantities from going negative). You still receive customary FIFO negative quantity errors when the FIFO layer is enabled; these stop you from continuing to process these types of transactions.
If Avg or FIFO is selected in the Costing Method field when running the Load Cost Details selection (on the Actions menu in the Costing Workbench), and the Enable FIFO Layers check box has been selected for the associated site in site Cost Maintenance, the Costing Workbench loads FIFO average costs stored in the parts cost record (rather than first available FIFO costs). For example, if the part has two FIFO cost layers of 10.00 and 20.00, with a part quantity of one each, the average FIFO cost displays as 15.00 in the Costing Workbench.
Important: If you select the Enable FIFO Layers check box, the FIFO logic will ignore parts marked as non-quantity bearing in the Master Part Record as they do not go or are taken from stock.
For example, if you select the Enable FIFO Layers check box in site Cost Maintenance and create a new non-quantity bearing part record using Part Maintenance, no FIFO Layers will be created for this non-quantity bearing part once you issue it to a job.
Hi Greg - we do not have anything showing in the Part Tracker, General, Costs, and FIFO.
We do a lot of backflushing in production, so we cannot do lot tracing.
Our customers want up front tariff costs, so anything we do is estimated tariff costs, especially on new assemblies and ever changing percentages.
We actually have a customer asking us now to identify what type of tariff it is: Section 301; IEEP, Section 232 or Reciprocal. 
We input our supplier estimate Tariff as a Misc Charged Coded on the PO. At receipt we have logic to pull the Tariff Charge / Line Qty and that is stored in a UD02 table. Next time that part comes in on a different PO, the same process happens and it just updates the average of old UD02.TPP with new receipt.
Then we run a process that calculates at night every sales order line and adds tariff misc charge to the line. That is our estimated to the customer. Based on every part that is marked as Tariff. That goes out as the SO Acknowledgement. CS can wait for the next day or run the process manually.
Then at shipment, we run another process on the Assemblies that we shipped that day and store that in UD04. This way the next day, AR can invoice and just pull the cost of the Assembly Per Piece cost. That is the final cost, which can now include any purchase parts that are new and not stored in UD02. Customers seem to be okay with that. Though they are trying to find out what usage to their assemblies is tariff and at what cost. That is difficult since we share material with other customers and backflush.
I also have and excel sheet that helps me calculate tariffs in about 30 minutes on multiple assemblies. so far I have done about 3000 material lines max.
First month was harsh, but things are steady. We are at a negative when it comes to AP Tariffs vs AR Tariffs. 
