Sage 100

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…

I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.

Hello, We had something strange happen once last week, and now once again today. We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…

We are in the beginnings of trying to get positive pay setup. I have our bank specifications for the positive pay file. I am learning that this file can be setup to be produced by Sage under the Bank Reconciliation module. We do not use the bank reconciliation…

Under what circumstances does the AR_Customer SalespersonNo2...5 populate? I am trying to determine if we can use this field for tracking. Thank you for your input!

I'm working with a client to clean up chart of accounts, vendors, customers, and items. We want to create a new company with no history. The plan is to create the new company and activate/set up all modules. Then, I'll copy the chart of accounts…

For context, I tried searching these forums for at least an hour to find an answer on this, but the only active discussions that popped up were 8+ years old. Either I was using the wrong search terms, or this is an uncommon issue. Apologies in advance…

Hello, I have been searching for and can't seem to find the information that I am looking for. My question is, what exactly does Year End Processing do to the data inside of SAGE? Does this make it so that fields can no longer be changed in that fiscal…

Able to export and save the positive pay file to the Application Server or the Terminal Server, but unable to save the file to another location on the local network or tsclient. We can export other files and even the ACH file to a local network or tsclient…

I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company? Any recomended procedure to pull this data to the table? Thanks for all responses!

Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies. Thanks

When in Cash Receipts Entry - the customer balance on the header tab does not always show the correct amount. Mostly seeing it show 0 even though there are open invoices for that account that have a balance on it. Not all accounts and it seems to be random…

We are on Sage 100 (Version 6.00.3.0). We have noticed, only in the last week, that we have invoices dropping line items when we switch from Lines tab to Totals tab and go to print. I am not 100% sure of this, but it seems it is just the last item…

I'm attempting to import an invoice using VI import and encountering a "HS Record Invalid or Write Failed. The Vendor Number is Required" condition. I've confirmed that the Vendor record exists but it continues to fail on the import. This error also…

I am hoping someone can help. I have ad no issue "Getting External Data" from excel with Microsoft Query prior to today. I have export customer information and Vendor information. I am trying to do the same task using table "IM_BalanceQtyOnHandWork…

I have a client that just converted to Sage 2017 and switched over to Office 365. One of their workstations is receiving the message that Microsoft Excel must be installed to import data when they try to run their GL Exchange import jobs. Has anyone else…

Hello, We're recently encountered a problem with posting AR Cash Receipts. This has occurred over the last 5 months and we haven't found a solution. A Cash Receipt is properly posted and clears the AR invoice. If you view AR Inquiry, the invoices…

I want to see a list of customers that I have added to the system since January. Is there a way to do this?

Does anyone have experience with using the SAS Concur Expense Solutions and importing the data extract via VI to the accounts payable module? or can you tell me which VI table is used for import of invoice data to A/P? Thanks!

A very odd error that I believe is a bug - the customer received payment towards an invoice several months prior and properly shows a zero balance for that invoice. Now a new payment is received from that customer. If you look at Customer Inquiry, everything…

Hello, What would be the correct query to use (what tables, etc) to pull the exact same data as you get from the Trial Balance from the Inventory module while showing every item with its value? I want to do this at month end. Basically I want a big…

A VI Job was created to import and update some data in a few fields on Customer Maintenance. Something in the VI job was wrong that wasn't caught and it ended up creating a bunch of bogus customers. Is there any utility that can delete all of…

I found invoices in AP_InvoiceHeader that move to AP_InvoiceHistoryHeader table after the invoice posted, but I cannot find any documentation on where to find payments. I created a Visual Integrator job that imports our credit card transactions as…

Is there a way to recalculate the AR aging for all customers at one time? I know we can change the setting in the setup going forward, but there are several hundred customers with incorrect aging, many of whom are infrequently accessed. We're investigating…

Hi, I've tried to search for data dictionary of all tables in Sage Advanced ERP 2015, but not successful. Please help! Thank you so much Edward