web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to summarise BACS ...
Microsoft Dynamics AX (Archived)

How to summarise BACS vendor payments to one line for bank reconciliation?

(0) ShareShare
ReportReport
Posted on by Community Member

When using a payment proposal for vendor payments, the payment journal generated has many lines each with an offset account of 'bank 1' say.  I've tried changing the journal set up to have the posting level of 'summary' but this makes no difference. Each voucher shows separately in the bank reconciliation form.

I need to be able to reconcile say 100 lines of vendor payments as one in the bank reconciliation screen, so ideally show as one payment going out of the bank (which is what happens on the bank statement).

I can't find any options in the method of payment, the payment proposal, or the journal set up to do this.  This must be a standard 'problem',

the vendor payments don't show as any 'bank transaction type' so I can't use the 'group' option, unless I should map the payments to be a certain bank trans type, although I can't see where to do that either?

thanks

AXF

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello AXfinance,

    What is Setup in your method of payments form in the period field? Does it say "total" or "invoice" or something else? Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig, it's set up as 'Total' to just give one payment per supplier rather than per invoice, can't see anything else that might help,

    thanks

    AXF

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi AXfinance,

    Ok, thanks for the feedback.

    And the major problem that you have is that you get a number of ledger transactions rather than a single one when you post the vendor payment journal, right?

    What I am interest in is whether your vendors respectively the vendor invoices you are going to pay are all setup with different financial dimensions, such as cost centers, departments or alike?

    If so, does the selection of the transactions to pay inherit the financial dimension to your payment (bank) account and does this prevent a summary of the different Transactions on your payment (bank) account?

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    yes there will be lots of different dimensions involved, but there is always a separate bank entry per supplier.  I suspect it is because there is a bank offset account on every line rather than having lots of debits for all the supplier accounts and then just one credit to the bank, but I don't know how to get it to do that from a payment proposal.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi AXfinance,

    On the ledger account that is assigned to your bank account can you specify some fixed financial dimensions? I would assume that this is a Balance sheet account for which you do not Need financial dimensions such as cost Centers, departments and alike. If you can do that and if your payment Journal summarizes the Transactions, AX should record everything in a single bank-ledger account Transaction. Can you test that and let us know your outcome?

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig, I just fixed all the dimensions on the GL account for the bank, and it made no difference.  I also tried changing the payment control on the method of payment to NOT say 'offset account has type bank' as it did before, but no difference still.  I did find there though the box to assign a bank transaction type to that method of payment, so at least I can see all the different lines marked as the same type now in the bank rec.  I created a bank trans group for this type but cannot see how to use it to mark all entries of this type to be reconciled at the same time.

    regards

    AXF

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi AXF,

    Please try the following setup of your vendor payment journal:

    * Detail Level field: summary

    * new voucher: one voucher number only

    When you create the payment proposal you have to make sure that

    * you enter a date value in the total payment date field

    * that the offset account you use (=> your bank / cash account) makes use of the same financial Dimension. you might have to fix the financial Dimension for this account or Setup a special account structure for it.

    This works in my case. Please test if it summarizes your Transactions.

    Would be great if you could Keep us updated.

    Thanks,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi AXF, Just wondering if the last steps worked out for you? Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    I just checked all the above, and generated a journal with 3 supplier payments on.  the bank rec summarised two of them and not the other.  The difference was the financial dimensions on the lines, the two that grouped were all blank, the other line just had a Business Unit dimension on it.  These came from the Supplier set up rather than the bank set up.

    I removed any rogue dimensions from the suppliers and retried and it grouped all payments perfectly.

    many thanks for your help.

    AXF

  • maram fraij Profile Picture
    maram fraij on at

    If type of journal is Payroll Disbursement , summary option cannot be selected , is there an alternative solution to make payroll payment journal summarized?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans