Questions tagged [acumatica-kb]

The knowledge base for Acumatica, 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.

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.

327 questions
2
votes
2 answers

Importing Thousands of Records Into Acumatica via SOAP Contract-Based API

I’m using contract-based SOAP APIs to try to import about 25,000 Journal Entry lines from a banking system into a single Acumatica GL batch. If I try to add all the records at once to the same GL batch, my request times out after a few hours.…
TheNewbie
  • 33
  • 4
2
votes
1 answer

How to create a Form-Specific Help menu in Modern UI?

One of the standing out features of Acumatica's Modern UI is the Form-Specific Help menu, which is opened when you click the Help button while viewing the majority of forms: I wonder how big is the effort to create Form-Specific Help menu for a…
RuslanDev
  • 6,718
  • 1
  • 14
  • 27
2
votes
1 answer

Generic Inquiry in Acumatica Mobile App

We created a bunch of Generic Inquiries in our Acumatica instance and now want to make some of them also accessible via Acumatica mobile application. What is the recommended approach to include Generic Inquiry into the Mobile SiteMap?
RuslanDev
  • 6,718
  • 1
  • 14
  • 27
2
votes
3 answers

Generate Report Programmatically

Let's say that I have created a report using the Acumatica Report Designer and it is linked to the relevant DAC. I also have a custom screen with an Action. When the user executes this action, I want to generate the report so that it the user…
Joseph Caruana
  • 2,241
  • 3
  • 31
  • 48
2
votes
1 answer

How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?

Out-of-box Acumatica Inventory Item Label report (IN619200) is designed to print multiple labels for the line item on the receipt only when the item is serialized. We will be modifying report that will allow user to select a receipt number and have…
DChhapgar
  • 2,280
  • 12
  • 18
2
votes
1 answer

CREATE VIEW Statement in Acumatica Customization Project

Does anyone know how to push a CREATE VIEW SQL statement into an Acumatica Customization Project? I know how to do it in SQL Management Studio, but doing it through a Customization Project would be useful for Acumatica SaaS customers.
Tim Rodman
  • 66
  • 9
2
votes
1 answer

How to conditionally hide PXTabItem inside an Acumatica screen?

I want to HIDE the Sales Order Line Commissions Tab, but I only want the Tab Hidden for a Specific Role. Is this possible?
RuslanDev
  • 6,718
  • 1
  • 14
  • 27
1
vote
1 answer

Active' field is not updating to 'false' in Acumatica API even though the response code is 200

I am attempting to update and create new locations using the Acumatica REST Web-services Endpoint. As you can see in the image below, the endpoint CustomerLocation entity includes the 'Active' field. CustomerLocation Entity I'm making a PUT request…
Hadegh
  • 11
  • 2
1
vote
1 answer

Acumatica - Open Combined Financial Reports w/ Parameters from Code

I'm trying to write a process screen in Acumatica ERP 2021R2 (version 21.210.0030) that will generate a financial report for each selected branch in the grid, combine them, and open the combined report when all of them are created. I know how to do…
kchron
  • 29
  • 3
1
vote
3 answers

Dialog box for new action on SO301000 screen, cannot add more than one item to the grid

I am trying to add a dialog box to the SO301000 screen, this dialog box (I think its also considered a smart panel but the difference is lost on me) is just supposed to show a list of orders that a customer has made. What I have working: 1: I am…
Shoonly
  • 15
  • 1
  • 4
1
vote
0 answers

Acumatica Mobile App - Inventory Allocation Details

I have added the Inventory Allocation Details (IN402000) to Mobile Acumatica ISSUE 1 When Opening the Inventory Allocation Detail (IN402000) screen on the mobile app, I would like the screen to open with the fields showing but instead an empty block…
1
vote
1 answer

Acumatica CREATE VIEW to create SQL view and load it as a DAC for use in GI & Reports

Similar post to this: Curious about properly defining the DAC. I have a T-SQL CREATE VIEW script that I've added to the 'Database Scripts' are of the Customization project as shown. But I suspect that I haven't added the DAC properly. When I attempt…
SQL Learner
  • 89
  • 1
  • 1
  • 7
1
vote
1 answer

Lock Extended Cost

How can extended cost be locked, so that it cannot be keyed over? Currently, a qty and a unit cost calculate, but the extended cost can be changed. View of Changed Cost
1
vote
0 answers

Another Process has added a "Note" Record(ProdDetail) in 22R1

I was trying to update OperationCD in AMProdOper with my ProcessStepCD. But it gives me error when I call prodDetailMaint.Save.Press(); Error: Another process has added the 'Note' record. Your changes will be lost. at…
subodh
  • 11
  • 2
1
vote
2 answers

Acumatica Graph functions

I've been programming in acumatica for a year, but I still can't quite understand how certain things work. For example, how the graphs work in the following code, logic is being added, however, I do not understand how the information is passed to…
TuDictador
  • 15
  • 4
1
2
3
21 22