Introduction
While rare, the InvalidCastException: Specified cast is not valid error can occur in Acumatica when working with custom Boolean fields on any screen — such as Sales Order — if specific scenarios, like Copy and Paste, introduce unexpected data formats. This can disrupt workflows, espe...
Adding a profile photo uploader to Acumatica’s Employee screen (EP203000) is an excellent way to enhance the user experience and personalize employee records. While this functionality is not directly supported through the Customization Project Editor, it can be achieved using custom code.
Below,...
When developing custom screens in Acumatica, it’s common to join multiple Data Access Classes (DACs) in a view to display related data. However, a frequent challenge arises: fields from secondary DACs often appear as disabled (read-only) on the UI. This article will explore why this issue occurs...
By default, Acumatica does not include record notes in Excel exports. However, you can retrieve and export them using a Generic Inquiry (GI). This guide outlines the steps to link record notes with your data to ensure they appear in your exports.
Why Are Notes Not Exported Automatically?
Acumatic...
When extending the Modern UI in Acumatica to include custom fields, you may encounter the error:
"The field [FieldName] cannot be bound to a FieldState."
This error commonly arises when attempting to bind a custom field to the UI without defining it properly in the underlying data access class (D...
Customizing field visibility based on conditions is a frequent requirement in ERP systems like Acumatica. One common scenario is enabling or disabling a combo box based on another field's value. In this guide, we’ll explore how to achieve this using Acumatica's tools, covering both low-code and c...
By default, the PXDBWeblink attribute in Acumatica is designed to open URLs in a new tab. However, if your customization requires opening links in a new window, you can achieve this with a custom button and additional configuration.
This article demonstrates how to implement this functionality st...
As of version 24R1, Acumatica has introduced a notable enhancement. This change affects how developers declare Data Access Classes (DACs) and their inheritance from PX.Data.BQL interfaces .
This concerns a change where you now need to inherit from PXBqlTable, IBqlTable when declaring a DAC, for e...
When you create a field in DAC, the field may differ from the one you wrote, namely, write everything in capital letters.
The lines will look like this.
To fix this, you just need to add an inputmask to the field attribute. It will look like the code below .background{font-family:monaco...
Hello everybody,
recently for me it was needed to find out all key fields of DAC class. Code below does this:
public List<string> GetKeyFieldsOfDAC(Type dacClass)
{
var result = new List<string>();
&nb...