Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

How to add grand total or sum of all in historical Inventory Balance Report

HI, I am trying to add total of each colum at the end of the report. But report is just populating 0 instead of sum of all values. Can any one give me idea on how to add it? I use variable of total end qty. But its nor working. Even its repeating again and again for every row. I have attached the report

265

8 minutes ago

DrewNisleySemi-Pro III

Develop Customizations

SQL Connection Timeout

Every now and again, I will suddenly get the error shown below that says the execution timed out when publishing my customizations. It validates just fine and then it will try to either batch sql or sometimes its some place else in the publishing process and it will give me this error. Sometimes it just goes away after a few days of trying to publish. It is very frustrating because I can have no issues one day and then have endless issues the next. Is there SQL settings I need to change or is there acumatica settings I need to change? I don’t know where to go from here. I have tried resetting stats on sql, I’ve run dbcc freeproccache, I have set the sql execution time to zero to make it not timeout. Nothing seems to fix it, it just decides to work randomly. The only thing I have noticed that might be reoccurring (I’m not sure, but I think this is true) is that it usually happens when I am either publishing fresh customizations or publishing on a fresh instance. If I could get some help

17 minutes ago

kviranga38Freshman I

Develop Customizations

How to Open a Report Parameter Screen Before Running the Report

Hi Community,I am working on a customization in Acumatica, where I need to open the parameter screen for a report before the report is executed. I am using the report ID AM660000 for the "Move Report," and I want to pre-fill some parameters (like BatchNbr) from the current screen, but I want to ensure that the user can select additional parameters (like AcctCD) before the report is actually run.I have tried using the following code:throw new PXReportRequiredException(parameters, "AM660000", "Move Report");However, this approach immediately runs the report instead of just opening the parameter screen. I would like to know if there's a way to only show the parameter screen and allow the user to modify or select their parameters (e.g., AcctCD) before proceeding with the report.Any insights or examples would be greatly appreciated!

25 minutes ago

donnahenderson00Freshman I

CRM

Opportunities pricing not updated when Sale price worksheet is created

I updated our current pricing in through a sales price worksheet. When creating a sales order the price is correct however, when we create an opportunity the pricing is not updated. How can we resolve?

191

26 minutes ago

ReddyFreshman I

Develop Integrations with Web Services | APIs

422 Unprocessable Entity Error during request

The following error occurs when I try to create an expense receipt using the REST API. Could anyone help with this?Error: error: "Inserting 'Expense Receipt' record raised at least one error. Please review the errors.; TranDesc: 'Description' cannot be empty.".Body:{ "Date" : {"value" : "04/17/2025"}, "ExpenseItemID" : {"value" : "MEAL"}, "Details": [ { "Description" : {"value" : "Team outing"}, "Quantity" : {"value" : "2"}, "UOM" : {"value" : "PIECE"}, "Amount" : {"value" : "175"}, "Currency" : {"value" : "USD"} } ] }

202

27 minutes ago

Namrata13Freshman I

Develop Integrations with Web Services | APIs

How to fetch updated inventory from contract based rest api?

Hello,I am using contract based rest api. I was looking for the endpoint which can help me to fetch updated inventory changes nearly on real time based scenario, where I can pass updated date filter. So, can you please suggest which entity or endpoint would work better for this?And also looking for the endpoint where I can update stock quantity.Please look into the issue.Thank you

6413

46 minutes ago

PDharmasena10Varsity II

MYOB User Discussions

Unable to publish any customization project to Myob instance

I Created a new customization project in Myob Acumatica instance in Build 2024.110.101.1720 [24.110.0017]. And did few modifications in a screen and tried to publish, it publishes successfully but after opening the customization project again it looks like below and it gives following error messages in the trace. I tried this in a cloud demo environment and in a local instance as well. But same gives the same error. I tried few customizations with simple modification (only a new field for existing screen just for testing) even such customizations are giving same error

100

3 hours ago

tuan755

Develop Customizations

Cannot find 'CRPMTimeActivity' table in database

I want to join the tables together to have the following information: Customer | Project | Type Activities 1 customer can have multiple projects, and 1 project can have multiple activities. Activities are associated with both Customer and Project. That means my table Activities must contain 2 primary keys, the customer ID and the project ID. I found the CRPMTimeActivity DAG table that meets the conditions, but I can only see it in the generic inquiry and not in the database.The report I constructed is based on a complex logic involving three tables: Activity, Project (PMProject), and BAccount, so I need to process data in SQL Server before uploading it into Acumatica to create a new DAC. I just saw CRActivity, but in this one, I didn’t have a Project ID, so it caused duplication when I tried to join the project table (PMProject) with CRActivity. Because CRActivity has no ProjectID (ContractID). Does it have any other name to call in the database or what can I do or will you update i

172

4 hours ago

SidduJr Varsity II

Develop Customizations

Modern UI changes package publish getting errors

hello everyone , as per our requirement classic to converted into modern UI, while publishing the package getting errorts file code HTML File code please suggest how to resolve these error

7010

4 hours ago

HarrySemi-Pro II

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2392 topics

Distribution

2292 topics

Manufacturing

839 topics

Construction

801 topics

CRM

275 topics

Field Service

371 topics

Retail

553 topics

Payroll

264 topics

Professional Services

16 topics

Low Code | No Code Customizations or Integrations

386 topics

Develop Customizations

3155 topics

Develop Integrations with Web Services | APIs

811 topics

ISV Solutions

145 topics

Configuration and Installation

1005 topics

Reports and Generic Inquires

2401 topics

Import and Export Scenarios

903 topics

System Health and Performance

160 topics

Community site discussions

347 topics

Community Introductions

97 topics

Everything Else

950 topics

Technology Partners and Customers

Forum for Acumatica technology partners and customers to collaborate on their unique products

MYOB User Discussions

27 topics

JAMIS Prime User Discussions

6 topics

News & Announcements

Get the latest on our community & company!

Acumatica News & Updates

141 topics

Events & Meet-ups

153 topics

Developer Newsletter

19 topics

55 topics

tahayabaliVarsity II

Reports and Generic Inquires

How to add grand total or sum of all in historical Inventory Balance Report

265

8 minutes ago

DrewNisleySemi-Pro III

Develop Customizations

SQL Connection Timeout

17 minutes ago

kviranga38Freshman I

Develop Customizations

How to Open a Report Parameter Screen Before Running the Report

25 minutes ago

donnahenderson00Freshman I

CRM

Opportunities pricing not updated when Sale price worksheet is created

191

26 minutes ago

ReddyFreshman I

Develop Integrations with Web Services | APIs

422 Unprocessable Entity Error during request

202

27 minutes ago

Namrata13Freshman I

Develop Integrations with Web Services | APIs

How to fetch updated inventory from contract based rest api?

6413

46 minutes ago

PDharmasena10Varsity II

MYOB User Discussions

Unable to publish any customization project to Myob instance

100

3 hours ago

tuan755

Develop Customizations

Cannot find 'CRPMTimeActivity' table in database

172

4 hours ago

SidduJr Varsity II

Develop Customizations

Modern UI changes package publish getting errors

hello everyone , as per our requirement classic to converted into modern UI, while publishing the package getting errorts file code HTML File code please suggest how to resolve these error

7010

4 hours ago

HarrySemi-Pro II

New to the community?

Get Started HERE be sure toIntroduce Yourself and reach your Community ManagerChris Hackett

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! March, 2025

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

Rakshandahas earned the badge Easy talker
LauraWyckoffhas earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded