• Documenting payments made outside of Sage 300 to vendor information

    I'm not sure if this will make sense, so please bare with me. I made a payment with our bank via ach to pay for a larger invoice. Is there a way to document this invoice in sage 300 and mark it as paid so that it reflects on the vendor profile? We don…
  • Canadian Payroll 7.3 and latest Tax Table Update - Calculating Tax on non-periodic payments has changed

    Has anyone else had an issue with tax calculations on non periodic payments since the installation of the January tax table update? We have a client, that had used these types of payments for retro pay for a number of years, and always added that non…
  • Bank Reconciliation help needed.

    Hello there , i started reconciliation and even there is no withdrawal cleared but the totals screen shows clearing of $ 1000. where should i look to figure this out?
  • Bank Reconciliation - SLOW

    Our bank reconciliation is so slow - system takes forever to calculate. What data do we need to purge to make this process faster? Do we need to clear history?
  • Can Sage 300 automatically calculate HOOPP contributions?

    One business we do payroll for participates in HOOPP (Healthcare of Ontario Pension Plan). Is there a way to set up a deduction code to automatically enter the appropriate contribution amounts each pay? Of note, HOOPP uses an "employee low" and "employee…
  • bank reconciliation

    Hi Could you kindly assist me with an issue I encountered in Sage300? How Can I reduce “Withdrawals Outstanding” amount on bank Reconcile Statement without affecting in GL accounts?
  • Control of non-stock items

    Hello, We have a repair department where we have lots of non-stock items. Is there a way in Sage300 to be able to keep track of those items? We don't want to consider them as inventory items. Thanks,
  • Sage 300 v2023 web screen login returns UNDEFINED error

    I have installed Sage 300 v2023.1 in a cloud server. Login using localhost/sage300 works fine. However, when I try to login using public domain name, the login screen appears but gives an error "Undefined" upon entering the user ID and password. Any suggestions…
  • Sage 300 Month End Procedures

    Does anyone have a month-end procedure that they follow in Sage 300? Reconciling accounts payable to the balance sheet, etc? I'm looking for something to have everyone follow to ensure that everything is entered correctly.
  • AR module disappeared

    Sage 2019 app n db on one server. SQL database in use. Users of AR module were complaining of batch posting being slow so a reboot was done. After reboot realized , Ar module completely disappeared. Steps taken: 1. Did a sage full repair yet AR…
  • ICSHipment in Postman

    Hi Im getting the below error when i try to post back to the API using postman
  • Sage 300 Payroll Setup (Earnings and Deductions)

    How would I set up a group life insurance policy for which the employer pays 100% of the premiums but get coverage in excess of $50,000? I'm mostly concerned about tracking the tax to the employees. Do I need to set up two different benefits - one that…
  • creating PO invoice using RESTful API

    How do I create a PO invoice via the RESTful API? There are only GET methods when trying to overcome this by creating an invoice using AP/APInvoiceBatches in the body of the request in the field "SourceApplication" I've given the value "PO" this isn…
  • PJC Change Orders

    Hi. We are trying to get posted change orders to be reflected in PJC. Any suggestions? Thanks.
  • Sage 300 2023 Web screen AR unable to create entries

    When choosing AR Batch or AR Entry via web screens, the page loads but the detail and optional grid spin incessantly, making it impossible to enter any data. IMPORTANT: log in as admin, we are able to enter data. See screenshot.
  • Sage 300 Posting Bank Reconciliation without asking all users to logout

    Multiple bank accounts that need to be reconciled and posted are being used by our Sage300 company. The problem is that, even when a certain bank isn't being used, it's always necessary to request that users log out. Is there another way to post a bank…
  • AR integration to GL not bringing across functional values

    Hi Just wondering if there is a known issue with the posting of AR invoice batches to the GL when multicurrency is in use. All of a sudden, starting Mid Feb 2023, the functional values are not posting to income accounts and all income is going to the…
  • How to reverse an AR Refund Entry that do not have Bank Code?

    Hi All, I posted an AR Refund Entry that is using Cash Payment, No Bank Code, use Cash Account instead. It does not have a Bank Code so I cannot use the Reverse Transaction from Bank Transaction. Any other way to reverse this refund? Thank …
  • Reconciling Shipment Clearing & Payable Clearing Accounts

    Hi, I want to know, what is the best way to reconcile shipment clearing account and payable clearing account ? is there an easy way to make it zero at the end of the reporting date. Thank you
  • How to populate GL Journal Entry - CUSTVEND column

    Hi all, On the GL Journal Entry screen, entry number finder, there are Customer / Vendor Number and Customer / Vendor Name column, which is related to GLJEH table, CUSTVEND column. I check on it and found that there is no value in this column. I would…
  • Sage 300 Web API - ICDayEndProcessing

    Hi All, I am developing a website that will use Sage 300 Web API to integrate with Sage 300 data. Currently, I would like to run the IC day end processing in my development, but I am confuse on the payload. Does someone have a sample or tutorial…
  • Customs Duties - How do we add them as additional costs with different rates for different items.

    Hi all. With American tariffs changing a lot recently, and therefore being volatile and different between types of products, we are looking for a way to add customs duties as additional costs based on each of the individual duty/tariff rates for each…
  • Anyone using Sage 300 V.2016 to do Budgeting ?

    Hi all, My company hasn't been using Sage 300 (V.2016) to do budgets. Its typically been done in excel. I know it can be done, (use sage to budget) but don't know where to start or what reports i can print. Are there any courses just for the budgeting…