cancel
Showing results for 
Search instead for 
Did you mean: 

Batch at Good Receipt from Production.

Former Member
0 Kudos

Hi all

The scenario is if i am creating the production order of any item then at the item of issuing the Raw Material or Semi finished Goods the new Window of batches opens and by selecting the batches i can issue the components easily But at the time of receiving the items from Production then in the batches window i have to put batch no manullay but i want to see those batches which i used at the time of issue for Production based on Production Order wise..

I tried to create the FMS as well in the Window of batch at receipt from Production but the FMS Is not working over there...

I need the solution as early as possible please provide it and if there is any any Fms Query then please forward it as well.......

Thanks and Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Dear sap.ankit06,

It is not possible to see the batch numbers that you used in the Issue for production available for the production father because the items are different.

As you said you can add the same batch manually.

An alternative could be:

- create a UDF on the Receipt from Production at row level. Please, remember that the Receipt from production is table OIGE /IGE1. Therefore the field should be added in the marketing document at row level;

- create a Formatted search that looks into the IBT1 table where the movement of batches for the Issues for Production is recorded;

You can use this query to search for the correct baseentry of the Issue for Production:

SELECT T0.[BatchNum] FROM [dbo].[IBT1] T0 WHERE T0.[BaseType] = '60' and T0.[BaseEntry] =[%0]

The query will give you the batch used in the previous document and you can reuse it for the Receipt from production. However, I am concern that this business process can create confusion in the batch tables.

Please, let me know if this information helps you.

Regards,

Marcella Rivi

SAP Business One Forums Team