• Cost Codes last used

    Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?
  • run macros using Windows Service (local system) - Session Could not be opened

    I have Windows Service which read some data from database then run macros to generate some reports as pdf files automatically (statement of account, Customer Aging....), when I run the service as "local system" the service can read the data from database…
  • FR Report not suppressing zeros

    Good Day Sage 300 PU4 Client recently upgraded to above. The FR report runs successfully but is no longer suppressing zero value lines even though this is defined in column c. I have tested on 32bit Excel and it works correctly. The client uses 64bit…
  • When printing an invoice in Sage 300 2017 the user is always asked for a password

    The full story is that our client of over 20 years has had to move their system from their local server to an Azur server at short notice. Everything is working fine except when they print the AR invoice form, both the customized form and the default…
  • open session in Windows Service

    I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…
  • Pay now button on invoice sent by email

    Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…
  • Use invoking session inside XLSM

    Sage menu invoked an XLSM file Inside that XLSM file I want to use the invoking Sage300 session because customer has limited licenses So do not want to login and make another session with another userid and or have to know user's password etc. sort…
  • Program screen ID

    hi all, I am following example on this link https://www.sagecity.com/us/sage300/b/sage_300_erp_r_and_d/posts/launching-non-sdk-programs-from-the-desktop to create a screen using C#. I am able to create and working fine. However, the details is not looking…
  • Sage300 2023 installed on W2022 OS stanadard edition - 64 bit office 365

    Is there a plan to get the sage 300 macros to run in 64 bit excel? If someone has them running in 64 bit, what was your solutions? I find the macros will only run in 32 bit and cannot get the out of box macros to run in 64 bit. Also Sage intelligence…
  • how to deploy Sage 300 as a published app

    Using published apps with a terminal server and users are complaining about speed. Works fast directly on the server if you RDP to it. What are best practices for setting up published apps with Sage 300 ERP 2023?
  • Sage 300 always prompt SQL login database when Custom Report from Crystal Report is printed

    Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…
  • Users and User Authorizations Report

    Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
  • Antregrate Custom made piped Crystal Report / existincg Exe in Sage 300 Web Screen

    Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.
  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • Need to update a crystal reports invoice with a specific field

    Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan
  • Sage 300 Employee Information report crash

    We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…
  • Fiscal Period for Specifik Module Macro

    I have some problem in macro the case was, i want to get 2022-01 (yyyy-mm) fiscal period status of my IC module in ACCPAC using macro Can anyone have some solution for this? thanks in advance
  • How to figure out errors ViewExceptions .NET API

    I'm trying to insert an order using the API - and I'm getting back an error that just says 6666 How can I find what this means, and in general, is there a way to get the COM exceptions and error codes? I know how to get session.Errors, but that is empty…
  • Invoice PDF

    Hello Team, Is it possible to export the Invoice in PDF format from Sage 300? If yes, could you provide an example of how to do it? Also, is it possible to receive the Invoice PDF via API from Sage 300?
  • Doesn't work correctly request filter 'allpages'

    Hello Team, According to the Sage 300 specification, we can use the following filter 'allpages' For example: http://{ip adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$inlinecount=allpages But, we cannot receive the number of customers in the response…
  • Error during API call ARCustomers

    Hello Team, When I try to call ARCustomers via API using a filter that designated in the Sage 300 specification, I received an error. Example of the request: http://{IP Adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=DateLastMaintained le datetime…
  • Allow users to run Macros, but not edit or record Macros

    Hi, I'm trying to allow users to only run Macros without also giving permission to record or edit. In Administrative Services Security Authorizations (sage300.com) , for the "Maintain Macros" permission, it says " Allows users to record and edit macros…
  • How to do data filtering in macro VBA?

    Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520
  • Work Force Analyzer hangs in startup

    I have a client that replaced their workstation and now they are unable to run the Work Force Analyzer. We installed the latest updates of Sage 300 payroll and the Work Force Analyzer, but when they launch the program we see a message Connecting to Sage…
  • Crystal Report Error

    I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears