Sage 100

 View Only
  • 1.  Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 09:38
    Customer on 4.5.5 using barcode. Currently uploads into SalesOrderInvoicing with no batches turned on. The question is... If we turn on batches for new functionality, how will system prompt for the batch, can we tell it to use xxxxx or does this have to be in the internal code coming from the Scanner or some other process?


  • 2.  RE: Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 11:29
    You can have your upload process specify a batch number. It has to be 5 character. If it's numberic use leading zeros. (00001). If you are creating invoices from a VB script, there is a Businss Object function to get the next batch number.


  • 3.  RE: Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 11:35
    @DougJenkins thanks for the reply. I knew I could accomplish this in VI but wasn't sure of the parameters of a scan upload. So there is no way for realtime determination of the batch ID.


  • 4.  RE: Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 11:36
    Here is a sample: If isNumeric(txtBatch) then tmpBatch5=Right(""00000""&txtBatch,5) end if retVal = oSO.nSelectNewBatch(tmpBatch5,""N"",""Batch Comment"")


  • 5.  RE: Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 11:40
    You need to know the batch number at the time of the import, if you want to accumulate invoices in a batch. You may be able to arrive at a batch number if you can send a handheld id, or a shipper id. these fields could be formatted and used as a batch id.


  • 6.  RE: Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 11:58
    Awesome Info @DougJenkins , Thank you very much.


  • 7.  RE: Customer on 4.5.5 using barcode. Currently upload

    Posted 06-20-2013 12:11
    Richard, One more thing. In your description you didn't mention if the user would be manually launching VI from the menu. You can use the ""Run Assign"" option on the H.Batch field. The user can then key a batch number.