dasaproject/exim_testimport.py

138 lines
4.7 KiB
Python

dt2 = [{'CustomerRef_FullName': 'JM Abadi',
'ARAccountRef_FullName': 'Accounts Receivable',
'TemplateRef_FullName': 'DBW Invoice (11%)',
'TxnDate': '2022-08-26',
'RefNumber': '10671',
'BillAddress_Addr1': 'JM Abadi',
'BillAddress_Addr2': 'Jl. Raya Ps. Minggu No. 75',
'BillAddress_Addr3': None,
'BillAddress_Addr4': None,
'BillAddress_Addr5': None,
'BillAddress_City': None,
'BillAddress_State': None,
'BillAddress_PostalCode': None,
'BillAddress_Country': None,
'BillAddress_Note': None,
'ShipAddress_Addr1': 'JM Abadi',
'ShipAddress_Addr2': 'Jl. Raya Ps. Minggu No. 75',
'ShipAddress_Addr3': None,
'ShipAddress_Addr4': None,
'ShipAddress_Addr5': None,
'ShipAddress_City': None,
'ShipAddress_State': None,
'ShipAddress_PostalCode': None,
'ShipAddress_Country': None,
'ShipAddress_Note': None,
'TermsRef_FullName': '30 Hari',
'DueDate': '2022-09-25',
'SalesRepRef_FullName': 'W',
'ShipDate': '2022-08-26',
'IsToBePrinted': 'false',
'IsToBeEmailed': 'false',
'InvoiceLineAdd': [{'Quantity': '12',
'UnitOfMeasure': 'Box',
'Rate': '35000',
'Amount': '420000.00',
'LinkToTxn_TxnID': 'A289A-1661495309',
'LinkToTxn_TxnLineID': 'A289C-1661495309'},
{'Quantity': '6',
'UnitOfMeasure': 'Box',
'Rate': '122500',
'Amount': '735000.00',
'LinkToTxn_TxnID': 'A289A-1661495309',
'LinkToTxn_TxnLineID': 'A289D-1661495309'}]},
{'CustomerRef_FullName': 'JM Abadi',
'ARAccountRef_FullName': 'Accounts Receivable',
'TemplateRef_FullName': 'DBW Invoice (11%)',
'TxnDate': '2022-08-26',
'RefNumber': '10671',
'BillAddress_Addr1': 'JM Abadi',
'BillAddress_Addr2': 'Jl. Raya Ps. Minggu No. 75',
'BillAddress_Addr3': None,
'BillAddress_Addr4': None,
'BillAddress_Addr5': None,
'BillAddress_City': None,
'BillAddress_State': None,
'BillAddress_PostalCode': None,
'BillAddress_Country': None,
'BillAddress_Note': None,
'ShipAddress_Addr1': 'JM Abadi',
'ShipAddress_Addr2': 'Jl. Raya Ps. Minggu No. 75',
'ShipAddress_Addr3': None,
'ShipAddress_Addr4': None,
'ShipAddress_Addr5': None,
'ShipAddress_City': None,
'ShipAddress_State': None,
'ShipAddress_PostalCode': None,
'ShipAddress_Country': None,
'ShipAddress_Note': None,
'TermsRef_FullName': '30 Hari',
'DueDate': '2022-09-25',
'SalesRepRef_FullName': 'W',
'ShipDate': '2022-08-26',
'IsToBePrinted': 'false',
'IsToBeEmailed': 'false',
'InvoiceLineAdd': [{'Quantity': '12',
'UnitOfMeasure': 'Box',
'Rate': '35000',
'Amount': '420000.00',
'LinkToTxn_TxnID': 'A289A-1661495309',
'LinkToTxn_TxnLineID': 'A289C-1661495309'},
{'Quantity': '6',
'UnitOfMeasure': 'Box',
'Rate': '122500',
'Amount': '735000.00',
'LinkToTxn_TxnID': 'A289A-1661495309',
'LinkToTxn_TxnLineID': 'A289D-1661495309'}]}]
# print(dt)
dt = {'CustomerRef_FullName': 'JM Abadi',
'ARAccountRef_FullName': 'Accounts Receivable',
'TemplateRef_FullName': 'DBW Invoice (11%)',
'TxnDate': '2022-08-26',
'RefNumber': '10671',
'BillAddress_Addr1': 'JM Abadi',
'BillAddress_Addr2': 'Jl. Raya Ps. Minggu No. 75',
'BillAddress_Addr3': None,
'BillAddress_Addr4': None,
'BillAddress_Addr5': None,
'BillAddress_City': None,
'BillAddress_State': None,
'BillAddress_PostalCode': None,
'BillAddress_Country': None,
'BillAddress_Note': None,
'ShipAddress_Addr1': 'JM Abadi',
'ShipAddress_Addr2': 'Jl. Raya Ps. Minggu No. 75',
'ShipAddress_Addr3': None,
'ShipAddress_Addr4': None,
'ShipAddress_Addr5': None,
'ShipAddress_City': None,
'ShipAddress_State': None,
'ShipAddress_PostalCode': None,
'ShipAddress_Country': None,
'ShipAddress_Note': None,
'TermsRef_FullName': '30 Hari',
'DueDate': '2022-09-25',
'SalesRepRef_FullName': 'W',
'ShipDate': '2022-08-26',
'IsToBePrinted': 'false',
'IsToBeEmailed': 'false',
'InvoiceLineAdd': [{'Quantity': '12',
'UnitOfMeasure': 'Box',
'Rate': '35000',
'Amount': '420000.00',
'LinkToTxn_TxnID': 'A289A-1661495309',
'LinkToTxn_TxnLineID': 'A289C-1661495309'},
{'Quantity': '6',
'UnitOfMeasure': 'Box',
'Rate': '122500',
'Amount': '735000.00',
'LinkToTxn_TxnID': 'A289A-1661495309',
'LinkToTxn_TxnLineID': 'A289D-1661495309'}]}
from QBClass.QBClasses import InvoiceAdd
# IA = InvoiceAdd(**dt, debug=True)
IA = InvoiceAdd(*dt2, debug=True) #a list
print(IA.all())