Skip to main content
Solved

ShpVia_Carrier_description


Forum|alt.badge.img+1

Other than the SOOrder table, what other table(s) contain the ShipVia_Carrier_description? I am modifying the invoice (AR641000) to match what we need for emailing out and one of the fields that needs to be on the form is the Ship Via description. If possible, I would like to not use the SOOrder and feel that if it is on the SOOrder, then it should be somewhere on the ARInvoice, which appears to be not the case. I have combed over the following tables in the hope of finding it rather than mapping additional tables to the form:

Branch, Address, ARTran, Contact, Customer, ARAddress, Terms, Note, EPEmployee, Location, ARInvoice, ARContact, PreferencesGeneral, BAccountNoMask, and CCPayLink which are the standard tables within AR641000.

Best answer by dcomerford

Afraid not the field is not stored on the ARTran or ARInvoice so you would have to join the SOOrder table to get it or else get it from the SOShipment table

View original
Did this topic help you find an answer to your question?

2 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • 639 replies
  • Answer
  • October 24, 2023

Afraid not the field is not stored on the ARTran or ARInvoice so you would have to join the SOOrder table to get it or else get it from the SOShipment table


Forum|alt.badge.img+1
  • Author
  • Varsity I
  • 134 replies
  • October 24, 2023

I thought as much. Thank you for your help.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings