Sage 100

I know this has been discussed just recently, but I have a potential new client that wants to put a spin on it. They want to transfer goods from one whse to another but add the freight cost to the item on the destination whse side. It's like adding landed cost to the transfer. Put in the cost of the freight and then it divides the $$ by units transferred. And since item transfer does not allow you to change the cost any thoughts on how I can do this easily?

Can you just issue the goods out of the ""from"" warehouse, and treat the 'to"" warehouse as a Vendor and use regular P/O Processing?

I thought of that but how do I handle the open receipt of invoice/purchase clearing???

Diane this IS possible. You will need to get with the good folks at DSD. This was an extended solution ""back in the day"". It was probably not rolled up so DSD is probably upgrading it and making it available.

Maybe you can get creative with G/L-specific extra lines during ROG/ROI?

Just FYI - built-into MAS500 transfers.

@LouisAraiza thanks I will give them a call and see what version they have it at. @alanniergarth Thanks but Sage 100 is what they are looking at. @BrettZimmerman working on that thought but haven't gotten it to work cleanly just yet... Going to see what DSD has first might be the easiest... Thanks everyone for all the suggestions.

Found it IM-1226 I/M Transfers With Additional Costs Add an Additional Cost field and a G/L Account Number field to the lines tab of I/M Transaction Transfers. You can add costs to Items as they are transferred from one Warehouse to another, and specify the G/L account that will hold the difference.

Thank you @LouisAraiza I found it and spoke to them. They have it in 4.3 but will bring it up to 4.4 or 4.5 if need be. Was just reading the spec's on it and it is exactly what I needed. Thank YOU !!!! Hummm!!! Now I wonder if a script can be written to do the calculation for all items in the transfer based on a $ amt. UDF $$ / total qty then add it to the additional cost field for each item . But looking in 4.5 it seems like you can't add a script to the inventory - transfer - transaction entry -detail file - just the header am I wrong?? Can't believe that I can't do that....

@DianeRuth: In my 4.5 I can indeed add a script to IM Transaction Entry Detail.

Ok have to relook at it thanks @AaronClark !

Diane if you go the upgrade route for the ES -- put the order in sooner rather than later.

Thanks Wayne that is what I was told by DSD also.