I need to delete a bunch of users in OG so I can delay having to purchase more licenses. I have 300+ customers that are cancelled and have not done business with us in at least 2 years. The accounting department needs to keep the customer details for 5 years though. So I tried the export to Quickbooks since they use that over there. The export - import worked fine, but there are no payment details, only invoices and credit invoices. They need payment dates, amounts, authorization codes, check numbers, etc. Am I missing something about the export to Quickbooks that it hasn't done that? Thanks, Chuck
The QuickBooks export will export payment data automatically (there's not an option to turn it off). Did you choose to export all data (and instead use your date range)?
I did a search for all customers with termination dates before 11/30/2003 and then did a global change on the found set to change the account class to Archived. Then I went to the Export to Accounting. I have the following set. Only new items: No Invoices: All Export Only Current: No Export Negative Payments: Yes Truncate after: 15 characters Only export for account class: Archived Specify Date Range: both blank Defaults for the fields left below. Also here's some text of the qbooks.iif file produced. There doesn't appear to be any payment information for each customer unless it's somewhere else in the file. !TRNS,TRNSID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,MEMO,CLEAR,TOPRINT,NAMEISTAXABLE,ADDR1,ADDR2,ADDR3,ADDR4,DUEDATE,TERMS,OTHER1 !SPL,SPLID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,MEMO,CLEAR,QNTY,PRICE,INVITEM,PAYMETH,TAXABLE,VALADJ,SERVICEDATE,OTHER2,EXTRA !ENDTRNS TRNS,2122,INVOICE,12/9/02,Accounts Receivable,bluecat,,16.95,021209-0010,,N,N,Y,"","Joe Blow","2xx Siley St.,","St. Charles, MO 63301",12/19/02,, SPL,35689,INVOICE,12/9/02,"EO-DA1-M","",,-16.95,,"EPCOnline Monthly Dialup Analog 33.6",N,-1,16.95,"EO-DA1-M",,N,N,,, SPL,2122,INVOICE,12/9/02,Sales Tax Payable,State Board of Equalization,,0,,,N,,%,,,N,N,,,AUTOSTAX, ENDTRNS This was paid by CC and has an an auth code and more info in the Payment screen in OG. That's the info I also need to be in the Quickbooks customer records. This information is nowhere in the qbooks.iif file. Did I do something wrong? Chuck
Account Class is stored per payment, so changing it on the customer record will not affect payments that were already in the system. You will need to rebuild indexes and when it asks if you want to rebuild invoice, payment, line item and billing cycle indexes also, say "Yes".