« Return to Thread: two errors on GL post journal entry

two errors on GL post journal entry

by PCS-Lists :: Rate this Message:

Reply to Author | View in Thread

Nathan,

perp svn 3345

when posting a journal entry appears this:
Invalid SQL: INSERT INTO perp_bank_ledger (trans_id,line_no,bank_account,exchange_rate,payment_method,amount,currency) VALUES (10,0,'150347',1,0,856,'BRL'):
Unknown column 'line_no' in 'field list'


then I created a column name:line_no, type:INT, lenght:11 and clear the entries of this table.
when trying to post again:

Invalid SQL: INSERT INTO perp_bank_ledger (trans_id,line_no,bank_account,exchange_rate,payment_method,amount,currency) VALUES (11,1,'1503470',1,0,-856,'BRL'):
Duplicate entry '11' for key 1


And there's no entries for this table.

Can you help me?

 « Return to Thread: two errors on GL post journal entry