Skip to Content
0

Automatic bank reconciliation in SAP Business Bydesign

Aug 17, 2017 at 10:35 AM

174

avatar image
Former Member

Hello,

Can we do automatic bank reconciliation using SAP business bydesign

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Annapurna Vunnam
Aug 17, 2017 at 03:07 PM
0

Hello,

You can use memo lines to allocate the payments automatically for automatic bank reconciliation.

You can refer to help documents "Memo Line Analysis Rules" and "Creation of Memo Line Analysis Rules for Common Use Cases" for more details.

Best Regards,

Annapurna

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your reply.

I have BAI2 file and i am trying to upload it using WC Liquidity management-->inbound file--->new-->bank statement

file is similar to blow screen shot

bai-file.gif

Type code are different ,it is for TD Bank.

Is this way of uploading correct.

Or first i have to go for "memo line analysis rules"

Can you guide me.

Thanks

bai-file.gif (12.9 kB)
0

Hello,

There are different cases, for example for payment advices, where the bank statement item document id is used as a search text to try and complete the allocation. But for invoices etc it is done on the memo line.
In invoice case, first you need to maintain the memo lines and then need to upload the file and then it will allocate payment automatically.

Bank Statement upload creates items, these will have payment allocations. Depending on the import format and the file provided, some information will be places in the memo lines of the corresponding payment allocation. Then when the Bank Statement is posted, the payment allocations will try a 'Propose' action. This uses the memo lines provided and cross checks with the memo lines rules that are in the system, it then tries to find a match that corresponds to the rule. If a match is made, then the payment allocation is posted.

So you need to maintain the memo lines before uploading the file.

Best Regards,
Annapurna

0