• Bank reconciliation variance

    Hello, there is a discrepancy between the adjusted book balance of our bank rec and our gl account over a number of periods. The first variance ties perfectly to one entry that appears like it was posted correctly as a bank entry and cleared on the bank…
  • Filling up the GL-JE Import template in Excel

    Hi All, Trying to fill up an import template in Excel - As you can see in the screenshot, there are 4 transaction per journal entry but in some cases there are 5 - 6 transactions as well. I know that excel follows a 20-40-60-80 patter in the TRANSNBR…
  • Reversing GL entries that have been cleared in the bank?

    Hi All, I entered a bank USD entry with the wrong USD to CAD rate. This is messing up the balance of the clearing account and so I would like to reverse the bank entry and re-enter it with the correct USD to CAD rate. However, the bank entry is now…
  • 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…
  • Inactive accounts allowing posting - Sage 300 2017

    FormerMember
    FormerMember
    We have many inactive accounts. Previously, we would get a warning when positing to these accounts. A beep and a visual. This now only happens to some inactive accounts, not any of the newly inactive accounts. We do have the setting in "Common Services…
  • 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…
  • GL code

    Hi there general newbie question How do we correct a GL code on Sage 300