Hi All,

This is a question regarding Baan - CMG - Electrnoic Banking Statements.

Can any one help me in handling the following business case?

Summary of the question - Does Baan EBS (Electronic Bank Statements) handles the scenario of excess amount received than the actual invoice balance or not?

Or in other words,

Does Baan EBS build with the assumption that the bank file always contain the exact amount or less amount than the actual invoice balance and not greater than the actual invoice balance?



Case Details -

Customer has an invoice balance of 1000$ but customer has paid 1500$ as an advance in a single check through bank. The customer intention could be, to clear the invoice balance and keep the additional 500$ as an advance/unallocated.

When Baan imports the bank file through EBS and tries to match the conversion line, the match will not go because of the excess receipt amount. Baan EBS does not allow changing the amount on converted line also. In that case, what is your recommendation to handle this transaction through Baan EBS?

If there is any place to change the amount from Received amount to actual amount then how to keep track of the excess balance amount (in our example it will be 500$) through EBS only?

Kind Regards
Srikanth

The only option I can think of is Manual Matching. Using Manual Matching we can enter the receipt for invoice and separate advance (500). After posting EBS, an advance receipt will be created.

Thanks a lot Madan. I got the same response from Infor too but the way you drafted clarified how to do this and all. When I open EBS session that your refered the add/duplicate icons are disabled. I got to know latter that once you double click the line, the detail session has the provision to add the excess amount. Thanks a lot Thanks for your help.