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
3
votes
1 answer

Acumatica BQL Query with the same table more than once

I am trying to build a BQL query using the same table more than once. In my example below I am trying to use POVendorInventory as it relates to the default for the item and for each item warehouse (reason for the table listed twice in the…
Brendan
  • 5,428
  • 2
  • 17
  • 33
3
votes
1 answer

How do I keep focus on PXNumberEdit field after postback?

I have a PXNumberEdit field which, on enter, adds a product to a grid on a customized SO301000 page. The insert works and the field is emptied after the product is added. However, I would like to return the focus to that field. There doesn't seem…
3
votes
4 answers

How to override the tax details when adding a sales order through web service API

When I was trying to add our e-commerce orders into Acumatica through Acumatica Web service API, the tax details including totals were always automatically calculated in Acumatica based on product and customer information I send from our e-commerce…
Gladiator
  • 176
  • 11
3
votes
1 answer

Is it possible to make input as password in Acumatica

In configuration screen I need to have storage of passwords. Also I want to make it invisible for others ( displayed as stars ). How should I mark DAC class text field and/or modify PXTextEdit control in order to get this functionality?
Yuriy Zaletskyy
  • 4,983
  • 5
  • 34
  • 54
3
votes
1 answer

Customer Action "Extend To Vendor"

Using the latest version of Acumatica 5 with the latest and greatest updates, I’m running into a Web API issue that I have not been able to solve. I have code to execute the “Extend To Vendor” action on the Customer screen. It seems to run fine and…
John K.
  • 55
  • 4
3
votes
1 answer

Acumatica, how to check action is completed

I have a graph call action Create Shipment as below var soshipmentEntry = PXGraph.CreateInstance(); var confirmShipment =(soshipmenEntry.Actions["action"].GetState(null) as PXButtonState).Menus.FirstOrDefault(p => p.Command ==…
Larry Dinh
  • 379
  • 1
  • 3
  • 16
3
votes
2 answers

Is it the natural behavior of an Acumatica grid checkbox column to auto-refresh?

I have a grid that contains thousands of records. That grid contains a check box column, and every time I tick the box, it posts back, causing it to reload and go through the delegate each and every time. This means that every time you tick a…
Christine
  • 621
  • 7
  • 21
2
votes
1 answer

Add Usr Custom Field to Acumatica Appointments Mobile App

I'm trying to add a custom field to the mobile application Appointments screen FS300200. It seems simple where I update the containers and add the field but it's not showing up on the screen. For testing purposes, I was able to edit the display name…
2
votes
1 answer

Error in Process screen when attaching report to email

We have a requirement to attach custom report to email as an attachment. As per our requirement we created a process screen for this. Issue we are facing is, when we use below line of code we are getting “OBJECT REFERENCE ERROR”, can you please have…
John
  • 763
  • 3
  • 11
2
votes
1 answer

How to Get DefaultSite from UserPreferences For Current User in Acumatica

This is for Acumatica ERP 2021 R2: I need to get the Default Warehouse Site for the current user. This is shown as part of the UserPreferences DAC, and the field name is DefaultSite Getting the UserPreferences seems easy enough: var…
MarkJoel60
  • 537
  • 2
  • 6
  • 24
2
votes
0 answers

is it possible to use a PXTransactionScope inside of a test using the test SDk

I am trying to have all of my database actions rolled back after my test executes. I have included the using block inside the Execute method of my test. But every time that my code calls to the SAVE() method of the SOOrderEntry it immediately gets…
mbargar13
  • 45
  • 5
2
votes
1 answer

Acumatica Delete from Graph

I would like to delete a record from a graph, I can easily add one, but what is the syntax for deleting one with filter on Immatriculation field : Example do add ZVEHICULEGRAPH graph = PXGraph.CreateInstance(); ZVEHICULE dac = new…
2
votes
2 answers

How can I disable the Copy/Paste Save Template action?

Acumatica offers a great feature to Save as Template which makes creating new records from the template faster and easier. However, I have a use case where I need a more interactive sort of template in which the user can create a list of 100 items…
Brian Stevens
  • 1,826
  • 1
  • 7
  • 16
2
votes
1 answer

Create a new DAC : naming advice

I just have one question to make sure I'm doing it the right way. When creating a field in an existing DAC, the system automatically adds the prefix "usr". From what I understand, this allows Acumatica to know that the field is specific and that it…
AmélieG
  • 25
  • 4
2
votes
1 answer

Cannot find mapping for Status field

My application is integrated with Acumatica 2020R2. When I try to create a task (PUT /ProjectTask) with such body: { "Description": { "value": "xxx" }, "ProjectID": { "value": "xxx" }, "TaskID": { "value": "xxx" }, …