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.