Skip to Content

Hello Everyone,

 

I would like to cover with this document regarding the Automatic allocation of bank statement items with multiple invoice references.

Automatic allocation is a way by which the system tried to find matching invoices for payments through a search algorithm.

You can follow the below steps for automatic allocation of bank statement items with multiple invoices references.

1. Create multiple invoices for the customer Ex: “ 10000005”

2. Check invoices status in customer account monitor:

  • Go to Receivables work center -> Customer Accounts view.
  • Search for Customer “10000005” & Click on Action->View.
  • Navigate to Trade Receivables tab.

Here we can see Invoice 1RE-25-2017, 1RE-26-2017 and 1RE-27-2017 are in Open status.

3. Now Go to Liquidity Management work center ->New Bank Statement (under Common Tasks).

Enter the required details in the step 1:Enter General Data

4. Go to Step3: Create and Edit items.

In the Items Section, select the payment method for ex: Incoming bank transfer and enter credit amount which is equal to Open invoices amount and post the bank statement

5. Click Items Details tab and go to Memo lines. Enter the references of open invoices and post the bank statement. Here both invoice and Payment are in same currency: EUR

6. Once the bank statement is posted, we can check the post processing status of the Bank Statement, it should be Not Required. (it will take time to process, click refresh and check)

Also, check the invoices status customer’s account monitor and it will be in cleared status.

 

Best Regards,

Annapurna V

 

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Elbek Mehmonov

     

    Hi, Annapurna

    Thank you for the useful blog. I was trying to configure similiar setting on ByDesign. In my case, I use Bank Statement Upload funtion instead of manually creating bank statement. In that case, I cannot edit memo line. What should I do in order to solve this issue?

    Looking forward to hear from you soon

    Elbek

    (0) 
    1. Annapurna Vunnam Post author

      Hi Elbek,

       

      This is applicable if you are creating bank statement manually. Incase of automatic bank statement upload, you can create Memo lines using fine tune activity: Global Settings for Payment > Create and edit rules for analyzing memo lines.

      Also, you can go through help center documentation on how to create memo lines: Memo Line Analysis Rules.

       

      Best Regards,

      Annapurna

      (0) 

Leave a Reply