#sapb1 — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sapb1, aggregated by home.social.
-
Biometric Integration Addon for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking & workforce management
🔗Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
📺 Watch Overview: https://youtu.be/gD4a9aLrokM?si=UtCkMUJk3FKhmNQ8 -
Biometric Integration Addon for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking & workforce management
🔗Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
📺 Watch Overview: https://youtu.be/gD4a9aLrokM?si=UtCkMUJk3FKhmNQ8 -
Biometric Integration Addon for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking & workforce management
🔗Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
📺 Watch Overview: https://youtu.be/gD4a9aLrokM?si=UtCkMUJk3FKhmNQ8 -
Automate your GST reconciliation with our SAP B1 Addon. Effortlessly match purchase and sales data with registered returns to ensure total accuracy and seamless tax compliance.
🌐https://www.kabeerconsulting.com/gst-reconciliation-addon-for-sap-b1/
🔗https://youtu.be/41MEzXVSXnA?si=zWdHa1LcuhwDNgHk -
Great Day Everyone! 🚀
We are Extremely Happy to share a proud milestone with you all — the successful Go-Live of our Barcode / QR Code Add-on integrated with SAP Business One for a leading Fastener Manufacturing Company in India!
A huge appreciation to our incredible Sales Team, Support Team, and Functional Experts who worked tirelessly to make this project a grand success 👏👏
#SAPB1 #GoLive #Barcode #QRCode #Manufacturing #DigitalTransformation #ERPforSME #KabeerConsultingGroup
-
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility
🌐 https://www.kabeerconsulting.com/transport-management-system/
🔗 https://youtu.be/eFi7T9crD6o?si=57qZfgQvv1QfcLeQ -
SAP B1 ERP for the Food Industry, streamline your entire process — from sourcing to production to delivery — while staying fully compliant and traceable.
🔗 Learn More: https://www.kabeerconsulting.com/industries/sap-b1-food-industry/
https://youtu.be/b-wBBOXiKSE?si=DztSBZqoJFtFxbqN -
May Lord Hanuman bless you with strength, courage, and success. Wishing you growth, prosperity, and positivity in all your endeavors.
Happy Hanuman Jayanti by Kabeer Consulting Group#HanumanJayanti #HappyHanumanJayanti #BusinessGrowth #Success #Strength #Prosperity #SAPB1
-
SAP B1 ERP for Food Industry | ERP for Batch Control, Shelf Life & Quality
🍞 Running a food business and tired of juggling spreadsheets, quality logs, and manual tracking?
-
🚀Kabeer – A Global SAP Partner needs your attention for a quick announcement!
We are delighted to inform you all that we have officially kicked off the SAP Business One implementation for a large company in the Poly-Chem Industry based in Delhi.
This is a great achievement and a reflection of the hard work, dedication, and teamwork shown by everyone involved.
Very well done, Team! 👏
#SAPBusinessOne #SAPB1 #SAPImplementation #GlobalSAPPartner #ERPForChemical #PolichemIndustry
-
Best Maintenance Management Application for SAP B1
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Introducing HANA
While I had planned something about the General Ledger for this newsletter, circumstances changed, so I’ll do something entirely different.
As many of you know, I’m no longer with Scientific Device Laboratory. If you’d like to know more about that situation, I have described it in detail here, but the very short version is that I lost the ability to access SAP B1 for this newsletter for the last nine months.
Fortunately, I found someone to help. Richard Duffy and SMB Solutions are graciously providing me with a new Demo instance of SAP Business One, but with one Wrinkle: It is HANA.
Before I go into anything other topics, I’m writing a series of newsletters about how HANA affects SAP B1. We’ll cover the basics of how to write queries in HANA for those curious or needing to translate SQL to HANA and back. Once we have all that, I’ll share with you what I plan to do about writing this newsletter on a HANA system. I’ll assume you know SQL or have taken my course SAP Business One Reporting and Customization.
First, let’s give a little background on HANA. SAP decided several years ago to make a database system they could use across their product line. It has its pluses and minuses. The marketing for HANA was often around its speed due to the in-memory column-based database.
Data in a computer system is stored in dimensional sequence, not the two dimensions we associate with a table. It is as if you had a spreadsheet of only one row.
The best we can do to represent a table is to take the rows or the columns as groups, add them in sequence, then add the next row or column.
Let’s suppose you had this table:
The data would be stored in row order like this in a row-based database.
This is fast for performance in adding and deleting data but presents performance problems in calculations. To get a sum for balances, for example, you have to load each row, get the balance, add it to the total, and then get the next row, which is lots of work.
On the other hand, a column-based database would do this:
All the data for the columns are grouped. To get a sum, it loads the column and sums it. Unlike the Row-based arrangement, there is no jumping around in the data, making it much faster. However, this usually requires in-memory access to the data instead of on-disk access. Such an arrangement requires a substantial amount of memory to run efficiently. Also, insertions and deletions of rows are more complicated as you add data in several places, not as one group.
HANA is not the only column-based database. Data analysis tools like Pandas and even Microsoft SQL Server 2012 have in-memory processing in columns.
Because the HANA implementation of the SAPB1 started from scratch, you will notice a different User interface when running HANA compared to a SQL Server version of Sap Business One. My disparaging quip about SAP B1 UI being as fashional as Windows 95 is no longer accurate.
I’ll discuss this UI in a later column, but from now on, you’ll see screenshots like this in my newsletters.
The real fun begins when you start making queries. HANA has its variant of SQL. Creating a query in the SAP B1 Query Generator of the names and quantities of inventory items produces this query.
SELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited",T0."OnOrder" FROM OITM T0
You’ll notice the double quotes on the column names. Double quotes are required on column names. Some, like the table name, have optional quotes, but putting quotes around all tables, columns, and aliases like TO is legitimate and often good style.
SELECT "T0"."ItemCode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "OITM" "T0"
What’s in the Quotes is case-sensitive. Can you spot the two errors here?
SELECT "T0"."Itemcode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "oitm" "T0"
“T0″.”Itemcode” and “oitm” do not have the proper case. Interestingly, it will work if I do oitm without quotes.
Comments are still two dashes. Like many other programming languages, HANA adopts the
/*and*/for block comments.-- This is a comment/*This is a block comment. You can add several lines until you use the termination character on the next line.*/
Basic selection, literal strings with single quotes, and sorting also work the same as SQL: this query works with a parameter and sorting:
-- A comment is two dashesSELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM OITM T0 WHERE -- Compound data filter T0."SellItem" = [%0] -- Parameter AND T0."PrchseItem" = 'Y' -- String Literal AND T0."OnHand" > 0 -- ComparisonORDER BY T0."IsCommited" -- Sorting
If you look at only the basics, HANA looks a lot like SQL. However, once you get past the syntax, HANA starts getting different from SQL. In the next newsletter, I’ll look at some commonly-used functions in HANA.
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness