Sage 100

 View Only

  • 1.  VI Import of Sales Order invoices to ship all quanities

    Posted 02-02-2022 21:15
    HI All,
       I am working on a VI import to invoice sales orders complete.  I am able to pull in all the SO data and lines but it does not ship the quantities.  I am not sure what I am doing wrong.  I am using @David Speck II logic to bring in the lines  
    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 ! '​​

      I get all the lines but no quantities are shipped.   I tried adding another temp field with with ShipRemaining()  as well as ShipRemaining(tmpSalesOrderNo$)  but got the same result.  Can anyone tell me where I am going wrong in this or what I need to do. 

    Much appreciated! 

    ​

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: VI Import of Sales Order invoices to ship all quanities

    Posted 02-03-2022 10:09
    Does Temp001$ hold the sales order number in your VI job definition?
    Where are you putting the perform logic?
    Off the top of my head, it looks like that PL should be used in the calculation of a temp field whose type is numeric.
    What version are you on?

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



  • 3.  RE: VI Import of Sales Order invoices to ship all quanities

    Posted 02-03-2022 11:02
      |   view attached

    Hi David,

      I am testing this in 2019 Standard.   Here is both a screen shot and a PDF of the job.   I took this from your post, which showed these temp fields -  nothing about PL which may be what I am missing.  When I invoice the order I am testing manually, it ships all the line quantities so I am a bit baffled on why it doesn't in VI (nothing new)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378    f 714.282.0235  Direct 714.439.9467

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     




    Attachment(s)

    pdf
    VI_ImportJobDefinition.pdf   47 KB 1 version
    Original Message


  • 4.  RE: VI Import of Sales Order invoices to ship all quanities
    Best Answer

    Posted 02-03-2022 11:16
    That should have worked. At least I'm pretty sure that worked for me in the past.
    Try changing the ShipComplete$ variable to "YES" instead of just "Y".


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

    Original Message


  • 5.  RE: VI Import of Sales Order invoices to ship all quanities

    Posted 02-03-2022 13:44
    HI David,
      That did the trick!   Thanks much.   It's these fine point differences that are maddening..  LOL

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------

    Original Message


Related Content