Skip to main content
Solved

Parent and child fields to link service orders and AR invoices

  • 16 February 2024
  • 3 replies
  • 77 views

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?

 

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

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?

Hello @lewisad ,

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.

 

 

 

 

 

Reply


Terms & ConditionsCookie settings