I am creating a generic inquiry where i would like to join the ARInvoice table to the FSServiceOrder table. This is so i can refence the docdate of the Invoice. What are the Parent and child fields to link service orders and AR invoices table?
Answer
Parent and child fields to link service orders and AR invoices
Best answer by darylbowman
I don’t have much experience with the Service module, but from a bit of investigation, it looks like Invoices would show up under ‘Billing Documents’ on Appointments. These documents come from the FSBillHistory table, which can be joined to FSServiceOrder like:
FSServiceOrder.SrvOrdType = FSBillHistory.SrvOrdType and
FSServiceOrder.RefNbr = FSBillHistory.ServiceOrderRefNbr.
Then, to join the FSBillHistory table to ARInvoice:
FSBillHistory.ChildDocType = ARInvoice.DocType and
FSBillHistory.ChildRefNbr = ARInvoice.RefNbr
+15I don’t have much experience with the Service module, but from a bit of investigation, it looks like Invoices would show up under ‘Billing Documents’ on Appointments. These documents come from the FSBillHistory table, which can be joined to FSServiceOrder like:
FSServiceOrder.SrvOrdType = FSBillHistory.SrvOrdType and
FSServiceOrder.RefNbr = FSBillHistory.ServiceOrderRefNbr.
Then, to join the FSBillHistory table to ARInvoice:
FSBillHistory.ChildDocType = ARInvoice.DocType and
FSBillHistory.ChildRefNbr = ARInvoice.RefNbr
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Thanks for your response. I will try it and keep you posted. Do you know what would be a good resource to get a better understanding of table relationships in Acumatica or an in-depth guide on generic inquires?
+4Hello
To get a better understanding of the DAC/Table relationships, you can use the Merged DAC Relations (SM402000) screen and DAC Schema Browser.
In addition, you can follow the S130 Data Retrieval and Analysis course at Acumatica University.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.