Sage 100

I have a customer who really doesn't like the fact that his receiving department has to enter landed cost or that it cannot be allocated during receipt of invoice entry. Anyone know of anything available out there?

if you are on V4.4+ it should be scriptable.

Isn't it too late during ROI. Inventory tables are updated during ROG. How are they updated during ROI?

That's the point - they can't update the inventory cost during receipt of invoice and he wants to. This is not an usual complaint. They don't know the landed cost during receipt of goods and they want to get the items in stock. His other complaint is that even if he knew the cost during receipt of goods he doesn't want his receiving people entering them. Jim you said it should be scriptable but did you understand what I was asking for? It seemed to me with as many times as I have heard complaints about this that someone would have had to have done a modification. I was thinking though, what if you did receipt of goods and then by the time you did receipt of invoice the tier or quantity has already been relieved from inventory. What would it do with the cost then? Seems like it could be pretty complicated.

I looked at this some time ago for a customer and remember thinking that Sage basically did the minimum to proclaim that landed cost worked.... though there is also an issue where container shipments with multiple POs do not capture landed cost per PO. I think ultimately when we'd discussed before part of the ""solution"" might have been estimated freight added to the PO and the ROI had the full amounts with variance posting to a PO variance. I don't remember ever getting the warm fuzzies. I also looked at two landed cost enhancements. One was IIG and one was Extended Solutions. My memory is both were barely more than what stock Sage did. At the time (2007) the IIG solution did not look fully completed and I think they admitted it wasn't.

This a bit like the post earlier today regarding negative tiers. The only way to really deal with it is to train the folks in the way MAS really works so that they can develop work arounds. To me, a good way to deal with the landed cost issue is for the purchasing department buyer to become proactive with freight charges (just as they should be proactive with getting the correct costs on the PO before it is received. Create a UDF on the PO header for the buyer to input the freight amount that will be billed by a third party. There will then be two fields for freight - one for the PO invoiced amount the other for the third party billed amount. You could then write a script to transfer the non PO freight to landed cost when the ROG is entered. This WILL work if the purchasing department becomes proactive.

I have frequently advocated for using a standard cost for landed costs. If the freight was more than the standard then the buyer should be held accountable. Just an example. Calculate a standard for the landed cost amounts, use that for receiving, hold those responsible for purchasing and transport accountable for deviations from the expected standards.

Thank you all so much - I feel like I can at least confidently tell him he needs to work around this and I know how we can. You guys are great!

@RobertaFerguson That's the value of this group - even when the second opinions validate your own - at least you know that you're not overlooking something incredibly obvious

Most competitors have the ability to enter landed costs much later. In NAV, you can do so after the product has been shipped and invoiced to a customer. Don't ask me how, but it goes through a revaluation process and recalculates everything.