[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: NaN, AP account credited twice after trying to correct wrong 'Payment' entry





On Thu, Dec 13, 2012 at 5:39 PM, ario <..hidden..> wrote:
On Wed, 2012-12-12 at 23:19 -0800, Chris Travers wrote:
>
>
> On Wed, Dec 12, 2012 at 6:49 PM, ario <..hidden..>
> wrote:
>         Hi (Chris),
>
>         not so long ago there was an issue with 'NaN' in the amount
>         field, where
>         the source field contained the amount. This was supposed to be
>         solved by
>         issuing the psql statements:
>
>         SELECT trans_id FROM acc_trans WHERE source = '1,893.00';
>
>         to find the affected trans_id which turned out to be 15956,
>         and
>
>         UPDATE acc_trans SET amount = 1893 WHERE amount = 'NaN' AND
>         trans_id =
>         15956;
>
>         to fix the wrong entry.
>         However, after doing this, the AP account (2100) wasn't
>         balanced: The
>         'purchases account (5010) is debited, the cash account (1010)
>         is
>         credited, which both seem to be right, but the Accounts
>         Payable account
>         (2100) is credited twice.
>         Should the AP account not be credited once and debited once to
>         reflect
>         the completed payment?
>         And how would I correct that with a psql statement?
>
>
> can you send me:
>
>
> SELECT * FROM acc_trans WHERE trans_id = 15956 ORDER BY entry_id

http://tinypic.com/view.php?pic=2e38h3r&s=6

> My thinking is from what you say that is right, but let's identify the
> row, then you can switch from credit to debit by:
>
>
> If it is the AP account, it should be a debit on the payment not a
> credit.
>
>
> UPDATE acc_trans SET amount = -1 * amount WHERE entry_id = ....

So, from the screenshot and your suggestion, am I correctly concluding
that entry_id should be either 9827 or 9828?

Yes, 9828 is the one to flip.

Best Wishes,
Chris Travers 

thanks,
ario


> Best Wishes,
> Chris Travers
>
>         Thanks,
>         ario
>
>         A screenshot of the record can be found here:
>         http://tinypic.com/view.php?pic=1zq7gab&s=6
>
>
>
>         ------------------------------------------------------------------------------
>         LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free
>         Trial
>         Remotely access PCs and mobile devices and provide instant
>         support
>         Improve your efficiency, and focus on delivering more
>         value-add services
>         Discover what IT Professionals Know. Rescue delivers
>         http://p.sf.net/sfu/logmein_12329d2d
>         _______________________________________________
>         Ledger-smb-users mailing list
>         ..hidden..
>         https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
> ------------------------------------------------------------------------------
> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
> Remotely access PCs and mobile devices and provide instant support
> Improve your efficiency, and focus on delivering more value-add services
> Discover what IT Professionals Know. Rescue delivers
> http://p.sf.net/sfu/logmein_12329d2d
> _______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users