cancel
Showing results for 
Search instead for 
Did you mean: 

Bank Reconciliation using SAP standard tempate in FIORI App Manage Bank Statement

abhimanta
Discoverer
0 Kudos
687

I am trying to do Bank Reconciliation using SAP standard tempate in FIORI app Manage Bank Statement. In case where i have multiple receipts with same amount but different value in "Reference" and "Assignment" fields in the original receipt entry and i have updated the field "Item Refernce" with the same value. But system is not posting these lines and they need to be posted through reprocess option and then choosing the line to clear.

How is this scenario to be handled?

Thanks in advance for your help

Accepted Solutions (0)

Answers (1)

Answers (1)

Edrilan_Berisha
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

 

I didn't get exactly what you do. Do you have a posting rule or processing rule in place to handle your posting automatically?

I would propose to create an automatic processing rule: https://help.sap.com/docs/SAP_S4HANA_CLOUD/918bca53037f408f91a2295d04ac16bc/d6fe6526b26f46e59d9d1dd0...

 

 

Can you share some screenshots explaining what exactly you mean?

 

Best,

Edrilan Berisha

SAP S/4HANA Cloud Financials Development

abhimanta
Discoverer
0 Kudos

Hi Edrilan

I am attaching herewith the screenshots

3 open items having same value in assignment and Reference fields

abhimanta_0-1717406075810.png

The value in assignment and Reference updated in Memo Line and Item Reference in the Bank Statement template

abhimanta_1-1717406128359.png

New Manual Statement created

abhimanta_2-1717406153765.png

Statement saved

abhimanta_3-1717406171492.png

After clicking on Post, none of the lines got posted

I am confused as to where is the mapping of assignment / reference to be maintained.

Are the fileds Memo Line / Item Reference selected by me correct fields

The link given by you does not open. I am getting following message

abhimanta_4-1717406336196.png

Thanks in advance

 

Edrilan_Berisha
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

 

there are two options, either you fill that information in the Assignment field of each of the bank statement line items or you do not use the assignment but the document number from the journal entries.

 

So option 1:

Navigate into each item:

Edrilan_Berisha_0-1717416032722.png

Add the assignment reference in the assignment field:

Edrilan_Berisha_1-1717416054280.png

 

 

Option 2:

You enter the document number into each memo line:

Edrilan_Berisha_0-1717416132613.png

 

 

Best,

Edrilan Berisha

 

 

abhimanta
Discoverer
0 Kudos

Hi Edrilan

I am downloading the template from the SAP FIORI app "Manage Bank Statements" and am using it to update Bank statement and upload. In the template i cannot find the Assignment field, so am not understanding how to update. The template is having only the following fields.

Manual Transaction
External Transaction
Value Date
Amount
Acct Currency
Memo Line
Check Number
Payment Medium Ref.
Customer Ref No
Item Reference
Payment Amount
Payment Currency
Partner Name
Partner Bank Code
Partner Bank C/R
Partner IBAN
Partner SWIFT
Partner Bank Account
Customer
Supplier
G/L Account
Description

Can i insert the assignment field in this template and then upload?

Thanks in advance

Edrilan_Berisha
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi, I think you are not using the software correctly. Please use the UI in case you fill out the information by hand. Why do you fill out an excel by hand? You can see the screenshots that I took. Click on the arrow, navigate to the item enter the information. Or as I said Option 2, which I would propose anyway in your case. Best, Edrilan Berisha