Group logo of B1 Functional Tips and Tricks

B1 Functional Tips and Tricks

Gary Robert Sales + 72 Members

Item Master Data Workflow

Back to Discussions
May 18, 2026 at 3:31 pm

Item Master Data Workflow

I saw this great post on LinkedIn for an Item Master Approval Workflow. Abdelrahman Zaghoul’s post shows how to create an approval flow for Procurement Manager → Warehouse Manager → General Manager. Similar processes could be made for any specific workflow required following his 3 step zero code process.

1. The Default Lockdown:
I configured the system so that every newly created item automatically defaults to “Inactive.” No one can add it to a Sales Order or GRPO or any marketing document by mistake.

2. UI Hardening via UI Configuration Template:
I added 4 custom UDFs (Procurement, Warehouse, GM, Stop Alert). To prevent users from cheating the system, we locked the fields based on roles:
– Normal User: All 3 approval dropdowns are completely disabled.
– Procurement Manager: Can only edit their own dropdown; others are grayed out.
– Warehouse Manager: Can only edit theirs; others are grayed out.

3. The Automation (The Magic Link):
Once a user saves the item, an alert fires to the Procurement Manager. Once they flip to ‘Yes’, the alert moves to the Warehouse, then to the GM. The moment the GM flips the final ‘Yes’—a HANA/SQL Transaction Notification script instantly runs in the background, flipping the item status radio button from “Inactive” to “Active.”

https://www.linkedin.com/in/zaghloul07/?lipi=urn%3Ali%3Apage%3Ad_flagship3_feed%3BPLBdt%2BFNS%2FmgjXG4qAzmUA%3D%3D

  • Abdelrahman

    May 18, 2026 at 5:30 pm

    Thank you for sharing

  • Rahul

    May 19, 2026 at 10:03 pm

    The proposed solution is a legitimate, creative use of native SAP B1 tools for simple environments with:

    It breaks — not theoretically but in production — when:

    • Silent Transaction Notification failures occur
    • DI API access exists alongside UI-layer lockdown
    • Data migration or bulk operations run against OITM
    • COM memory accumulation hits the client layer
    • Alert delivery reliability is assumed rather than engineered

    Zero-code solutions have non-zero failure modes.

    The consultant who knows where those failure modes live before the client discovers them is providing something the LinkedIn post is not.

Log in to reply.

About group

Group Organizers

  • Gary

    Active 5 weeks ago

Description

SAP Business One Tips and Tricks for functional topics.  This includes how to perform functions, configure modules and correct errors.

Group Description

SAP Business One Tips and Tricks for functional topics.  This includes how to perform functions, configure modules and correct errors.

About group

Group Organizers

  • Gary

    Active 5 weeks ago

Description

SAP Business One Tips and Tricks for functional topics.  This includes how to perform functions, configure modules and correct errors.

Group Description

SAP Business One Tips and Tricks for functional topics.  This includes how to perform functions, configure modules and correct errors.