Discussion Forums

I have received some requirements from users. They want to display a QR code payment image that is generated as a base64-encoded PNG from an external API.I need to show this base64 image on an Acumatica form. Once the user scans the QR code and completes the payment, we will receive a response from the API and continue with the next process.Please guide me on how to display a dynamic base64 image in Acumatica 2025 R2, for both the Classic UI and the Modern UI.

Hi , In GL Module the tran description has 256 Characters where in Fixed asset Module in it 512 Characters so could you please validate and add the point

I’m experimenting with getting Acumatica running under Ubuntu Linux using Mono on my portable Linux server. I have ASP.NET working with Apache and the few test .aspx and .cs programs working. I’m currently working my way through the web.config file translating Windows paths to Linux paths. I noticed that Node.js-win is installed under WIndows. My understanding this is used for the Modern UI which isn’t a focus for me right now. Is there any additional Node.js packages used by Acumatica beside the base install that Acumatica checks for even if I don’t have the Modern UI enabled?I’m hoping the Acumatica developer team that may be lurking here on the forum can respond to my above questions.My NpmCache doesn’t show any files for the tenant I’m converting nor can NPM be found or used from PowerShell. My assumption at this point installing Node.js v22.19.0 is all that is needed.   

One of our clients recently went live on Acumatica and are struggling with easily logging time against multiple production orders at once. They are on 22.212.0046. The Multiple Clock Entry screen gets them close to what they need, but isn’t efficient for their shop floor team at all. They need to be able to select all production orders that are associated with a single sales order, clock into a work center, and then clock out of that work center. Ideally this could be done on the mobile app and via scanning, but that’s not supported. I tried exposing the Multiple Clock Entry screen on mobile but could not get it to be selectable when trying to add to a mobile workspace. (is there a step I’m missing here, or is this screen not supported on mobile?) With the browser interface, they can use column filters to select only the sales order and only the work centers they need, but they would still have to individually select all the lines to clock into -- there should be a “select all” option

Hi everyone,I'm looking for guidance on syncing color information from Acumatica to Shopify using the native Shopify Connector on 2026 R1.The requirementIn Acumatica, product color is stored as a descriptive name. On the Shopify side we're populating a Color metafield, which expects a hexadecimal value rather than the name:Black → #000000 White → #FFFFFF Smoke → #808080 Dark Smoke → #4A4A4AWhat I've triedCreated a Substitution List mapping the Acumatica color names to their hex values, and referenced it in the Shopify Entity Mapping. The substitution was not applied and no hex value was exported. Changed the Acumatica color field to store the hex value directly (for example, #000000) and re-synced the product. The Shopify color metafield still was not populated. Tried the following expression in the entity mapping: =SubstituteListed([shopify.color-pattern], 'Metacolor') — the expression editor returns an error that the function is undefined.My questionsIs there a supported way to trans

 Hi Everyone,I'm facing an issue with barcode scanning in Acumatica 2026 R1 and would appreciate any guidance.I have created a report that prints a Code128 barcode using the standard PictureBox barcode control.Current barcode settings:Source: Barcode Barcode Type: Code128 Value: =Trim([INLocation.LocationCD]) (also tested with LocationID) BarHeight: 1000 BarWidth: 10 WidthRatio: 3The barcode prints correctly and the human-readable text is displayed below it.However, when I try to scan the printed barcode using the Acumatica Mobile App, nothing happens—the app does not detect the barcode at all.To isolate the issue, I generated the same barcode using the TEC-IT online barcode generator with the same value (e.g., PACKING-AR), and the Acumatica Mobile App scans it successfully. This suggests the mobile app is working correctly and the issue is related to the barcode generated by the report.Has anyone experienced a similar issue?

Hi, How to delete UnAssigned Locations lines in Inventory Summary. In Inventory Summary data is not saving through direct tables.Can anyone Suggest me how to delete UnAssigned Location from Inventory Summary.Thanks,Giri.

Hi,I have a requirement to configure an approval rule so that AP Bills are routed for approval when the vendor is an employee.This is only one of several approval rules in our workflow, so hardcoding vendor IDs is not a feasible solution, as employees may change over time. Is there a standard way to identify employee vendors within approval conditions so that the rule can be evaluated dynamically?Thank you!

