cancel
Showing results for 
Search instead for 
Did you mean: 

Incoming Payment amount doubled and negative

Former Member
0 Kudos

Hi Support,

I have this concern with regards to having doubled Amount in our incoming payment.

NOTE: we enabled allow negative

Scenario:

1. Enter incoming payment and enter negative payment which is I enter -100 through credit card.

what happen why the balance becomes -200?

Please help.

Thanks,

Accepted Solutions (0)

Answers (2)

Answers (2)

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Do you get any result from the following query:

SELECT 'Incoming Payment', DocNum, TransId FROM ORCT WHERE PayNoDoc = 'N' AND NoDocSum <> 0
UNION ALL
SELECT 'Outgoing Payment', DocNum, TransId FROM OVPM WHERE PayNoDoc = 'N' AND NoDocSum <> 0

Regards,

Jitin

Former Member
0 Kudos

Hi Jitin,

Query result is empty.

thanks

Former Member
0 Kudos

Hi Benjamin,

is there any partial payment in that invoice ? maybe it will be double your amount.

thanks

Andri

Former Member
0 Kudos

Hi Andri,

Unfortunately No, this is the 1st time that this Incoming payment is process payed with the exact amount through credit card.

former_member312729
Active Contributor
0 Kudos

Hi Benjamin,

Un-check the payment on account field and try the entry.

Regards:

Balaji.S

Former Member
0 Kudos

Hi Balaji,

what is the effect if this payment on account is checked?

Thanks

former_member312729
Active Contributor
0 Kudos

Hi Benjamin,

On what scenario you are trying to enter negative amount in payment means.

Since you are entering negative amount on payment means,system consider the amount as unmatched to the existing transaction and posts as "payment on account". As a result you are getting double the amount.

Regards:

Balaji.S

Former Member
0 Kudos

Hi Balaji,

Sorry for the very late reply, I have tried trying the transaction on our test DB, with the same scenario but payment on account is not ticked, unfortunate balance amount is still doubled.

So what should we do to resolved this issue? reconciliation?

what will be our option or the best thing to do if we will face the same scenario again?

Thanks

former_member312729
Active Contributor
0 Kudos

If you are entering negative amount on payment means,system consider the amount as unmatched to the existing transaction and posts as "payment on account". As a result you are getting double the amount.