Sage 100

When we import by Visual Integrator to update certain records it adding on another line instead of updating. Needed to update price_columns on AR_PriceLevelByCustomerPriceCode, where expected it will update the 'pricelevel' by looking the combination…

We have a new part that will be taking the place of an existing part, but only in some of the bills in which the current part is used in. The existing part is used in hundreds of bills, but it is only a suitable replacement in less than a hundred of the…

We have a client that receives about 50 to 60 Sales Orders a day via PDF's that are being emailed to them. They would like to be able to process those orders through a program that will convert them to a file format that can be automatically imported…

I am trying to create a VI job to import work orders. The job works fine, but there does not appear to be the option to use the next available work order number., the "Next Assign" feature is not available. Does anyone know how I can auto assign the next…

Hello, I have a Invoice type credit memo that I need to do and it's about 800 line items. What table, fields and their parameters I need to setup for an invoice credit memo import. I appreciate your help in advance. I got some of it the fields done…

How do I export inventory part no, descripition & quantities? thank you, charlene

I'm using Sage 100 Advanced 2017. I've been successful in coding a new MRP reporting solution for my business using the existing MP database files in Sage. One small but crucial bit of information I haven't found in the database is the actual creation…

We are preparing a global price increase but have many products that have quantity price breaks maintained in Item Pricing Maintenance. The Automatic Cost and Price Change utility works fine for the Standard Price but does not address the price breaks…

I have a spreadsheet filled out for over 200 new part numbers, all the fields in CI-item. The question I have is can I import these while people are using the system. New to Sage sorry.

Here's the deal: we need to create undervalued dummy invoices (or some kind of equivalent packing list) for international customers that work with us on CONSIGNMENT. Because the shipment is on consignment and not firm sale, we can't use a normal sales…

We want every single item to have an extended description so when we export a catalog to Excel, we do not have to manually merge or modify rows. Currently when we want to export a catalog, we must migrate shorter descriptions from one column into another…

I am sorry. I cannot find MAS90 group so that I post this question under MAS100. I have tried to figure out where the base quantity for Bill of Material in MAS90 system is stored. I was told that the Yield field in the Bill of Material Maintenance screen…

Hello all, I need to change A LOT of items' standard costs, I was trying to look for a way to import into the Standard Cost Adjustment Entry table via VI job, but didn't see this table available? Can anyone let me know what the name of this table is…

Some of the items codes we use in inventory start with a letter instead of a number. In the data grid view of Business Insights Explorer, when I try to select a custom range of item codes or do a filter builder for item codes, none of the items that start…

Hello I Need to upload my customer price list, someone can help me to do that. I did pull the file and change already price on it. but now I need to put it back, appreciate your help.(excel file) I am using sage 100 advance ERP V 5.008.00. Joe…

Ironically, every time I upgrade, I find myself with LESS functionality, not more. This one is a real problem though and I'm hoping someone has been able to think out of the box on this. Here's the situation. When we do inventory, we try to fix the transaction…

A company currently using MAS90 (don't know what version, but not a "Sage 100" one) is moving to Sage 300 later this year. They have a program that exports data to a CSV file, and one of the fields is referred to as a 'ship suffix'. The controller tells…

I am using MAS 200 V4.2. We are planning to upgrade next year but need the following functionality now. My original reseller is no longer available. I am trying to import BOM production entries via Visual Integrator. I have created an access query that…

Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third…

I am trying to create a VI import job for Reciept of Goods. We use batches for our receipt of goods, for the BatchNo field, I would like to set it as "NEXT" so it assigns the next batch number automatically, but it will not allow me to do this? Can someone…

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 have a large entry to make in Job Posting Entry. I took a shot at building a CSV file in excel and I created a Visual Integrator Job using the file JC.POSTCST. My CSV contains the following fields: CREDIT GL ACCOUNT JOB NUMBER COST CODE…

We have a small list of items that accidentally got created in the Sage default 000 Main Warehouse when a credit memo was processed incorrectly. A debit memo was done to reverse the incorrect credit memo, so the overall effect is that the quantity on…

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.

We are using Bill Options for a limited number of our products and it works great. The reason we don't use it more is we have too (to my knowledge) manage each option price individually. If we have an item that is an option on multiple bills and we receive…