• Sage 300 2023: Issue with Expense Account Not Updating in AP Invoices

    We're utilizing Sage 300 2023. After generating and receiving a Purchase Order (PO), along with creating the associated Accounts Payable (AP) invoice and posting it to the General Ledger (GL), we've noticed that the expense account remains unaffected…
  • 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…
  • Posting batches in Web Client hangs or gets stuck

    I am unable to post batches from the Web screens of Sage 300 2022. The batches I am attempting to post are small one or 2 entries. I have tried both GL and AP. When I attempt to post them in the web client they just appear hung indicating it is processing…
  • Database error (operation=GET-LE, error=105)

    Dear Gurus, I am using SAGE 300 Premium 2018. I installed and loaded SAMSYS, SAMINC and SAMLTD. I am at the General Ledger Module --> G/L Transactions, trying to browse Journal Entries. Whenever I scroll to the end of the entries, I will get this…
  • Recalculate Cost Inventory Control Item

    When we are using costing item on Inventory Control module, Day End Process or During Posting. Then we have Audit result and doing Adjustment backdate, ex. current period Nov 2023 (many issued/internal usages Item from Jan to Oct), we input IC Adjustment…
  • Vendor pay and deduct

    Hello. One of our vendors wants us to do a pay and deduct from a PO Invoice when items are short shipped. We have been short paying based on the receiving receipt so that our inventory is correct, but that does not work for them. How can we add the information…
  • AP Batch Invoice has been posted, but it didn't push an invoice into the payment. How do I get the invoice to pushed into the payment section?

    AP Batch Invoice has been posted, but it didn't push an invoice into the payment. How do I get the invoice to pushed into the payment section?
  • AR errors

    A credit note was created and the system automatically generates a credit note number but an error batch was generated with the message CN00ABC already exists. Why would the system generate a credit note number which already exists?
  • how to "unlock"/"release" a credit note for applying to an invoice?

    Normally in Sage 300 when we create and post credit notes in AR, we can apply the credit note to a customer's invoice the next day. We created and posted a credit but on the following day it's not available to apply against an invoice nor does it show…
  • fiscal calendar change - customer wants to move posted transactions to a different period in the tables

    Is there a good way to change all posted transactions from one period to another? A customer is wanting to change their fiscal calendar and move the last 6 months worth of data to a different period. I told them they would have to do journal entries but…
  • Exporting payment via REST API

    Hi All, In my current project I'm writing a code to create a payment batch in Sage300 via REST API. In order to do that I'm doing a GET to a random payment and then clearing the fields to add the new data. Is there a way to get a template of the payload…
  • Sage 300 Web Screens Posting Batch entry Stuck

    Sage 300 v2020 PU4 on AWS cloud Server ll works fine on the desktop version, however, when trying to create a batch entry within the Web Screens in AR Invoice it hangs and does not add an entry, it allows navigation to other modules and adding batch…
  • Price check failed when processing an OE

    I have setup price Check with Price Check approval. However, when processing the O/E . Whether the price is below the percentage threshold or not . l get the below errror message: "Description: The price check failed because currently the unit cost…
  • How do I correct AP Invoice import batch error. The document total amount does not match payment schedule amount.

    I keep getting error which prevent importing of Invoice Batch created using in Excel 2007 template. "The document total amount does not match payment schedule amount. Correct 05:15:30 payment amounts in the schedule". I have populated all necessary columns…
  • 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 …
  • Difference between AR General Ledger and AR Subledgers

    Hi, We found a Difference between AR GL balance and AR subledgers as at 31st December 2022 and that difference comes from December 2022. i want to know how to reconcile the month of December 2022 and find the reasons for this difference. Please advice…
  • 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…
  • Employee Expense Automation

    I'm setting up AP Automation but was looking for a solution for employee expenses. Preferably where employees can capture/scan their receipts and then feed AP. We have looked at Concur but not happy with the product. Any suggestions appreciated. …
  • Sage & Orion

    Hi Support, We are using Sage 300 ERP 6.0 for our group of 3 companies. At present, we have one application server and multiple DB's and Terminal server for other 2 companies. One of the sister companies will be implementing Orion POS in the near future…