• Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
  • SO Invoice Data Entry: Button Script to get Invoice No from an SO No

    I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker. Essentially, instead of the user typing the invoice # they would type the sales order…
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • Need the Administrator password for Sage 100cloud installation to migrate the data to the latest version

    I have just setup an existing Sage100c customer on the Sage Provisional Portal and I am trying to migrate their Sage 100c 2019 version to the cloud version 2020. Now I did not install the Sage 100cloud so I do not have the Administrator password however…
  • Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window?

    Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window? I tried and I can't get it to work. Not really familiar with scripting, but this seemed like it would be easy.
  • Add a column in BIE? Help, I am not that smart!

    I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…
  • How to upgrade from MAS 90 3.71 to Sage 100 2018

    I am trying to upgrade from MAS 90 3.71 to Sage 100 2018. Could someone tell me which versions I need to upgrade to get to the latest version? Thanks,
  • Add a Spell Check to Extended Description, Memo's, Notes, UDF and other Text Box Fields - PLEASE VOTE!

    It would be great to have a Spell Check to find common spelling errors in Sage 100! This would eliminate embarrassing misspelling on invoices and other documents that go to customers and/or vendors. • Have the ability to turn the Spell Check on/off in…