Sage 100

Hello everyone, apologies if this has been asked before but I wasn't able to find something quite like this. We're on SAGE 100c 2018 v6.00.6.0 I have a script I want to run on a table to update the batch comments based on a few conditions. I have…

We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…

General Ledger posting on transaction register but not posted to the gl but posted to bank reconciliation module

For FFCRA, we need to add the same 4 new GL Accounts to over 200 different companies. Does anyone have a suggestion on how to "automate" this process? We are using Sage 100 on SQL Server. My background is in MS SQL Server database management and development…

Hello everyone, I'd greatly appreciate help with generating a total revenue report for all customers within a certain date range. I've tried using the "Revenue by Customer" report and wasn't successful. I wasn't allowed to select all. I've tried…

As I understand it, if I change the "active" status to "delete" on a GL Main account prior to closing the year, the account will be removed once I complete the year end process. If I do that, do I lose the history too? Many of these accounts have not…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

I am trying to check the box under GL Options for Integrate with Bank Reconciliation and I get this message: You cannot enable or disable integration to Bank Reconciliation while Transaction Journal Entry is in progress. I do not have any TJE in progress…

Client reported an odd situation where they would be doing a VI import and the GL account number in the import file would be changed to an entirely different account number for a number of different accounts upon import. If you used file explorer to look…

Dear experts Using Excel need to pull the data that the general ledger detail report displays but I need to add invoices number, invoice date, comments... what tables in Sage 100 gives me: GL Account Number, description, Date, Journal Comments…

We have revamped our naming convention for "budgets". I want to delete the old budget codes. I went into General Ledger, Setup, GL Options, "Budget" tab. When I click on the old budget name I want to delete, I get a message that states I cannot delete…

I tried searching for answers to this issue, but was surprised to find that nothing addressed this not uncommon issue. We had a customer that was invoiced for a purchase and paid with a credit card. It turns out it was a fraudulent credit card. Recently…

Has anyone seen this before? I'd like to pass it off as just a little hiccup in our system, but if truly random it makes me wonder how many other little random hiccups are not caught... and if not random what was done wrong to cause it... so we prevent…

We added a third segment to our GL account structure using the wizard, We went from AAAA-AA to AAAA-AA-AA. After the change was completed we can pull reports etc and see the accounts but any time we try to enter anything into the GL it says "this account…

I need to run an Income Statement for an odd time period for an insurance audit (Mid -Month to Mid- month) for a 6 month time period. Is this possible?

The finished goods on my balance sheet is way to high. where does Mas 90 get this number?

Our finished goods number is badly out of sync with our valuation report under inventory management. I understand the two are not connected but they should be in the same ball park. my finished goods number is much higher on the balance sheet. we actually…

Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…

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 am trying to merge two accounts together but I get the following errors. Any ideas on possible solutions?

Hello, The new company I work for has several cash accounts that the adjusted bank balance per the bank rec are not matching up to the GL amounts that hit the balance sheet even though the out of balance amount is zero on the bank recs. 2 of the accounts…

I see that I could do it this way, but there is a limitation. Here is what I would do if I was to delete the last segment: 1) Export GL_Account to Excel/csv 2) Remove the last segment in the Excel sheet. 2) Use Data File Display and Maintenance…

I am only familiar with the surface level of Sage products therefore, how can I use data that is in an excel format and import it into AR to generate invoices? We are currently putting the information into excel and than retyping item codes and descriptions…

We have a PO that was received and updated, then invoiced and updated, and then paid and updated. However when I go into A/P - Vendor Maintenance - Invoice and click on the invoice the Source Journal Drill down is gone. I also pulled up the GL Detail…

Our fiscal year has ended and in reviewing the detail GL I have found that sales from the previous fiscal year were updated to the current fiscal year, due to a date error. All sub-ledgers have been closed, and the G/L has also been closed for the last…