Sage 100

Has anyone used the new v2020 feature under File, Desktop Utilities, Customization Import? I have an upgrade from 2017 to 2020 and have classic users on the 2017 version with shortcuts and the boxes to check for importing are blank. There doesn't seem…

We are talking with a potential client that uses Timeclock Plus. With their current payroll module, they are manually enter the time transactions from reports printed from Timeclock Plus. I called their rep and she told me that it would be an 8 to 16…

I am using VI to Import an SO Invoice batch. The batch is automatically being created as an Invoice batch (batch type I). I need it to be a Shipping Batch (batch type S). I don't see anywhere where that can be assigned in the import job. Other than DFDM…

I need to re-migrate system settings during go live after a long pilot testing period. Multiple changes have been made in the source version since the pilot began. I was wondering if I can export the security roles and user settings from the upgraded…

Hi, I am pretty new to Sage 100 and I am still getting up to speed. We had a server crash at the office. I was able to reload Sage 100 and restore from backup. My problem now is getting into the archives for previous years that I do not have backups…

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,…

On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…

Having an issue with Cost Codes in an import into Job Posting Entry. The cost codes, with "-", are longer than 9 characters, and I do have the Skip Source Data Transaction checked. It still did not like the Cost Code, so I did a calculated field where…

I am work with VI to import AP invoices. One of the required Fields is the GL Account Key. I am looking for a way to look up the GL Account Key to be entered into the record for importing AP Invoices into Sage 100?

Hello all, Need some help. Hoping someone else has seen this before. Trying to use a VI import on a table I haven't imported into before. Asked if my Job_Name was a new VI job. Hit Yes and... POOF. Pop up error. Unable to instantiate BO_BillOfLadingMargin_bus…

I have a client his mas90 program crashed. He has a backup. Can i get the name of a company that can help me import the data into sage 100

Hello, Today I had someone want to delete a batch that was entered into A/R cash receipts entry. When I try to delete it, a pop up box says "Missing or Invalid Header," and I am not allowed to delete the batch. I have seen this error before while importing…

Have upgraded a client who uses a spreadsheet to import payroll. They have about 10 columns, so have about 10 linked payroll imports. In the prior version, the Deductions were Yes'd on the last import (Regular pay), because it assumed everyone would have…

The original statement we have is as follows - Temp001$=“458” I want to include "459". How should the formula look? Temp001$=“458, 459" or Temp001$=“458” or Temp001$=“459”

I'm trying to design a VI job to import manual payroll checks to assist with conversion from another payroll system. When I test it the log says all the records are importing successfully; however, when I actually try to import the data the header record…

Hello, please i have a question, I created more than 4000 product with the parameterizable file, and I put the price in incl tax and the problem sage considers it as a price in excl tax and it adds VAT again. is there a way to define at once that the…

Hi Everyone! We are going to be using Concur Standard to handle our company credit card expenses. The Concur rep told me to contact Sage and ask for a sample input file so she can customize our upload file to Sage's specification. I contacted Sage…

We have a Sage Customer that manually inserted a qty of 1 for every inventory item for every warehouse. I feel that the last updated date is not being updated to allow our interface to retrieve the information. Any methods to update a lot of inventory…

I'm running into a problem with an import job from Excel where the VI Job passes in Test mode but not when executed. If there is more information needed please let me know and I will try to get it. Keep in mind that I was not fully trained in this…

I am able to import records into the WOS and WOU files individually through visual integrator, but the issue I am having is how to determine the Line Index for the WOU file. I can get the index from the WOS file after I import it in, but I would like…

Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.

We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…

I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016. The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…

I have an integration built that works really well. The problem I run into is if the order has more than 40 lines on it, I get an "Internal Server Error". Is anyone using it in a similar manner and have you run into this? Is there a workaround or…

Is there a fairly simple straightforward way of importing timecard information into payroll data entry without using Visual Integrator? Thanks!