SNSsystem team completed an exporter tool to export data from Indysoft to Quick Books. Here is the flow of tool:
- Exporter reads the data from IndySoft MSSQL DataBase
- Allow user to select relevant options, like region etc
- Exporter tool export the data based on selection to Quick Book By using SOAP API
- Exporter tool update invoice number in Indysoft MSSQL Database
We use a xml file to save database connection string and other info related to exporter in this xml file name is “IndySoft_QB_X_Webconfig.xml” which exist in c: drive of local system. user can make changes in this file directly.
Exporter reads the data from IndySoft MSSQL DataBase :
For getting data in exporter we need to first select period from date and to date. then select Complete check box it mean show only those work order in which have status “Complete” then select Region (profit centre) checkboxes [SD] for TECHMASTER SAN DIEGO,[SJ] for TECHMASTER SAN JOSE and [FL] for TECHMASTER FLORIDA. then click on Get Order as see in following screen.
When we click on Get Order button the first get Customer list from Work_Order table based on passing date. after that we passed customer list then got order list.after that based on Customer list and Order list we have got complete information of Work Order Without line Item and assign in to IndySoftShipper class object. after that get Work Order based on Order list from database and assign into IndySoftOrder Class Object. and after that based on date on fetch data from WORK_ORDER, WORK_ORDER_DETAIL, WORK_OEDER_CHARGES, EVENTS, GAGES and SCHEDGI tables using Join and assign in to IndySoftOrderItem Class Object. as shown in following screen.
Description Relationship Map of Classes in Exporter
Allow user to select relevant options :
We have added many features in Exporter as following.
Partially Complete :
Some time all Line items of any Work Order Not completed then we can use this features.
Sequence Number :
Some time User want to change Invoice Number Sequence then we have added this feature. with this feature user can change Invoice Number sequence. we have added editable text box.
Blanket PO :
With the help of this feature user can see PO Balance of Blanket PO Orders.
Status Filter :
We can filter Work Order Status Wise. Like Invoice, Complete and Incomplete.
Exporter tool export the data based on selection to Quick Books By using SOAP API :
We have use Interop.QBXMLRP2Lib .dll for
Interop.QBXMLRP2Lib .dll :
Interop.qbxmlrp2lib.dll is a type of DLL file associated with Quick Books Pro 2011 developed by Intuit Inc. for the Windows Operating System. The latest known version of Interop.qbxmlrp2lib.dll is 220.127.116.11, which was produced for Windows.
All communication between Quick Books and SDK applications follow the same basic pattern. The application first establishes communication with Quick Books (this involves both connection-related method calls AND human interaction (getting the company owner’s authorization). The application then sends a request set containing one or more requests. Quick Books processes the requests and sends back a response set containing one or more responses.
This is a pretty high level view of things, but it is general enough to serve for the various supported ways to access Quick Books. Once you get down to particular types of access, such as desktop applications accessing local Quick Books, you’ll learn about request processor DLL running in the Quick Books process to handle incoming requests and send out outgoing requests.
Exporter tool update invoice number in Indysoft MSSQL Database :
When we click on export button then Copy Order and Order Item Detail class Object into Invoice and InvoiceItem Class Object.after that check Customer Exist in Quick Books or Not if exist then get some important information about Customer from Quick Books else if Customer not exist in QB then Create Customer for Quick Books via xml request. after check/create customer information send xml request to generate invoice into Quick Books. here is xml format for sending Export Invoice.
<?xml version="1.0"?><?qbxml version="13.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <InvoiceAddRq requestID="40"> <InvoiceAdd> <CustomerRef><FullName>Spaulding</FullName></CustomerRef> <ARAccountRef><FullName>12000</FullName></ARAccountRef> <TxnDate>2015-10-13</TxnDate> <RefNumber>SD07003</RefNumber> <BillAddress> <Addr1>Spaulding Surplus</Addr1> <Addr2>12829 Landale St</Addr2> <City>Studio City</City> <State>CA</State> <PostalCode>91604</PostalCode> </BillAddress> <ShipAddress> <Addr1>12829 LANDALE ST</Addr1> <City>STUDIO CITY</City> <State>CA</State> <PostalCode>91604</PostalCode> <Country>UNITED STATES</Country> </ShipAddress> <PONumber>213</PONumber> <TermsRef> <FullName>Net 30</FullName> </TermsRef> <DueDate>2015-11-12</DueDate> <ItemSalesTaxRef> <FullName>Non-taxable</FullName> </ItemSalesTaxRef> <Memo>Ref# SPAULDING SURPLUS</Memo> <CustomerSalesTaxCodeRef> <FullName>Non</FullName> </CustomerSalesTaxCodeRef> <InvoiceLineAdd> <ItemRef><FullName>CalibrationSD</FullName></ItemRef> <GLAccountRef></GLAccountRef> <Desc></Desc> <Quantity>1</Quantity> <Rate>125.00</Rate> </InvoiceLineAdd> </InvoiceAdd> </InvoiceAddRq> </QBXMLMsgsRq> </QBXML>
in this xml send next generated Invoice number and after export successfully Invoice into Quick Books this Invoice Number update in to IndySoft Database WORK_ORDER.WO_CUSTOM2 field and also iin to WORK_ORDER_CHARGES.CUSTOM2 field.
IndySoft Introduction :
IndySoft we believe the purchase of a calibration or tooling asset management system is one of the most important decisions you can make in relation to your quality program needs. We understand that these are your operations and the right software package is going to be the one that can compliment and augment your process, not unflinchingly dictate how you have to run your business. At IndySoft we take the time to understand your business needs and challenges, then pull from our extensive experience to offer just the right mix of products and services to meet your long-term goals. We look forward to hearing from you, learning about your business, and showing you all the great things you can accomplish by working with us. Let's build something great together.
Quick Books Introduction :
Quick Books from Intuit is the #1 best-selling small business accounting software in US.1 It's the brand more businesses use for their bookkeeping needs. Quick Books is easy to use and organizes your finances and bookkeeping all in one place. Bookkeeping software and services come in many different flavors, providing a range of capabilities and features. Think of Quick Books as the easy to use bookkeeping software that turns even business novices into bookkeeping services professionals. No need to dread issuing invoices, or reconciling the books. Quick Books puts you back into control of your business. And no need to fear tax time either. Quick Books helps you keep your business in order, so everything will be right where you need it.
IndySoftX Introduction :
- (QB login points 1 to 3)
- Should be before logined to QB
- After login, should display Home page, as below screenshot
- Clicked on “Customers” button
B. IndySoftX login and check any particular WO(Points 4 to 6)
- Clicked on IndySoftX from start menu and after it should be open window and select from date & todate, as below screenshot.]
- Clicked on Get Records as below screenshot.
- After we select any WO for the check to QB ID it is exist or not in the QB?, as below screenshot.