Skip to main content
Solved

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


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)

View original
Did this topic help you find an answer to your question?

mbarrett
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 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
  • Jr Varsity III
  • April 1, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings