Welcome to the Sage 300 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.
Hi all,
I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet.
My user setting:
…
Looking for someone who knows their SQL tables here.
What is the SQL table or view where I can query the Sage 300 ERP "Type" field as it relates to the CRM person record? Through the integration, the new fields "Sage 300 ERP A/R Contact" or "Sage 300…