• After upgrade from 2021 to 2023 I got Error HRESULT E_FAIL has been returned from a call to a COM component.

    After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen. What would be the reason of this and solution ?
  • Good news for PJC Web Screens users with Sage 2023 Product Update 1!

    With Product Update 1 for Sage 2023, users can now setup Account Sets, create Charges transactions, update Retainage and revise estimates in Sage 300 cloud web screens. Users can also post Revise Estimates transaction(s) easier by using a Post Transactions…
  • Sage 300 What's New in Version 2023.0 training is now available on Sage University

    A new What’s New in Sage 300 Version 2023.0 anytime learning training is now available on Sage University for customers and consultants. This training provides you with information on the exciting new features and improvements that have been implemented…
  • Sage 300 FTP Credentials

    It seems sage have changed their FTP credentials. How can I download patch updates
  • [Sage 300] I cannot add optional fields.

    Hello Team, I cannot add the optional field for A/R Documents. Previously, I used the button Create New Example: But in Sage 300 2022 the button is absent. Example: Could you clarify on how to add the button 'Create New' optional field?
  • How to reverse posted job-related transactions?

    There are two types of job-related transactions. One is done within the Project and Job Costing module ( in PJC transactions folder). The other one is done outside of PJC module and it’s a job-related transaction. Now we are going to talk about these…
  • Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • Email more than one invoice at a time

    How can you select more than one invoice for the sane customer and email in one go
  • Sage 300 What's New in Version 2022.2 training is now available on Sage University

    A new What’s New in Sage 300 Version 2022.2 anytime Learning course is now available on Sage University for customers and consultants. This course provides you with information on the exciting new features and improvements that have been implemented in…
  • Error message when post Invoices: Invoice Batch Attempt to perform Record Update without security authorization.

    Hello Team, I try to post the Invoice, but receive the following error message: Invoice Batch Attempt to perform Record Update without security authorization. Could you clarify how to fix this error message? What settings I should do?
  • Sage 300 and AutoSimply Barcode application very slow

    Hello fellow Sage 300 users and IT Admins, We are using Sage 300 2022 and we use AutoSimply Barcode application along with our Sage 300. We currently are on the latest PU for Sage 300 2022 and we even have the latest customized AutoSimply Barcode 2022…
  • Processing Invoices and Receipts for National Account

    I am trying to process invoices and receipts in Accounts Receivable for a National Account (main account and not a member account), but I get the error that " Customer number XXXX does not exist ". I was under the impression that this is possible and…
  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…
  • Identify Account Segment from PO Transaction

    I need your advise on how to use account segment (identification of account segment) even from PO. Let’s make example, a PO was created from Segment Division of 100 (Fakultas Kedokteran). What I wanted is when I receipt goods, the Journal will be Dr Inventory…
  • Sage 300 What's New in Version 2022.1 training is now available on Sage University

    Sage 300 What's New in Version 2022.1 training is now available on Sage University A new What’s New in Sage 300 Version 2022.1 anytime learning video is now available on Sage University for customers and consultants. This video provides you with information…
  • Sage 300 doesn't allow removing posted AR Documents

    Hello Team, I cannot remove posted documents in Sage 300. Could you clarify how I can remove posted documents?
  • 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. I…
  • BUDGET ON OPTIONAL FIELDS

    As per my understanding Sage 300 budget linked to Account code (on GL). How can I handle objective based budget? Objectives are like optional fields: Eg: Acccount 1010 : Allowances Objective 1: budget $100k Objective 2: budget $200k
  • Error during the search Customers by period via API

    Hello Team, Could you help me with the following question. I cannot filter Customers by date and time. Example: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$top=1000&$filter=DateLastMaintained gt 2000-01-01T01:08:35 or DateOfLastActivity…
  • Difference between payments type in Sage 300

    In Sage 300 when the user creates a Receipt payment, the user can select a few types of payment. For example: Receipt Prepayment What is the difference between these types? I found one difference. If the type is Receipt , the user applies a payment for…
  • How to receive Sage 300 account currency via API

    Hello Team, I want to receive the Sage 300 account currency via API. The account currency is CAD. To receive the currency I use the following endpoint - CSCurrencyRates And I expected that Sage 300 should return me one row with the Account currency. But…
  • Sage 300 Currency ISO-CODE

    Hello Team, Is it possible to receive the Currency ISO-CODE via API? I tried to use the following endpoints: CSCurrencyCodes CSCurrencyRates But Sage 300 doesn't return the Currency ISO-CODE. Also, I cannot find the Currency ISO-CODE on UI. Could you…
  • How to receive the Invoice unique identifier

    Hello Team, We use the following endpoint to receive Invoices - http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARInvoiceBatches But, Sage 300 API doesn't return the Invoice unique identifier. Invoice Batch is not unique due to combining a few invoices…
  • Sage 300 API doesn't return deleted Customers

    Hello Team, We use the following endpoint to receive Customers from Sage 300: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers But, if the Customer is deleted in Sage 300, this endpoint doesn't return Customers. How we can receive deleted…
  • Customer Balance

    In Sage 300 the Customer has three balances: But via API Sage 300 returns only the Outstanding A/R Balance. How to receive A/R Pending Balance and Total Outstanding Balance via API?