Hi, I have setup receivables and beginning balances for customers using debit and credit memos and putting both sides of the entry to receivables. I am getting the error below when I try to do the same for vendors in payables. I tried using the payables acount, I tried using an expense account, I tried with the VAT selected and with it unselected but always the same error.
ERROR: postGLSeries commit failed with -5
CONTEXT: PL/pgSQL function createapcreditmemo(integer,integer,integer,text,text,date,numeric,text,integer,date,integer,integer,integer) line 120 at RAISE
(P0001) QPSQL: Unable to create query
The Query:
SELECT createAPCreditMemo( :apopen_id, :vend_id, fetchJournalNumber(‘AP-MISC’), :apopen_docnumber, :apopen_ponumber, :apopen_docdate, :apopen_amount, :apopen_notes, :apopen_accnt_id, :apopen_duedate, :apopen_terms_id, :curr_id, :apopen_taxzone_id ) AS result;
Bound Values:
:apopen_accnt_id: 89
:apopen_amount: 235.47
:apopen_docdate: 2019-03-31
:apopen_docnumber: 1
:apopen_duedate: 2019-03-31
:apopen_id: 5
:apopen_notes:
:apopen_ponumber:
:apopen_taxzone_id: 1
:apopen_terms_id: 1
:curr_id: 3
:vend_id: 2
Any help?
Kurt