Home Page link  

How identify paid invoices in export file?

  
Groups | Search | About
User Password
Register Now! Lost Password?

Peachtree Accounting Discussions - Discussions about Peachtree - accounting software by Sage

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
How identify paid invoices in export file? Bill 05-22-2007
Posted by Bill on May 22, 2007, 10:50 pm
Please log in for more thread options
 I need to perform an export from Peachtree 2006 that will give me the
data I need to identify the invoices that the customers have paid in
full. There is a status field that shows Paid when I view an invoice in
Peachtree but I cannot find it in any of the exports. What am I
missing? Thanks.

--
.Bill.

Posted by Laura on May 23, 2007, 12:15 pm
Please log in for more thread options
>I need to perform an export from Peachtree 2006 that will give me the
> data I need to identify the invoices that the customers have paid in
> full. There is a status field that shows Paid when I view an invoice in
> Peachtree but I cannot find it in any of the exports. What am I
> missing? Thanks.

You are not missing anything. It is not an available field in the export
process. You could run a Sales Journal report and add the "Payment status"
field to the report to get the data you need. The only problem is that the
invoice number is not included on the A/R account line with the Payment
status. You would have to duplicate the invoice number on the A/R record.

Maybe Crystal reports would work better.



Posted by Bill on May 23, 2007, 11:56 am
Please log in for more thread options
Laura wrote:

> You are not missing anything. It is not an available field in the
> export process. You could run a Sales Journal report and add the
> "Payment status" field to the report to get the data you need. The
> only problem is that the invoice number is not included on the A/R
> account line with the Payment status. You would have to duplicate the
> invoice number on the A/R record.

AFAIK Peachtree does not offer an option to print the Sales Journal
report to a file. I'll have to set up a text printer driver and see
what that gives me. Having the status on a separate line is something I
can program around. It is just more work. Thanks for the suggestion.
Parsing the Sales Journal report may be easier than exporting the Sales
Journal and Cash Receipts Journal and writing code to determine if the
invoice has been paid in full.

>
> Maybe Crystal reports would work better.

Crystal is not an option.

--
.Bill.

Posted by Laura on May 23, 2007, 3:42 pm
Please log in for more thread options

> Laura wrote:
>
>> You are not missing anything. It is not an available field in the
>> export process. You could run a Sales Journal report and add the
>> "Payment status" field to the report to get the data you need. The
>> only problem is that the invoice number is not included on the A/R
>> account line with the Payment status. You would have to duplicate the
>> invoice number on the A/R record.
>
> AFAIK Peachtree does not offer an option to print the Sales Journal
> report to a file. I'll have to set up a text printer driver and see
> what that gives me. Having the status on a separate line is something I
> can program around. It is just more work. Thanks for the suggestion.
> Parsing the Sales Journal report may be easier than exporting the Sales
> Journal and Cash Receipts Journal and writing code to determine if the
> invoice has been paid in full.

I've never messed with printing a report to a file before so I don't how
that would work. How about printing to a pdf file? Would that help?

>>
>> Maybe Crystal reports would work better.
>
> Crystal is not an option.

I don't have Crystal installed myself. It's been many, many moons since I
used the program. It was in another lifetime.



Posted by Bill on May 23, 2007, 4:23 pm
Please log in for more thread options
Laura wrote:

> I've never messed with printing a report to a file before so I don't
> how that would work. How about printing to a pdf file? Would that
> help?

I need a file that can be read and processed by a program so PDF does
not fill the bill. What I have done is added a Generic/Text printer and
created a custom local port named c:PeachtreePrintSalesJrnl.txt. When
the user prints the custom Sales Journal report to that printer it
automatically overwrites the existing file, if any, and gives me a
plain ASCII text file containing the report. All I have to do is write
code to read the report file, skip the header lines then extract the
invoice number and payment status. With that information I can
calculate commission for the sales reps based on just the invoices that
have been paid by the clients. Its a bit more work than it would be if
I could get payment status in the Sales Journal export file but it
works. :) Thanks for your help.

--
.Bill.

Similar ThreadsPosted
Help changing the status of invoice from paid in full to open October 5, 2006, 2:00 pm
Peachtree Export of Sales Journal June 30, 2006, 7:04 pm
Where find export record layouts May 22, 2007, 8:07 pm
GST on Vendor invoices November 20, 2007, 5:24 pm
How do I set default invoices June 10, 2008, 7:35 am
Quantum Recur Invoices September 27, 2006, 2:33 pm
Adding workstations reverts invoices August 6, 2006, 11:21 am
Incessant reading of config.ini file February 19, 2007, 12:06 pm
Sample General Journal Import File August 25, 2006, 5:12 am
v2007 Peer to Peer Installation Troubles - Can't Ping File Share System October 4, 2006, 1:40 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap