Skip to main content

Unanswered questions

3125 Topics
Varsity I
vib1980
asked in Configuration and Installation
Error when upgrading from 2022 R1 - 2023 R1

Hi Team,We are getting the below error while upgrading db from 2022r1 - 2023 r1. Any thoughts.MySQL version - 5.7.1System.NotImplementedException: MySqlScripter: There is no conversion from logical data type Udt to MySql physical type   at PX.DbServices.Points.MySql.MySqlScripter.scriptColumnDataType(TableColumn col, String& comment)   at PX.DbServices.Points.MySql.MySqlScripter.getColumnDefinition(TableColumn col, String tableName, DefaultScriptingMethod scriptDefault)   at PX.DbServices.Points.MySql.MySqlScripter.<Script>d__40.MoveNext()   at PX.DbServices.Points.DbmsBase.DefaultExecutor`1.Execute(Func`1 cmdProvider)   at PX.DbServices.Points.DbmsBase.PointDbmsBase.executeCommands(IEnumerable`1 commands, ExecutionContext context, Boolean withoutUsingDb)   at PX.BulkInsert.Installer.PointInstallationExtensions.RunSchemaFirst(PointDbmsBase point, DataSchema schema, ExecutionContext context, Boolean customScript, Int32 timeoutMultiplier)   at PX.BulkInsert.Installer.PointInsta

101
hkabiri
Acumatica Moderator
14 minutes ago
R
Freshman II
ranjithduraisamy72Freshman II
asked in Low Code | No Code Customizations or Integrations
Is it possible to automate the print of production label with help of business event?

Is it possible to automate the printing of production label with help of business event?I’m trying to automate label printing from production order details screen when certain operation status got changed to completed. 

235
R
Freshman II
22 minutes ago
martinxfe
Jr Varsity II
martinxfeJr Varsity II
asked in Develop Customizations
Workflow Event Handler Not Firing.

I’ve been having trouble getting a custom event handler to fire. I’ve followed this process......as closely as I could, and while the action that fires the event runs, the transition triggered by the event does not. I feel like I’m missing something obvious, but I just can't put my finger on it. I’m working with 24R1 Build 24.101.0059.For context, this is more an exercise in personal edification than looking for a workaround. Any input would be appreciated.  // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class APInvoiceExtZ : PXCacheExtension<PX.Objects.AP.APInvoice> { public class Events : PXEntityEvent<APInvoice>.Container<Events> { public PXEntityEvent<APInvoice> DescChanged; } } // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class APInvoiceEntry_Ext : PXGraphExtension<APInvoiceEntry> { publi

40
martinxfe
Jr Varsity II
36 minutes ago
K
Freshman I
kdesbiensFreshman I
asked in Develop Customizations
Issue with ClientID Synchronization Across Tabs in Custom Screen

Hello everyone,I'm facing an issue with a custom Acumatica screen that involves managing customer records (SanitationCustomer). I have a custom graph (SanitationCustomerMaint) and DAC (SanitationCustomer) that allow users to select a different ClientID using a selector. The main problem occurs when switching between tabs and updating the ClientID.Here is the specific issue: When I update the ClientID from the General tab, the customer information is correctly updated for fields such as name, address, city, etc., and all the related views are refreshed accordingly.   However, when I switch to a different tab (e.g., Brewers or Invoices) and change the ClientID, the new ClientID appears to be set, but when I navigate back to theGeneral tab, the customer information shown is still from the previous ClientID.  Additionally, if I save a new record to a related view (e.g., AssignedBreweries), it gets associated with the previous ClientID instead of the newly selected one. using System;using

30
K
Freshman I
41 minutes ago
J
Jr Varsity III
jmorganJr Varsity III
asked in Configuration and Installation
How is the modern UI in 24R2 enabled on the mobile app ?

I am assuming that this exists.

224
J
Jr Varsity III
1 hour ago
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Distribution
Printing multiple copies to Device Hub using an Override

On the Shipments Screen, I overrode the Print Shipment Confirmation button so that I can direct the print job to a specific printer on the Device Hub.  It works.  But I want to specify a number of copies.  There is a printer parameter NumberOfCopies but when the print job is sent to the Hub, it seems to be ignoring the parameter.//THIS WORKS but only prints one copy even if NumberOfCopies is greater than 1//PrintSettings printSettings = new PrintSettings()//{// PrinterID = printer.PrinterID,// NumberOfCopies = iCSPrintHubActions.NumberCopies,// PrintWithDeviceHub = true,// DefinePrinterManually = true//};//PXGraph.CreateInstance<SMPrintJobMaint>().CreatePrintJob(printSettings, reportID, parametersDictionary, "Shipment Confirmation", CancellationToken.None);//to use this you must uncheck Use Parallel Processing in the Device Hubfor (int i = 0; i < iCSPrintHubActions.NumberCopies; i++){ PrintSettings printSettings = new PrintSettings() { PrinterID = prin

131
Joe Schmucker
Captain II
1 hour ago
T
Semi-Pro I
TharidhiPSemi-Pro I
asked in Develop Customizations
Copy Qty. to Produce Value for Child Production Orders in Production Order Maintenance Screen (AM201500)

Hi, I have a requirement as follows and need to know how this can be catered via customizing the action.When I click on “Generate Orders for Subassemblies” for a parent item such as given below with a qty to produce of 10.00 When the button is pressed the child items also need to be set to a qty to produce of 10.00, currently the system sets it to 1.00 as shown belowHow can I also copy over the qty to produce as well over to the child items once the button is pressed?

171
lauraj46
Captain II
1 hour ago
J
Jr Varsity III
jzhuJr Varsity III
asked in Everything Else
Is there a way to automatically send email when on a specified date/month?

Hello! I want to send an automatic email to customers on December 1st to remind/teach them how to set up Fiscal Year for the next year. Is there a way to automatically send this email from the system if there is no event that triggers it? I thought about using Business Event but I can’t think any changes in the system that would process this, other than maybe when system date changes? But I’m not sure if that can be done with Business event.I also thought of Automation schedules, but I don’t have a screen ID to use that would cause this email to send… Any ideas? Thank you!

111
lauraj46
Captain II
1 hour ago
A
Varsity I
AndrewAVarsity I
asked in Financials
Can the Accounts Payable report display by Financial Period?

Hi, For the AR Aging report, there is an option in the Statement Cycles screen shown below that allows this report to display by Financial Period. Is there a way for this same setup to be used for the AP Aging report? If not, is there another way this can be implemented in the system, or would it need to be done via a customisation. Kind regards,Andrew 

371
cbrown07
Freshman I
3 hours ago
D
Jr Varsity III
dsenevirathne54Jr Varsity III
asked in Reports and Generic Inquires
Project Revised Budget for a historical date

Hi ,I have a requirement to create a generic inquiry to see the projects revised budget (Original + Change Orders) for a given date. It needs to be able to select the date as a parameter and system show the total revised budget for the parameter date. I tried creating a GI but it was not successful. Do you anyone know a table to fetch this data or way of creating a GI to get this results?Thank You,Dulanjana

50
D
Jr Varsity III
3 hours ago
B
Freshman II
brettd36Freshman II
asked in Reports and Generic Inquires
Exact number of records cannot be retrieved on a Generic Inquiry

Good day, we have a client that has suddenly received an error on one of their Generic Inquiries.On the Main GI there is an exclamation mark that states System was not able to get record count and there’s an exclamation mark in the top right corner indicating that the number of records is capped at 50,000On one of the exisitng filters it states: The exact number of records cannot be retrieved. During export to Excel top 1000 transaction records will be exported.See screenshot below.Version 2024R1 PCS on an Azure server  

284
B
Freshman II
4 hours ago
S
Jr Varsity II
SBaldwinJr Varsity II
asked in Manufacturing
Selecting multiple locations for materials

Is there a way to set up a hierarchy of locations within a BoM.Our company makes seed mixes and often times end up with a “partial” bag of a seed mix, for example 5 pounds remaining from a 50 pound bag. We often set this bag aside away from the retail location to use in the next seed mix.Is it possible to set up the BoM to say “use all that is in THIS location first, and then pull from a secondary location if needed”? I would like it to show up on the production ticket if an employee needs to pull product from 2 different locations.

161
chameera71
Jr Varsity III
4 hours ago
MichaelShirk
Semi-Pro II
MichaelShirkSemi-Pro II
asked in Develop Customizations
Customization publish freezing with no errors on local dev instance

Does anyone have ideas about what might be causing this?When I publish my customizations that I’m working on, in my local instance, the process doesn’t complete. There are no errors whatsoever. It just gets part of the way through the publish process and stops with seemingly no rhyme or reason. Then I have to unpublish all customizations and publish them one by one for it to work. This has been happening for some time now, and getting more frequent.Thankfully the issue is not present in the production instance, but it’s still annoying and concerning.I have a very fast machine and even if I leave it overnight it doesn’t complete, so it’s not just a slow publish.

272
Manikanta Dhulipudi
Captain II
7 hours ago
T
Semi-Pro I
TharidhiPSemi-Pro I
asked in Develop Customizations
How to Access Customer Location User Defined Field Defined in CR.Standalone.Location from Sales Order Graph

Hi, I have a user defined field in customer screen (LocationExt.usrExpectedPaymentDate) as below, I need to access this field for a calculation in the sales order entry graph but I get this error.[2024-10-23 04:45:10.957] \App_Code\Caches\SOOrderEntry.cs(159): error CS0246: The type or namespace name 'StandaloneLocationExt' could not be found (are you missing a using directive or an assembly reference?)using System;using System.Collections;using System.Collections.Generic;using System.Diagnostics;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.DR;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.IN;using PX.Objects.PM;using PX.Objects.PO;using PX.Objects.TX;using POLine = PX.Objects.PO.POLine;using POOrder = PX.Objects.PO.POOrder;using PX.CarrierService;using PX.Concurrency;using CRLocation = PX.Objects.CR.Standalone.Location;

403
T
Semi-Pro I
12 hours ago
aaghaei
Captain II
aaghaeiCaptain II
asked in Everything Else
Installing Acumatica on Azure using App Services.

Hello all, I do not want to setup a virtual machine and install Acumatica and then worry about the patches and upgrades …So, the question is, has anyone installed Acumatica on Azure using Azure App Services? If yes, any documentation that you can share?

80
aaghaei
Captain II
16 hours ago
D
Freshman I
DelFreshman I
asked in Reports and Generic Inquires
Add a newly created report to a customer's Mailing and Printing settings

We have a newly created report that we would like to add to certain customer’s Mailing and Printing setting. When we attempt to add the report it is not found under either Mailing ID or Report ID. What is the process for adding a new report to these setting. 

141
Laura02
Captain II
17 hours ago
K
kstehman
asked in Configuration and Installation
importing two units of measure conversion for one stock item

is it possible to import multiple units of measure conversions on the same import scenario?  

161
lauraj46
Captain II
18 hours ago
B
bdale32
asked in Financials
New 1099 regulations for 2024

There are new regulations for determining 1099 filing, etc for 2024. I was wondering how Acumatica is working to accomodate these changes.

161
Laura02
Captain II
19 hours ago
A
aaddsi
asked in Payroll
Active and Inactive Employee Filter/Column

How can I add a column for inactive/active employees on this employee payroll settings screen?

333
pbennett
Varsity II
21 hours ago
A
Freshman I
alejandroalvarado64Freshman I
asked in Develop Integrations with Web Services | APIs
How to send an API Key authorization method in a POST request?

I have been trying to send a token via API Key Authorization method but I've been getting an unauthorized error: {StatusCode: 401, ReasonPhrase: 'Unauthorized', Version: 1.1, Content: System.Net.Http.NoWriteNoSeekStreamContent, Headers:{  Date: Wed, 23 Oct 2024 16:35:03 GMT  Transfer-Encoding: chunked  Server: Microsoft-IIS/10.0  Content-Type: application/json; charset=utf-8}}This is my code:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.Common.Extensions;using PX.Objects;using PX.Objects.IN;using RiverlandDesarrolloV231;using System.Net.Http;using System.Threading.Tasks;using Newtonsoft.Json;using PX.Concurrency;namespace PX.Objects.IN{    public class INReceiptEntry_Extension : PXGraphExtension<PX.Objects.IN.INReceiptEntry>    {        #region Event Handlers        public

300
A
Freshman I
22 hours ago
Tony Lanzer
Semi-Pro I
Tony LanzerSemi-Pro I
asked in Develop Customizations
Launching an external url from mobile

I have code that opens a new tab to an external URL like this (builder.Uri is just referencing a url):throw new PXException($"Redirect0:{builder.Uri}$target=_blank")This fails on mobile. I assume maybe because the mobile browser doesn't recognize it? If so, does anyone know how to launch an external web app from the Acumatica mobile app?

364
Tony Lanzer
Semi-Pro I
22 hours ago
K
Semi-Pro I
krausef77Semi-Pro I
asked in Everything Else
Expose Acumatica Custom Wiki to external Sources (i.e. BigCommerce) / Make Parts of Wiki Public?

Hi All, I was wondering if there is a way to make part of the Acumatica Wiki (specifically Custom Wiki Articles) public/ expose them to Users having the Link?One Usecase might be linking back to Acumatica Wiki Articles from BigCommerce. Any thoughts/ideas?

392
J
Jr Varsity III
1 day ago
J
Freshman I
jhoncandare04Freshman I
asked in Develop Customizations
Is It Possible to Change the Report Displayed When the Print Button Is Clicked?

 Hello po i just want to ask if i can change the report when the print is clicked ? base on Branch

538
J
Freshman I
1 day ago
K
kviranga38
asked in Develop Customizations
Capturing the User Who Released the Invoice form

I have a requirement to include a field for storing the user ID of the person who released the invoice. How can I achieve this? 

383
J
Freshman I
1 day ago
J
Jr Varsity III
jsudakJr Varsity III
asked in Distribution
How do we use RR when we ship the replacement and pick up the return at the same time?

How do we use RR when we ship the replacement and pick up the return at the same time? We typically send the replacement item via company truck and pick up the defective/warranty item at the same time (or sometimes a day or two later, as the original item still needs to be extracted when the replacement item gets installed). The problem we are having is that the replacement shipment needs to be Confirmed before the Return item can have it’s shipment created. The SO entry appears to function the way we desire with the replacement item and the return item on the same transaction, but we have no document(s) for our driver and the customer to indicate both the replacement and the return being processed at the same time.

130
J
Jr Varsity III
1 day ago

Badge winners

Show all badges
Terms & ConditionsCookie settings