Browse By Tags

  • lines in a sales order invoice doubling

    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…

  • Disabling "Clear History" in G/L Periodic Processing for certain users

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

  • AR Invoice Adjustment not reflected in GL

    Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…

  • Incorrect GL account type Balance Sheet > Income Statement

    Our client has a few GL account configured as Balance Sheet account instead of Income Statement account. The account was incorrectly created as a balance sheet account. We need to change the account type to income statement but firstly, correct the…

  • Missing "updated by" GL Journal Drill down

    Sage 100 2020 Premium (6.20.1) After deleting old users off a system, the GL drill down from Transaction tab "Updated By" is blank for the deleted users. The deleted user keys are listed in SY_UserHistory. Short of 'reactivating' the deleted users…

  • Trial Balance - Active Accounts Only

    How can I change my settings in the GL Module to only show Active accounts on my Trial Balance? Currently it is showing deleted and inactive accounts along with the active? Thank you

  • Reverse posted prepayment and credit memos

    We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account. To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…

  • PPP Loan Forgiven

    We had our PPP loan forgiven, and our CPA told me to book it in under "Non-taxable income". I spoke with one person that set to setup account 950 to book this as non-taxable revenue. It still shows up on the Income Statement, is this correct?

  • Updating Batches via BOI

    Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

  • GL posting Error - "Entry for a period before the prior fiscal year"

    FormerMember
    FormerMember
    In AP, I entered a manual ck incorrectly as 4/19/01. When the system tried to post the resulting GL entry, I got this error. I have since voided the manual ck and re-entered it correctly. Now, how to clear this error in the GL posting?

  • G/L Inquiry with Income Statement Year End Income Statement Amounts

    FormerMember
    FormerMember
    Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

  • 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

  • Help

    Can someone help me on our to get this done. Client is currently using Sage 300 two companies on one database.He has been posted on it, now he wants to seperate it.Same users will be working on the new comapny,He wants seperate reporting, customer statement…

  • When you create a new Hierarchy Codes and link it to employees it does not pull through to the GL Export file

    On the Navigation Pane Expand Parameters Expand General Ledger Select Account Segment and highlight the Segment Name with that Hierarchy Header i.e.PAY POINT Right click on the GL Codes as seen below and click on Refresh : This will now pull…

  • Delete Budget Code with Activity

    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…

  • Posting Mechanic Labor to Equipment Expense in the GL

    Mechanic Labor Posting problem. Sometimes our mechanic doesn’t list on his timecard, what equipment he worked on during the week. The payroll department will use our Equipment Repair cost code when entering his time, but if an equipment number isn’t entered…

  • HST in GL Entries

    Hello, I am fairly new to sage. I was wondering for a GL entry if you have to enter the HST on a purchase or should it automatically record? I know when you create an invoice you can add it in, but for some reason it is not getting added in when I do…

  • Is there any way to set a default expense (purchase) or default income (sales) ledger account for an individual cost code?

    Is there any way to set a default expense (purchase) or default income (sales) ledger account for an individual cost code. I would like it so that when I select a cost code on a line within a PO,CO, AR invoice, etc. the account is auto populated with…

  • AP detail description

    Hi, In AP GL integration, if the detail description option was not selected to be transferred to GL initially, what happens if this setup is done mid way. Will the detail description be transffered for history data? If not, then how can this be retrieved…

  • Re: Error when printing in webscreen

    Hi I encountered the below error when printing via the webscreen Sage 300c 2017. I had installed the latest patch Sage 2017.3 and it still give the same error. I got this error when I am trying to print the GL TB, GL Transaction Listing. Has anyone…

  • List of previous month's activity

    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…

  • When can we change GL Account numbering in v19 (Sage 100)?

    Since the change in Sage 100 Contractor with version 19 combining the period and year, and not closing company before starting new year, when can the GL account structure be changed?

  • DOH! I closed my fiscal year in General Ledger when I shouldn't have! - Sage 300 CRE

    We've all done this at some point in our careers. You were clicking along minding our own business. Closing the month, printing checks, running reports, then.... BOOM! You closed the fiscal year in General Ledger when you shouldn't have! The room begins…

  • Prior Year Adjustments a.k.a PYA'S

    Prior year adjustments occur when you record an entry to an income statement account with an accounting date in your prior fiscal year. When this happens, your Current Ledger and Year-to-Date Ledger reports are out of balance until those prior year adjustments…

  • Entering beginning balances

    Is there anyone who can tell me the order of modules used for entering beginning balances? I know that this is something that my consultant or business partner should help me with, but they will not respond to any of my emails. I need to get an existing…

*Community Hub is the new name for Sage City