Set Value - Selecting a certain field to be updated Answered

Sarah Swettlen

Hello!
Here is the situation I am in and what I am trying to accomplish:

1. Customer has a Sales Bill of Material. When added on a sales order, they want the child GL Account to match the parent GL Account

Example: Parent Item is Parent 1 GL Account 1000-10-100

Child Item is Child 1 GL Account is 10000-20-100

How can I have my set function to update the child GL account to match the parent?

They are never on the same lines of a sales order, so when setting the SET function, I have been unable to select the correct Syntax

Comments

1 comment

  • Comment author
    Yaremi Miranda Lopez
    • Official comment

    Hello Sarah,

    In this case you need to create something like this:

    -A line loop that will be executed before SAP creates the document.

    -The line loop will include a condition that validates that the item is included in a BOM type sales.

    -If the condition is met, the Lineloop will execute a macro with the command SET, but the value of the account should be the result of a query.

    Here are some examples in our online help to accomplish the last part of the functionality:

    https://help.boyum-it.com/B1UP/index.html?macro.html

Please sign in to leave a comment.