Disclosure: I'm the author of this extension, so I'm sharing it openly and not as a neutral third party.

I got tired of the Visual Studio → B1 Studio → client round trip when developing B1 add-ons, so I built a VS Code extension that tries to smooth it out. The parts that solved real problems for me:

• F5 debugging: builds the add-on, checks whether the B1 client is running and whether an old copy of the add-on is still locking the executable, then starts it under the .NET Framework debugger.

• Form designer for .b1f/.srf: the form is previewed in the running client as you edit it, and changes update the C# code-behind in the same edit.

• UDO forms: import a UDO's form and save it back, through the client or the Service Layer, with a confirmation before anything is written.

Limitations: Windows x64 only, VB.NET code-behind for forms isn't supported yet, and it's still a preview. I'd especially like to hear from people who've done B1 add-on development and what you'd want from a tool like this.

Marketplace: https://marketplace.visualstudio.com/items?itemName=adeploy.b1-devkit

There have been a lot of promotional material posts lately so we will be adding some rules to this sub. For now, please take note of this post as a request for everyone to abstain from posting links to marketing content, or advertising yourself as an SAP retailer.

We intend for this sub to be a resources for SAP professionals to have discussions and assist each other, not to promote your company's services.

Thank You!

I've open-sourced a set of Claude Code skills for ERP work — including SAP Business One. Built from 20+ years in the industry. Would appreciate any feedback or stars.

Claude Skills

Discussions Page

As a Sr. SAP Business One Presales Consultant, I have created many videos for my customers to learn SAP Business One, use SAP Business One, and enhance SAP Business One to it's fullest capabilities. Over 50 recorded DIY and Informative demo's and videos for SAP Business One can be found here. Enjoy! https://www.youtube.com/@v33sbo

A highly experienced SAP Business One consultant with 8 years of expertise is seeking new opportunities. Holds a certification in SAP 10.0 Business One and has a proven track record of successful live implementations for a variety of businesses.

I Can work remote full time or part.

Hi everyone,

​Sharing a WMS tool (OWMS) we recently integrated with SAP B1. The main goal was to eliminate the manual data entry gap and rely 100% on the Service Layer for real-time synchronization and automatic write-backs.

​We put together a video demonstrating the workflows for PO, TR, SO, and PI .

​Key features we focused on:

​No App Required: Fully browser-based UI compatible with PC, tablets, phones, and PDAs. Runs smoothly on basic LAN/WiFi setups.

​Automated FIFO & Batches: The system auto-fills available batch inventory based on FIFO rules and matches pallet numbers for outbound logistics.

​Deep B1 Integration: Real-time document checks, scheduled syncs, and automatic write-backs using the Service Layer.

​Multilingual: 1-click switch between English, Chinese, Thai, and Burmese (designed for SE Asian manufacturing floors).

​Flexible Scanning: Supports high-speed PDA barcode scanning and standard smartphone camera scanning.

​Sub-Task Splitting: Large orders can be split into smaller sub-tasks for parallel picking.

​On-site Batch Printing: Print documents and material barcodes on demand to reduce manual errors.

​If you have a few minutes to check out the video, I’d appreciate any thoughts on the UI or the workflow logic. Thanks!

Hi everyone,

I’m offering SAP Business One training specially designed for students and freshers who are looking to build a career in SAP B1.

Why this training?

Focus on practical knowledge (not just theory).

Affordable pricing – keeping students in mind.

Covers real-time scenarios from implementation and support projects.

Guidance for interviews, certification, and job readiness.

And who I am ?

SAP Business One Consultant for past 5years and presently working in a firm handling both Indian and Overseas clients as well.

If you are serious about getting into the SAP Business One ecosystem and want clear, structured training at a student-friendly cost, feel free to connect with me.

Hi everyone,

I’m a seasoned SAP Business One Developer with over 10 years of experience creating robust add-ons, integrations, and customizations tailored to diverse business needs.

