Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 06-20-2017 12:45:36

timeclockexpress
Member
Registered: 04-15-2008
Posts: 63

T-Hub

In V9 Where do you go to update an order sent to T-Hub (True/False)
Had a problem with T-Hub and I need to pull some resent orders

Offline

 

#2 06-21-2017 08:12:29

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: T-Hub

(1) Access Store / Component / Settings / Extension Module: T-Hub Connector and note the 'Accounting System Data Storage Slot' for THUB.

(2) Access System / Database / Raw Database Admin then the Submit Raw SQL Statement function.  If the data slot being used above was the Primary slot, use this SQL to reset the order so it can be exported again.  The order number in this example is 'XXX':

UPDATE ecom_orders SET acctsyspri='' WHERE id='XXX'

If the data slot being used above was the Alternate slot, use this SQL to reset the order so it can be exported again.  The order number in this example is 'XXX':

UPDATE ecom_orders SET acctsysalt='' WHERE id='XXX'


Nick Hendler

Offline

 

#3 06-21-2017 10:13:14

timeclockexpress
Member
Registered: 04-15-2008
Posts: 63

Re: T-Hub

Thanks Nick

Can you include an exported to T-Hub Flag (True/False) in orders in next maintenance release like in V8?

Would make things a lot easier


Randy

Offline

 

#4 06-22-2017 07:36:46

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: T-Hub

Thank you for the request, but that's not going to happen.  K9 supports integrations with two accounting systems simultaneously.  Those primary and alternate connection details are embedded throughout the software for all different types of data.  The K9 core itself is not going to contain any module-specific flags for accounting system integrations.  The intention is to use one or the other of the data slots based on settings. 

This type of setup makes it easy to migrate to different accounting systems or use different connection types.  When you get tired of THUB bastardizing your data on the way into QuickBooks, and are ready for a heavier/better integration, you'll likely want to use the QuickBooks Web Connector extension module, which plugs into K9 the same way the THUB module does.

We could make a THUB helper that does this for you in an easier fashion, but a client would have to sponsor that.


Nick Hendler

Offline

 

Board footer