I'm looking for someone out there who has actually used the new R:Base product
RQBDataDirect to export data to QuickBooks. I'm preparing a proposal for a
customer who wants to export invoice information to Quickbooks.
Looking at the documentation for RQBDataDirect, I have 3 questions.
1. Am I correct in assuming that since RQBDataDirect does not support
expressions, if I wanted to export, for example, all invoices for a certain
date, I could NOT use a WHERE clause like "WHERE InvDate = .#Date"? Instead I
would have to add a Flag column to the R:Base table and do these steps:
1. UPDATE Invoice SET Flag = 1 WHERE InvDate = .#Date
2. PLUGIN RQBDataDirect.RBL vResult|ACTION Run |SCRIPT_FILE_NAME
Invoices.RTF OUTPUT_FILE_NAME InvData.iif RETURN
The script file would have the condition above.
3. UPDATE Invoice SET Flag = 0 WHERE Flag = 1
Is that correct?
2. Can I CHANGE the name of the export file so it doesn't keep
overwriting? E.g., could I name my files InvDatammddyy.IIF where mmddyy is the
month/day /year? Then build the PLUGIN command like this:
SET VAR vPlugIn = ('PLUGIN RQBDataDirect.RBL vResult|ACTION Run
|SCRIPT_FILE_NAME Invoices.RTF OUTPUT_FILE_NAME' & .vFileName & 'RETURN')
&vPlugIn
Is that possible?
3. I'm puzzled as to how you export invoice DETAIL to Quickbooks. I'm
assuming that the list of tables in the documentation for RQBDataDirect is
complete. I've carefully reviewed all fields in the Quickbooks TRNS table and
see nothing for items on an invoice. I've carefully looked at all the tables: I
see what appears to be the equivalent of an item master table, (INVITEM), but
not a table that shows items for which a customer is being billed on an
invoice. Has anyone done this and can you explain what I've missed? Is there
ANOTHER Quickbooks table that will appear in the dropdown list that's not in
the RQBDataDirect documentation?
Thanks for your help!
David Blocker
David Blocker
[EMAIL PROTECTED]
Telephone: 781-344-1920
Cell Phone: 339-206-0261
