Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Auto posting to pre-defined account in advanced reconciliation

(0) ShareShare
ReportReport
Posted on by 6
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!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans