• Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • On Journal Entry, Rate value is different from the other item line

    Hi all, my customer is making a journal entry when this happen. Please refer to the Rate column and the cell value in red rectangle. The value of the rates on this column are prefill accordingly. But the value for the last item line is different from…
  • 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 ) …
  • GL Account Code without Delimiters

    A client has a need for a General Ledger Account Code made up of more than one segment, but with the option of not using delimiters. Is there a way to do this in Sage 300? For example, Segment #1 = Cost Centre, XXXX; Segment #2 = Account, XXXXXX Instead…
  • Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and transactions for a given period at the G/L level?

    Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and the G/Ls associated with them for a given period? Essentially I need all vendor transactions with the G/L detail associated with them for a given period across all different…
  • 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…
  • Trial Balance amount difference from GL transaction listing balance

    Please, need an urgent response. The amount showing the trial balance for a particular account for a specified period is different from the amount showing on the balance in GL transaction listing report. I didn't know this because my trial balance actually…
  • The Sage 300 General Ledger Year-End process

    The summer sun has set and before you know it, you'll be asking yourself where the heck 2016 went. One of the most important things you'll need to do at the end of the year is close your income and expense accounts for the past year and open them for…
  • On spec: Getting to know the sample financial statements

    You are trying to write up several financial reports but are unsure which ones are the right one to use in Sage 300 ERP. This week’s blog post takes a look at which Financial Reporter (FR) spec template is the right one for you to use in the G/L Statement…
  • Balancing the books

    Recently, I listened in on a call where the customer was having an issue where their book balance didn’t agree with the General Ledger. They noticed this while trying to reconcile their statements in Bank Services. Here is an example of what that would…
  • Year End Not Closing

    Good morning, My client is doing her first year end in 6.0. She is using MS SQL 2008 R2 for her database engine and running everything locally on a Windows 7 machine. Her retained earnings account is set up and in place. She used the Create New Year…
  • It's the most wonderful time of the year: General Ledger Year End

    In our final Year End blog post, we took a look at how to perform a Year End in General Ledger. You probably can guess what the first step in a GL Year End is. If you guessed perform a good backup then you are correct! Next we will create a new…
  • The more you know: Sage 300 ERP tips and tricks

    In this blog post, we wanted to share little tips and tricks that we here in support have picked up and want to pass on to you. How do I Get Real Time Posting in Inventory Control The only way to have real time posting to work is if in IC options…
  • FR Report Designer - no network drives shown in the File>>Open area

    Hi all, Strange FR behavior - when opening the FR Report Designer then going to the File>>Open area to select a report to modify, the only contents are the C drive of the workstation. If we close out of FR and launch Excel from the desktop I can see…
  • No GL No Problem

    In Sage 300 ERP there are some modules that are dependent on each other. For example, Order Entry requires Inventory Control and Accounts Receivable while Purchase Orders has tight integration with AP. However, there are some modules that can run as…