Browse By Tags

Anyone come across the excel button in GL Transaction being greyed out? All of the other exports work, but the GL screen is greyed out, even when i have a transaction highlighted.

I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.

It appears that the beginning balance for period 1 is coming into the reports without regard to the beginning period selected. The subordinate transactions come into the report correctly, but the balances are all off because of the incorrect beginning…

Can I make GL entries to closed years?

I forgot to select "departments" as the subsidiary type in a GL direct cost GL account. There has already been activity so it won't let me change the subsidiary type. How to I fix?

In the General Ledger, I would like to transfer history in a GL Code to a new GL. The new account will not have been used before, just trying to clean up the books. Is there a way to do this?I have looked at Utilities/Change accounts, but am not sure…

Hi Team Please help to locate the Opening Balance column/field in the GL table list. Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP. Thanks Thulasi.

My company has two departments, the main account dept are doing a process called Backdating. While they do this, another department is doing customer lookups for their current balances. The issue is when the main Account Dept is doing the backdating;…

Hi I am using Sage version 2014.1. I am wondering if depreciation can be done by different groups. Meaning to say, I have a company in Sage, where all the assets listed have their own GL Expense Account. I would like to only depreciate a specific…

When you run the GL posting after disposing an asset that was not fully depreciated I get two different numbers in the GL posting report depending on how I run the report, either "all complete assets" or "active assets" ? Why is that? My reconciliation…

I'm trying to delete a job. I'm getting a message that there is Ledger Activity but no job cost or committed cost. Is there a way to run a Ledger report by job number?

I'm looking for best practices concerning closing jobs and handling warranty items after the initial job is closed. Reconciling WIP to the GL has been a challenge based on our current practices and reporting limitations within Sage. If anyone has any…

When I want to add new account, this message showing that, account 11111111 my AccID does not match the format of the Structure Code ACC selected. This message why showing, my accounts length is 8.Can anybody know about this type problem.

I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…

Hi Guys, New member here and new to Sage 100. I am trying to custom build a GL Details postings report for beg of the year to present to present to management and want to include my own parameters like: (period, account, account description, p&l category…

So I've been asked about setting up Source Journals in Sage 300 CRE to assist with looking up summary entries in GL and not having much luck finding documentation on the subject. I'm guessing there might be a gap in terminology (and my ignorance) but…

Good morning, We have our office on a payroll service outside of Sage. We worked with them to set up the weekly GL entries for us so we could import them rather than fat finger them in. I've only imported files into Job Cost so I was curious if anyone…

Our AP / Inventory person yesterday ran into this issue...old transactions suddenly appearing the the Daily Transaction Register. She alerted me of the issue and I have searched here and KB but not finding any answers: Also odd that the 10-31-22 transaction…

GL Activity - Items are not hitting GL for the bank account, AP, AR until bank reconciliation is completed. Is this a setting? Thank you in advance for all answers!

Hi all, On the GL Journal Entry screen, entry number finder, there are Customer / Vendor Number and Customer / Vendor Name column, which is related to GLJEH table, CUSTVEND column. I check on it and found that there is no value in this column. I would…

We used a Job Cost Direct Costs Journal entry to post a wire fee to one of our jobs. The fee correctly posted to the GL, but when we attempt to complete our monthly bank rec, the wire fee is not showing. How do we ensure the wire fee is recorded in Cash…

Hi, Could anyone please provide the Account Type number mapping to the descriptions on this page ? Here's the list to make it easier, with my guesses: 10 Accounts Payable 1 Accounts Receivable ? Accumulated Depreciation 24 Expenses 4 Fixed Assets…

Hi have been trying to figure out how I can disable "Clear History" for certain Users.) (last item in screengrab) Tried unticking "Period End Maintenance" and "History/Budget Maintenance" - both did not work. ( please see list of options for GL ) …

Hi, We have cash accounts set up that haven't had balances in years on our GL and Cash Management. Can we rename and reuse these accounts? What is the best practice, please? Thanks, Cathé Young

Sage 300 Premium (Version 2022) SQL 2019 on Windows Server 2019 GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL…