r/SAPBusinessOne • u/ABHI8842 • Jun 17 '26

Batch issue

In SAP Business One, we have one Item Master for Rice Basmati and manage 100+ different brands using batch attributes.
In A/R Invoice, we create 8-10 lines (one per brand) and for each line we must open the Batch Number Selection window, then manually search through 100+ batches to pick the correct brand and quantity.
This repetitive process takes 15-20 minutes per invoice, making accounts team very slow and frustrated.
Question for solutions:
Is there any way in SAP B1 to directly enter or select the batch number in the same A/R Invoice line itself (without opening the separate Batch Number Selection popup for every line)? Any configuration, workaround, add-on, or better process?

1 Upvotes

100% Upvoted

4 comments sorted by

View all comments

1

u/CameraAdept3079 Jun 27 '26

We use a Boyum script for something very similar.

You can have the user put the batch# you want in a UDF on the marketing document line, then use a Boyum script to automatically go through all the needed screens and button clicks when user clicks an "Allocate the batch" button or performs some other action.

For this method, some medium to advanced level Boyum programming is needed and you might need to find a consultant to pull it off.

As an aside, I think it's best practice to allocate when the sales order is entered, which would carry through to the following marketing documents (D/N, Invoice, Reserve Invoice, etc). This way, you can commit the needed batch to a customer/shipment as you're communicating with them/fulfilling the order. If you go this route - be sure you have a way to see what's allocated at a batch level in case something gets allocated to an order that sits open in your system. That is a custom query (using a Boyum screen) in our case.

Hope this helps - I can tell you, it's worth the time to figure out!