Skip to main content
Question

Unable to Link Project Invoice to AP Bill after upgrade to 22R1

  • December 7, 2022
  • 0 replies
  • 68 views

Forum|alt.badge.img

Prior to 22R1, we were able to display AP Bill Line data linked to a Project Invoice.

The joins to get from ARTRan to APTran are:

ARTran Left Join PMTran on

  RefNbr = ARRefNbr AND

  TranType = ARTranType

  LineNbr = RefLineNbr

 

PMTran Left Join GLTran on

  BatchNbr = BatchNbr

  OrigLineNbr = LineNbr

  'AP' = Module

 

GLTran Left Join APTran on

  RefNbr = RefNbr

  TranLineNbr = LineNbr

  Module = 'AP'

  TranType = TranType

 

Acumatica used to populate both he orig doc number and the line when posting the GLTran row, but they stopped doing that in 22R1.The Tran Line number is NULL now.

Our clients need to see  the AP Bill details related to the Invoice.

Is there another path to join ARTran to APTran with project invoices?

Thanks