Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Batch Number in Pick List

Hello,

I am using SAP Business one 2005A Patch level 29. In the pick list I would like to include the batch number of the goods to be picked. That is based on the expiry dates and those with the expiry dates closest are picked up first -- FIFO.

Before I start thinking of developing an add-on for this, is there a work around for it , a simpler solution ? Has some one worked on this before ?

replied

Martin,

Batch numbers can be associated to an Item at the Sales Order stage. Using the usual CTRL+Tab on Quantity.

Once this is done, you can try to use this sample query, replace {your Sales Order No} with the actual Sales Order Number

SELECT T0.ItemCode AS 'Item No.', T0.BatchNum AS 'Batch', T0.BaseType AS 'Base Doc. Type', T0.BaseEntry AS 'Base Document Key', T0.BaseNum AS 'Base Document Number', T0.DocDate AS 'Posting Date', T0.Quantity AS 'Quantity' FROM [dbo\].[IBT1\] T0

WHERE T0.BaseType = 17 AND T0.BaseNum = {your Sales Order No}

You can create User fields in Inventory > Pick List Rows

On this User field add a Formatted Search using something like

SELECT T0.BatchNum AS 'Batch' FROM [dbo\].[IBT1\] T0

WHERE T0.BaseType = 17 AND T0.BaseNum = $\[$11.18.0]

Please test this first

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question