Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

vib1980

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

14 minutes ago

ranjithduraisamy72Freshman II

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

22 minutes ago

martinxfeJr Varsity II

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

36 minutes ago

KarthikGajendranAcumatica Moderator

Retail

How guest customer sales orders from eCommerce site like BigCommerce and Shopify are handled in Acumatica?

BigCommerce:eCommerce Admin can choose how the customers should checkout in BigCommerce as shown in the below screenshot. If the customer decide to checkout as guest a customer account will not be created in BigCommerce. So in Acumatica the Sales Order will be imported with Generic Guest Customer provided in the Store Settings as shown below. If a customer decide to checkout with account details, then a customer account will be created in BigCommerce. And in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers are allowed to checkout as guest but BigCommerce will create a customer account as soon as the order is placed and in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers cannot checkout as guest in BigComm

5469

37 minutes ago

kdesbiensFreshman I

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

41 minutes ago

ranjithduraisamy72Freshman II

Manufacturing

How MRP calculation works for blanket purchase order.

Is the Blanket Purchase are calculated for the supply in inventory planning (MRP). I tried to do that but it is not working as expected. Can anyone have idea, will the Blanket purchase order calculated for MRP?

112

49 minutes ago

Kandy BeattyCaptain II

Manufacturing

How is MRP Requirement calculated?

When looking at the MRP display, there is an item that is on there for a base qty of 5,000. I have a few questions in regards to it. There is a Sales Order for 5,000, however this item has no Safety Stock and no min/max order qty. There is also nothing on the replenishment tab. There is also nothing on the Vendor tab. So, how does Acumatica calculate this? I know it is demand based but if you do not want to carry 5,000 in a warehouse, how do you get this to not show up on the MRP display? Will a Purchase Order clear this?

2828

58 minutes ago

jmorganJr Varsity III

Configuration and Installation

How is the modern UI in 24R2 enabled on the mobile app ?

I am assuming that this exists.

224

1 hour ago

Joe SchmuckerCaptain II

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

1 hour ago

TharidhiPSemi-Pro I

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

1 hour ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2071 topics
6936 Replies

Distribution

2045 topics
7654 Replies

Manufacturing

734 topics
2770 Replies

Construction

693 topics
2466 Replies

CRM

220 topics
668 Replies

Field Service

343 topics
1110 Replies

Retail

511 topics
2333 Replies

Payroll

239 topics
841 Replies

Professional Services

1 topic
1 Reply

Low Code | No Code Customizations or Integrations

322 topics
1201 Replies

Develop Customizations

2787 topics
11345 Replies

Develop Integrations with Web Services | APIs

702 topics
2825 Replies

ISV Solutions

129 topics
537 Replies

Configuration and Installation

896 topics
3300 Replies

Reports and Generic Inquires

2066 topics
8108 Replies

Import and Export Scenarios

795 topics
3259 Replies

System Health and Performance

147 topics
560 Replies

Community site discussions

268 topics
529 Replies

Community Introductions

95 topics
293 Replies

Everything Else

828 topics
2765 Replies

Technology Partners and Customers

Forum for Acumatica technology partners and customers to collaborate on their unique products

MYOB User Discussions

15 topics
41 Replies

JAMIS Prime User Discussions

2 topics
0 Replies

News & Announcements

Get the latest on our community & company!

Acumatica News & Updates

123 topics
177 Replies

Events & Meet-ups

150 topics
90 Replies

Developer Newsletter

19 topics
0 Replies

49 topics
0 Replies

vib1980

Configuration and Installation

Error when upgrading from 2022 R1 - 2023 R1

101

14 minutes ago

ranjithduraisamy72Freshman II

Low Code | No Code Customizations or Integrations

Is it possible to automate the print of production label with help of business event?

235

22 minutes ago

martinxfeJr Varsity II

Develop Customizations

Workflow Event Handler Not Firing.

36 minutes ago

kdesbiensFreshman I

Develop Customizations

Issue with ClientID Synchronization Across Tabs in Custom Screen

41 minutes ago

jmorganJr Varsity III

Configuration and Installation

How is the modern UI in 24R2 enabled on the mobile app ?

I am assuming that this exists.

224

1 hour ago

Joe SchmuckerCaptain II

Distribution

Printing multiple copies to Device Hub using an Override

131

1 hour ago

TharidhiPSemi-Pro I

Develop Customizations

Copy Qty. to Produce Value for Child Production Orders in Production Order Maintenance Screen (AM201500)

171

1 hour ago

jzhuJr Varsity III

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

1 hour ago

AndrewAVarsity I

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

3 hours ago

dsenevirathne54Jr Varsity III

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

3 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! September, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

arthia98has earned the badge Easy talker
eucciferri35has earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded