def test_Purchase_Order_Current_Search(self): ''' Tests Accpac's ability to search for sales orders in current fiscal period ''' try: AP = accpac_class.Accpac() Teststring='29727' Result = AP.Purchase_Order_Current_Search(purno=Teststring) self.assertEqual(Result[0][0], '29727') self.assertEqual(Result[0][1], 'GECAPT') self.assertEqual(Result[0][2], 'GE Capital Corporation') self.assertEqual(Result[0][3], '-1120') self.assertEqual(Result[0][4], '2005-10-03') self.assertEqual(Result[0][5], '0') self.assertEqual(Result[0][6], '2005-10-03') self.assertEqual(Result[0][7], 'FG') self.assertEqual(Result[0][8], 'UPS') self.assertEqual(Result[0][9], '') self.assertEqual(Result[0][10], 'R') self.assertEqual(Result[0][11], '') self.assertEqual(Result[0][12], 'AH') self.assertEqual(Result[0][13], '2005-10-03') except Exception as TPOCSError: TPOCSError = str(TPOCSError) print (TPOCSError)
def test_Purchase_Order_Current_Items_Search(self): ''' Tests Accpac's ability to search for line items ''' try: AP = accpac_class.Accpac() Teststring='29727' Result = AP.Purchase_Order_Current_Items(purno=Teststring) self.assertEqual(Result[0][0], '29727') self.assertEqual(Result[0][1], '5060-002') self.assertEqual(Result[0][2], 'Printer, C750N, Lexmark') self.assertEqual(Result[0][3], '280') self.assertEqual(Result[0][4], '-4') self.assertEqual(Result[0][5], '0') self.assertEqual(Result[0][6], '2005-10-03') self.assertEqual(Result[0][7], '-1120') self.assertEqual(Result[0][8], '1899-12-30') self.assertEqual(Result[0][9], '2005-10-03') self.assertEqual(Result[0][10], '1140-000') self.assertEqual(Result[0][11], 'FG') self.assertEqual(Result[0][12], '') self.assertEqual(Result[0][13], 'R') self.assertEqual(Result[0][14], '1') except Exception as TPOCISError: TPOCISError = str(TPOCISError) print (TPOCISError)
def test_Purchase_Order_Current_Address_Search(self): ''' Tests Accpac's ability to search for A Purchase Orders address details ''' try: AP = accpac_class.Accpac() Teststring='77901' Result = AP.Purchase_Order_Current_Address(purno=Teststring) self.assertEqual(Result[0][0], '77901') self.assertEqual(Result[0][1], 'Radiant Systems, Inc') self.assertEqual(Result[0][2], '6610 Shiloh Rd. East') self.assertEqual(Result[0][3], '') self.assertEqual(Result[0][4], '') self.assertEqual(Result[0][5], 'Radiant Systems Unfinished Goods-No') self.assertEqual(Result[0][6], '') self.assertEqual(Result[0][7], '') self.assertEqual(Result[0][8], '') self.assertEqual(Result[0][9], 'SC') self.assertEqual(Result[0][10], '2009-10-12') self.assertEqual(Result[0][11], '30005') self.assertEqual(Result[0][12], 'GA') self.assertEqual(Result[0][13], 'Alpharetta') except Exception as TPOCASError: TPOCASError = str(TPOCASError) print (TPOCASError)
def test_Purchase_Order_Historical_Items_Search(self): ''' Tests Accpac's ability to search for line items ''' try: AP = accpac_class.Accpac() Teststring='96841' Result = AP.Purchase_Order_History_Items(purno=Teststring) self.assertEqual(Result[0][0], '96841') self.assertEqual(Result[0][1], '40Y9033') self.assertEqual(Result[0][2], 'Hard Drive, 40GB 7200RPM, SATA') self.assertEqual(Result[0][3], '0') self.assertEqual(Result[0][4], '1') self.assertEqual(Result[0][5], '0') self.assertEqual(Result[0][6], '2012-01-01') self.assertEqual(Result[0][7], '0') self.assertEqual(Result[0][8], '2012-01-01') self.assertEqual(Result[0][9], '2012-01-01') self.assertEqual(Result[0][10], '1140-000') self.assertEqual(Result[0][11], 'YC-UFG') self.assertEqual(Result[0][12], 'X') self.assertEqual(Result[0][13], '') self.assertEqual(Result[0][14], '1') except Exception as TPOHIError: TPOHIError = str(TPOHIError) print (TPOHIError)
def test_Item_Header_Search(self): ''' Tests the Item Master ledger/header info search Icitem ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Item_Header_Search(item=Teststring) self.assertEqual(Result[0][0],'TEST') self.assertEqual(Result[0][1], 'Test P/N') self.assertEqual(Result[0][2],'') self.assertEqual(Result[0][3],'') self.assertEqual(Result[0][4],'') self.assertEqual(Result[0][5],'') self.assertEqual(Result[0][6], 'TEST60') self.assertEqual(Result[0][7], 'TEST70') self.assertEqual(Result[0][8], '') self.assertEqual(Result[0][9], '') self.assertEqual(Result[0][10], '') self.assertEqual(Result[0][11], '4') self.assertEqual(Result[0][12], '2017-04-11') self.assertEqual(Result[0][13], '2017-08-08') self.assertEqual(Result[0][14], '1899-12-30') self.assertEqual(Result[0][15], '2017-08-17') self.assertEqual(Result[0][16], '0') del AP
def test_Open_SO_Search(self): ''' Tests the Open Sales order search tool ''' AP = accpac_class.Accpac() Result = AP.Open_Sales_Order_Search(item="TEST") self.assertEqual(Result[0][0],'HSG')
def test_Hist_SO_Search(self): ''' Tests the sales order history search tool ''' AP = accpac_class.Accpac() Result = AP.Sales_History_Order_Search(item="TEST") self.assertEqual(Result[0][0], 'NUKE') self.assertEqual(Result[0][1], '240907') self.assertEqual(Result[0][2], '0') self.assertEqual(Result[0][3], '1') self.assertEqual(Result[0][4], '2014-10-06')
def test_SAS(self): ''' Tests the strip and string. Feeds in a unicode string with spaces Expects back a regular string ''' AP = accpac_class.Accpac() TestString = 'bob ' TestString = TestString.encode('utf-8') TheReturnedString = AP.SAS(Obj=TestString) self.assertEqual(TheReturnedString, 'bob') del AP
def test_Open_PO_Search(self): ''' Tests the sales orders that searches this fiscal period ''' AP = accpac_class.Accpac() Teststring = "TEST" Result = AP.Purchase_Search(item=Teststring) self.assertEqual(Result[0][0], '175632') self.assertEqual(Result[0][1], '03820') self.assertEqual(Result[0][2], '0') self.assertEqual(Result[0][3], '3') self.assertEqual(Result[0][4], '0') self.assertEqual(Result[0][5], '')
def test_Hist_PO_Search(self): ''' Tests the History Purchase order search tool ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Purchase_History_Search(item=Teststring) self.assertEqual(Result[0][0], '156524') self.assertEqual(Result[0][1], 'CPW') self.assertEqual(Result[0][2], '0') self.assertEqual(Result[0][3], '1') self.assertEqual(Result[0][4], '1') self.assertEqual(Result[0][5], 'C')
def test_Item_Cost_Search(self): ''' Tests the item cost tier search for current period ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Item_Cost_Search(item=Teststring) self.assertEqual(Result[0][0], 'TEST') self.assertEqual(Result[0][1],'FG') self.assertEqual(Result[0][2], '1075077') self.assertEqual(Result[0][3],'0') self.assertEqual(Result[0][4],'0') self.assertEqual(Result[0][5],'KW') del AP
def test_Sales_Comment_Search(self): ''' Tests the sales order comment search function ''' try: AP = accpac_class.Accpac() Teststring = '41877' Result = AP.Sales_Order_Comment_Current_Search(sono=Teststring) self.assertEqual(Result[0][0], '41877') self.assertEqual(Result[0][1], '') self.assertEqual(Result[0][2], 'GY') self.assertEqual(str(Result[0][3]), '2010-04-05') except Exception as TSCSError: TSCSError = str(TSCSError) print(TSCSError)
def test_Item_By_Location_Search(self): ''' Tests the QTY item search for current period by search location ''' AP = accpac_class.Accpac() Teststring = 'FG' Result = AP.Items_by_Location_Search(loctid=Teststring) self.assertEqual(Result[0][0],'CITIBANK3036') self.assertEqual(Result[0][1], 'FG') self.assertEqual(Result[0][2],'19') self.assertEqual(Result[0][3],'0') self.assertEqual(Result[0][4],'') self.assertEqual(Result[0][5],'') self.assertEqual(Result[0][6], '1') del AP
def test_Item_Search(self): ''' Tests the QTY item search for current period ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Item_Search(item=Teststring) self.assertEqual(Result[0][0],'TEST') self.assertEqual(Result[0][1], 'FG') self.assertEqual(Result[0][2],'2') self.assertEqual(Result[0][3],'0') self.assertEqual(Result[0][4],'TBT') self.assertEqual(Result[0][5],'TBT') self.assertEqual(Result[0][6], '15') del AP
def test_Purchase_Order_Current_Comments_Search(self): ''' Tests Accpac's ability to search for A Purchase Orders address details ''' try: AP = accpac_class.Accpac() Teststring='29727' Result = AP.Purchase_Order_Current_Comments(purno=Teststring) self.assertEqual(Result[0][0], '29727') self.assertEqual(Result[0][1], 'MC 5569 2850 0001 5429 11/12 Scott Johnson (858)') self.assertEqual(Result[0][2], 'AH') self.assertEqual(Result[0][3], '2005-10-03') except Exception as TPOCCSError: TPOCCSError = str(TPOCCSError) print (TPOCCSError)
def test_Item_Location_Search(self): ''' Tests the items at location search function for current fiscal period Iciloc ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Item_Location_Search(item=Teststring) self.assertEqual(Result[0][0], 'TEST') self.assertEqual(Result[0][1], 'WIP') self.assertEqual(Result[0][2], '0') self.assertEqual(Result[0][3], '0') self.assertEqual(Result[0][4], '0') self.assertEqual(Result[0][5], '0') self.assertEqual(str(Result[0][6]), '1899-12-30') self.assertEqual(str(Result[0][7]), '1899-12-30')
def test_Sales_Header_Current(self): ''' Tests the Sales order header search ''' AP = accpac_class.Accpac() Teststring = '41877' Result = AP.Sales_Order_Header_Current_Search(sono=Teststring) self.assertEqual(Result[0][0], '41877') self.assertEqual(Result[0][1], 'PCMALL') self.assertEqual(str(Result[0][2]), '2004-04-09') self.assertEqual(str(Result[0][3]), '2004-09-22') self.assertEqual(Result[0][4], 'FEDP') self.assertEqual(Result[0][5], '90010') self.assertEqual(Result[0][6], 'Net 30 Days') self.assertEqual(Result[0][7], '0') self.assertEqual(Result[0][8], '0')
def test_Summary_Item_Search(self): ''' Tests Accpac's ability to search run general item summary searches ''' try: AP = accpac_class.Accpac() Teststring='TESTEZ' Result = AP.Summary_Item_Search(item=Teststring) self.assertEqual(Result[0][0], 'TESTEZ') self.assertEqual(Result[0][1], 'Test EZ Drive') self.assertEqual(Result[0][2], '0') self.assertEqual(Result[0][3], '0') self.assertEqual(Result[0][4], '') self.assertEqual(Result[0][5], '1899-12-30') self.assertEqual(Result[0][6], '1899-12-30') self.assertEqual(Result[0][7], '1998-02-03') except Exception as TSISError: TSISError = str(TSISError) print (TSISError)
def test_AP_Header_Current(self): ''' Tests the search function to find invoices in accounts payable in current fiscal period Accpac table Apmast01 ''' AP = accpac_class.Accpac() Teststring = 'PO75299' Result = AP.Accounts_Payable_Current_Header(invno=Teststring) self.assertEqual(Result[0][0],'PO75299') self.assertEqual(Result[0][1], 'TMCOMP') self.assertEqual(Result[0][2],'') self.assertEqual(Result[0][3],'2009-06-15') self.assertEqual(Result[0][4],'2009-06-15') self.assertEqual(Result[0][5],'-31300') self.assertEqual(Result[0][6], '0') self.assertEqual(Result[0][7], 'PREPAY') self.assertEqual(Result[0][8], '25752') self.assertEqual(Result[0][9], '1002-000') self.assertEqual(Result[0][10], 'AH') del AP
def test_Summary_Purchase_Order_Search(self): ''' Tests Accpac's ability to search run general purchase order summary searches ''' try: AP = accpac_class.Accpac() Teststring='418' Result = AP.Summary_Sales_Order_Search(sono=Teststring) self.assertEqual(Result[0][0], '41877') self.assertEqual(Result[0][1], '') self.assertEqual(Result[0][2], '354285') self.assertEqual(Result[0][3], 'PCMALL') self.assertEqual(Result[0][4], '90010') self.assertEqual(Result[0][5], '2004-04-09') self.assertEqual(Result[0][6], '2004-09-22') self.assertEqual(Result[0][7], 'O') self.assertEqual(Result[0][8], '647002847740') except Exception as TSPOSError: TSPOSError = str(TSPOSError) print (''+str(TSPOSError))
def test_Summary_Sales_Order_Search(self): ''' Tests Accpac's ability to search run general sales order summary searches ''' try: AP = accpac_class.Accpac() Teststring='155510' Result = AP.Summary_Sales_Order_Search(sono=Teststring) self.assertEqual(Result[0][0], '155510') self.assertEqual(Result[0][1], 'C') self.assertEqual(Result[0][2], '196055') self.assertEqual(Result[0][3], 'YCREP') self.assertEqual(Result[0][4], '211') self.assertEqual(Result[0][5], '2012-01-01') self.assertEqual(Result[0][6], '2012-01-01') self.assertEqual(Result[0][7], '') self.assertEqual(Result[0][8], '') except Exception as TSSOSError: TSSOSError = str(TSSOSError) print (''+str(TSSOSError))
def test_Item_Transaction_Search(self): ''' Tests the item transaction history search for current fiscal period ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Item_Transaction_Search(item=Teststring) self.assertEqual(Result[0][0], '4287875') self.assertEqual(Result[0][1], '16') self.assertEqual(Result[0][2], 'FG') self.assertEqual(Result[0][3], 'TEST') self.assertEqual(Result[0][4], '1108452') self.assertEqual(Result[0][5], '') self.assertEqual(Result[0][6], 'R') self.assertEqual(Result[0][7], '') self.assertEqual(Result[0][8], '1') self.assertEqual(Result[0][9], '0') self.assertEqual(Result[0][10], '') self.assertEqual(Result[0][11], '769248') self.assertEqual(Result[0][12], 'DAMIONS')
def test_Sales_Header_History_Search(self): ''' Tests Accpac's ability to search for header entry records in the historical period. ''' try: AP = accpac_class.Accpac() Teststring='155510' Result = AP.Sales_Order_Header_History_Search(sono=Teststring) self.assertEqual(Result[0][0], '155510') self.assertEqual(Result[0][1], 'YCREP') self.assertEqual(Result[0][2], '196055') self.assertEqual(Result[0][3], 'C') self.assertEqual(Result[0][4], '0') self.assertEqual(Result[0][5], '79') self.assertEqual(Result[0][6], '2012-01-01') self.assertEqual(Result[0][7], '2012-01-01') self.assertEqual(Result[0][8], '') self.assertEqual(Result[0][9], '') except Exception as SOHErrorTest: print(SOHErrorTest)
def test_AR_Header_Current(self): ''' Tests the current fiscal period of accounts receivable header search function Accpac table Armast01 ''' AP = accpac_class.Accpac() Teststring = '188942' Result = AP.Accounts_Receivable_Current_Header(invno=Teststring) self.assertEqual(Result[0][0],'188942') self.assertEqual(Result[0][1], 'SUPERG') self.assertEqual(Result[0][2],'C') self.assertEqual(Result[0][3],'') self.assertEqual(Result[0][4],'177154') self.assertEqual(Result[0][5],'Attn martha') self.assertEqual(Result[0][6], 'RMA#E176502') self.assertEqual(Result[0][7], '') self.assertEqual(Result[0][8], '-516') self.assertEqual(Result[0][9], '-93.8') self.assertEqual(Result[0][10], '-422.2') del AP
def test_Sales_Address_Search(self): ''' Tests Accpac's ability to search for sales orders in current fiscal period ''' try: AP = accpac_class.Accpac() Teststring='41877' Result = AP.Sales_Order_Address_Current_Search(sono=Teststring) self.assertEqual(Result[0][0], 'PCPC') self.assertEqual(Result[0][1], '41877') self.assertEqual(Result[0][2], 'California Family Health Council') self.assertEqual(Result[0][3], '3600 Wilshire Blvd. Suite 600') self.assertEqual(Result[0][4], '') self.assertEqual(Result[0][5], '') self.assertEqual(Result[0][6], 'Los Angeles') self.assertEqual(Result[0][7], 'CA') self.assertEqual(Result[0][8], '90010') self.assertEqual(Result[0][9], '90010') self.assertEqual(Result[0][10], 'JMH') self.assertEqual(str(Result[0][11]), '2014-09-16') except Exception as TSASError: TSASError = str(TSASError) print (TSASError)
def test_AR_Items_Current(self): ''' Tests the current fiscal period of accounts receivable items search function Accpac table Artran01 ''' AP = accpac_class.Accpac() Teststring = '188942' Result = AP.Accounts_Receivable_Current_Items(invno=Teststring) self.assertEqual(Result[0][0],'188942') self.assertEqual(Result[0][1], 'Our SO # 177154') self.assertEqual(Result[0][2],'4610-TI9') self.assertEqual(Result[0][3],'Printer, SureMark Thermal Receipt') self.assertEqual(Result[0][4],'SUPERG') self.assertEqual(Result[0][5],'RMAWIP') self.assertEqual(Result[0][6], '82') self.assertEqual(Result[0][7], '0') self.assertEqual(Result[0][8], '129') self.assertEqual(Result[0][9], '-4') self.assertEqual(Result[0][10], '-4') self.assertEqual(Result[0][11], '-516') self.assertEqual(Result[0][12], 'C') self.assertEqual(Result[0][13], 'RM') del AP
def test_Item_Transaction_History_Search(self): ''' Tests the item transaction history search for current fiscal period ''' AP = accpac_class.Accpac() Teststring = 'TEST' Result = AP.Item_Transaction_History_Search(item=Teststring) self.assertEqual(Result[0][0], '2717654') self.assertEqual(Result[0][1], '2') self.assertEqual(Result[0][2], 'FG') self.assertEqual(Result[0][3], 'TEST') self.assertEqual(Result[0][4], '336743') self.assertEqual(Result[0][5], 'Shipment SO# 240907') self.assertEqual(Result[0][6], 'I') self.assertEqual(Result[0][7], '2014-10-06') self.assertEqual(Result[0][8], '') self.assertEqual(Result[0][9], '-1') self.assertEqual(Result[0][10], '0') self.assertEqual(Result[0][11], '0') self.assertEqual(Result[0][12], 'NUKE') self.assertEqual(Result[0][13], '240907') self.assertEqual(Result[0][14], 'AMY') self.assertEqual(Result[0][15], 'TURCHINETZ')
def test_Sales_Item_Search(self): ''' Tests Accpac's ability to search for sales orders in current fiscal period ''' try: AP = accpac_class.Accpac() Teststring='41877' Result = AP.Sales_Order_Item_Current_Search(sono=Teststring) self.assertEqual(Result[0][0], '41877') self.assertEqual(Result[0][1], 'PCMALL') self.assertEqual(Result[0][2], 'C4110-67923') self.assertEqual(Result[0][3], 'Kit, Maintenance') self.assertEqual(Result[0][4], '0') self.assertEqual(Result[0][5], '365') self.assertEqual(Result[0][6], '2004-09-22') self.assertEqual(Result[0][7], '0') self.assertEqual(Result[0][8], '1') self.assertEqual(Result[0][9], '0') self.assertEqual(Result[0][10], '365') self.assertEqual(Result[0][11], '0') except Exception as TSISError: TSISError = str(TSISError) print (TSISError)
def test_Sales_Address_History_Search(self): ''' Tests Accpac's ability to search for sales orders in historical fiscal records Table: soyadr ''' try: AP = accpac_class.Accpac() Teststring='155510' Result = AP.Sales_Order_Address_History_Search(sono=Teststring) self.assertEqual(Result[0][0], 'YCREP') self.assertEqual(Result[0][1], '155510') self.assertEqual(Result[0][2], 'Yankee Candle Company') self.assertEqual(Result[0][3], 'The Crossing @ Smithfield') self.assertEqual(Result[0][4], '371 Putnam Pke Suite 550') self.assertEqual(Result[0][5], '') self.assertEqual(Result[0][6], 'Smithfield') self.assertEqual(Result[0][7], 'RI') self.assertEqual(Result[0][8], '02917') self.assertEqual(Result[0][9], '211') self.assertEqual(Result[0][10], 'SC') self.assertEqual(str(Result[0][11]), '2012-01-02') except Exception as TSASError: TSAHSError = str(TSAHSError) print (TSAHSError)