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

Saving multiple lines related to a Document Line

Hi all,

does anyone has any idea how to do this?

I'd like to save data related to each row of a SalesOrder

in the same way a userfield added to a line is saved

automatically with the order

(that is in the same "run unit").

The problem is that my data are a matrix:

for each SO line I have to save many lines (no fixed number) with 2 columns.

The idea is the same of specifying which batch numbers

I ship in each delivery line: for each line I can specify

more than one batch number.

With user defined fields I can only add columns to a line.

Is there a way to do it?

TIA

francesca

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 29, 2005 at 08:35 AM

    Ciao Francesca,

    I think you will have to create a user-defined table (UDT) for that and store your data there.

    In the SalesOrder from you would have to use a UDF to enable the user to access the additional data in your UDT:

    - react to <TAB> when pressed in this UDF

    - launch a form with a matrix on it that will display or accept the data with all the consequences regarding

    ..- matrix handling

    ..- keeping the data in memory until the SO is saved

    ..- data serialization (UserTable object in DI API) etc.

    - preventing data manipulation in the UDT through the standard access to UDTs in the menu

    HTH,

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Francesca

      I have a same problem with you.

      I called UDF from sales order line level.

      Then I update/add UDT's records.

      Problem is after updating UDT, user can click cancel button from Sales Order form. It means the UDT's records should be rollback.

      I put StartTransaction command on Sales Order form ItemEvent and EndTransaction command on Add/Update and Cancel Button Click Event.

      But after StartTransaction, my add-on to search data from UDT does not respond at all. I have to kill the B1 process.

      I really hope somebody can help me.

      If rollback and commit action does not work, I have to redesign my addon to save before updating data.

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.