Discussion Forums

Hi, in AR Clerk default dashboard, there is a DSO (Days Sales Outstanding). Its purpose is to understand how long it takes in average for customers pay their outstanding.On the other side, there is a default AP Clerk dashboard but I can’t find its equivalent which should be the DPO (Days Payables Outstanding). I understand AR Clerk displays something actionable, but it would be good to maintain good vendor relationship as well by understanding how long in average does it take to pay the suppliers. Has anyone built a GI for this? I am unable to find the equivalent/appropriate tables for this. Thank you in advance!

We are using Acumatica 2025 R2 and the contract-based REST API.We created a custom endpoint exposing:Shipment → ShipmentDetail → AllocationsWe need to split one component of a non-stock kit across two warehouse locations while keeping everything on one shipment line.Example:Shipment line: KIT-001, Shipped Qty. 2 COMPONENT-A requirement: 4 units at BIN-A COMPONENT-B requirement: 2 units at BIN-BDesired result:COMPONENT-A: 2 units at BIN-A and 2 units at BIN-C COMPONENT-B: 2 units at BIN-B, either as one allocation or two allocations of 1 each Kit shipment line remains at Shipped Qty. 2The equivalent operation works manually on the Shipments screen.Non-kit control testUsing the custom endpoint, we successfully split a regular stock-item shipment line by:Reducing the existing allocation quantity. Inserting a second allocation. Updating the newly assigned SplitLineNbr to the desired location in a second PUT.The request uses:PUT /entity/WMS/24.200.001/Shipment?$expand=ShipmentDetail/Allocat

The PO receipt screen used to show the $ of the receipt so our purchaser could verify both $ and qty.  Now only the qty is there.  Why was the $ removed and can it be included again?

Hi, I created a GI to show approval maps (XML attached). How do I set the sorting of Steps and Rules in ascending? Note that sorting of Rule description to ‘ascending’ won’t work. Also, how do I show the Entity and Field name from schema instead of DAC name?Approval Maps Steps and RulesShowing DAC name instead of SchemaSchema name 

Hello,We recently encountered an issue where production order variances are being attributed to the incorrect branch. Our current set up is a two tenant, two branch instance.Our production orders for both sites are manually closed by a site admin, who has a profile at one branch but not both. In this case, the work order variances are being attributed to the branch the site admin’s profile belongs to. I’ve checked the warehouse profile and there are no GL accounts populated at all throughout the list. I guess the question is, will the user’s profile who is manually closing the orders play a role in determining what branch the variances are posted to? Especially if the warehouse profile GL accounts aren’t set up. 

Wrapping up Chart-of-Accounts design on a 2026 R1 build (clean-slate migration off a legacy ERP whose chart had grown past 400 accounts) and would like outside eyes on the overall shape before we lock the sub-account segment layout — that part is effectively set-once (segments can be appended later but not removed, reordered, or shortened). Company profile: single CAD legal entity, USD as a meaningful secondary transaction currency, ~15–20 ERP users, business mix of distribution + light assembly + full manufacturing across roughly 7–8 product families. Chart: 55 GL accounts total (roughly 14 Asset / 9 Liability / 4 Equity / 2 Revenue / 10 COGS / 8 Operating Expense / 7 Other Income-Expense / 1 Income Tax). Design philosophy throughout: push repeatable detail into a sub-account dimension or the relevant sub-ledger module rather than adding GL accounts — e.g. Fixed Asset CCA classes live in the FA module per-asset rather than as separate GL lines; product-family detail on COGS/Revenue li

Hi All, we have an old setup of 20231R1 which is highly customised with lots of GI’s, business events  and APIs and due to our heavy usage we have a lot of performance issues and bugs.  Recently we have decided with the help from MYOB Support to upgrade in the coming months straight from 2023R1 to 2026R1 sequentially.  My concern here is, how can I make sure each of our customisation will work and not break.  Or has anyone done this and face any major dramas between the  version which they then had to change their customisation?  One thing I have already pickup is the API authentication protocol between the two version is big reduced as 2026R1 does not support URL encoded anymore.

Hello everyone, so one of my clients they have transactions using other currency. We already set up module currency management, rate transaction, etc, but why there is no menu for Financials Statement or budget report using other currency. Do we need to add customization report in Acumatica to display the menu?Our base currency is IDR and the other currency we want to added for the report is USD.Please help me to solve this, I really appreciate, thank you. 

I did have an import scenario that worked and then the upgrade to 2026 R1 appears to have broken it. 

26R1 25R2  Does anyone else also have this issue, I can’t export/import approval maps in 26R1    

