Hi

I am looking for Broker, Freigh, Duties on Receipts
So I can track the cost to bring in goods in a report
I can see this info in Purple on Document Detail Info screen

Can you tell me the Table Name I would find this in ?
The Fields I am looking
Vendor Number
Vendor Name - if possible
Receipt Value
Receipt Date
Document Number
Broker cost
Freight Cost
Duties Cost
Can you tell me the name of fields I should be looking for ?

thanks

You can find the fields in all the tables, and the tables themselves, using the Data Dictionary Export tool that is installed with GridView or available for download off our tech tips page.

The miscellaneous charges are in the transaction details in the same table as all line items, including regular items, miscellaneous charges, comments, and instructions. Each line is has a line type that allows you to segregate the lines, and the miscellaneous charge code is in the same field as the item #.

The transaction table includes PO's, Receipts, and Invoices(Adjustments). If your freight costs are booked when you enter the receipt then filter out transaction type "2" as a receipt, or type "4" if you are booking freight details only as an Invoice.

Best,
Brian