two errors on GL post journal entry
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?