Skip to main content
Answer

Third line of Remmitance data does not include correct Bill Description on Check with remittance AP641000

  • March 19, 2024
  • 3 replies
  • 165 views

martingaxiola
Varsity I
Forum|alt.badge.img

Team,

I am trying to inlcude the Bill Description as part of the AP641000 check with Remittance in Acumatica, the only way I found to do the relation is to do a APPayment related to APAdjust and the APAdjust to the APInvoice to get the Bill Description. In this report, I used the BillType variable to now host the APInvoice.DocDesc, on a check with 3 bills paid, the remmirance DocDesc is correct for the first two lines, but not the third line. I hope somebody could check the report and let me know if I am missing something. 

 

report is on the zip attachment

 

Thank you.

Best answer by mbarrett

Hi @martingaxiola,

I just ran into this same issue the other day and I was able to resolve it by adjusting the Line # value in each formula by minus 1. I believe this has to do with the ADJ table that all the other variables reference.

 

Can you try changing all of your $DocType00 through $DocType09 formulas as follows:

From this - =IIF($LineNbr = 0, [APInvoice.DocDesc], $DocType00)

To this - =IIF(($LineNbr = 0)-1, [APInvoice.DocDesc], $DocType00)

3 replies

mbarrett
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • Answer
  • March 29, 2024

Hi @martingaxiola,

I just ran into this same issue the other day and I was able to resolve it by adjusting the Line # value in each formula by minus 1. I believe this has to do with the ADJ table that all the other variables reference.

 

Can you try changing all of your $DocType00 through $DocType09 formulas as follows:

From this - =IIF($LineNbr = 0, [APInvoice.DocDesc], $DocType00)

To this - =IIF(($LineNbr = 0)-1, [APInvoice.DocDesc], $DocType00)


mbarrett
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • April 1, 2024

@martingaxiola, Did my previous response help solve the issue for you? If not, can you share any updates?


martingaxiola
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • January 9, 2025

Hola ​@mbarrett, We ended up using a customization from our developer where he added the docdesc to the APPrintCheckDetailWithAdjdDoc table, from the APInvoice. Thank you so much for your help on this.