UDF for Actual Freight Expense

In which table should I place a UDF for actual freight expense to compare against the freight billed to a customer?

We use StarShip Online but do not write back actual freight charges to the Shipping Data Entry Freight Amount field since we bill them a predetermined freight amount entered in Sales Order Entry.  I would like a way to compare the actual freight expense against the amount billed to the customer.  I plan to create a UDF and map the actual freight expense from StarShip to the UDF for reporting and analysis.

Thanks.

Parents
  • 0

    We set this up once with a UDF added to the AP invoice data entry for the SO# (because the data from the carrier didn't have the invoice #), with the UDF flowing through to the GL.  I then wrote a report that groups invoiced freight and posted AP freight by SO#, and they do their review that way.  Watch for multiple invoices per SO.

Reply
  • 0

    We set this up once with a UDF added to the AP invoice data entry for the SO# (because the data from the carrier didn't have the invoice #), with the UDF flowing through to the GL.  I then wrote a report that groups invoiced freight and posted AP freight by SO#, and they do their review that way.  Watch for multiple invoices per SO.

Children