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? 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
