Another option would be to have a UDF at Pack level. In our case, we already know the exact price for each of our trucks when we ship them. Many of the FGs we sell, have freight included in the price, so having the actual cost of freight by Pack#, helps us even more when we get the AP invoice from our transportation vendors.
You can play somehow, moving the UDF to the Pack Line level if you want to allocate partial cost of a shipment to the multiple lines you might handle, but definitely keep a field to match the AP Invoice UOM.
You can play somehow, moving the UDF to the Pack Line level if you want to allocate partial cost of a shipment to the multiple lines you might handle, but definitely keep a field to match the AP Invoice UOM.
--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> I use a UD table/field for freight.
> It sounds like your situation isn't too much different.
>
> In our case, when an order is placed, we get an estimate for the shipping from a carrier. That may or may not be entered as a misc charge.
>
> Eventually, we get an invoice for the actual freight, that goes in the UD table/field.
>
> I used a UD table instead of an Order UD field.
> This is because it can take a long time for the freight invoices to come in. The orders are often closed by the time we get them.
>
> I have a custom Gross Margin report that considers the actual freight.
>
> --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> >
> > There are some order shipments that we absorb the cost of shipping on. We want to know if there is a way to attach that shipping cost to us to an order for tracking. We do not want to do a positive misc charge then a negative misc charge on the invoice to represent this. The purpose of knowing how much we eat in shipping costs is to determine how much we lose in a year on shipping costs that are not paid by the customer.
> >
>