• Year End Closing Entry

    New year is already created but now need to close the previous fiscal year to retained earnings. How do I create the closing entry if the new year is already created?

  • T4A Box 144 -Exempt Income

    Has anyone figured out how to get income to show in Box 144 of the T4A in Canadian Payroll?

  • Sage 300 2014 AR Receipt Entry numbering

    Hi Everyone,

    I have a client running on Sage 300 2014 and is facing challenges on AR document numbering. The system's AR Receipt document auto-numbering sometimes skip the sequence by a random number hence distorting the trail. Can anyone assist on how…

  • Sage 300 AR Credit Card Receipt - can't post

    I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post.  The charge was applied to two invoices.  Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…

  • box 28 cpp exempt not showing x even though cpp not a tax on employee

    i have a few employees that have chosen to be cpp exempt on account of turning 65 and filing a cpt30 form.  the x is missing in box 28 on their t4 for some employees and there for others

  • Bank Reconciliation posting error: Requested payment was cleared previously

    We have been working with a customer who has had some issues with their bank rec.  We have worked through their issues and are at the point where we are ready to post the reconciliation and we have received this error:

    Requested payment was cleared pr…

  • Can you reconcile E-Statements with Fifth Third Direct Bank that is different from Fifth Third Bank


    I have a client that would like to Reconcile E-Statements with Fifth Third Direct not Fifth Third Bank and they cannot. Does anyone no if Fifth Third Direct is supported?

    Thanks for all you do

  • Customer number change and National Accounts

    Client has a request to change the customer id but the customers belong to a national account.  Reason for the change is that the customers are changing affiliations and client built in national account identifiers in the customer number.  Most of the customers…

  • Accounts Payables discount not posting a Journal

    I have a client who's vendor is giving out some accessories with a 100% discount in a certain month. On Purchase order, the client is capturing  this accessories with the previous cost but discounting it at 100%.

    The challenge is and I stand corrected…

  • Bank Services Error

    So I posted a transaction in Bank Services (deposit) in January - it was the wrong amount (posted say $150 when it was only $100) - so I went in and reversed it and reposted the transaction with the correct amount. No big deal right? well now my boss…

  • Automatic Shipping and invoice Order Entry

    Here is our scenario. We give a customer a qoutation  in Order entry. The customer then goes to the cashier to pay or payonline. Then the receipt is taken back to our sales team to ship and create invoice. Isnt there away that at the time of paying the…

  • AR Adjustments

    How do you remove a posted adjustment in AR.  I had a xact that I adjusted incorrectly, entered the correct adjustment but left with an adjustment that is essentially hanging.  I can't adjust the adjustment because the document's balance is 0.  Any…

  • Mass Apply Documents

    Sage 300

    Any solutions that can Auto-Apply mass open documents for all Customers in the A/R?

    Credits (Open Receipts, CN etc) against Debits (Invoices, DN etc)  using a certain criteria e.g. Date etc

  • Sending Both A/R Invoice and Statement in the Same Email

    Sage 300 Cloud

    How possible is it to send both A/R Invoice and Statement in the same Email communication as separate attachments.

  • Timeout while sending A/R Invoices/Statements via Email

    Sage 300 2019 PU7

    While sending A/R Invoices/Statements via Email, the system sends some e.g. 50-90 and returns the Error below;

    "Description: Mail delivery failed. Use the Email tab on the Company profile screen to send a test email and confirm that…

  • Statetement designer - not updating current year figures


    I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs as…

  • Period locks change on upgrade to 2021

    I just upgraded a customer from Sage 300 2018 to Sage 300 2021.  After upgrading they pointed out that many of their "Locked" periods were now unlocked.

    In their old database in the CSFSCST table there are NO lock records for 2020, 2018 and 2016…

  • Sage 300 FR formula

    Hi there,

    I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column?



  • A/R Prepayments Payment Plan

    Customer Receipts are posted in the A/R as Prepayments because there is no Invoice.

    There is a plan on when and how much the Customer should pay.

    How can this Plan be managed in Sage 300 without raising an Invoice?

    An invoice is raised at the end when…

  • Currency Rate

    Hello Team,

    To receive the currency rate I use the following endpoint -> CSCurrencyRates

    The response has the following structure:


    I have chart of accounts with two segments i.e MAIN & MAIN SUB

    1234 Repair and maintenance

    1234-01 Repair and Maintenance - HQ

    1234-02 Repair and Maintenance - TZ

    1234-03 Repair and Maintenance - ZM


    On printing financial reports only Main Accounts…

  • Tax Services Setup for Irish Entity

    Good day,

    Sage 300 2021 PU2

    I have a new Irish entity to setup which will be my first time setting up an Irish/European entity.  In looking at the VAT/Tax reporting requirements I was wondering if there were any samples out there of the Tax Services configuration…

  • Internal Error: field [25] of [AP68AOBP] is not a string field.-when using Vendor Number Change

    We have a client running 200 2021 with Product update 1.  On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change.

    Anyone have any sugeestions as to how to proceed.

  • Multicurrency with Multiple Entities in Single Sage 300 Database

    A company wishes to setup Sage 300 for their operations in 4 different countries, 4 different currencies all reporting back to a single currency.    There are two options

    Option 1:  4 different Sage 300 Databases

    Option 2:  1 Sage 300 database with a entity…

  • Moving some transactions from a Customer to another in A/R

    Sage 300 2019 PU7

    How can we move some posted transactions (Invoices, Debit/Credit Notes, Receipts etc) between Customers in Accounts Receivable.

    Break the Account move some and leave the rest.

    Without creating Debit/Credit notes.