Filter invoices-SAP Business One

[former_member697445]

I'm trying to reconcile an account and instead of going down the list click each invoice, I want to copy what is on my spreadsheet and paste it on SAP and than select the invoices. This is for SAP Business One. I know this was possible on SAP Pro.

[lenastodal]

Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
For example you:
- can outline what steps you took to find answers (and why they weren't helpful)
- can share screenshots of what you've seen/done
- can use a descriptive subject line

Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Best,

Lena (SAP Community Moderator)

[msundararaja_perumal]

Hello,

You can copy and past the Bank Statement from Excel under the scree Process External Bank Statement, under the Banking Module.

Then you can either run Auto/Semi-Auto/Manual Reconciliation.

Which is similar option to SAP ECC version.

Thanks.