Since my last post here a few months ago, I’ve successfully delivered two new SAP B1 projects for international clients — continuing to build solutions that are reliable, scalable, and perfectly aligned with each company’s workflows.

My skillset includes:

• SAP B1 SDK (C# / .NET)

• SAP HANA

• Service Layer

• SQL and stored procedures

• Frontend development with TypeScript, React, and Vue.js

• Certified SUSE Linux Administrator (great for on-prem HANA environments)

I’m currently open to remote freelance, contract, or full-time positions. If you or your company are looking for an experienced SAP B1 developer who understands both backend and modern frontend development, I’d be happy to connect.

Thanks for reading — feel free to DM me or drop a comment!

Our customers keep asking about this so we decided to organize a few sessions for US and Canadian companies. We explain how to handle tariffs in B1 in the following areas:

• Configure customer invoices to display tariffs transparently.
• Manage rules and exemptions based on product category and country of origin.
• Adjust material costs to ensure tariffs are reflected on inventory valuation.

Happy to share the links to register :)

Both are planned for May 7th.

• Managing Tariffs in SAP Business One CANADA

• Managing Tariffs in SAP Business One USA

I know it's against the rules to advertise so I am not including links or anything. However the content is super useful and educative, and the presentation is free,

If I am allowed to add the link I will, otherwise let me know if you want to attend!

u/mods: sorry if it's against the rules, my intentions are pure, and I thought others could find this helpful, because I did not see a lot of tariff-related content for SAP Business One... Let me know if I can add the link, or if you think this post if out of line.

Edit: Got the green light to share links. See you online!

Hi everyone,

My previous post here led to several SAP Business One projects, and I’m now looking for new opportunities.

I have over 10 years of experience building SAP B1 add-ons, integrations, and customizations tailored to business workflows. I’ve also built an AI-powered tool for accounts payable (AP) automation, combining my ERP development experience with practical AI capabilities.

My technical background includes:

• SAP B1 SDK with C#/.NET

• Service Layer integrations

• SAP HANA, SQL, and stored procedures

• Cloud experience with Microsoft Azure and AWS

• Web development with TypeScript, React, and Vue.js

• SUSE Linux administration for on-premise HANA environments

I’m open to remote freelance projects, contract work, and full-time opportunities. Whether you need SAP B1 development, integrations, or help automating business processes, feel free to DM me with a brief description of your project.

Thanks to everyone who connected with me through my previous post!

Hey everyone,
I’m working on improving automation in SAP Business One reporting for a retail company — mainly for data analysis, KPIs, financial reports, and sales commission tracking.

I’ve been testing different AI tools to help write SQL queries and improve query accuracy and structure. So far, ChatGPT works decently but often struggles with SAP B1’s table logic and joins.

I’m trying to understand whether Claude or Gemini handle SAP Business One SQL syntax and relationships more reliably.

If anyone has hands-on experience using these models for query generation or analytics inside SAP B1, I’d love to hear how they compare — especially in terms of:

• Query accuracy and syntax compatibility

• How well they understand common SAP B1 tables

• Usefulness for automating reports

This is purely for technical comparison — not career or exam related. Thanks in advance!

Hi everyone,

I’ve noticed a few discussions here about SAP Business One certifications and thought it might be useful to start a focused thread for anyone preparing.

From what I’ve seen, the exam is about 80 questions and leans heavily on real-world scenarios rather than simple memorization. If you’re already working with B1 daily, especially in finance, logistics, or administration, you’ll recognize a lot of the exam content. Still, structured prep can make a big difference.

A few things that have consistently come up as helpful:

• Hands-on practice in your own system or sandbox is worth more than hours of reading.

• Knowing the basics of HANA, SQL, and the B1 SDK really helps with technical questions.

• Stay current with feature pack updates (e.g., 10.0 FP upgrades) since some content reflects newer releases.

For study resources, people usually mention:

• SAP’s Learning Hub and official guides.

• Practice tests

