on 05-30-2017 9:18 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Benjamin,
is there any partial payment in that invoice ? maybe it will be double your amount.
thanks
Andri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.