Does Acumatica have a solution for tracking price/compare at price from Shopify on an order level?There are a number of reasons to use the ‘Compare At’ price function in Shopify. They can be utilized in more complex promos to avoid Shopify’s limited discount ‘slots’. They also offer a better customer experience with slashed pricing, an immediate view on the actual sales price, and no requirement to remember a code. The problem with this is that Acumatica is just receiving the price as compare at price so it doesn't look as if it has been discounted. E.g.Product X has a normal price of $50We use Shopify compare at functionality so that this now has an 'Is' price of $40 and a 'Was' price of $50 (which will shown a slashed pricing on the storefront).When this comes in to Acumatica the line item just shows a pricing of $40 but we want to be able to track the fact that this actually represents a $10 discount The compare at pricing isn't available through normal order JSON but is accessible

Wonder if anyone has started looking into the new Materials Management feature in the Construction edition and if so, any thoughts/feedback on it?It looks like it shows promise but we aren’t going to be using this in a typical construction scenario since we are focused on Custom Engineering projects and simpler/smaller types of transactions where we aren’t using hundreds of materials. Thank you.NOTE for Acumatica, please add a Tag for “Material Management” for posts.

I have an Acumatica instance with 16 tenants, and one of our requirements is to maintain a single set of supplier (vendor) master data that is shared across all tenants. The expectation is that a supplier and all its related information (locations, addresses, contacts, etc.) should be visible and remain consistent regardless of which tenant the user is working in.Our initial approach was to use Company Mask so that the supplier records could be shared across all tenants. This works well from a visibility perspective, but we have concerns about update operations.For example, assume the supplier record is physically owned by Tenant A (CompanyID = 2) and has a location with LocationID = 15. Because the record is shared using Company Mask, a user logged into Tenant B (CompanyID = 3) can open the supplier and edit the location details. However, when the update is performed, much of the Acumatica framework identifies records using the current tenant context together with the record key. Sinc

We are currently on 2022 R1, and plan on upgrading regularly. We were attempting to use Smartsheets for project management with Acumatica because of the built in integration. Smartsheets is no longer support, and was pretty far behind in capabilities. What project management programs integrate with Acumatica - we are Project Accounting only, NOT construction. Thanks!

Overview:In Acumatica, the standard behavior calculates and records Withholding Tax at the time of payment. However, for compliance with local statutory requirements (e.g., India), we are exploring whether it is possible to calculate and post Withholding Tax at the bill creation stage instead.Current System Behavior in Acumatica1. Bill Creation (No WHT Yet) Account Debit (Dr) Credit (Cr) Purchase/Expense A/c 100   Accounts Payable   100 2. Payment (WHT Applied) Account Debit (Dr) Credit (Cr) Accounts Payable 100   Withholding Tax Payable   1 Cash/Bank   99 Expected Behavior (Needed)1. Bill Creation (WHT Recorded Immediately) Account Debit (Dr) Credit (Cr) Purchase/Expense A/c 100   Withholding Tax Payable   1 Accounts Payable   99 2. Paymen

I'm building a Project Margin Summary Report in Acumatica 2026 R1.I have a Generic Inquiry that returns project task detail with estimated/actual labor, cost, revenue, profit, and margin.The remaining requirement is to reproduce our legacy management summary with these rows:Total Project  Process  Shop  Controls  Controls Labor  Controls Material The challenge is that a single task intentionally contributes to multiple rollups. For example:Task 815 contributes to:  Total Project  Controls  Controls Labor  Can this type of overlapping rollup be implemented entirely within a Generic Inquiry, or would Blytheco recommend another supported approach (such as Report Designer, an SQL view, a DAC projection, or another reporting method)?Our goal is to stay within supported Acumatica functionality and minimize future maintenance.

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Arpine Arzumanyan - Acumatica Community Featured Member for July 2026Meet Arpine Arzumanyan our Acumatica Community Featured Member for July 2026. It’s great to have you as part of the Acumatica Community ​@arpine08! Acumatica User GroupsNew! Special Interest Groups:  Food Distribution Customer User Group, Nonprofit Customer User Group, Industry Groups: Construction Customer User Group, Distribution Customer User Group Request to join today!All Acumatica User Groups How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and intere

Has anyone used a 3rd party product for AP automation? Companies like TRAILD, Tipalti, etc?We use the native AP “New Document Recognition”, but it is really klunky, and slow.  We have a ton of 3rd party Landed Costs and outbound freight.   We spend too much time processing these vendor invoices when they should simply just flow through the AP process. thank you.

Hi, can someone please help me how to create a selector with 2 (All records, project codes) tabs like this This screen is in the Daily Field Report y the tab Equipment in the coumn cost code I was looking on the internet but I did not find an example. Additional.My project is a customization. The Screen id of reference is: PJ304000Thank you very much I will appreciate any help

Hi Team, through testing, we've confirmed:Delegation only works if the delegate is already listed as an authorized approver (in the Approval Map or Workgroup) for that step. Delegating to someone outside the map/workgroup has no effect - they can't see or act on the item, even though the delegation is saved. If a person is already a listed approver/workgroup member, they can approve on a colleague's behalf regardless of whether delegation was set up at all - simply because they're already authorized. This raises the question: what scenario is Delegation actually solving, if a Workgroup member doesn't need to be delegated to act, and a non-Workgroup member can't act even if delegated?Is Delegation intended for a narrower use case - for example, routing to a specific single person outside the group (rather than "any workgroup member"), or perhaps intended for approval maps that use a single named Employee approver (not Workgroup-based) so there's normally no built-in backup? Any clarific

When a user is created manually on the Users screen, entering login ID directly, with Generate Password checked, linking to an employee, assigning roles, and saving, the welcome email fires immediately and is logged in Activities.When a user is created using the "Add Active Directory User" button, following the same subsequent steps (link employee, assign roles, save), the welcome email does not fire. Is this expected/documented behavior, i.e., is the welcome email trigger tied specifically to system-generated password creation (which AD-linked users never get, since they authenticate via AD)? Or is there a setting/condition we're missing that would allow the email to fire for AD-imported users as well?We'd like the same welcome notification to go out to AD-imported user.

We are newly using 2025R2 AP incoming document recognition.  Am curious from other users if/when it learns the repeat invoice(s)?  We are finding it is not learning at all.  Each time you are having to map the missing fields.  We are likely going to abandon soon.

Looking for options on how to handle this scenario. I need a way to send an attachment that is sitting on a purchase order when PO moves to open status. Any ideas on how to accomplish this?

Does anybody have an import scenario for the product configurator?

Hi all,I put together a small customization to make the **Sales Person** fieldrequired on the Sales Order Lines grid (SO301000), since our process needs asales person on every line for commission tracking. I figured I'd share ithere in case it's useful to someone else, and also because I'm still fairlynew to Acumatica customization and would love a sanity check from people withmore experience.The approach: since `SalesPersonID` already exists on `SOLine`, I used a`CacheAttached` handler with `PXMergeAttributes(Method = MergeMethod.Merge)`to add `Required = true` without redeclaring the field's other attributes,plus a `RowPersisting` handler to actually block the save (since `Required`alone only affects the UI).Full code + explanation here: https://github.com/i-wild/acumatica-sales-person-required```csharp[PXMergeAttributes(Method = MergeMethod.Merge)][PXUIField(DisplayName = "Sales Person", Required = true)]protected virtual void SOLine_SalesPersonID_CacheAttached(PXCache cache){}prote

I'm trying to make the Subaccount (SubID) field editable on the Journal Transactions screen (GL301000), regardless of the Batch Module (GL, AR, AP, etc.) or the Batch Status (Balanced, Released, etc.).My goal is to have the Subaccount field always enabled so that users can modify it.I first tried the following graph extension:using PX.Data;using PX.Objects.GL;namespace EnableSubaccount{ public class JournalEntry_Extension : PXGraphExtension<JournalEntry> { protected virtual void _(Events.RowSelected<GLTran> e, PXRowSelected del) { del?.Invoke(e.Cache, e.Args); if (e.Row == null) return; // Make the detail cache editable Base.GLTranModuleBatNbr.AllowUpdate = true; Base.GLTranModuleBatNbr.Cache.AllowUpdate = true; // Enable only the Subaccount field PXUIFieldAttribute.SetEnabled<GLTran.subID>( e.Cache, e.Row, true);

I’m going live on Acumatica 8/3 (leaving DDI after 20+ years). We're an inventory-based B2B wholesale distribution business with our own fleet of delivery trucks. Since it’s cloud-based, I’ve been eager to see how much functionality we can get out of the mobile app…….my preliminary evaluation of the app is that it seems to have limited transactional functionality, but I’m eager to hear from folks in the community (especially users with their own fleet of delivery vehicles) how they leverage the app. Can the native app be used by delivery drivers for proof of delivery purposes? Is there signature-capture functionality in the app? Thanks.mikeSanico