def transactionToDict(transaction, entities):
if transaction is None:
return None
else:
simple_transaction = {}
simple_transaction['guid'] = transaction.GetGUID().to_string()
simple_transaction['num'] = transaction.GetNum()
simple_transaction['notes'] = transaction.GetNotes()
simple_transaction['is_closing_txn'] = transaction.GetIsClosingTxn()
if 'splits' in entities:
simple_transaction['splits'] = []
for split in transaction.GetSplitList():
if type(split) != Split:
split = Split(instance=split)
simple_transaction['splits'].append(
splitToDict(split, ['account']))
simple_transaction['count_splits'] = transaction.CountSplits()
simple_transaction['has_reconciled_splits'] = \
transaction.HasReconciledSplits()
simple_transaction['currency'] = transaction.GetCurrency(
).get_mnemonic()
simple_transaction['imbalance_value'] = transaction.GetImbalanceValue(
).to_double()
simple_transaction['is_balanced'] = transaction.IsBalanced()
# This function changes at some point between Guncash/Python 2/3
if sys.version_info >= (3, 0):
simple_transaction['date'] = transaction.GetDate().strftime(
'%Y-%m-%d')
simple_transaction['date_posted'] = transaction.RetDatePosted(
).strftime('%Y-%m-%d')
simple_transaction['date_entered'] = transaction.RetDateEntered(
).strftime('%Y-%m-%d')
simple_transaction['date_due'] = transaction.RetDateDue().strftime(
'%Y-%m-%d')
else:
simple_transaction['date'] = transaction.GetDate()
simple_transaction['date_posted'] = transaction.RetDatePostedTS(
).strftime('%Y-%m-%d')
simple_transaction['date_entered'] = transaction.RetDateEnteredTS(
).strftime('%Y-%m-%d')
simple_transaction['date_due'] = transaction.RetDateDueTS(
).strftime('%Y-%m-%d')
simple_transaction['void_status'] = transaction.GetVoidStatus()
simple_transaction['void_time'] = transaction.GetVoidTime().strftime(
'%Y-%m-%d')
simple_transaction['description'] = transaction.GetDescription()
return simple_transaction
def new_transaction(root, book, out, USD):
# global existing_customers, existing_vendors
# Assemble the invoice dictionary
isinvoice = False
isbill = False
isinvpayment = False
isbillpayment = False
isentry = False
for row in out:
if 'type' in row.keys():
rtype = row['type']
else:
rtype = ''
if rtype:
new_rtype, date_opened = get_rtype(row)
new_rtype['entries'] = []
if rtype == 'Invoice':
isinvoice = True
elif rtype == 'Payment':
isinvpayment = True
elif rtype == 'Sales Tax Payment':
isentry = True
elif rtype == 'Paycheck':
continue
elif rtype == 'Bill':
isbill = True
elif rtype == 'Credit':
isbill = True
elif rtype == 'Bill Pmt -CCard':
isbillpayment = True
else:
isentry = True
elif 'account' in row.keys():
if row['account']:
test, new_entry = get_entries(row, date_opened)
if test == 'tax_table':
new_rtype['tax_table'] = new_entry['tax_table']
new_rtype['tax_rate'] = new_entry['price']
elif test == 'entry':
new_rtype['entries'].append(new_entry)
# No account in total row, so process entries
elif isentry:
trans1 = Transaction(book)
trans1.BeginEdit()
trans1.SetCurrency(USD)
if 'owner' in new_rtype.keys():
trans1.SetDescription(new_rtype['owner'])
trans1.SetDateEnteredTS(
new_rtype['date_opened'] + datetime.timedelta(microseconds=1))
trans1.SetDatePostedTS(
new_rtype['date_opened'] + datetime.timedelta(microseconds=1))
if 'num' in new_rtype.keys():
trans1.SetNum(new_rtype['num'])
if 'notes' in new_rtype.keys():
trans1.SetNotes = new_rtype['notes']
if new_rtype['account'] != '-SPLIT-':
split1 = Split(book)
split1.SetParent(trans1)
# if new_rtype['type'] == 'Deposit':
# new_rtype['amount'] = new_rtype['amount'].neg()
split1.SetAccount(root.lookup_by_name(new_rtype['account']))
# if split1.GetAccount() == ACCT_TYPE_EQUITY:
# isequity = True
# new_rtype['amount'] = new_rtype['amount'].neg()
# else:
# isequity = False
split1.SetValue(new_rtype['amount'])
if 'owner' in new_rtype.keys():
split1.SetMemo(new_rtype['owner'])
# split1.SetAction(get_action(new_rtype['type']))
for entry in new_rtype['entries']:
if 'amount' in entry.keys():
split1 = Split(book)
split1.SetParent(trans1)
# if isequity:
# entry['amount'] = entry['amount'].neg()
split1.SetValue(entry['amount'])
split1.SetAccount(root.lookup_by_name(entry['account']))
if 'description' in entry.keys():
split1.SetMemo(entry['description'])
# split1.SetAction(get_action(new_rtype['type']))
trans1.CommitEdit()
isentry = False
elif isinvpayment:
try:
owner = GetCustomers.iscustomer(new_rtype['owner'])
assert (isinstance(owner, Customer))
except AssertionError:
print 'Customer %s does not exist; skipping' % \
new_rtype['owner']
continue
xfer_acc = root.lookup_by_name(new_rtype['account'])
date_opened = new_rtype['date_opened']
if 'notes' in new_rtype.keys():
notes = new_rtype['notes']
else:
notes = ''
if 'num' in new_rtype.keys():
num = new_rtype['num']
else:
num = ''
for entry in new_rtype['entries']:
posted_acc = root.lookup_by_name(entry['account'])
owner.ApplyPayment(None, None, posted_acc, xfer_acc,
new_rtype['amount'], entry['amount'],
date_opened, notes, num, False)
isinvpayment = False
elif isbillpayment:
try:
owner = GetVendors.isvendor(new_rtype['owner'])
assert (isinstance(owner, Vendor))
except AssertionError:
print 'Vendor %s does not exist; skipping' % \
new_rtype['owner']
continue
xfer_acc = root.lookup_by_name(new_rtype['account'])
date_opened = new_rtype['date_opened']
if 'notes' in new_rtype.keys():
notes = new_rtype['notes']
else:
notes = ''
if 'num' in new_rtype.keys():
num = new_rtype['num']
else:
num = ''
for entry in new_rtype['entries']:
posted_acc = root.lookup_by_name(entry['account'])
owner.ApplyPayment(None, None, posted_acc, xfer_acc,
new_rtype['amount'], entry['amount'],
date_opened, notes, num, False)
isbillpayment = False
# new_customer.ApplyPayment(self, invoice, posted_acc, xfer_acc, amount,
# exch, date, memo, num)
# new_customer.ApplyPayment(None, None, a2, a6, GncNumeric(100,100),
# GncNumeric(1), datetime.date.today(), "", "", False)
# invoice_customer.ApplyPayment(None, a6, GncNumeric(7,100),
# GncNumeric(1), datetime.date.today(), "", "")
elif isbill:
# put item on entries!!!
# Accumulate splits
# QuickBooks Journal has a total row after splits,
# which is used to detect the end of splits.
try:
owner = GetVendors.isvendor(new_rtype['owner'])
assert (isinstance(owner, Vendor))
except AssertionError:
print 'Vendor %s does not exist; skipping' % \
new_rtype['owner']
continue
try:
cid = book.BillNextID(owner)
# save Bill ID and tax rate for xml overlay.
# ReplaceTax.bill(cid, new_rtype['tax_rate'])
except:
raise
bill_vendor = Bill(book, cid, USD, owner)
vendor_extract = bill_vendor.GetOwner()
assert (isinstance(vendor_extract, Vendor))
assert (vendor_extract.GetName() == owner.GetName())
if new_rtype['type'] == 'Credit':
bill_vendor.SetIsCreditNote(True)
bill_vendor.SetDateOpened(new_rtype['date_opened'])
if 'notes' in new_rtype.keys():
bill_vendor.SetNotes(new_rtype['notes'])
if 'num' in new_rtype.keys():
bill_vendor.SetBillingID(new_rtype['num'])
if 'tax_table' in new_rtype.keys():
tax_table = book.TaxTableLookupByName(new_rtype['tax_table'])
assert (isinstance(tax_table, TaxTable))
# Add the entries
for entry in new_rtype['entries']:
# skip entries that link COGS and Billentory
if 'quantity' not in entry.keys():
continue
bill_entry = Entry(book, bill_vendor)
account = root.lookup_by_name(entry['account'])
assert (isinstance(account, Account))
bill_entry.SetBillAccount(account)
if 'tax_table' in new_rtype.keys():
bill_entry.SetBillTaxTable(tax_table)
bill_entry.SetBillTaxIncluded(False)
else:
bill_entry.SetBillTaxable(False)
if 'description' in entry.keys():
bill_entry.SetDescription(entry['description'])
bill_entry.SetQuantity(entry['quantity'])
bill_entry.SetBillPrice(entry['price'])
bill_entry.SetDateEntered(entry['date'])
bill_entry.SetDate(entry['date'])
if 'notes' in entry.keys():
bill_entry.SetNotes(entry['notes'])
isbill = False
# Post bill
account = root.lookup_by_name(new_rtype['account'])
assert (isinstance(account, Account))
bill_vendor.PostToAccount(account, new_rtype['date_opened'], new_rtype['date_opened'],
str(new_rtype['owner']), True, False)
elif isinvoice:
# put item on entries!!!
# Accumulate splits
# QuickBooks Journal has a total row after splits,
# which is used to detect the end of splits.
try:
owner = GetCustomers.iscustomer(new_rtype['owner'])
assert (isinstance(owner, Customer))
except AssertionError:
print 'Customer %s does not exist; skipping' % \
new_rtype['owner']
continue
try:
cid = book.InvoiceNextID(owner)
# save Invoice ID and tax rate for xml overlay.
# ReplaceTax.invoice(cid, new_rtype['tax_rate'])
except:
raise
invoice_customer = Invoice(book, cid, USD, owner)
customer_extract = invoice_customer.GetOwner()
assert (isinstance(customer_extract, Customer))
assert (customer_extract.GetName() == owner.GetName())
invoice_customer.SetDateOpened(new_rtype['date_opened'])
if 'notes' in new_rtype.keys():
invoice_customer.SetNotes(new_rtype['notes'])
if 'num' in new_rtype.keys():
invoice_customer.SetBillingID(new_rtype['num'])
if 'tax_table' in new_rtype.keys():
tax_table = book.TaxTableLookupByName(new_rtype['tax_table'])
assert (isinstance(tax_table, TaxTable))
# assert( not isinstance( \
# book.InvoiceLookupByID(new_rtype['id']), Invoice))
# Add the entries
for entry in new_rtype['entries']:
invoice_entry = Entry(book, invoice_customer)
account = root.lookup_by_name(entry['account'])
assert (isinstance(account, Account))
invoice_entry.SetInvAccount(account)
if 'tax_table' in new_rtype.keys():
invoice_entry.SetInvTaxTable(tax_table)
invoice_entry.SetInvTaxIncluded(False)
else:
invoice_entry.SetInvTaxable(False)
invoice_entry.SetDescription(entry['description'])
invoice_entry.SetQuantity(entry['quantity'])
invoice_entry.SetInvPrice(entry['price'])
invoice_entry.SetDateEntered(entry['date'])
invoice_entry.SetDate(entry['date'])
if 'notes' in entry.keys():
invoice_entry.SetNotes(entry['notes'])
isinvoice = False
# Post invoice
account = root.lookup_by_name(new_rtype['account'])
assert (isinstance(account, Account))
invoice_customer.PostToAccount(account, new_rtype['date_opened'], new_rtype['date_opened'],
str(new_rtype['owner']), True, False)
# ReplaceTax.replace(gnc_file.path)
return 0