• Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Error 26 : variable type invalid

    Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…
  • Unable to edit order line and tax amount

    Hello I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created.... And when i am trying to add a new line and over…
  • Getting error "Unable to select this batch. This batch was created in Invoice Data Entry." from SO_Shipping_BUS

    I am trying to create a new batch and use the SO_Shipping_BUS object to process a sales order automatically through Shipping Data Entry. The code works if I use SO_Invoice_BUS, but not for SO_Shipping_BUS. When I try to set the invoiceNo key, I get…
  • IM_Transaction - SetKey Failed ERP MAS 200 SQL (Version 4.50.7.0)

    Hi All, Everytime I try to set the key, failed but its working on other MAS Version (Sage 100 Standard ERP 2015 - Version 5.20.3 - Providex) retVAL = oIM_TE.nSelectNewBatch(BatchNo, "N", "Created by Auto Import") '--> Good TransactionType =…
  • Do I need to post batches for work orders, purchase orders, etc? Is there still a risk of data corruption if I run the system in 'real time'?

    I've been told that I need to run the system in batch mode. That causes issues because the time delay is down to the person/people who have the authority to run batches. We're currently on 100 2014, but will be upgrading next month to 2016 100C. Does…
  • Sage 100 Sales Order Invoice Batch posted in a future period

    A sales order invoice batch with deposits was posted to a future period. The customer inquiry shows the correct balance, however, the aged trial balance shows an outstanding balance. How do I correct the trial balance?
  • Create new Batch / Get used Batch number

    Hello, I'm inserting invoices for a client and they have requested that they all go into the same batch. I can't figure out how to create a new batch and keep using it. The best I can come up with is creating a new batch for each invoice. I pull…