Want a list of your Business Partners email address for marketing? Email your business partners from your favourite email marketing site by using this report query. It’s SQL that you run from within Query Generator or SQL Server. Simply copy the code between the /* … and … */ for your version of SAP B1 and paste into the Query Generator. Here’s something for free! Have a great bank holiday weekend! SAP Business One SQL Server version – /* –Start. Marketing Email List V1.1 select t1.CardCode, t2.cardname, t1.E_MailL from ocpr t1 inner join OCRD t2 on t1.CardCode = t2.cardcode and t2.cardtype = ‘C’ –End. Author Stuart Folley www.1dash1.co.uk 0843 886 1449 */ …
Category: SAP Business One Jobs
Senior Implementation Consultant – SAP Business One (SAP B1 ) Home Based in Bedfordshire, Buckinghamshire, Cambridgeshire, Hertfordshire, Surrey, Oxfordshire, Northamptonshire £35k – £50k + Bens SAP Business One (SAP B1) Implementation Consultant SAP Business One Certified ERP Project Definition & Costing Project Life Cycle Pre-Sales Data Migration Installation Configuration Product Training Accounting background (ideally AAT) SQL CRM SQL Server Crystal Reports DTW Senior Implementation Consultant – SAP Business One, SAP B1 A Senior SAP Business One (SAP B1) implementation consultant is required by 1 dash 1. We want an experienced and enthusiastic SAP B1 Senior Consultant with an ERP/ SAP Business One implementation background to join our team. An Accounting background would be an advantage. ERP Consultant? Do you…