Shipping amount field in SQL table.

Jun 01, 2009 1 Replies

Good Morning To All, I have a customer who is having one of their internal programmers write an interface that will update GL accounts according to their finance department's needs. They are very specific. One of the things they need is the shipping amounts at a transaction level. I cannot find these amounts anywhere. I read somewhere else that in order for this amounts to be populated the ship to and the shipping carrier had to be filled in on the transaction. I tested it, and I still can't see the totals for the shipping charges. Does anyone know anything about this? THANKS!


Try the Shipping table for each transaction that contains shipping information there should be a corresponding Shipping entry in the table Shipping linked back via TransactionNumber.

Robert

"msalazar" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required