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