Sage 100

Is Sage Landed Cost basically an "all or nothing" option?
What I mean by this is that it doesn't seem as if you can receive freight on a PO as well as separately ( landed cost ) without the underlying posting potentially becoming messy.

When landed cost is enabled and you receive a PO where the vendor charges freight there is no easy way that I can see to add that freight to the inventory cost without also using landed cost. Then that means - depending on how you have the control accounts setup and if you're posting by warehouse code - that the underlying GL entry is a bit jumbled. Of have I overlooked a secret somewhere?

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Connecticut
------------------------------

The most straight forward way to setup the Landed Cost accounts are as offsets to Freight, not to the Freight account itself, since that can vary by Division.  You'll be debiting the Freight account for anything in the Freight field, then crediting the Landed Cost offsets that you've entered in Landed Cost. In theory they net to zero... Of course, if it's third-party freight, it's an estimate in the ROG a lot of times. So you're debiting Inventory for the cost of the item plus the freight, debiting Freight Expense, and crediting the Landed Cost offsets. You end up recognizing the cost just once, as part of the value of Inventory.

------------------------------
Beth Bowers
Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
(269) 358-0989
------------------------------

Per your comment: "When landed cost is enabled and you receive a PO where the vendor charges freight there is no easy way that I can see to add that freight to the inventory cost without also using landed cost."

Probably because the freight and other costs other than the beginning item cost can be allocated using different methods: weight, cost, quantity, volume.  A step up in features would allow the user to assign a  HTS code to an item. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

@Doug Higgs it would be easier if Sage allowed the use of either the allocation of the freight as entered in the Freight field on the PO / OR the use of Landed Cost. From what I can see once you turn on Landed Cost Sage presumes you will always use landed cost.

When landed cost is turned on if you have a PO where the freight is being billed by the vendor on that PO ( Invoice ) and you just use the freight field ( no landed cost ) then Sage debits freight expense and does not allocate freight to the inventory item. The only way - when landed cost is enabled - to get freight into inventory is by also adding a value to landed cost by clicking the landed cost button.

The issue becomes when you have both freight expense and landed cost that there may not be an easy way to "wash" those amounts against each other. That's ok for probably a lot of users (or they just never notice or don't use landed cost). I just happen to stumble upon a user who didn't like that they couldn't wash the freight expense against landed cost.

More of an FYI as I haven't dealt much with landed cost in the past so it took some time to learn exactly what entries are made when that feature is enabled.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Connecticut
------------------------------

Original Message:
Sent: 03-25-2026 21:03
From: Doug Higgs
Subject: Is Sage Landed Cost basically an "all or nothing" option?

Per your comment: "When landed cost is enabled and you receive a PO where the vendor charges freight there is no easy way that I can see to add that freight to the inventory cost without also using landed cost."

Probably because the freight and other costs other than the beginning item cost can be allocated using different methods: weight, cost, quantity, volume.  A step up in features would allow the user to assign a  HTS code to an item. 

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------