Good day Team,
I am trying to add the AP Bills Branch ID to the AP642000 Additional Remittance Form, I used the APAdjust table with the APPayment, doing Doctype equal to AdjgDocType and RefNbr equal ADJgRefNbr, also used the adjd ref and doctypes to test but did not worked either. When I used the APAdjust.AdjgBranchID, as I tested on a GI, it worked, but when doing in the report designer does not work. I have used other tables as well, but no luck.
I hope, there is a way.
Best answer by martingaxiola
I ended up adding APPrintCheckDetailWithAdjdDoc with APAAdjust (not from the original report), and did the below connections:
That gave me the correct branches per line, Linked the Payment Reference and Bill reference. This solve my problem, where I needed to add the branch from the Bill into AP642000.
+4I didn’t go back through and verify it was showing the correct branch, but it populated for both the Adjd branch and the Adjg branch (they were the same of course).
Did you make other changes to the Additional Remittance form?
Maybe show your relations or attach the report if it doesn’t require specific data from your site to populate it
Hola
I am trying to add the Branch from the Bill into the Detail section of the Bill that was paid with the check.
+4I double checked moving the fields around on my report and it still generated the branch, but my report doesn’t have something to populate the fields still work.
Hola
Hola
I manage to add table APAdjust and make it worked, where I using APAdjust, but when the report has more than one bill, it will only show the Branch of the first bill, and not the correct assinged branch per Bill, I have an example where I have a payment paying, a TN branch and a AZ Branch, and its only showing the TN branch on both lines of the bill, instead, of showing on first list the TN and second line AZ even though the data is correct for everything else.
Do you have any ideas how to solve this issue?
I ended up adding APPrintCheckDetailWithAdjdDoc with APAAdjust (not from the original report), and did the below connections:
That gave me the correct branches per line, Linked the Payment Reference and Bill reference. This solve my problem, where I needed to add the branch from the Bill into AP642000.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
