Browse By Tags

  • If the uploaded file hasn't been processed by the bank, can I reverse so it can be paid?

    What happens when you use the upload direct deposit to pay various suppliers and one payment did not go through, therefore the total in Sage does not match the withdrawal from the bank. We still need to pay this invoice but it is showing as paid. Can…
  • Adjustment Inventory after Audit

    We use Sage 300 2022 PU2, and Costing setup Inventory Control is During Posting (not Day End Process). We have done Adjustment Cost (IC Adjustment --> Cost Increase) for date 31 Dec 2022, after that we do issue (internal usage) for 24 Aug 2023. But the…
  • Import stock adjustments

    As part of our improvements to our import functionality, we have extended the import to include stock adjustment transactions. This is useful if you have a large number of stock adjustments to do at once. Read more about importing stock adjustmen…
  • Transaction occurred before previous fiscal year - No it Did not!

    I am trying to adjust a receipt that I made on July 31, 2022. I get a message saying "The transaction cannot be adjusted because the transaction date occurred before the previous fiscal year." Our fiscal year end is June 30th. I KNOW I did not create…
  • Item Adjustment

    Hi everyone, We have started a fresh in Jan1 2022 to Sage accounting with all opening balances from 2021. When we entered the inventory opening balances total values of each item were entered correctly but the quantities were duplicated for some reason…
  • bad debt showing in client aged report

    After posting YE adjustment for bad debt in GJ, my client aged summary report still shows the client. Here is the adjustment that was made: 1201 (Accounts Receivable) Cr 2000 1205 (Allowance of Doubtful Accounts) Cr 10000 2310 (GST Charged on sales…
  • Comment ajuster les soldes d'ouverture après avoir quitté le mode Historique dans Sage 50 CA

    Nous arrivons à la fin de l'année et beaucoup d'entre vous travaillent peut-être à mettre à jour les entrées de transaction dans votre base de données d'entreprise Sage 50 CA. Avez- vous travaillez dans Sage 50 CA depuis quelques mois, quitté le mode…
  • How to adjust opening balances after exiting History Mode in Sage 50 CA

    We're coming up on year end and many of you may be working to update transaction entries into your Sage 50 CA company database. Have you been working in Sage 50 CA a few months, exited History Mode and realized that your opening balances need adjusting…
  • Another Petty Cash Foreign Exchange Question

    We have a secondary USD Petty Cash, account that should be at $0.00, which it is showing that in CAD side, but the foreign balance is showing -1952.78. How do I clear out the foreign balance but keep Canadian at $0.00?
  • Payee has issued us a cheque for a duplicate payment

    I double paid an invoice in error, and the vendor cashed the cheque before realizing it. I deleted the duplicate invoice, and entered the amount as a "deposit" instead of an invoice. This left me with a credit on their account of -430.00 They then…
  • Partial Credit Note not working....

    Upon trying to apply a partial Credit Note to a purchase invoice (of lower value) it seems I am not able to keep the remainder of the Credit Note but it has debited the whole remainder into my bank account. I used the Payments window and selected the…
  • Comptes clients et fournisseurs de 2019

    Bonjour! Je viens de commencer la comptabilité pour une petite entreprise qui ne s'en occupait pas vraiment. En gros : toutes les factures clients et factures fournisseurs passées en 2019 ont été mises ''À payer plus tard'' et jamais encaissés/payées…
  • Suggestion : enhanced 2nd valuation method (Cumulative AUC) with all the features of the first valuation method.

    Some users want to use a 2nd valuation method (Cumulative AUC) as the first method (for example, for sales agent profit calculation). But, this 2nd valuation method has limits: it doesn’t work with cost adjustment (FUNSTKADJ function). Suggestion…
  • Is there a way to change the Inventory adjustment transactions to use the 'Average' instead of the 'Replacement' unit cost?

    We are setup for inventory adjustments to use the replacement value, this value is incorrect. Can we change it to use the average cost?
  • A/P Invoice Distribution (Coding) Change

    Hi, I would like to correct a previously entered invoice. The coding of the invoice is incorrect however I don't want to actually reverse the cheque, I just want to change the coding. Normally, I would do a JE to correct it however I would like to follow…
  • Adjusting CPP at year end

    I have a situation where my client issued more paycheques than the bi-monthly payroll and did not adjust for the CPP exemption. As a result, the employee did not contribute sufficient CPP. My question is how can this be adjusted before the T4s are prepared…
  • Down loading bank information

    I am using Sage 50 Pro accounting. I am having extreme difficulty cannot download updates from my Canadian bank account. Do I have the wrong version?
  • 10% Hold Back

    I have a client that we have been billing now for about 1.5 years and they are holding 10% back from invoicing. The way the billing has been done by a previous book keeper was just doing it as a receivable and leaving the amount to go over 91+ days. My…
  • Article: Unable to access Adjustment Function (TPSSTDR)

    Issue: When trying to access the adjustment function (TPSSTDR) you get an error that No transaction authorized. Solution: A setup on the Entry Transaction (GESSTH) code STDAD for Adjustment needs to be done. Path: Setup> Entry Transactions>…
  • How to adjust serialized inventory

    I've identified a serial number that was reported and issued from the books in error. I now want to add the serialized inventory back to 'available' status. . I can easily adjust serialized inventory out with the use of a manual inventory adjustment assuming…
  • How do I post a shareholder loan to the company from a director?

    FormerMember
    FormerMember
    I have accounts setup in Sage 50 from our accountants. I'm taking over the bookeeping and am new. I am not sure how to properly post a shareholder loan I transferred to the company. Should I do a general account ledger adjustment? What is the best way…
  • Tax Recalculation and Adjustment in February period.

    FormerMember
    FormerMember
    How do we deal with the tax adjustment in February. The system doesn't allow us to amend the tax amount in February, however it has recalculated it automatically after doing a rollover to the next period. Also how do we adjust the sytem so that it automatically…
  • HST Tax Detail Report Doesn't Match Balance Sheet

    On my tax detail report, the total of taxes paid/charged figure correctly matches the figure on my balance sheet, and the total taxes charged matches the figure on my balance sheet. However the figure at the bottom of the Tax Detail report Net refundable…
  • QuickTips! Did you mistakenly delete an invoice before deleting a payment?

    Mistakes happen! Please note that it's not possible to delete a paid invoice before deleting its payment in any version of Sage 50. There is an audit trail that keeps a log of any transaction. Reversed or adjusted transactions will show. If you…
  • How to "uncommit" a product that was "committed" through O/E Order Entry

    An item that was entered through O/E Order Entry but not delivered/invoiced can't be sold to another customer. How are we able to sell the item to another customer that was committed without deleting the Order Entry? We still have an item sitting in the…