Browse By Tags

Hi, I am having a hard time importing transaction on AR module, this notif. keeps on prompting while i keep on trying. I have searched some trouble shoot for this but still I can't proceed to what I am doing. Any help? Please! Thanks, B…

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…

I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…

I have tried looking into the Enter global Global price changes and global part change and it only give me Base, Line, and Margin, but Not Absolute option. I have 200+ items I need to change to Absolute so that I can import pricing on them. any ideas…

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…

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

Hello. We recently purchased Sage 50 Premier for our small business. Our accountant has our information using Sage Quantum. I am attempting to restore from the accountant's backup to our software, however I get a message that I cannot restore from Quantum…

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.

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

Version 6.2 PU1 Sage 300 ERP SQL 2012 I exported an I/C receipt, copy data to it from another spreadsheet and tried to import it back in as a new receipt (i.e. changed the sequence #) and am getting the following error: Description: System error.…

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…