i am posting a gl journal into a NZ quickbooks copy using 6.0.0.174 that goes
Sales 444.44 GST 55.56 (entity is "IRD") (but have also tried without an entity with same result) Accounts Receivable 500 (entity is a customer account)
here is the sql statements
INSERT INTO JournalEntryCreditLine (TxnDate,JournalCredLnAcctRefListID,JournalCreditLineAmount,FQSaveToCache) Values ({d'2006-07-25'},'80000-1080012878',444.44,1) INSERT INTO JournalEntryCreditLine (TxnDate,JournalCredLnAcctRefListID,JournalCreditLineAmount,JournalCredLnEntityRefListID,FQSaveToCache) Values ({d'2006-07-25'},'50000-1080012515',55.56,'BB0000-1114737908',1) INSERT INTO JournalEntryDebitLine (TxnDate,JournalDebLnAcctRefListID,JournalDebitLineAmount,JournalDebitLineEntityRefListID,FQSaveToCache) Values ({d'2006-07-25'},'350000-1080017085',500,'27E0000-1153347225',1) INSERT INTO JournalEntry (TxnDate,RefNumber) Values ({d'2006-07-25'},'4150')
this results in an error (however the Quickbooks error message is not shown)
if i do this same transaction using the quickbooks screen, when i put the GST account (list id '50000-1080012515') onto the screen, it shows up a box at the top of the screen asking if this GST should be reported in the purchase or sales side. if i do not select where it should be reported i can not save the transaction from within quickbooks, however if i do select it the it saves.
when posting this through QODBC i cannot see where i can set whether it is purchase/sale and i think this is the reason i get an error.
i can also not see any place on the debti/credit lines for me to put a tax code, which would solve my problem because i could then just post 2 lines using the correct tax code (instead of having to post the third line to the gst account) |