SAP Business One Consultants | IT Support | 0843 886 1449

All posts in SAP Business One Implementation Consultant

Business Partner Email Report SQL HANA

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

 

 

 

 

SAP Business One HANA SQL version –

/*

 

–Start. Marketing Email List V1.1

SELECT T1.”CardCode”, T0.”CardCode”, T1.”E_MailL”

FROM OCRD T0  INNER JOIN OCPR T1 ON T0.”CardCode” = T1.”CardCode”

WHERE T0.”CardType” = ‘C’

–End. Author Stuart Folley www.1dash1.co.uk  0843 886 1449

 

 

 

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message

 

 

ERP SAGE SAP B1 Implementation Consultant

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

ERP SAGE SAP B1 Implementation Consultant

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 have skills?

 

Do you know the difference between Net and Gross Profit?

As a SAP B1 certified Consultant you will have a proven and demonstrable track record in all aspects of the project life-cycle of SAP Business One implementations.

Your duties will include Pre-Sales, project definition and costing, installation and configuration, and training. Coupled with this, strong knowledge of Microsoft Windows operating systems and Microsoft Office products is essential for the successful Implementation Consultant. You’ll understand the accounting needs of an organisation from general accounting, A/R, A/P, ordering process and configuration, production, stock, delivery and distribution, and CRM.

Naturally you’ll have superb communication Skills and pride yourself in your consultative approach.

If you can convince us that you deserve the job, you’ll get it.

Rewards, bonuses and other incentives are on offer for the right SAP Business One consultant. If you have a background in ERP consultancy in Sage, Access, Dynamics or the larger ERP suites from SAP or Oracle – we still want to hear from you.

Enter your details below or send an email to contact@1dash1.co.uk

Your Name (required)

Your Email (required)

Your Telephone

Your Company

Subject

Your Message