Sage 300

Hi, PO Receipts additional costs are available at the header level in the table PORCPS. Is there a table that has the prorated costs at the line level for each item? Thanks & Regards, Ubaidullah Nubar.

I have an old Sage 300 macro that uses Excel. We've upgraded to Excel x64 and I need to change the path to where Excel lives in the existing macro, since I believe it is still pointing to the old location in C:\Program Files(x86)\. Anyone know where in…

I am currently working on a task where I need to capture the salesperson's name in the Order Entry > Sales Split form. However, I only have the salesperson code and am unable to locate the corresponding salesperson name. I am aware that I can link the…

Good morning, I am running a report in Stonefield and when i run the report, it shows for instance same invoice numbers with the same $ amount. just like this invoice # 60000 $200.00 invoice # 60000 $200.00 invoice # 60005 $600.00 I just…

I am looking for someone to be able to call on when I need Alerts in Sage Alerts and Workflow developed or changed. Knowledge with the REST API features of Alerts and Workflow would be beneficial as we have a couple of third party applications that we…

We just upgraded to Sage 300 2024 (from Sage 300 2021) which included an upgrade from Office 2019 x86 to Office 365 x64 (which includes an upgrade from Access Database Engine 2016 x86 to Access Runtime 365 x64). Everything seems to be working great with…

Hello, I was wondering if anyone could help guide me in adding the Order Entry -> Deliver By field onto the header of the Order Entry -> OECONF01.RPT report? I would have thought this was easy to do but I can't spot the field in the Object Model or…

I recently inherited a client who is using many macros in their environment. Some of these macros are used in place of the standard Order Entry and Shipment forms. Everything works fine in their current environment which is Sage 300 2021. Recently I installed…

Anyone have clients using the GetRates macro and having an issue with the website it pulls the data from? It appears the default fx.sauder.ubc.ca site as been down for a few days. Does anyone have an alternate site we can replace it with?

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…

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…

We're printing a custom report (PJC) built using Crystal Report 16 and running Sage300 Premium v7.0 2023 How can we resolve the error below?

This is hopefully a simple request. Trying to use the stock APLETT01.rpt form and have it filter out all "inactive" vendors. Focusing on the {APVEN.SWACTV}=1 field as a record selection but cannot get it to filter. I assume it has to do with the APSLVEN…

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…

I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs. When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter. It also works fine running…

Does anyone know if this program is capable of inserting a signature on a cheque? if so how? If not what do others use to do this?

Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…

I am trying to have a calculated cost - ie. Ic most recent * 1.8 rounded up to the next 100. Say I get 2445 that would print 2500 and then I am trying to substruct 1.00 from 2500 to get a new sales price of 2499. I am using two formulas one to get the…

I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…

Does anyone have a sample C# example of how to insert a customer into the AR Customers section of Sage 2017 ? I have the Visual Basic macro sample, but it looks so complicated, don't know where to start.

I've added the DataSource Control and FEC control to my Form ok. My COMAPI session is working fine. I'm running into a couple of issues getting the FEC working. I'm getting the following error trying to set the DataSource control to active. Also I…

So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…

Hello We have a C# program that takes as its input a text file, processes the file and then posts the OE Order using the class ACCPAC.Advantage. We open the OE Views to create the OE Order. The programs runs every 15 minutes on a Windows Server with…

I can't find any functionality for coding a specific period from 1 year ago in a fixed 12 month financial. I've got multiple columns set-up with FRAMTA ("NET1P"), NET2P, etc. and I want to add the same period from 1 year ago. All I can find is formulas…

I have a client that i upgraded from Sage 300 v2014 to Sage 300 v2022. They have some macros where some of them needed some minor changes. One of them prints a bunch of forms and they print them to different trays of the printer based on a screen selection…