Sage 100

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

Hi, Thought I would post this as an FYI that can hopefully be found if someone searches with a similar issue in future. A client accidentally imported the XLSX version of their spreadsheet into CI_Item instead of their CSV. Normally V/I and the business…

Hi All, I have been importing sales order invoices from an external source but I can't make the price level information work properly. I would expect that if I just import the unit that the price level would be transferred to the unit prices properly…

Converting to Sage 100 and need to import jobs, estimates, and JTD costs. Does anyone have VI jobs to do any of these? Thanks,

We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read. What causes this to happen? From looking at the summary…

Using VI to import into physical count. On serialized items, if I import a new serial number (did not previously exist in the system), the "frozen" qoh (which should be 0) is incorrect. If I had 3 new serial numbers for the same part, each new line shows…

First, I'm an IT guy, but have little Sage 100 knowledge. We have created a new company in Sage. I need to move some inventory records from the old company to the new company. I have two CSV files. The first contains inventory records of items that…

We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them. I've built a VI job that seems…

We are constantly updating the Bill #'s & Quantities for Gross Requirement Reports. In an effort to eliminate that data entry, I am looking for tips on importing this data into the table (whatever table that is). Thanks, Scott

I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years. I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Hi, I am trying to load some sales orders using VI, the file that the customer is sending has some unwanted charecters in the ship to name field. I am wanting to remove them during the import. i noticed in the field properties of the ship to name…

we use visual integrator to import sales orders. I have a customer that sends us a csv file and on that file we have header and detail information on each line. so i would see something like: PO#, Vendor#, Shipto, item#, model#, sku#, ship date, qty…

Hello! I am having a problem importing records with Visual Integrator using the IM_PriceCode table. HELP! In the past, we have used this table to manually import customer pricing, basically uploading the CustomerNo, ItemCode, & Price directly into…

I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file. As an example, the import file that has been provided includes an account…

Hi, Couldnt find anything in KB so thought i would post a question. was looking to create an import that would maintain the Standard Price in Item Maintenance. is there a way to create a VI Job to CI_ITEM? has anyone done this? wanted to just…

Hello - I am looking for someone to be so kind as to post the syntax for Perform Logic to look for already posted duplicate A/P invoices during VI. I used perform logic in the past (non-framework) but do not know what the current syntax should be. …

Hi we are running MAS90 V4.5.4.0, I get a excel spreadsheet from customer, they supply PO#, check description, doc date, gross amt, disc amt, net amount paid. Currently someone manually enters into cash receipts, we have 1000s of entrys, the customer…

Has anyone used Visa Commercial Format (VCF) with MAS 90? I've been told I need to export a file in "VCF" format. Is anyone familiar with this requirement? Thanks.

When importing a new Sales Order the Primary Ship To Code is assigned to the new order even though a different address is imported and Ship To code is not even used in the import. I don't want the Primary Ship To code to be assigned to an order that is…

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

I have created a UDF in the IM_ItemCustomerHIstoryByPeriod table to store the item unit sales forecast. I want to import the forecast qty to this field, but any item that has never been sold to the customer does not have an existing record, so can't import…

I'm attempting to import MRP Demands for a client, but unlike the entry screens, the imports will not work without a customer number. They don't want a customer number related to the forecasted demand. Is there a workaround other than using an internal…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…

After importing Excel database files through the "job Select" option, I run the TEST option and it is starting to "Ignore" all the imported files, which it has never done that before. Does anyone have an idea why this would happen and more importantly…