• 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  entries…

  • 2FA for webscreens


    I am looking for a 2FA solution to protect the web interface of Sage300. Any suggestions?

    I use CISCO DUO for other applications - this requires the application to be SAML enabled. Any ideas on this?



  • Bank feeds for UK banks


    Can anyone let me know if there is a recent list of banks for the bank feeds? I am mostly interested in UK and Switzerland banks.



  • Can You Recover a Deleted GL Batch

    Hi...I made a big mistake this morning.

    I posted a large number of receipt batches from AR, to the GL in one posting, and I noticed a problem in one of the receipts after the fact. So, I hastily deleted the UNPOSTED GL batch, thinking I could fix the problem…

  • A/P Invoice Batch

    Brand new here in the A/P world!  Have used the G/L side for 20+ years Slight smile

    We entered in invoices to be paid and realized when the checks printed that the vendor was selected to combine invoices and we need the invoices to not be combined on the check.  We…

  • PJC Change Orders

    Hi. We are trying to get posted change orders to be reflected in PJC. Any suggestions? Thanks.

  • What is required to get OE Invoices to show in AR Receipt batch

    I'm trying to mark that payment was received for one of today's OE Invoices

    I've run I/C Periodic processing > Day End Processing, but the invoice does not yet show in A/R Receipt Batch Entry when looking up the customer.

    Is there an additional…

  • Deleting a billing

    I having a billing sitting in accounts receivable with a pending post status because the invoice date is 03.29.2030.  How do I delete this billing?

  • 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.

  • 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 specified…

  • Accounts Payable Clear History function not clearing old paid documents

    Sage 300 v2022, latest pu.  This has also happened in prior versions, was hoping this one would fix the issue. Periodic processing/clear history done at EOY every year. All other transactions and reports have cleared up through 2017.  Only paid documents…

  • 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…

  • AR integration to GL not bringing across functional values


    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…

  • Standing Orders - how to update prices when price in price list changes

    Is there a way to update the prices on standing orders to reflect prices that have changed on a price list.

    ie. standing order has line item "Widget A" @ $2.00 from price list "Price List A"

    We then update "Widget" on "Price List A…

  • How to write off an invoice but capture taxes?

    Good Afternoon, 

    I couldn't find anything in the forums specifically about taxes so here goes.  

    We are writing off some OE invoices, customer bankrupt and we will not see payment.  However, in the A/R Adjustment screens I don't see any tax option to…

  • AP and Job Distribution

    How do I correct where the retentioin amount was entered to the discount instead of the retention  on the job distribution line when entering an AP invoice. This invoice has been paid. I need to correct the amount paid show in the job too. Thanks.

  • 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…

  • 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 you

  • Sage 300 webapi OEOrders update the entry

    I have been able to successfully create a POST for the order entry. Now I want to update the shipping information and invoice it.

    But according to the sage documentation we cannot use PUT or PATCH for OE.


  • AR & AP Settlements

    Hi, we purchase goods from a supplier and we sell items to the supplier as well. therefore, the Supplier A is in both AR and AP Ledgers. so, they settle our payments after deducting their outstanding (our AP balance under the same supplier A) therefore…

  • Batch Date and Posting Date


    We recorded a sales invoice selecting batch date 01st March 2023 and posting and document date 31st December 2022. however, we identified that the value of the sales Invoice did not go to the Accounts Receivable Ledger in GL as at 31st December 2022…

  • Difference between AR General Ledger and AR Subledgers


    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…

  • 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

  • Purchase Requisition


    Is there a simple way for a user to see the PO associated with a Purchase Requisition? Example, he entered a PR and wants to see the PO.



  • Customer order with down payment


    We have been using Sage300 for years (latest v2022 PU1), and there is a new requirement from business related to customer's down payment.

    It is simply like this:

    1. We receive an order from customer and they agree to pay the down payment (DP) by…