def test_create(self):
bill_payment = BillPayment()
bill_payment.PayType = "Check"
bill_payment.TotalAmt = 200
bill_payment.PrivateNote = "Private Note"
vendor = Vendor.all(max_results=1, qb=self.qb_client)[0]
bill_payment.VendorRef = vendor.to_ref()
bill_payment.CheckPayment = CheckPayment()
account = Account.where("AccountSubType = 'Checking'", qb=self.qb_client)[0]
bill_payment.CheckPayment.BankAccountRef = account.to_ref()
ap_account = Account.where("AccountSubType = 'AccountsPayable'", qb=self.qb_client)[0]
bill_payment.APAccountRef = ap_account.to_ref()
bill = Bill.all(max_results=1, qb=self.qb_client)[0]
line = BillPaymentLine()
line.LinkedTxn.append(bill.to_linked_txn())
line.Amount = 200
bill_payment.Line.append(line)
bill_payment.save(qb=self.qb_client)
query_bill_payment = BillPayment.get(bill_payment.Id, qb=self.qb_client)
self.assertEquals(query_bill_payment.PayType, "Check")
self.assertEquals(query_bill_payment.TotalAmt, 200.0)
self.assertEquals(query_bill_payment.PrivateNote, "Private Note")
self.assertEquals(len(query_bill_payment.Line), 1)
self.assertEquals(query_bill_payment.Line[0].Amount, 200.0)
def test_create(self):
bill_payment = BillPayment()
bill_payment.PayType = "Check"
bill_payment.TotalAmt = 200
bill_payment.PrivateNote = "Private Note"
vendor = Vendor.all(max_results=1)[0]
bill_payment.VendorRef = vendor.to_ref()
bill_payment.CheckPayment = CheckPayment()
account = Account.where("AccountSubType = 'Checking'")[0]
bill_payment.CheckPayment.BankAccountRef = account.to_ref()
ap_account = Account.where("AccountSubType = 'AccountsPayable'")[0]
bill_payment.APAccountRef = ap_account.to_ref()
bill = Bill.all(max_results=1)[0]
line = BillPaymentLine()
line.LinkedTxn.append(bill.to_linked_txn())
line.Amount = 200
bill_payment.Line.append(line)
bill_payment.save()
query_bill_payment = BillPayment.get(bill_payment.Id)
self.assertEquals(query_bill_payment.PayType, "Check")
self.assertEquals(query_bill_payment.TotalAmt, 200.0)
self.assertEquals(query_bill_payment.PrivateNote,"Private Note")
self.assertEquals(len(query_bill_payment.Line), 1)
self.assertEquals(query_bill_payment.Line[0].Amount, 200.0)
def setUp(self):
self.account_number = datetime.now().strftime('%d%H%M')
self.name = "Test Item {0}".format(self.account_number)
self.income_account = Account.where(
"AccountType = 'Income' and AccountSubType = 'SalesOfProductIncome'", max_results=1)[0]
self.expense_account = Account.where("AccountSubType = 'SuppliesMaterialsCogs'", max_results=1)[0]
self.asset_account = Account.where("AccountSubType = 'Inventory'", max_results=1)[0]
def setUp(self):
super(ItemTest, self).setUp()
self.account_number = datetime.now().strftime('%d%H%M')
self.name = "Test Item {0}".format(self.account_number)
self.income_account = Account.where(
"AccountType = 'Income' and AccountSubType = 'SalesOfProductIncome'", max_results=1, qb=self.qb_client)[0]
self.expense_account = Account.where(
"AccountSubType = 'SuppliesMaterialsCogs'", max_results=1, qb=self.qb_client)[0]
self.asset_account = Account.where("AccountSubType = 'Inventory'", max_results=1, qb=self.qb_client)[0]
def test_create(self):
accounts = Account.where(
"Classification = 'Asset' AND FullyQualifiedName != 'Accounts Receivable (A/R)'",
max_results=2,
qb=self.qb_client)
from_account = accounts[0]
to_account = accounts[1]
transfer = Transfer()
transfer.Amount = 100
transfer.FromAccountRef = from_account.to_ref()
transfer.ToAccountRef = to_account.to_ref()
transfer.save(qb=self.qb_client)
query_transfer = Transfer.get(transfer.Id, qb=self.qb_client)
self.assertEquals(query_transfer.Id, transfer.Id)
self.assertEquals(query_transfer.Amount, 100)
self.assertEquals(query_transfer.FromAccountRef.value, from_account.Id)
self.assertEquals(query_transfer.ToAccountRef.value, to_account.Id)
# reset transfer (so the from_account doesn't run out of cash)
transfer = Transfer()
transfer.Amount = 100
transfer.FromAccountRef = to_account.to_ref()
transfer.ToAccountRef = from_account.to_ref()
transfer.save(qb=self.qb_client)
def test_create(self):
accounts = Account.where(
"Classification = 'Asset' AND FullyQualifiedName != 'Accounts Receivable (A/R)'",
max_results=2, qb=self.qb_client)
from_account = accounts[0]
to_account = accounts[1]
transfer = Transfer()
transfer.Amount = 100
transfer.FromAccountRef = from_account.to_ref()
transfer.ToAccountRef = to_account.to_ref()
transfer.save(qb=self.qb_client)
query_transfer = Transfer.get(transfer.Id, qb=self.qb_client)
self.assertEquals(query_transfer.Id, transfer.Id)
self.assertEquals(query_transfer.Amount, 100)
self.assertEquals(query_transfer.FromAccountRef.value, from_account.Id)
self.assertEquals(query_transfer.ToAccountRef.value, to_account.Id)
# reset transfer (so the from_account doesn't run out of cash)
transfer = Transfer()
transfer.Amount = 100
transfer.FromAccountRef = to_account.to_ref()
transfer.ToAccountRef = from_account.to_ref()
transfer.save(qb=self.qb_client)
def lookup_deposit_account(account_name):
try:
default_deposit_account_result = Account.where("Active = True AND Name = '" + DEFAULT_DEPOSIT_ACCOUNT + "'", qb=qb_client)
if default_deposit_account_result is not None:
return default_deposit_account_result[0].Id
except Exception as e:
logging.error("Error assigning default account info [{}], Error:{}".format(DEFAULT_DEPOSIT_ACCOUNT, e.message))
def setUp(self):
self.qb_client = QuickBooks(
sandbox=True,
consumer_key=os.environ.get('CONSUMER_KEY'),
consumer_secret=os.environ.get('CONSUMER_SECRET'),
access_token=os.environ.get('ACCESS_TOKEN'),
access_token_secret=os.environ.get('ACCESS_TOKEN_SECRET'),
company_id=os.environ.get('COMPANY_ID')
)
self.account_number = datetime.now().strftime('%d%H%M')
self.name = "Test Item {0}".format(self.account_number)
self.income_account = Account.where(
"AccountType = 'Income' and AccountSubType = 'SalesOfProductIncome'", max_results=1, qb=self.qb_client)[0]
self.expense_account = Account.where(
"AccountSubType = 'SuppliesMaterialsCogs'", max_results=1, qb=self.qb_client)[0]
self.asset_account = Account.where("AccountSubType = 'Inventory'", max_results=1, qb=self.qb_client)[0]
def setUp(self):
self.session_manager = Oauth1SessionManager(
sandbox=True,
consumer_key=os.environ.get('CONSUMER_KEY'),
consumer_secret=os.environ.get('CONSUMER_SECRET'),
access_token=os.environ.get('ACCESS_TOKEN'),
access_token_secret=os.environ.get('ACCESS_TOKEN_SECRET'),
)
self.qb_client = QuickBooks(
session_manager=self.session_manager,
sandbox=True,
company_id=os.environ.get('COMPANY_ID')
)
self.account_number = datetime.now().strftime('%d%H%M')
self.name = "Test Item {0}".format(self.account_number)
self.income_account = Account.where(
"AccountType = 'Income' and AccountSubType = 'SalesOfProductIncome'", max_results=1, qb=self.qb_client)[0]
self.expense_account = Account.where(
"AccountSubType = 'SuppliesMaterialsCogs'", max_results=1, qb=self.qb_client)[0]
self.asset_account = Account.where("AccountSubType = 'Inventory'", max_results=1, qb=self.qb_client)[0]
def test_create(self):
credit_card_account = Account()
credit_card_account.Name = "Credit Card Account {0}".format(
self.account_number)
credit_card_account.AccountType = "Credit Card"
credit_card_account.AccountSubType = "CreditCard"
credit_card_account.save(qb=self.qb_client)
accounts = Account.where(
"Classification = 'Asset' AND FullyQualifiedName != 'Accounts Receivable (A/R)'",
max_results=1,
qb=self.qb_client)
from_account = accounts[0]
to_account = credit_card_account
credit_card_payment = CreditCardPayment()
credit_card_payment.Amount = 100
credit_card_payment.BankAccountRef = from_account.to_ref()
credit_card_payment.CreditCardAccountRef = to_account.to_ref()
credit_card_payment.save(qb=self.qb_client)
query_credit_card_payment = CreditCardPayment.get(
credit_card_payment.Id, qb=self.qb_client)
self.assertEquals(query_credit_card_payment.Id, credit_card_payment.Id)
self.assertEquals(query_credit_card_payment.Amount, 100)
self.assertEquals(query_credit_card_payment.BankAccountRef.value,
from_account.Id)
self.assertEquals(query_credit_card_payment.CreditCardAccountRef.value,
to_account.Id)
# reset transfer (so the from_account doesn't run out of cash)
# I wonder if we can do a transfer from credit_card_account to a bank_account
transfer = Transfer()
transfer.Amount = 100
transfer.FromAccountRef = to_account.to_ref()
transfer.ToAccountRef = from_account.to_ref()
transfer.save(qb=self.qb_client)
