Sage 100

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

Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled. Thanks for your help!

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.

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…

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…

I would like to know if there is a way to change the default "General" cell formatting to "Text" in Sage 100 ERP (MAS90). The issue I am having is that when I use Item Maintenance to list a product line, we have many items that have leading zeros. These…

We recently upgraded to a new server and to Office 2013. I am running a report in business insights reporter and when I try to export the report to excel, the main excel window opens, but no worksheet and no data. I've tried several combinations and I…

Our company uses MAS 90 and we have inherited a company across town and I just need to go and export the company on their instance of MAS 90 and import it into ours. (both same version) Is there and export/import function for this? Thank you for your…

Tried to create export with VI for GL Transaction detail and it pulls 0 records. Need it to pull for a whole month. and currently using the GL_TransactionJournalHeader. Want it to pull SourceJournal, EntryNo, PostingDate, JournalComment, and JournalTotal…