Question

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

  • 7 December 2022
  • 0 replies
  • 42 views

Userlevel 3
Badge

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


0 replies

Be the first to reply!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved