• Receivables

    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.
  • GL entries

    Can I make GL entries to closed years?
  • What is your process for closing a job and how do you handle warranty items?

    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…
  • Sage 300 CRE Source Journal

    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…
  • GL Import File

    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…
  • GL Activity

    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!
  • Wire Fees posted through Job Cost are not showing in Cash Management

    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…
  • Best Practice for Setup for Cash Account

    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
  • no data on the earnings distribution table for year-end closing

    I need to close the fiscal year of 2021, TB is balanced, chart of accounts all right, I can't figure out why the earning is not showing on the earnings distribution table?
  • Report showing jobs associated to companies?

    Hi, Within a datafolder we have numerous companies - all with jobs associated to them. Is there a report or easy way to show what company each job is associated to or show a list of jobs associated to a certain company within a datafolder? Further…
  • VAT recording from AP to GL

    Dear Team, Re posting the issue again to get more attention , the problem is unsolved and demanding immediate attention. We have noticed a strange issue in treatment of VAT. The VAT is calculated in AP correctly and reflected in VAT report as well…
  • VAT recording

    Dear Team, We have noticed a strange issue in treatment of VAT. The VAT is calculated in AP correctly and reflected in VAT report as well. However, while posting in GL it has been split into two base accounts named 1601 and 1690. Below is an example…
  • PR related amounts in GL is described as PR Post checks summary.

    Dear team, When ever we review the amounts in GL , check amounts from PR is showing as PR Post checks summary irrespective of the original PR summary contains breakage pay roll to Salary, other allowances ,deductions , fringes and so on. Could you please…
  • When will the Year End be posted?

    When will the year end be posted?
  • Inquiry to review both sides of a journal entry

    How can you look up & review both sides of a journal entry that was posted?
  • GL Import File

    I am new to Sage, but trying to create a GL import file for a journal entry. It is not through payroll module, but it is an entry to record weekly payroll through a GL entry. The amounts change weekly, but the accounts and descriptions are consistent…
  • GL Clean Up

    Good afternoon...Is there a way to deactivate unused accounts or prohibit them from showing up on a report or your GL? We need to clean up a bunch of accounts that are no longer used.
  • Change Cost code accounts setup

    Hello...I believe our cost codes are set up incorrectly for my equipment accumulated depreciation. When I enter depreciation it's hitting the asset account and not the accumulated depreciation like it's suppose to. We do not have the asset add on software…
  • Making the Phase field in AR Invoice Distributions functioning

    I am trying to figure out how to make the Phase field in AR for Invoice Distributions functioning since clearly when setup originally that was not completed. I understand that this has to be done in GL > File > Company Settings > Custom Descriptions…
  • Clearing Rejected Entries on GL Post Entries Report

    I am the new CFO with my company and new to Sage 300 CRE. I am working on cleaning up a few things and I came across an area where I need some help. On the GL Post Entries Report there are four separate entries that were made in the Billing module that…
  • What does *!! at the end of a general ledger report mean?

    On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant
  • GL account file error

    What does account not in GLM file mean, i did not find a kb, but I suspect the GL account number is not set up.
  • Correct AP and CCP

    FormerMember
    FormerMember
    For the majority of this year we used Credit Card Management without have the Credit Cards Payable account set. Because of this, our AP totals in General Ledger are higher by the amount of the CCP transactions. What is my best bet to correct this mishap…
  • Is there a way to return distinct results in MyAssistant?

    FormerMember
    FormerMember
    I'm trying to run a task that pulls prior year actuals from the GL for all accounts not equal to zero at year end, but the task returns almost 400,000 results with dozens of duplicates for each account type. Is there a way to return only distinct values…
  • is there a way to incorporate on the trial balance quarter activity instead of current period activity?

    I need to create a trial balance with quarterly activity instead of the current period activity, not sure how to do this since there is no field for quarterly numbers. Any help would be great