Welcome to the Sage 50 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I'm trying to figure out how to import invoices into Peachtree 2010 from my own Order Entry application using the COM interface. I have a process and code that I have been testing but keep running into hurdles so I would like to pose some questions to the community. First some background:
1. I am a software architect / developer.
2. I'm using Visual Studio 2010, C# and .NET 4.0.
3. I need to import into Peachtree 2010.
4. My O/E app creates the orders and manages customers, inventory, etc. so I import customers and inventory items first.
1. Is it better to export from my app into CSV or XML and why? Currently I am trying CSV.
2. The Importer object in PAW does not provide any feedback in the way of return values or events. It's an all or nothing process. Therefore, if I an error occurs on any line in the CSV file I get no information as to which line it is. I'm thinking about importing a single invoice at a time (with multiple line items) so that I have some context for the error, rather than putting all invoices into a single file. Does that make sense?
3. The orders are managed in my app until they need to be exported as invoices to Peachtree. Should I be importing them as Sales Invoices and not Sales Orders?
4. My current app (based on the app I rewrote) imports a single invoice as a single record into Peachtree with no line items. I want to possibly overwrite these historical invoices with the fully expanded invoice with line items but I get a warning message that the invoice # already exists. Any way to overwrite them? I get that it may not be advisable, but for testing purposes against a copy of the customer's Peachtree data files I would want this.
