Skip to Content
author's profile photo Former Member
Former Member

Table for batches and SP_Transaction Notification

Hi there,

You have a good receipt for some items (items with batches definition on every transaction).

When you press create, a new form appears for batches definition. When you finish creating batches, press update button (Question N°1: Can I capture these fields values using SP_Transaction Notification for batch definition?) and go back to good receipt form (The button CREATE still appears in good receipt form).

Question N° 2: In which tables are the batches definition located for that good receipt before create the goods receipt?

Thanks and regards,

Fernando.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 01:41 AM

    The SBO_TransactionnNotification does not trigger till the GRPO is added. the Batch screen values are stored in a internal temp table which you might not have access.

    The Batch number tables are OIBT and IBT1

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 02:18 PM

    Hi Fernando

    What do you want to achieve in terms of "capturing" the batch information. Do you have a specific requirement that cannot be dealt with in SAP Business One? If so, I think the answer would be to try a query and Formatted search on the batches screen, but I need your response to the aforementioned to ascertain this.

    Kind regards

    Peter Juby

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Fernando,

      I exactly understand what you are looking to do and as I said the values in the batch window are not accesible in the GRPO window. Not even through formatted searches.

      The 2 options are

      1. Write the values in the Batch screen to a temp table in SQL Server and fetch the values from there on the GRPO screen

      2. Write some SDK Code to achieve this

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 08:49 AM

    HI Fernando

    As Suda said, this will not be possible in standard SAP Business One. SDK would be the best alternative.

    Kind regards

    Peter Juby

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.