Sage 100

 View Only

  • 1.  VI Invoice Import

    Posted 10-15-2020 16:42
    I am trying to create invoices for orders that shipped by ways of a VI job. The VI job only has the Header info including the SO Number but when I run it it creates the Header but will not bring in the the Detail Lines. Am I missing something or does the VI job not follow the standard BOI rules? When I manually create an invoice, all the Detail lines of the order are automatically populated.   TIA

    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------


  • 2.  RE: VI Invoice Import

    Posted 10-16-2020 12:14
    What version of Sage?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: VI Invoice Import

    Posted 10-16-2020 12:19
    You can either use perform logic set up on the after assign of the sales order number or use a calculated temp field set up as a number on the header and set to clear after each record.

    You want to use the detail object's CopyLinesFromSalesOrder method. The first argument is the sales order number and the second argument indicates to ship in full ("Y") or not ("N").


    You can toggle the ShipComplete$ variable's value between "N" and "Y".
    0; ShipComplete$ = "Y"; oLines = coBusiness'Lines; If oLines > 0 Then If oLines'GetRecordCount("Main") = 0 Then Var = oLines'CopyLinesFromSalesOrder(Temp001$, ShipComplete$); oLines'MoveFirst() End_If End_If ! '​


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



  • 4.  RE: VI Invoice Import

    Posted 10-18-2020 10:59
    @David Speck II Thank you so much. The calculated fields worked the first time and exactly as I needed them to. I have no idea what it's doing or how you know all this stuff but I'm just glad that you do. Really appreciate your help. Thanks again. 
    @Jeff Schwenk They are running version 2016 Advanced.​

    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------

    Original Message


Related Content