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

Acumatica and Automation Notifications and how to get them to show up in an opportunity activity tab

We are looking into automation notifications and here is our use case: We will be automating the creation of opportunities through process screens. And then after an opportunity is created, we want to have the system automatically send the contact…
Cory
  • 305
  • 1
  • 8
2
votes
1 answer

Acumatica - Generic Inquiries - printing Output Reports

Is it possible to print output reports from a Generic Inquiry page? The use case would be for our users to review a GI, sort/filter as they desire, then print the result set through an output report. They need the data to be presented and formatted…
Cory
  • 305
  • 1
  • 8
2
votes
1 answer

Replacing a blank field with a custom string in an Acumatica template

We have created some notification templates to send Sales Order details. The issue is, when the Description is blank, we need to add our custom message. How can we do that? Here is a code sample:
John
  • 763
  • 3
  • 11
2
votes
2 answers

Acumatica : Is my joined selector badly written?

I'm just starting coding in Acumatica and I'm trying to add Sectors to the customer screen. I created a SQL Sector table (TRSector) with the 18 different sectors' names and codes. I also created another SQL table (TRCustSectorActive) that has all…
AlexS
  • 53
  • 9
2
votes
3 answers

Join Account to Sub Account

I am trying to create a GI to retrieve a list of GL Accounts with each associated Sub Account value. I have looked in the database and found the GroupMask column which ties the Account and Sub tables together with a bit relationship but I don't…
Jerry Welliver
  • 377
  • 1
  • 13
2
votes
1 answer

Overriding Shipping address passed to Avalara

We are having a requirement to pass other than shipping address to external tax calculation method to compute tax. I am storing the address in a simple custom table and it is selected in the sales order and the same is copied into sales invoice…
2
votes
3 answers

Make PXButton appear as pencil icon

I would like to place a button on my page that allows redirect to a custom processing page but the button must be the pencil icon such as when using AllowEdit="True" on a control. I have the following asp.net :
Joshua Van Hoesen
  • 1,684
  • 15
  • 30
2
votes
2 answers

Universal Search for Attributes

I am trying to search in the values stored under my Attributes. For example, I have a few attributes under the Cases screen. I want to search the value of these attributes from Universal Search. So when I do a universal search, it brings up this…
Krunal
  • 1,138
  • 1
  • 9
  • 28
2
votes
1 answer

Replace Data Provider and Scenario with Code using REST API in Acumatica

I am tasked with replacing a manual procedure in Acumatica with an automated one using the REST API. I have been through the integration guide, but I do not know how to determine the endpoints that match up with the manual process I am replacing.…
MarkJoel60
  • 537
  • 2
  • 6
  • 24
2
votes
1 answer

Sending Email Using Acumatica REST API

I am trying to send a mail from Acumatica RestAPI by using the below API URL: https:/{url}/entity/Default/17.200.001/Email?CompanyID=STS&ScreenID=CR306015 The problem am facing while calling this API with the request shown here: { "From": …
2
votes
1 answer

Add Excel Import to existing Acumatica Page - Without redefining the Data View

I want to extend an Acumatica page and include the ability to import form Excel in a grid. I understand that you can achieve this by adding PXImport to the data view and setting AllowUpload to the grid. However, my concern is that I don't want to…
Joseph Caruana
  • 2,241
  • 3
  • 31
  • 48
2
votes
1 answer

How to extend acumatica api to attach file in Sales order Line Item

I am able to attach file in the #acumatica sales order by rest api. Is there any way to attach a file in sales order line item.
2
votes
1 answer

Using PXDatabase to Delete Records with Null Fields

What is the proper way to use PXDATABASE to delete records in a table that specifically contain nulls?
jjacob
  • 156
  • 4
2
votes
1 answer

How to get Control Types for Attribute Values on the Grid when CSAnswers DAC is extended?

I am trying to show attributeID and Values on the SmartPanel grid with additional features. I am able to achieve in showing the values but the values are of type text. I am not able to get the control types for values like in Attributes tab of…
Prathyusha
  • 155
  • 10
2
votes
1 answer

Need help in selector control

I created a selector control which displays a list of all serial #s from INItemLotSerial table, it works fine, the problem is the description field is showing InventoryID, how to show InventoryCD. Please have a look at below sample…
John
  • 763
  • 3
  • 11