Sage 100

 View Only

  • 1.  VI Sales Order Import to Existing Line Key

    Posted 11-25-2019 14:57
    I am having a difficult time changing the line detail using a VI import to an existing sales order. I found and followed Sage Knowledgebase Article 20570 that indicates this is possible, however I am having no luck. The VI seems to ignore the line key assign and just creates a new line instead. Has anyone been able to accomplish this? All information is the same on the change import except the bill options assigned. Thanks in advance!

    ------------------------------
    Kimberly Davis
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: VI Sales Order Import to Existing Line Key

    Posted 11-25-2019 15:10
    H field points to the SO# with the first two L. fields as SO# and the line key (zero padded)?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: VI Sales Order Import to Existing Line Key

    Posted 11-25-2019 16:22
    I don't know what you mean. Can you explain? How do I put the sales order number in the lines?

    ------------------------------
    Kimberly Davis
    Lehman Wesley & Associates
    ------------------------------

    Original Message


  • 4.  RE: VI Sales Order Import to Existing Line Key

    Posted 11-25-2019 16:54
    Sorry... two L fields should be LineKey and what you are updating.  Example:

    And it works!


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: VI Sales Order Import to Existing Line Key

    Posted 11-26-2019 01:17
    If I recall correctly from a recent VI job I worked on, the L.LineKey field will only be set if you use the Replace operation, which is disappointing because I was trying to do a calculation on it.

    Here's a simple source.
    The target order.


    The VI job using Replace on the L.LineKey.

    The results.

    But if i switch the L.LineKey to Assign, it creates a new line.

    The results.

    Even using this yields a new line.

    There are a couple ways around this, either perform logic or a temp field set to the Calculated operation that instead calls the EditLine method using whatever value you want to pass to the GetEditKey method.
    The temp field must be before the L.* fields.

    The temp field must be set to Line Record and depending on what you are doing, you may want to reset on every record.

    The calculation.
    coBusiness'Lines'EditLine(coBusiness'Lines'GetEditKey$("000003"))​

    The results.


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 6.  RE: VI Sales Order Import to Existing Line Key

    Posted 11-26-2019 15:40
    This worked!! Thank you so much for your help!

    ------------------------------
    Kimberly Davis
    Lehman Wesley & Associates
    ------------------------------

    Original Message


Related Content