By using this website, you agree to our Terms of Use (click here)
Is there a way to print the bill to contact and bill to address? I am creating a generic inquiry that prints all the locations for a customer but I am having trouble figuring out how to get the billing info to show on the inquiry.
Hi @medvet
If you are looking at Customer, you will want to join Customer.DefBillAddressID to the Address DAC, and Customer.DefBillContactID to the Contact DAC.
If you are looking at Sales Orders, you will want to join SOOrder.BillAddressID to the SOAddress DAC and SOOrder.BillContactID to the SOContact DAC.
If you are looking at Invoices, you will want to join ARInvoice.BillAddressID to the ARAddress DAC and ARInvoice.BillContactID to the ARContact DAC.
You'll find most of the documents follow the same formula with their DACs, with an XXAddress and XXContact table for the documents in the specific XX module.
Address - BAccount, Contact
APAddress - AP Bills/Memos
ARAddress - AR Invoice/Memos
CRAddress - Opportunities/Quotes
FSAddress - Service
PMAddress - Projects
POAddress - Purchase orders
SOAddress - Sales orders
If you're starting from the Location DAC, you will want to use the BAccountID to link back to Customer DAC to get the BillTo IDs and go from there.