On Thu, Dec 13, 2012 at 5:39 PM, ario <ledger-smb-us...@infopower.nl> wrote:
> On Wed, 2012-12-12 at 23:19 -0800, Chris Travers wrote:
> >
> >
> > On Wed, Dec 12, 2012 at 6:49 PM, ario <ledger-smb-us...@infopower.nl>
> > 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
> > Ledger-smb-users@lists.sourceforge.net
> > 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 Ledger-smb-users@lists.sourceforge.net
> 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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
