Chris Kiehl
18th July 2006, 21:22
:confused:
Hello,

Using BaanIVC4 and soon to use Electronic Banking Statements.

We have customers who might reference a credit along with debits when they cut a check. Example:

sales invoice 12345 $100.00
sales invoice 12346 $100.00
credit invoice 50001 -$ 25.00

So the total for the check is $175.00

How should the negative amount be designated on the file?

Thanks in advance.

-Chris-

nansat99
19th July 2006, 21:15
you can make the negative amount as a outgoing payment.

Chris Kiehl
21st July 2006, 20:14
Thanks nansat99,

Yes, I can define 'Outgoing Payment' in tfcmg5105m000.

But does there need to me some sort of negative signifier in the .txt file itself? My debits go through the matching process successfully (tfcmg5212m000) but my credits do not.

Thanks. -Chris-

nansat99
21st July 2006, 21:45
i think you are maintaining your debits as outgoing payments .in that case maintian your credits as incoming receipts.

or vice versa.

as long as you can specify the incoming and outgoing payments i dont see any need to have -ves in the file.

avpatil
27th July 2006, 03:51
Hi,
In my set up I treat both negative and positive amount similar and had no issues. We have been running EBS for last 6 years, never faced such issues. But we don't use Baan standard EBS. All we do is populate the EBS tables using our logic and then Baan EBS program take over the rest.

Arvind Patil