Dynamics Community Forum Thread Details

Auto posting to pre-defined account in advanced reconciliation

Hi All,

We have hundreds of bank transactions with the bank transaction code NMSC and various unique Reference nos. We need to be able to put many matching rules with auto posting as follows:

Rule 1:

1) Bank transaction code = NMSC (this code is linked to MSC in Bank transaction type, therefore it is linked to main account 145678)

2) Ref.no = 123456

3) Amount less than 500

==>Then post to the main account 145678

Rule 2:

1) Bank transaction code = NMSC

2) Ref.no = 123456

3) Amount more than 500

==>Then post to the main account 145679

Rule 3:

1) Bank transaction code = NMSC

2) Ref.no = 99887766

3) Amount more than 500

==>Then post to the main account 145680

etc.

Is it possible to set up in D365?

Currently we can do only 1 main account associated to bank transaction code, then to bank transaction type, therefore all the above transactions would be posted to that 1 main account. Is there a workaround this scenario to post them to different main accounts?

Thank you in advance!!!

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL