Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Hello, Does anyone know how to convert a decimal values to inches in report designer?Example: Customer orders 12.50 feet in ACU on the sales order screen but want the value displayed on the report as 12ft 6inches. Thanks

11 minutes ago

bwhite49Captain II

Low Code | No Code Customizations or Integrations

Workflow Editor Production Order Maintenance Screen "Unknown Status"

Anybody familiar with this error? I added 3 statuses before planned status on the production order maintenance screen through the workflow editor (no code).Everything works well except I can’t delete the production order when in one of the 3 newly created statuses as well as the events table does not populate with order changes. Trying to delete presents the error in the screenshot below. When moving from “On Hold” status to one of these new statuses the events table states that the order moved from “On Hold” to “Unknown” rather than “On Hold” to “Initialized.”Anybody know how to fix this “Unknown Status” issue?

41 minutes ago

jennifer39Freshman I

Distribution

How to hide tenants dropdown list from customer portal?

Hello Everyone, Please advise on how to hide the list of other tenants from the customer portal login screen?Thank you,Jennifer

8 minutes ago

ronVarsity I

Develop Customizations

Modern UI customization Publication

I get this error when I am trying to add files on customization project and publish it.I am able to run npm run build-dev it gives no error. But if i run just npm run build it gives this error

215

2 hours ago

eucciferri35Jr Varsity III

Import and Export Scenarios

Is there a way to limit access in import scenarios to just one specific import scenario?

I created a generic inquiry that pulls data from the Purchase order module. I pull that data into excel and use with an import scenario to create records in the equipment module.Now that the report is created and import scenario is mapped and setup, I would like to have another dept at the company do the import monthly but I am concerned about giving them full access to the import scenarios. Is there a way to limit access so they can run this one scenario but not have access to others?

2 hours ago

adaughenbaugh95Jr Varsity II

Manufacturing

Inventory Item Configurator

Before I recreate the wheel, does anyone have anything like this?We have a lot of variables in our product lines. When customers request a new Length/Width/Material/etc we have to create a new Stock Item, Build a BOM, etc.Right now, we have ~5 spreadsheets with our product lines that have to be maintained to provide a quote for the customer. This is also sent to the Product Manager to build the Item and BOM.I want to build a New Item page that would have variables depending on Product Type, in which certain dropdowns would be available or options in those dropdowns would be selectable. Based on those parameters selected, it could build the Inventory Item, BOM, and provide a more accurate Quote.

3 hours ago

alexgillespie61Freshman I

Reports and Generic Inquires

APPayment ExtRefNbr field not populating in GI

Hello,I am trying to create a GI to show payment information (primarily the payment/ACH number and payment date) for a Purchase Order. The problem I am running into is that when adding the Payment Ref field from the Checks and Payments screen (which appears to be the ExtRefNbr field from APPayment), it does not return a value in the GI. I am posting here to see if this is a known issue with a workaround or if I am just missing something in the setup of the GI itself. This is my first community post, so apologies in advance if I left out any important information. Thanks!

155

22 minutes ago

premalathan35Freshman I

Develop Customizations

Issue with Custom Screens Not Rendering in Modern UI (25 R1)

Hi,I am working with a 25 R1 site that was originally created using 24 R2 and later upgraded to 25 R1. The site includes several customizations, including enhancements to base screens and the development of new custom screens.After configuring the necessary Modern UI settings in the web.config and site map, the standard base screens are correctly displaying in the Modern UI. However, the customized base screens and newly developed screens are not rendering in the Modern UI as expected.I have used the built-in converter and followed all the recommended steps for the transition. Below are sample .html and .ts files from a very simple screen that I have converted.WS101001.html<template> <qp-grid id="FreightForwarder_grid" view.bind="FreightForwarder"></qp-grid> </template> WS101001.tsimport { Messages as SysMessages } from "client-controls/services/messages";import { createCollection, createSingle, PXScreen, graphInfo, PXActionState, viewInfo, handleEvent, Custo

307

19 minutes ago

marcandrematteFreshman II

Construction

Link request to Purchase order, and purchase order from blank PO

Hi We would like to know how to business manages with Blank PO, Essentially we would like to have a lean process of which everyone goes througe a request process, and then it is the purchasing department that manages the rest. In certain cases, there are blank PO that are arranged with certain supplyers. What i would like to know is from the request, is there a way to link that request line to a blank PO Line, to it would deduct the total quantityfrom the blank PO. The inly way i have found for now is that from the request, i would have a quantity with a price of 1$. We thansform the request to a purchase requsition, and then a purchase order. From that order, we put the item price at 0 so there is no cost involved in that line transaction, and then in the same PO, in add the blank PO Line, and input the same quantity as the Request line, but at a 1$ unit price. This gives me the final amount identical from the request, and the “infant” PO is still attached to the request (so i have a

4 hours ago

jkoster

Construction

Acumatcia Project Accounting

Mid-market Commercial Construction company new to Acumatica - Live 1/1/25. 1 Entity with 7 Branches. We are struggling a bit in learning Acumatica and recovering some operating efficiencies, particularly in project accounting - budgeting - subcontracting workflows- and accounts payable management. Interested in a connection-conversation with a construction company a little further down the road using Acumatica Construction Edition happily and successfuly to manage project finance, or those who have been down our path and done something different for project accounting (Procore Integration?)

5 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2447 topics

Distribution

2336 topics

Manufacturing

860 topics

Construction

819 topics

CRM

279 topics

Field Service

375 topics

Retail

557 topics

Payroll

267 topics

Professional Services

16 topics

Low Code | No Code Customizations or Integrations

400 topics

Develop Customizations

3220 topics

Develop Integrations with Web Services | APIs

826 topics

ISV Solutions

147 topics

Configuration and Installation

1018 topics

Reports and Generic Inquires

2446 topics

Import and Export Scenarios

924 topics

System Health and Performance

164 topics

Community site discussions

353 topics

Community Introductions

99 topics

Everything Else

970 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

142 topics

Events & Meet-ups

154 topics

Developer Newsletter

19 topics

56 topics

etrojan28Varsity I

Reports and Generic Inquires

Converting decimal to inches

11 minutes ago

bwhite49Captain II

Low Code | No Code Customizations or Integrations

Workflow Editor Production Order Maintenance Screen "Unknown Status"

41 minutes ago

jennifer39Freshman I

Distribution

How to hide tenants dropdown list from customer portal?

Hello Everyone, Please advise on how to hide the list of other tenants from the customer portal login screen?Thank you,Jennifer

8 minutes ago

eucciferri35Jr Varsity III

Import and Export Scenarios

Is there a way to limit access in import scenarios to just one specific import scenario?

2 hours ago

adaughenbaugh95Jr Varsity II

Manufacturing

Inventory Item Configurator

3 hours ago

alexgillespie61Freshman I

Reports and Generic Inquires

APPayment ExtRefNbr field not populating in GI

155

22 minutes ago

premalathan35Freshman I

Develop Customizations

Issue with Custom Screens Not Rendering in Modern UI (25 R1)

307

19 minutes ago

marcandrematteFreshman II

Construction

Link request to Purchase order, and purchase order from blank PO

4 hours ago

apallawala21Jr Varsity II

Distribution

Extend Customers as company

Hello! We have created few customers, and we have created transactions against these customers as well. But now we are required to establish these customer IDs as companies. We want to have the same ID for both Customer, Company and in created transactions. Is there any way of doing this? Best Regards Amanda

5 hours ago

lucasdnd

Import and Export Scenarios

Using InvoiceNbr as a Unique Key in Customer Invoice Import Scenario

Hi everyone,I'm working on a customer invoice import scenario, and I’d like to know if it’s possible to use the "InvoiceNbr" field as a unique key to identify invoices.At the same time, I would like to keep the automatic numbering for the RefNbr field, and use InvoiceNbr to detect duplicates too.Ideally, if an invoice with the same InvoiceNbr already exists in the system, the import scenario should raise an error and prevent the duplicate from being imported.how can it be configured?

161

6 hours ago

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! April, 2025

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

Ankita Tayanahas earned the badge Financials expert
ranjithduraisamy72has earned the badge Manufacturing expert

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