Outgoing Payment and Bank Reconcilaition.

[Former Member]

HI All,

I have an issue regarding the bank account balance shown in the Bank G/L account. In case, cheques issued for outgoing payment but do not get cleared for more than a month, how do i carry forward it to the next month so that after reconcilaition the balance in physical bank statement and the G/L balance match at the end of the month. Currently in the legacy system used by the client they have the provision to change the posting date, so the posting dates for uncleared payment entries are changed to the next month, but this is not possible in SAP B1. how to match the balance in physical bank statement and system statement after reconciliation and get the exact available bank balance as indicated in the physical bank statement through the system.

Thanks,

Pritesh.

[former_member196081]

Hi,

There is no as such provision in standard B one.

You can use 1 work arround. Make Two banks for every bank (Like HDFC,HDFC Reco).

First make the payment from HDFC Reco and finaly when the check cleared from bank , pass an JE for HDFC and HDFC Reco.

Hope it will help you

Thanks

Deepak Tyagi

[Former Member]

HI,

Thnks a lot Deepak. That workaround would help for sure. the only doubt now is how would it affect the system because creating a new G/L for bank (outgoing paymnets) after 4-6 months of transactional entries might be a bit troublesome in a way as the users will have to do some additional work. anyways will surely work on it.

Thanks and Regards,

Pritesh.