316324 Quick Book Interface

Regarding Accounting User Interface with Quickbook . We have SQL Exdpress 2005 Database. e.g. For Salary Purpose : Data Table : Payable_QuickBK This table will be used for Account Payable. Account Payable: FIELDS: Contact ID Date Quantity Rate Amount Account Type ¡K¡K..Salary or bill or invoice etc. ¡Kand will be String Bill# TransferToQB CheckAmount these fields are incoming CheckNo from Quick Book. Check Date QBReturn TransferToQB is a flag so when every Friday automatic procedure runs to transfer the data from data tables to quick book : on transfer of this record the flag will be true. ( to avoid duplicate transfer) : for salary : when check is printed in QB for salary the QBReturn Flag will be true (To avoid duplication of printing check for salary) flag will be true. Check Date, Check Amount, QB Return and Check Date will be output from Quick Book and Input to this table. This will be procedure as soon as there is any update in quick book. Bill# is non usable field for Employee. But it is for other purpose vendors, utility bills and other type of Amount Payable. For employee purpose it may be consider as Time Sheet Number if at all if you want to use it. But in data table all these fields will be there. Now Following is one type of Account Receivable: Data Table : Receivable_QuickBK Contact ID Date Quantity Shift Rate Bill Amount Account-Type ¡K¡K¡K¡KMedicare, Medicaid, Private Pay, etc. TransferToQB Invoice Number These fields are Invoice Date output from QB Received Amount and incoming for Receipt Number our table. Received Date QB Return These incoming fields in our data table will be updated by QB procedure. Either there will be data in Quantity or there will be data in Shift. If Client is coming morning, afternoon shift or Full shift the value will be 1, 2 or 3 and value of Quantity will be zero. If client is coming for 6 hours or 7 hours than there will be data in Quantity and value of shift will be zero. Data should be in Shift or in Quantity is depends on the selection criteria when client is enrolled/ added whether he selected shift or specific time. Coming from Form Add Clint Information. Company Name and Address you can get from Data Table. ƒæ Following Data Tables will be used to save the information regarding the Day care center [Company]. The Screen Shot of this information in C# .Net Which will give you Idea about the Theme of Screen and Logo ¡Klogo is saved in data table. Regarding Employee more information the contact table is Contact where value of contact type id is 891 for salary and check purpose. Regarding Clients information it is same data table where contact type id is 884 Regarding QB interface you can grab the information straight matching Contact_ID not to confuse more in this because yo have ContactID in both he data table Receivable_QuickBK and Payable_QuickBK. You may create other user interface if you want to ask like bank and bank information in JAVA. Attached are screen shots in following pages In above screen shot top and left is frame and forms open within the windows¡K¡K..in quick book interface you can let system to open new windows ¡[login to view URL] required. Regards arun