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