Clearing Checks

SOLVED

How do I clear a check in X3? I don't want to delete it just show that it has cleared with the bank so I can see my outstanding check balance in X3.    I have no idea how to use the bank reconciliation functions in X3.  I have asked my support team (sage) multiple times and have not gotten any answers.  Also is there a way to search in here (Sage City) just in the community/forum I am in? 

  • 0
    verified answer

    Hi,

    Have you checked the knowledgebase? Please visit support.na.sage.com and login to search the Sage ERP X3 database. The article Overview of enhanced Bank Reconciliation function (BANREC) introduced in patch level 17 (ID: 16896) addresses clearing checks on the bank reconcilation.

    Cheers,

  • 0 in reply to pnightingale

    How do I find it there?  I have tried searching for Patch 17, Bank Reconciliation and even the exact wording you used and the searches didn't find this article.  I am finding 1 or 2 articles when I search anything and that is it.  

  • 0 in reply to Lsharpe

    After you logged in, you should see the "Search the Sage Knowledgebase" window. please try searching by ID. Type in 16896 in the search box. that should bring up the KB article.

    Thanks!

  • 0 in reply to Steffen Urban

    I get the result that 'There are no results; try re-wording your search'

  • 0 in reply to Lsharpe

    I tested a few different browsers but the article always displayed, as long as I was logged in. without logging in the article does not show.

    Please send me a Private Message with your email and I will ssend you the article directly.

    Thanks.

  • 0 in reply to Steffen Urban

    I am logged in and searching in the Sage X3 ERP product and getting nothing.  

  • 0 in reply to Lsharpe
    verified answer

    Does the following help ?

    Bank Reconciliation

    Path: A/P-A/R accounting > Reconciliation > Bank Reconciliation

    Click New icon

    Header Fields

    Bank – Enter or select Bank Code

    Description – Enter the bank reconciliation description

    Ending Statement Balance – Enter the bank statement balance

    The lines will show all transactions to this bank that haven’t been reconciled and posted.

    The user will then tick all items that are in the system as well as on the bank statement.

    The filed to be ticked is called Mark. It is ticked by double clicking it or pressing the space bar.

    Click Create

    Once the Create button is clicked a reconciliation number will be assigned by system and the Status will be Open.

    Closing the Bank Reconciliation

    The reconciliation can be closed if the variance is zero. Closing is the finalisation of the reconciliation

    To close click the Close button

  • 0 in reply to S Orrock

    This helped but how do we reconcile items that are incorrect?  We have a very, very tight month end closing for reporting and we have to have all of our reports and figures to our parent company before we even get out bank statement for the month so I cannot create correcting entries in the previous month to clear things if there are any incorrect or missed items.  I cannot change a previous months balances after I have reported my numbers.