Hello Everyone, I recently stumbled onto the requirement of injecting current user data into HTML to render it as an iframe within the Modern UI. It took me a while (and some AI assistance) to get there so I thought I would share the approach I took. Firstly, in the Classic UI, you can do this via the PageLoad event in the .aspx.cs file. The easiest way that I found with the Modern UI was to have a custom .ashx IHttpHandler in /Frames and which is called via fetch() within the activate() method that Aurelia uses. TS:export class CO301000 extends PXScreen { MasterView = createSingle(MasterViewClass); iframeSrc: string = "about:blank"; async activate(): Promise<void> { const app = window.location.pathname.split("/").filter(Boolean)[0]; const siteRoot = window.location.origin + (app ? "/" + app : ""); const userUrl = siteRoot + "/Frames/User.ashx"; try { const res = await fetch(userUrl); const [username] = await res.text(); if (!username) { console.error("Username

I got notified I have a private message on this forum but when I try to go in my private messages, even the old messages are gone.  Is it my account or someone else has experienced and know how to fix it?  This is kind of funny in a way :)​@Chris Hackett , something you can help with?

Hi All, we have our inhouse application integrated via API to  MYOB Acumatica where we create customer payment method and MYOB returns a GUID for each payment method.  I am trying to find out is it possible to display this GUID in a GI screen with MYOB user interface all?  If so, which table and column I need to integrate.  Is this explained somewhere, appreciate the help in advance.

Anyone that uses Rental360, can anyone tell me what “enable rental corrections” entails? What part is it referring to for corrections?  

Hi everyone,I'm working on a printing workflow in Acumatica and I'm trying to make it a little more reliable.Before sending an invoice or report to a printer, I'd like to have a quick way to confirm that the printer is actually producing good output. Checking whether the printer is online isn't always enough, since a printer can accept a job while still having issues such as faded text, missing colors, streaks, or alignment problems.For example, if a printer has recently had an ink or toner change, paper jam, or maintenance, I'd prefer to run a simple test print first rather than discovering the problem after several Acumatica documents have already been printed.Does anyone here use a printer test or verification step before running important Acumatica print jobs?I'm particularly interested in whether people rely on DeviceHub/printer status alone, or whether you also use a physical test page to check the actual output.What has worked well for you without adding too much extra work to t

We created a system email account for the user.We assigned it to the user on the Email Accounts Screen as shown. The reply address was populated as well on this screen.When I log in as this user, and email a sales order, PO, etc.  the email says it is from the default email account in email preferences.  We want it to say it was emailed from this user’s email address. 

I’ve been asked to provide a sidepanel on a few screens that will display the Remit To address of the vendor on the current screen.  That part is pretty easy and I’ve already provided that to the users.But the sidepanel is displaying the results of a GI (the Sidepanel technically points to a Dashboard that has a Data Table widget on it that displays the GI results).  The results are displayed horizontally, and since it’s displaying 5 fields, the results are kinda squished.  I’d love to display the results vertically, like:Addr 1: 123 Main StreetAddr 2: Box 17City:  AnytownState: PAPostal Code: 12345I’ve tried a pivot table but that’s not really what pivot tables are designed for.The only solution I can think of is developing a custom form screen and tying the sidepanel to that.  That kind of form screen is pretty simple...but I feel like I’m going down a rabbit hole for something that doesn’t justify that much work.

 Hi Team,I have a requirement on the Cases screen where I added a custom Date field. I want to apply conditional formatting to this field:If the custom date is greater than the Reported Date, the field should appear Red.  Else, it should be Green.The below JavaScript runs, but it always goes to the else condition and never enters the if.<script type="text/javascript"> function highlightWarrantyDate() { // Get values from fields by their IDs var reportedDateField = document.getElementById("ctl00_phF_form_t0_edReportedOnDateTime_text"); var warrantyDateField = document.getElementById("ctl00_phF_form_t0_NAWPREM03edUsrNAWPMWarrantyExpirationDate_text"); if (reportedDateField && warrantyDateField) { var reportedDate = new Date(reportedDateField.value); var warrantyDate = new Date(warrantyDateField.value); if (reportedDate > warrantyDate) { // Expired => Red background warrantyDa

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  Community Webinar - Capturing Signatures Inside Acumatica Mobile App. & Using Acumatica Community - Tue, Aug 25, 9:00 AM - 10:00 AM (PDT)Register HERE Rohit Rattan - Acumatica Community Featured Member for August 2026Meet Rohit Rattan our Acumatica Community Featured Member for August 2026. It’s great to have you as part of the Acumatica Community ​@RohitRattan88! Acumatica User GroupsSome new virtual groups: Construction Customer User Group, Distribution Customer User Group, Food Distribution Customer User Group, Nonprofit Customer User Group Join today!All Acumatica User Groups  How to Answer Questions on Acumatica Community - We need everyone’s help!Active Parti

Hello all,How can one create task situated under Activities tab in PM301000. I came across Task templates screen, so I mapped the values and then setup the biz event that should be triggered when the Project status changes to Active. But it is not firing off. Can anyone guide me on this?

On the customer statement you see the invoices, and a total, and if a payment was applied the total is decreased, but the payment is not listed.  Is there a way to expose/show/display the payments that took place in the statement period? 

The system was unable to connect to RabbitMQ on the current server. Try the Connect to an existing RabbitMQ instance option; thesystem will attempt to connect using the connection settings you provide.

I have tried all the possible ways to implement the Barcode or QR code it is working fine in Classic UI Modern UI Not-It is for Sales Order ScreenMy HTML code<template modify="#form-Order">    <field name="UsrQRCodeBase" unbound="" replace-content="">        <div class="v-stack col-12" style="align-items: center; justify-content: center; padding: 10px 0;">            <!-- Clean label element matching modern framework styling -->            <qp-label caption="Scan to Capture" style="font-weight: 600; margin-bottom: 8px;"></qp-label>            <!-- Standard HTML layout image container that natively decodes the Base64 variable -->            <img src="data:image/png;base64,{{Document.UsrQRCodeBase}}"                 alt="Sales Order QR Code"                 style="width: 160px; height: 160px; border: 1px solid var(--qp-border-color, #e0e0e0); border-radius: 4px; background-color: #ffffff; box-shadow: 0 1px 3px rgba(0,0,0,0.05);" />        &

How can I create/add a select all box on CST.PR.50.30.00 Create Liability Bills screen? Right now I can only select one screen at a time. I want to be able to check all boxes before I process anything. I need to know the total that I am selecting and cannot just click “Process All.”

Hi All,Has anyone here every used acumatica to track a rebate program with a customer and be able to generate a quarterly report to track it?  I want to track all their sales for a certain time period then calculate it in total and be able to use that rebate as a "credit" on future purchases by that customer.  Also it will be a fixed percentage of all sales