When using Text To Account Mapping on Payment Reconciliantion Journal, field Bal. Source No. is either editable or not, depending on the value of Bal. Source Type. If source type is Customer or Vendor, it is editable, if it is G/L Account or Bank Account it is not editable and no value can be chosen.
I propose, that if source type is Bank Account, Bal. Source No. should also be editable.
There is sometimes necesary to close/balance Bank Account directly when doing payment reconciliations, when dealing with credit cards and retail sales. You can manualy enter bank account on reconciliation journal for each, but currently you cannot specify text to account mapping with bank account. If there is a lot of entries like this is unnecesarry manual labor.
Let's make BC better. :)
Comments
I agree. I think when the Source Type is Bank Account, the Bal. Source No. should be editable.For others who have found this idea and are interested in it, be aware that you can set the Source Type to Bank Account and use back-door methods to assign a bank account. I was able to add a bank account value by using the Edit in Excel feature and expect you could also update it via a configuration package. If you do this, keep in mind you will not want to have a second, similar Text to Account mapping rule on the offsetting bank account. If you did that, the transaction would be incorrectly recorded twice (once for each Payment Reconciliation Journal processed).
Category: Financial Management
I agree, we added development to use an additional field to validate the bal source no and it works as expected, only need to make the field editable when Type = Bank
Category: Financial Management