Sage 100

My client is looking at improving the landed cost in Sage 100. They currently allocate (Duty and Freight) based on "cost" type in Landed Cost setup during the ROG process. 

This has worked well in the past, but now they are getting invoices from a 3rd party vendor that contains freight charges for multiple orders that have already been received.

Anyone have an idea on how to allocated these freight charges to the already received POs?

The goal was to update the allocated cost of the FIFO inventory items so we can get a better picture on how much each item is truly costing the company. They have product that is arriving from both Mexico and China and are losing insights on the gross profit of the inventory items since freight and duty is not part of the cost.

Thank you,

Michael

------------------------------
Michael Davis
Warren Averett Technology Group
Birmingham, AL
------------------------------

This sounds a little like container landed cost. At one time I had a customer in Alaska and they were looking for the same type thing. They’d have everything shipped up to Washington and put into a container and from there it shipped by boat to Alaska.

They wanted to allocated cost/freight by volume ( they basically had a flat rate container and shipped a lot of light bulky items ).

We never got this implemented and the best I ever could come up with then ( 10-15 years ago ) was a spreadsheet allocation performed after-the-fact.

Looked at a few enhancements but none seemed like a perfect solution.

---------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
---------------------------------

The big issue is the inventory has already been received.  I don't know of any enhancements that will change the tier cost after it's been updated.  I have implemented the IIG allocated landed cost module a couple of times and it works very well.  You can created an hts code and assign it to an inventory item.  Freight and duty can be allocated several ways across multiple purchase orders.  As far as I know it does NOT change the unit cost after the receipt of foot has been updated.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

I have a customer receiving goods from China all the time. Its usually one big container for 3 different companies in Sage. They do a spreadsheet allocation prior to the goods arriving and enter that as landed cost during receipt of goods. They are pretty good at estimating by now so its its usually close to the actual when the goods/invoices arrive. If they are way off they either do a return of goods and re-receive using actual numbers or they do a Inventory cost adjustment along with Journal Entries to duty, freight, etc. It's not perfect but they get the correct cost when all is said and done.  

------------------------------
Kenny Daniel
TechnoClarity, Inc.
------------------------------