csv import error -- invoice number already exists

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

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date csv import error -- invoice number already exists JohnK 09-26-2006  Re: csv import error -- invoice number already exi... lathem 05-05-2009  Re: csv import error -- invoice number already exi... veronica 06-12-2009
Posted by JohnK on September 26, 2006, 2:40 pm Please log in for more thread options Hi, I am trying to import invoices into Peach Tree 2006 using csv files created by a separate application. I get an error that the invoice number already exists. >From a previous post to this group, I gathered that this error may be occurring on the second line of the csv file (for csv files that contain multiple lines) if the NumberOfDistributions is not set correctly. As far as I can tell I am setting the NumberOfDistributions correctly--equals the number of lines for that invoice in the csv files. Do you have any ideas what might be causing the import error. Can I send a copy of a csv file or an export of my SalesJournal for you to diagnose? Thank you for your help. JohnK Posted by lathem on May 5, 2009, 4:14 pm Please log in for more thread options lathem had written this in response to http://www.rockryno.com/peachtree/csv-import-error-invoice-number-already-exists-126-.htm : I see that no one ever responded to this querstion. Frustrating, since I have the exact same question. Did you ever solve this problem? I want to import those invoices from MS ACCESS into peachtree (the sales journal I believe). To get started, Itried an experiment in the Bellwether sample company. I exported a sales journal entry to csv. Then changed the Invoice/CM # and tried to r ------------------------------------- JohnK wrote: > Hi, > I am trying to import invoices into Peach Tree 2006 using csv files > created by a separate application. > I get an error that the invoice number already exists. >>From a previous post to this group, I gathered that this error may >> be > occurring on the second line of the csv file (for csv files that > contain multiple lines) if the NumberOfDistributions is not set > correctly. As far as I can tell I am setting the NumberOfDistributions > correctly--equals the number of lines for that invoice in the csv > files. > Do you have any ideas what might be causing the import error. > Can I send a copy of a csv file or an export of my SalesJournal for you > to diagnose? > Thank you for your help. > JohnK ##-----------------------------------------------## Newsgroup Access Courtesy http://www.rockryno.com/ Tax and Accounting Software Forums Web and RSS access to your favorite newsgroup - alt.comp.software.financial.peachtree - 644 messages and counting! ##-----------------------------------------------## Posted by veronica on June 12, 2009, 6:23 pm Please log in for more thread options veronica had written this in response to http://www.rockryno.com/peachtree/Re-csv-import-error-invoice-number-already-exists-833-.htm : I need help with this two. Did you ever find the solution? ------------------------------------- lathem wrote: > lathem had written this in response to > http://www.rockryno.com/peachtree/csv-import-error-invoice-number-already-exists-126-.htm > : > I see that no one ever responded to this querstion. > Frustrating, since I have the exact same question. > Did you ever solve this problem? > I want to import those invoices from MS ACCESS into > peachtree (the sales journal I believe). To get started, > Itried an experiment in the Bellwether sample company. > I exported a sales journal entry to csv. Then changed > the Invoice/CM # and tried to r > ------------------------------------- > JohnK wrote: >> Hi, >> I am trying to import invoices into Peach Tree 2006 using csv >> files >> created by a separate application. >> I get an error that the invoice number already exists. >>>From a previous post to this group, I gathered that this error >>> may >>> be >> occurring on the second line of the csv file (for csv files that >> contain multiple lines) if the NumberOfDistributions is not set >> correctly. As far as I can tell I am setting the >> NumberOfDistributions >> correctly--equals the number of lines for that invoice in the csv >> files. >> Do you have any ideas what might be causing the import error. >> Can I send a copy of a csv file or an export of my SalesJournal >> for you >> to diagnose? >> Thank you for your help. >> JohnK > ##-----------------------------------------------## > Newsgroup Access Courtesy > http://www.rockryno.com/ > Tax and Accounting Software Forums > Web and RSS access > to your favorite newsgroup - > alt.comp.software.financial.peachtree - 644 > messages and counting! > ##-----------------------------------------------## ##-----------------------------------------------## Newsgroup Access Courtesy http://www.rockryno.com/ Tax and Accounting Software Forums Web and RSS access to your favorite newsgroup - alt.comp.software.financial.peachtree - 643 messages and counting! ##-----------------------------------------------## Similar Threads Posted import invoice data in peachtree 2006 December 15, 2006, 12:41 am "Posting Failed" error when trying to import Sales Journal January 23, 2007, 5:42 pm Peachtree Check Number Problem November 22, 2006, 3:20 pm CSV Import Problem with Peachtree July 26, 2008, 11:30 pm How to Import Excel to Budget? November 5, 2008, 1:56 pm Sample General Journal Import File August 25, 2006, 5:12 am Invoice Off Proposals April 18, 2007, 5:02 pm PT Invoice Do Not Print Zero Items May 3, 2007, 3:35 pm Deleting an old purchase invoice January 13, 2009, 11:45 pm tax exempt customer tax code changes on invoice January 18, 2007, 6:18 am