How to Generate the Proper Report Format Using QUICKBOOKS Software
Create a Generic / Text Only printer driver that prints to a FILE: (use the Printer Wizard and follow directions) Create a report and print it using the new printer driver. Your report should look something like this: ------------------------------------------------------------------------------------------ 06/28/10 Your Mall Name 4:35 PM Item Summary Date: 6/26/2010 12:00:00 AM to 06/26/2010 11:59:59 PM DeptName Qty SoldVendor Item Name Size ExtPrice ExtCost Jewelry Junkies 1 BraceletJJ142A 10.00 0.00 1 BraceletJJ142A 10.00 0.00 Jewelry Junkies 1 BraceletSilverCharmJJ219 14.00 0.00 1 BraceletSilverCharmJJ219 14.00 0.00 ------------------------------------------------------------------------------------------ Where Jewelry Junkies should be your dealer numbers instead. This report used the dealer name. Also note that stock numbers were included in the description. You should be able to configure your report similar to this. If not we will have to do some tweaking. Also, the report is only for one day and the date info is extracted after the word "Date:" shown on the 5th line above. Name it qb.txt. Replace existing file as necessary. Run the shortcut for SALES_UPLOAD.BAT on your desktop. Because the upload method used for QuickBooks is for selected days (ie 1one day) out of the month, be sure to check your sales between uploads. Checking your sales after uploading finalizes the upload process and makes it possible to upload again without losing data.Back to Store Page instructions