Connecting ARTran to the service contract

​@bwhite49 

When invoices are generated from service orders and appointments, the details that are “posted” are stored in a table called FSPostDet, this table keeps the references between the document line (service order and appointment lines) and the generated billing document line. Unfortunately, the same doesn’t happen with service contracts, there is no straight way to find the link between the invoice line and the service contract detail line (FSContractPeriodDet).

Hope this information is useful. 

When an invoice is generated from FS501300, all of these items under the “services per billing tab” are added to the invoice. If there are 60 items listed, then 60 items get added to the invoice. 

Everywhere else in Acumatica, it seems that when a document is generated from a detail list, there is a way to link back to each line that the document was generated from.

In this case, there are descriptions and other fields linked via the equipment number that we need to have available on the invoice. There must be others who have encountered or will encounter this issue as well?

We will need modify the action on FS501300 to copy FSContractPeriodDet to ARTran so that we can link to the equipment nbr.

We had to create a customization to copy FSContractPeriodDet.FSContractPeriodDetID to ARTran during invoice creation. It feels silly that we needed to build a link.