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 am trying to import a CSV into Sage 50's sample company Bellwether Garden Supply. The file imports fine, but creates two invoice records once complete. Can someone tell me why this is happening?
It can be reproduced (hopefully) by importing this CSV…
Invoice/CM # is an importable field. I assume this would import the invoice number? Also, are there any settings that would prevent the invoice id from being imported?
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
Did I lock down the data set? Was trying to trigger launch of End of Year Wizard, it did not launch and I closed program because each time I open program it would prompt to run End of Year Wizard.
This is only site I use Peachtree at - all other sites…