Multi-branch MICR Check with Remittance report
I am building a MICR check for printing from different branch bank accounts. I have the MICR line working OK, but ran into trouble when trying to find where the branch address is stored. I found it in one of the Address DACS (don't remember if it was AR. AP, or CR). Regardless, my problem is that the address table has multiple rows for the BAccountID for one of the branches and I cannot find what identifies the correct row in the address table and how to get it linked with the Branch table.
Has anyone run into this before? Any ideas?
Also, any good suggestions on where to put the check logo for the branch? Maybe as a file attachment? The client is on v6.1 and can't change any time soon because of the customizations they have.
When I get this working, I will post it here. A little disappointed that this is not a standard report already.
Join from PX.Objects.GL.Branch to PX.Objects.GL.Branch on PX.Objects.GL.Branch.BAccountID=PX.Objects.GL.Branch.BAccountID.
Then join from PX.Objects.CR.BAccount to PX.Objects.CR.Address on PX.Objects.CR.BAccount.DefAddressID=PX.Objects.CR.Address.AddressID.
Then pull the address field out of the PX.Objects.CR.Address table.
As for check logo, do they already have something loaded into the Logo tab of the Branches (CS102000) screen?
How many Branches? You could just load the logos into the report and use suppression logic to decide which to print.
Doesn't help you in your 6.1 environment, but Acumatica 2017 R2 does have a second section for a Report Logo. Actually, you might have been the one who pointed it out to me.
Attached is my version of the Multi-branch MICR Check report, AP.64.10.00. Here is a list of most of the changes I made to the standard form:
- It is in STUB-CHECK-STUB format.
- I added an attribute (BANKFRACTN) to the Bank to hold the fraction number. Couldn't find it anywhere else.
- The Branch address has the phone number added per client request.
- Added Bill Description to the stubs
- Added "VOID AFTER 60 DAYS"
- Added second signature line
- Added VOID above signature lines for the remittance pages.
Have not gotten logos to print by branch, yet. Been focused on a single branch, but will make that tweak before it is put into production. I plan to follow Tim's suggestion and embed all logos for all branches and conditional print only the correct one and suppress all the others.
MICR line has not been tested with the bank yet, but, on my printer, the MICR text prints exactly the same an in the same location as what is currently coming out of the old production system.
One note -- addresses are aligned to print in a two window envelope where the Vendor and return addresses are visible.
Hope this helps someone. Was a lot of work.
Thank you so much for sharing this @dws253
I'm including a screenshot here so others can have an idea of what it looks like, even though I get some errors because I don't have all of the fields in my database.
Just curious, how did you add an attribute to the Cash Account? I didn't know that you could do that!