Sage 100

Our Accounts Payable Specialist tried to export a positive pay file and received the following error: "Unable to create the export file using sequence number 0 through 9. You may need to rename or remove existing export files and run the export again…

I am working on building two VI Jobs that will automate our Cash Receipts Entry process. The first job inserts into the AR_CashReceiptsDeposit table, the second will insert to AR_CashReceiptsHeader so our AR Manager can simply spot check for accuracy…

How do I import the calculation method and commission rate for items? (IM Setup has been set to calculate commission by item) CI_Item does not contain those fields.

Running Sage 100 v2018. We receive an import file containing AP Invoice information. Within the import file there is a Purchase Order number. I am trying to figure out a way to match the PO number from the import with the PO number within the PO_ReceiteHistoryHeader…

Hello, I'm working on a VI Job to import a csv list of active Sales Orders with Sales Order Number, Line Key, the current Item Code, and the new Item Code we want to replace it with. It worked fine in our test environment except for the quantity ordered…

we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.

We have several people importing AP invoices and we have had a few instances that invoice was imported a second time. Does anyone know of a way to get these to flag for duplication? Brenda

I'm working on trying to export purchase orders that need to contain both line detail as well as the Total Amount of the PO but it appears the Total Amount is not a selectable field in either PO_PurchaseOrderDetail or PO_PurchaseOrderHeader. The client…

When chaining import jobs I thought they run concurrently without you having to manually clicking to accept the next import? I am pretty sure it ran through the imports the first time I did it, I did add another import to the end of the chain, would this…

I am working for a CPA on a financial review and do not know Sage 100. I need to download all sales transactions for a 3 year period into Excel. Can anyone tell me the most direct way to do this? I have been told Crystal however I am looking for help…

I am working on exporting PO_details through an ODBC in Access, teaching myself as I go. My query is close to what I want but, I need to find the table for the distribution of the "LineKey". In SO they have a table SO_SalesOrderTierDistribution, in the…

I can not find to much help on chaining export files together. Pretty sure this is a simple fix but I am struggling to find it. Trying to export Purchase Order information, header and details. I have the fields selected that I want to export from the…

Hello! Very new to Sage 100 and the forums. I have an excel spreadsheet from my purchasing manager, and we want to update 173 individual item codes with 173 new codes, and assign them all the same new product line. There may have to be multiple steps…

Hi Everyone , i just installed sage100 with 2012 express,will have this error when open the .mae please help and advise.

I am upgrading a client to Sage 100 V2020 and am running into issues with some Excel spreadsheets that have been working for years in prior versions of Sage 100. In V2020 the client upgraded their Excel version from 2013 to Excel 365 Enterprise 64 bit…

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

Hi, I'm trying to find a way to remove the price overrides someone created for a single customer, which has over 3,000 price overrides. It's too much to delete manually. I'm wondering if there's an easy way to simply delete all of the price overrides…

This is happening after our sales associates are done creating the sales order and have already clicked the EMV button, and swiped the card, then when the go back to click the "Get EMV Pmt" button, the sales order is gone. The credit card processes fine…

I went to process an ACH payment for a vendor invoice & it had a line that showed double the amount of the invoice. The total line was ok but when I got further in the process it said the daily transaction register was out of balance. The vendor inquiry…

Hello, We are currently entering journal entries manually and I would like to look into my options to do imports. I have heard the options to do this are through the GL Exchange or through Visual Integrator but I don't have a clear idea to the pro &…

I've got a Visual Integrator export job that I'd like to to be able to Select by the DateUpdated field in the CI_Item table. According to the CI_Item column list in File Layouts and Program Information, it should be field 85, but the list of selectable…

i have created a VI Job that I am trying to use to reverse a large amount of checks. Each check has one invoice. I do not want to recall original invoices but create a distribution amount to a GL acct. When the job is ran it automatically recalls the…

Hi Everyone When I try using the VI for Manual check imports I get an error. All the error is showing is the invoice numbers. IT seems that it is not being recognized as a new invoice., I do not see any option of putting in a NEW Invoice code from…

Hello, running into a strange issue here and a bit stumped. Running Sage 100 218 Premium (SQL) We have a customer who has no sales / invoice history, however in the AR Customer Maintenance / Inquiry module under Summary is shows values for Sales/Cogs…

My AR Delete and Change Customer Utility had 2,500+ entries in it this morning that I didn't place there, and it appears that the customers listed were dormant and were already purged out of our system. Any ideas on how this data got out there? We are…