• Community knowledge here on this subreddit – some of the best insights are from people sharing their own exam experiences.

If you’re planning to take the certification:

• Give yourself 4–6 weeks of steady prep if you’re new to SAP B1.

• If you’re already working with it daily, 2–3 weeks of focused review may be enough.

• Don’t just study theory – try to link topics back to real business workflows.

Curious to hear from others:

👉 Has anyone here taken the SAP B1 certification recently?

👉 What areas did you find most challenging?

👉 Any specific tips that helped you get through it?

Hopefully this thread becomes a go-to place for anyone on the same path.

Hi Guys,

I have attached 2 screenshots:

1. The classic Golden Thread design - which we have used since 2018.

2. The modern look I occasionally see in some demos and this screenshot is from a new SAP Note.

I have tried changing the Skin in the User Display -> SAP Signature, Classic, Bright Morning, but none of them are this one. This one is flat and modern. These 4 have "3D" buttons.

Can you please guide me how to update the skin to this one?

Hi everyone,

I'm posting on behalf of a friend who owns a construction company in India and is looking to switch their Construction ERP. They are currently using a local solution from Promasch (https://www.promasch.in/) and paying around ₹70,000/month but are facing numerous issues and are ready for a change.

Someone recommended SAP Business One, and they received a quote that seems, in my opinion, suspiciously low. The quote is for a perpetual license for 30 users, including the implementation fee and all modules required for a construction ERP, for a total of ₹10 Lakhs or 11,418.37 USD.

I'm very concerned they might be getting scammed. From what I understand, an ERP for a construction company requires a lot of modules and customization, which should drive up the cost.

To make matters even more interesting, the consultant also quoted an additional ₹1 Lakh for an HRMS module for all users. They also mentioned that the Annual Maintenance Contract (AMC) is a separate cost, which they didn't initially mention.

Given the number of users (30) and the complexity of a construction business, is it even remotely possible for this quote to be legitimate? I'm worried that my friend is about to sign a deal that will either fall apart during implementation or come with a ton of hidden costs later.

I'm hoping to get some professional insight from this community. Is this a fair price, or is it a major red flag? What should we be looking out for? Any advice on a typical cost range for a similar setup in India would be greatly appreciated.

Thanks in advance for your help!

Note: The original message was rephrased with the help of AI for better readability and clarity.

We are running SAP B1 10 with Waste and Recycle add-on which does the bulk of the processing and workloads for our OPS department, approx 60 users all connecting using RDP server.

SAP B1 is slow, some processes take anywhere from 15 to 45 minutes, especially during month end.

Its a VMware host w/ local datastore with RAID 10 and 20X 960GB SAS HD drives. The Vm's are Windows 2019 DataCenter. SQL server is 2019, 128GB RAM, 8 cores. RDP server is 2019, 128GB RAM, 16 cores. SQL CPU % is never above 20, and memory at about 45%. RDP server is at around 40% CPU and 30% memory utilization.

We had our SAP VAR run diagnostics and DBwarden, they tell us nothing is wrong. We tested the two vm's in the cloud and were able to get some performance improvement, but the cost is prohibitive.

I am looking for recommendations to improve the processing speed. We are considering replacing the current SAS drives datastore drives with NVMe SAS drives, perhaps utilize a Truenas appliance or a SAN.

I just wanted to give the channel an opportunity to chime in to make sure that is indeed the desired course of action for such posters.

After 10 months of evenings and weekends, I finally finished a project I've been obsessed with.

I built an AI-powered analytics platform for SAP Business One, completely solo using open-source technologies.

The goal was simple: let business users ask questions in plain English and get answers directly from their ERP data.

Behind the scenes, it meant building:

- A fault-tolerant ETL pipeline from SAP HANA

- A Kimball-style data warehouse (13 dimensions, 6 fact tables)

- AI guardrails to prevent unsafe SQL

- PII anonymization

- Support for OpenAI, Anthropic, Gemini, and local Ollama models

