PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

How to Automatic Generation of Warehouse Sublevels in SAP Business One

SAP B1 Tips Automatic Generation of Warehouse Sublevels


In the previous article, it was explained how to create a Warehouse Sublevel.

But what if there are too many sublevels you want to create? so it can be confusing if inputted one by one.

Did you know SAP Business One allows automated batch creation of Sublevel codes?

For Example:

Carlos created 10 Rows with the prefix “AISLE-“ AISLE-01 to AISLE-10.

In order to combine this code structure, Carlos did the following:

  • In the first segment field, he chose fixed and entered the value “AISLE-“
  • In the second segment field, he chose “Numeric” and entered the values 1 to 10
  • The system automatically added leading zeroes to match the longest number length.
  • Leading zeroes enable optimal alpha-numeric sorting.
  • You may create a more complicated code by defining up to 6 segments of a Sublevel code.

Here are the steps to create Automatic Generation of Warehouse Sublevels

  1. In the Warehouse Sublevel Codes window, choose the Manage Sublevels Codes button to open the Warehouse Sublevel Code Management window.

    SAP Business One Tips - How to Automatic Generation of Warehouse Sublevels in SAP Business One

    SAP Business One Tips – How to Automatic Generation of Warehouse Sublevels in SAP Business One

  2. Fill in the Range of Codes.

    SAP Business One Tips - How to Automatic Generation of Warehouse Sublevels in SAP Business One

    SAP Business One Tips – How to Automatic Generation of Warehouse Sublevels in SAP Business One

  3. Choose the OK button to open the Generation Preview window.
  4. the Preview window was opened.

    SAP Business One Tips - How to Automatic Generation of Warehouse Sublevels in SAP Business One

    SAP Business One Tips – How to Automatic Generation of Warehouse Sublevels in SAP Business One

  5. In this window, you can review the codes that are about to be generated.
  • You can also see if there is an error associated with one or more codes.

    SAP Business One Tips - How to Automatic Generation of Warehouse Sublevels in SAP Business One

    SAP Business One Tips – How to Automatic Generation of Warehouse Sublevels in SAP Business One

  • codes with error messages will appear in red. In the image above you can see the codes appear in red and all have an error message saying the code already exists.
  1. Choose the Generate button to add the codes that appear in the preview window with no error message.

    SAP Business One Tips - How to Automatic Generation of Warehouse Sublevels in SAP Business One

    SAP Business One Tips – How to Automatic Generation of Warehouse Sublevels in SAP Business One

  • Note: All generated codes will be in uppercase.

 

 

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , ,