Sage 300

I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish

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); …

Installed PU8 on server and now a macro with OCX dropped on userform1 does not work on the server where macro is being developed does weird stuff now like 1. no longer generates _OnRecordChange event 2. Set oHeader = AccpacOE1100UICtrl1.UIDSControls…

I know this is a very specific question and I may not get any replies. But I thought it was worth the ask. We are transiting our 401K fund to Charles Schwab. They have a quite extensive file spec for uploading payroll data in regards to 401K deductions…

Our IT company has turned on 2 factor authentication and now Sage Alerts and Workflows is not able to send out e-mail notifications. Has anyone figured out a way around this? TIA

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?

I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…

Hi all, I tried to use Visual Studio 2019 with Sage 300 Solution Wizard to generate a simple screen. Right after the solution was auto generated, I use Sage 300 Code Generation Wizard to create a payment code screen. I tried to build the solution but…

My client is running Sage 300 Premium Edition Version 2020. They want the G/L Account Description field to be increased to 120 Characters. Is there an available utility for doing this? How can I achieve it in the easiest way possible? All responces…

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…

We are emailing RFI's, Submittals, etc... out of Sage. Is there a way to autopopulate a signature into the body of an email sent from Sage? Or do we have type our name and contact info into the message block?

We are rolling out the Project Management module and want to require certain fields so our Project Managers are required to enter the information before they can create the new job. Is this possible?

Currently trying to insert a AR invoice detail line by line transaction and the optional field is set as auto insert under the AR/Setup optional field. . Problem: Detail lines are inserted under the AR invoice without the optional field. Source code…

Hi all, I am making an AR Receipt Entry import to import the receipt in bulk from an excel file. I follow the recorded macro to create it. And I see that the ARPOOP (in recorded macro is using ARRECMAC1detail4) set the APPLY value to "Y" on line 124…

Hello, I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs…

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

Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.

Hi !!, Need help on above thrown the message from one of the UIAppControls of AccpacAR3100UICtrl1 Awaiting soonest reply. thanks and regards, Joshua

Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144 " Invoice Detail Attempt to change read-only field 'Header Discount'. " keep popping up and I am not able…

Customer Receipts are posted in the A/R as Prepayments because there is no Invoice. There is a plan on when and how much the Customer should pay. How can this Plan be managed in Sage 300 without raising an Invoice? An invoice is raised at the end…

Hi All, I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…

I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…

I am trying to update the order detail lines, specifically setting the "PickingSlipPrinted" flag to true, what would be the minimum data I need to send to the service? I've tried the below, but, it just keeps returning that certain fields cannot be…

Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

Could someone please post a sample C# code for iterating the detail records ("OE0500") for a specific order? Stephen Smith has instructions to "Set detail key into the detail view." - but not sure how to interpret this. After composing my views, I…