• Sage 100 ERP 2013: Remove price overrides for 10 specific customers at once in batch process?

    Hi everyone, I'm using Sage 100 ERP 2013 and I'd like to remove the price overrides for about 10 specific customers. The customers have customer numbers that aren't sequential, but are scattered, in case that matters. I want to do this in a safe,…
  • Updating Batches via BOI

    Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…
  • Update GL_ActiveBatchComment Script Help

    Hello everyone, apologies if this has been asked before but I wasn't able to find something quite like this. We're on SAGE 100c 2018 v6.00.6.0 I have a script I want to run on a table to update the batch comments based on a few conditions. I have…
  • Business Object invoicing module's set key to an invoice number reports bogus error "Unable to select this batch. This batch was created in Invoice Data Entry." workaround?

    I have automated code that populates an invoice through the Sage Business Objects. In the module S/O and SO_Shipping_ui I am sometimes getting the error back "Unable to select this batch. This batch was created in Invoice Data Entry.". I know this error…
  • 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 =…
  • SO Batch Description

    I'm creating a Crystal Report to show the invoices in SO Invoice Data entry by batch. I want to include the Batch Name/Description in the report, but I can't find the correct table that includes that information. I know it's probably obvious but I can…
  • 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…
  • AR Cash Receipts

    We are on Sage 5.41, Can Multiple users enter a Cash Receipt at the same time with different deposit numbers???
  • MAS 90 WO are my new assignment. I'm looking for a good tut to get started on this.

    I have one week of training on Sales order entry and BOM. Now my boss is pushing me to get the work orders up and running. I'd like to find a good tutorial, or some resources. Where do I start? Is there any hope for me? I've checked on youtube. There…
  • Work ORder

    We are currently running MAS90 4.45 with upgrading planning to Sage100 underway... BUT... I have an error that I have no idea how to handle. Cannot create Batch: File WOK002.SOA Any ideas? Normally reboots of the MAS90 server clear some of the more…