|
Posted by Cesar Delanoval on July 24, 2008, 2:09 pm
Please log in for more thread options
I have a list of customers which are auto-invoice monthly the same
amount. My bank thru a lockbox service provides me with a import file
(see sample below ) which I import and post perfectly to each customer
and put the total of all funds into the Undeposited funds account.
Here's a sample of the import file
!TRNS,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,MEMO
!SPL,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM,MEMO
!ENDTRNS
TRNS,PAYMENT,07/23/08,UNDEPOSITED,C302,155.59,132,
SPL,PAYMENT,07/23/08,RECEIVABLES,C302,-155.59,132,
ENDTRNS
TRNS,PAYMENT,07/23/08,UNDEPOSITED,B313,155.59,103,
SPL,PAYMENT,07/23/08,RECEIVABLES,B313,-155.59,103,
ENDTRNS
TRNS,PAYMENT,07/23/08,UNDEPOSITED,B122,155.59,2099101793,
SPL,PAYMENT,07/23/08,RECEIVABLES,B122,-155.59,2099101793,
ENDTRNS
The problem is the following: The importing of the file is suppose to
reduce the outstanding balance on each customer, somehow when I go
back to the invoice I notice that the payment is not reflected on the
invoice as received. I would have to go to each customer and process
a manual "received payment" procedure. Once I initiate this process I
see the amount of the payment reflected as a discount which I need to
manually apply.
How can avoid going through these steps. Is there anything that can
be added to import file to auto-apply the discount to each customer,
or is there anything in the setup that I can do to auto-apply the
discount or set all customers as "no discounts" for this customer ?
Thank you for you help
|
| Similar Threads | Posted | | Importing data from file | June 18, 2007, 10:04 am |
| Importing Logiciel Data Into Quickbooks POS | September 9, 2006, 4:45 pm |
| Importing data from an *.IIF file into QBPro 2006 | September 28, 2006, 6:22 pm |
| Payroll data IIF import problem using 'QBP Employee' | July 11, 2006, 10:47 am |
| Discounts increase total income??? | November 15, 2007, 4:22 pm |
| Discounts and Credits -- NOT intuitive and NOT correct | August 19, 2008, 9:21 am |
| entering discounts AND DISCOUNTED TOTALS on invoices | June 5, 2008, 8:52 am |
| Cost of Goods Sold vs. Sales account for discounts | October 16, 2007, 2:19 pm |
| Importing Records into QB | June 12, 2007, 11:44 am |
| QBPro2007 importing deposits | January 12, 2007, 7:55 pm |
|
|
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap