Skip to Content
avatar image
Former Member

Batch number in Goods Issue

May 08, 2017 at 05:43 PM | 157 Views

Our company inventory stuff who creates Goods Issue can't check inventory, so I need to create an approval process when people submitting the Goods Issue. And I need to add a query for the approval process.

This query will check the item batch if it was allocated or committed.

Could you tell me which field in the table OIGE indicated the item batch number?

Or Sap b1 has other methods to fulfill this function?

Thank you,

SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Nagarajan K
    May 14, 2017 at 12:42 PM

    Hi,

    Approval process does not work on row level. You can try with transaction notification.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Danilo Kasparian
    May 08, 2017 at 07:51 PM

    Check IBT1 table, there you can find all the batch movement. BaseType 60 indicates oInventoryGenExit (Goods issue)

    Add comment
    10|10000 characters needed characters exceeded