Questions tagged [acumatica]

Acumatica is a cloud- and browser-based enterprise resource planning system (ERP), which can be customized and extended via an SDK and interoperated with via a web services API. Only topics about interfaceing via the SDK or API are on topic.

Acumatica often refers to the ERP and CRM product offered by Acumatica, but can also refer to the Acumatica Cloud xRP Platform.

Acumatica development is done using C# and ASP.NET markup language for interface or pages. Querying the back-end database occurs through BQL, which maps to SQL Server or MySQL queries. New applications can be developed using Visual Studio, and a web-based customization environment allows users to extend and customize existing screens using the Acumatica Customization Environment IDE. Acumatica applications can be run from the browser, or on mobile devices using the native iOS and Android applications. Deployment can be done in public and private clouds, using single-tenancy and multi-tenancy modes.

3477 questions
0
votes
0 answers

Updating custom field on Location via event handler on Customer breaks after Acuamtica upgrade

I have a custom field on the Location DAC which gets updated via event handlers on the Customer screen. Similarly this custom field can also be updated by events on the Business Account screen. My code is working in Acumatica version 2019 R1.…
abulger
  • 71
  • 9
0
votes
1 answer

Why didn't this field get added to to SOLine table

I've created a simple DAC extension on SOLine in a customization project to add a string field. I went through Code, +, New DAC Extension, and selected PX.Objects.SO.SOLine. When I publish the code below, no errors are reported but the field is not…
Customizer
  • 61
  • 10
0
votes
1 answer

Acumatica Adding Column to Files Dialog Grid

Issue I was asked if it was possible to add a column to the grid on the standard Files Dialog window in Acumatica. Findings I believe I can extend the cache to create a field in the Data Access Class (and modify the tables/create an extension table…
yc9nyw08vf
  • 183
  • 11
0
votes
1 answer

Acumatica Using $filter programmatically gives HTTP 400 Bad request

I am using this url in my php code https://awesomedomain.app/entity/Default/18.200.001/SalesOrder?$filter=Status eq 'Completed' Like this: $acumaticaOrder = $this->Acumatica_API("/entity/Default/18.200.001/SalesOrder?$" . 'filter' . "=Status eq…
Mohsin
  • 193
  • 1
  • 16
0
votes
1 answer

How can I set a default value on a projection field?

I have a projection DAC defined as below. I am using this DAC in a view on InventoryItemMaint. I need the InventoryID field of my projection DAC to default to the current item's ID, but nothing I try works. Is there a special way to do this? I've…
Deetz
  • 329
  • 1
  • 16
0
votes
1 answer

Unable to create Shipment by code - Acumatica

I trying to create shipment by code in Acumatica, it's working fine with Inventory item without Serial Number but im getting this error with item with serial number **PX.Data.PXRowPersistingException: 'SO Error: One or more lines have unassigned…
0
votes
1 answer

How can I modify the process prepare invoice

I've been looking for a method on the chart to achieve this, but I don't know where to start. I need someone to tell me with what event I can achieve what is stated. In any given day or week, there may be multiple deliveries or pickups of material…
Marco A.
  • 27
  • 5
0
votes
1 answer

How to get DAC fields display name in Selector When we are displaying data fields from joining 2 tables in Acumatica?

I have one customSelector conatins 4 data fields from 2 Tables Join. Here I am getting Tablename__FieldName as a Display in selector.. How can I see DAC Display names of Data fields for 2 tables Joined in A selector?
0
votes
1 answer

Prepare Payments page not showing PayDate after adding a filter

I added a new filter to Prepare payment(AP503000). The filter works as expected. After testing I realized that the Pay Date(APInvoice.PayDate) doesn't show data in the grid How can I make the paydate data show? I see that a lot of the data comes…
JvD
  • 473
  • 3
  • 18
0
votes
1 answer

Acumatica 2020 R2 Cant detect manufacturing reference

I have a customization project from acumatica 2019 r1 and this is working but the company required the acumatica version to be the latest version 2020 r2 upon my publsh of the customization project it is looking for the reference for a table of…
Rei Gner
  • 125
  • 11
0
votes
0 answers

Unable to update Reason dropdown values in Cases

I am trying to update the dropdown values for Reason field in Cases if Status is set to Open. { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (CRCase)e.Row; if (row == null) return; …
Bikash Lama
  • 177
  • 1
  • 13
0
votes
1 answer

Is there a way to set the default order of grid columns in a custom screen?

I have a custom screen with a grid section, and I've dragged the columns in the Customization Project Editor grid fields section to the order that I want them. I've unpublished all, republished, and reset grid fields to default and they still don't…
pmfith
  • 831
  • 6
  • 24
0
votes
1 answer

Why does my action affect more than the currently filtered records?

I have overwritten the Records data view on ARSalesPriceMaint with one of my own in order to also overwrite the data view delegate records. This is necessary because I have customized the page filter. This works great. I have added an action which…
Deetz
  • 329
  • 1
  • 16
0
votes
1 answer

Use Non Persistent field in Generic Inquiry Conditions

I am building a Generic Inquiry which would list the Contract Details with FixedRecurringPriceVal and UsrCustomFixedRecurringPriceVal. The later is a custom persistent field. Now, in this Generic Inquiry I would like to list only those Contract…
Bikash Lama
  • 177
  • 1
  • 13
0
votes
1 answer

Changing the Default Option for Column Filters

Is it possible to change the default option all column filters? I'm pretty sure I can accomplish this with some JavaScript, but I'd like to know if there's any way within the Acumatica framework to change this.
jhofer
  • 25
  • 8