Sage 100

We have a client that ships chemicals used in Fertilizer to customers via rail and truck. In some cases it is shipped to a contracted warehouse and then sold and delivered via truck from there. The freight is estimated and the Bill sent to the customer before they know what the actual freight costs are. What they need is a way to tie the actual freight costs back to the invoice in a way that would allow reporting. Has anyone worked out a way to do this? Do any of the shipping packages handle this? Thanks

I've got someone doing that. For them, I just had them put in the invoice number (from AR) into the line comment field in AP Invoice Entry, then wrote a Crystal report to match up the two. Have another person who can get their files from UPS with the invoice number on there and we wrote an import to bring in the UPS freight into a UDF field in AR Invoice History file and then they just use their lookup for a quick report.

Thanks, Beth. That is the direction I was looking at and the Customer has been putting the Sales Order # in the comment field but has been very inconsistent on how they format it. I would like to add a UDF for the Invoice number and use that instead. I figured the Crystal Report would be best run from the history headers. Does that make sense? This client ships nothing smaller that pallets of 60 lb bags and they use Rail and a bunch of different truck carriers so I think they will just have to get the invoice number in manually.

Header is perfect if one invoice = one AP invoice

I am doing the same for one of mine. UDF in the AP header...

We have one where we had to do UDFs at the line level because there were many cases with split shipments.

Thanks for the replies. I am told each transaction with a customer has one freight invoice so there may not be any split shipments. I need to get more information on what happens when bulk is brought into a remote contract warehouse and sold from there.