Manual Reconciliation help for multiple BP

[HollyGriffiths]

Hi everyone,

my company uses SAP B1 without much development. We are currently manually reconciling every single payment across our accounts everyday which takes us a minimum of 2 hours at a time. We have to manually reconcile an invoice with the journal payment for our orders. Is there a way we can limit the manual work and get B1 to do this for us?

Below  image is the list of accounts we manually have to search in our BP master data, open up the account summary then click the internal reconciliation button then click the payment to the invoice. We have to do this across minimum of 100 accounts a day which is very time consuming,

please note, our company has the bare minimum development within this system and a lot of the functions have not been available and this is the only way we have been 'trained'.

any help is appreciated! 

[jitin_chawla]

Hi,

The Internal Reconciliation window has option to perform the reconciliation of documents Manually which you have displayed in the screenshot. Another option available on the Internal Reconciliation window is 'Automatic' where user can give some criteria and the system performs the reconciliation of the documents. This automatic reconciliation however, works 1 to 1 document and not multiple documents to an Invoice.

So, you can check this on the COPY of the database by using the Automatic option and see it that is of any help for your case.

Kr,

Jitin

[Samudra]

Hi,

As per my understanding, the payments of your incoming and outgoing are not tagged correspondingly with your invoices. 

If I can recommend it, it would be better if you could make the payments tagging with your invoices. Or else you can use EFMs for your payments. But yes, it would require development.

With Regards,

Samudra Gupta