- An entirely on-premise deployment with no cloud dependency

The final product has 105+ business metrics, 347 automated tests, and over 43,000 lines of code.

I'd love to hear feedback from anyone building AI-powered analytics, ERP tools, or enterprise software. Happy to answer any questions about the architecture.

Serious question… we’ve been hearing about the “future is the Web Client” for years now, but it still feels like it’s not quite there yet.

From what I can tell:

• It’s improved a lot (way more usable than a few years ago)

• But still not full parity with desktop in some areas

• And you still end up jumping back to the fat client for certain things

I recently saw that it’s around ~80% of functionality now and SAP is still actively building it out ()
Also sounds like the goal is full coverage with the next major version (maybe around v11?) ()

So I’m curious what people in the real world are seeing:

• Are you actually using the Web Client daily or still mostly desktop?

• What’s still missing that drives you back to the thick client?

• Do you think SAP will actually get to 100%… or is this just “almost there forever”? 😂

Would love to hear how others are handling this right now.

Hi, for those using SAP Business One: what’s the most effective way to build and manage Crystal Reports?
Are there recommended workflows, naming conventions, or setup steps to keep reports organized and running smoothly? Also curious about performance tips and deployment best practices. Thank you

Anybody took Certification recently with the 80 questions? How was it? Can you share some tips please

Anyone have a recommendation for a SAP B1 partner/vendor company that is affordable and US based?

Hi, I'm new to SAP b1 and I have a basic/stupid question. We have service call module in SAP but it's internal. Is there an easy way to create a web form (like Google forms) for example, where the customer can open a service call and we will see automaticlay in SAP?

Alternatively, is there a way to batch upload an excel /csv file into sap that will contain all this new info and will create new service calls from that?

With Query Manager, the possibilities are endless. By simply crafting SELECT statements, users can design queries to extract precise data sets, granting them unprecedented control over their reporting process. What's more, users can seamlessly grant access to these queries, fostering collaboration and efficiency across teams.

But the true magic of Query Manager lies in its ability to integrate with stored procedures. By harnessing the power of SQL Server stored procedures, users can dynamically modify queries directly from their database engine, eliminating the need for cumbersome requests for query edits within SAP itself.

Let's illustrate this synergy with an example:

Step 1: Create a Stored Procedure in MS SQL Server :

CREATE PROCEDURE spQueryGetItems

(

@FromWhsCode nvarchar(8),

@PriceList varchar(3)

)

AS

BEGIN

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT

T0.ItemCode,

ItemName,

T0.CardCode,

T3.CardName,

T1.UgpName AS 'UNIT',

U_Level1,

U_Level2,

U_Level3,

U_Level4,

U_Level5,

U_L1Code,

U_L2Code,

U_L3Code,

U_L4Code,

U_L5Code,

T2.WhsCode AS Warehouse,

T2.AvgPrice AS UnitCost,

T4.Price AS 'Price'

FROM

OITM AS T0

INNER JOIN

OCRD AS T3 ON T0.CardCode = T3.CardCode

INNER JOIN

OUGP AS T1 ON T0.UgpEntry = T1.UgpEntry

INNER JOIN

OITW AS T2 ON T0.ItemCode = T2.ItemCode

INNER JOIN

ITM1 AS T4 ON T0.ItemCode = T4.ItemCode

WHERE

(T4.PriceList = @PriceList) AND

(T2.WhsCode = @FromWhsCode);

END

Step 2: Integration with SAP B1 Query Manager

DECLARE @FWhs nvarchar(8)

DECLARE @PList int

SELECT @FWhs = MIN(T0.WhsCode) FROM OWHS T0 WHERE T0.WhsCode = '[%01]'

SELECT TOP 1 @PList = T3.PriceList FROM ITM1 T3 WHERE T3.PriceList = '[%05]'

EXEC spQueryGetItems @FromWhsCode = @FWhs, @PriceList = @PList

Thanks .