Discussion Forums

We have a regular business need for barcode images (JPGs) of arbitrary lists of items for use on promotional and other sales materials. It could be up to a thousand items so the ability to mass-process is a must. It seemed silly to me to license additional software just for this when we already are printing barcodes internally on reports like the pick list. So I devised a report which gets as close as can be - it still relies on external software like Adobe Acrobat Pro or PDF24 to convert the PDF into images. It uses some clever page setup and join tricks, so I thought I’d share. Piece 1: Page SetupExported PDFs don’t have individual images embedded and the images don’t export to Excel. The PDF → Image converters can split the document by page, so the goal is to have one barcode per page. A page break after the detail section easily accomplishes this. To save on further processing, I also wanted the page to be exactly what was needed for our materials, that being just a thin strip of b

I am trying to set up overdue charges in Acumatica. We want the charge to be per invoice.I have our test account set up to apply overdue charges: Their customer class also has overdue charges applied: And the test invoices have overdue charges applied as well: When I calculate and generate the invoice for the overdue fee, it has a fee for each overdue invoice, as well as the “Contractor Overdue” fee:How can I set this up so that only the invoice fees appear on the Overdue fee invoice?The logical fix is to uncheck “apply overdue” on the Customer Class page and the individual Customer page, but when I do that, nothing populates during the “Calculate” function on the AR507000 page.

 GIDate MM/DD/YYExport ScenarioExport Scenario Date format is adding time. I want it in date in MM/DD/YYYY 

In a new 26 R1 instance, screens in /src/development using qp-include do not build the included elements.I’ve spent 4-6 hours racking my brain attempting to figure out what’s wrong. Here it is:It's a bug in the Acumatica build-tools package — specifically in extractScreenNameFromHTMLFile in utils.js.The guard clause at line 78 blocks development paths:function extractScreenNameFromHTMLFile(rootContext, resourcePath) { const filePath = resourcePath; const fileData = path.parse(filePath); const screensPath = path.join(rootContext, SRC_DIR, SCREENS_DIR); const screensCustomizationPath = path.join(rootContext, SRC_DIR, SCREENS_CUSTOMIZATION_DIR); const systemScreensPath = path.join(rootContext, SRC_DIR, SYSTEM_SCREENS_DIR); // ← This guard only allows src/screens, src/customizationScreens, src/systemScreens if (!fileData.dir.startsWith(screensPath) && !fileData.dir.startsWith(screensCustomizationPath) && fileData.dir !== systemScreensPath) return

Hi!  We have 3 different translation IDs set up so we can translate our foreign entities (GBP, HKD, and CNY) into our main reporting currency (USD).  We occasionally run into an error when preparing the translations that is intermittent.  Anyone have any thoughts on what’s causing this, especially with it being inconsistent in occurrence? I have confirmed that we have translation loss and gain accounts and subaccounts set for USD within Currency Management > Currencies.One of my employees had this error yesterday when trying to translate our GBP branch into USD, but was able to do the translation this morning.  We’re both now receiving this error when trying to translate our HKD branch into USD.  This doesn’t happen every month when we do this and usually goes away the next day, so it’s not critical since it appears to resolve itself; it’s more of an annoyance than anything else.  Thanks in advance for your thoughts!

 I am currently building a Generic Inquiry to identify valid Purchase Receipts that require an AP Bill. The logic is that if a receipt has no corresponding AP Bill, it should then check whether there is a related Purchase Return; otherwise, it is considered valid and requires an AP Bill but I seem to be getting a duplicate. Any insight as to how to make it efficient? Sharing my GI. Thank you for your time in looking.  

Hi, In the project record, I configured the Project Group with the intention of limiting visibility so that not all users with project access can see the project records. Specifically, each project manager has their own group, and only members of that group—such as the project administrator and coordinator—are allowed to view their respective projects.Additionally, I enabled the Restrict to Employees option for the foreman role. and set up their name under the Employees tab. Please note that foremen do not have access to the project record itself. The purpose of this setting is to ensure that foremen can only select projects in the Daily Field Report (DFR) that are assigned to them.Based on my understanding:Project Access controls visibility and access to the project record. Restrict to Employees controls access related to time activities (e.g., DFR and timecard entry).However, based on my testing, when Project Access settings are enabled, the Restrict to Employees functionality does n

Has anyone experienced this issue with Field Service billing? Could stale posting records, posting batches, or a known Field Service bug cause this error?Any suggestions on additional tables, posting records, or diagnostics to review would be appreciated.

We want to clear out our purchase accrual report of outdated Purchase Receipts and Purchase Receipt Returns that have no Bills or Debit Adjustments against them.  We are creating Bills and Debit Adjustments using an import scenario for these outstanding lines, however, the unit cost on each line must be updated to 0.  The documents will have a total of 0.00.  That’s the tricky part, particularly for Debit Adjustments, because you don’t have the option on that screen to pull in purchase receipt lines one by one there, only entire purchase receipts, which brings in e.g. 6 lines at a time.  How do you “go back” in an import scenario to update each line to 0, one by one?  @@inventoryID is not a solution because in some cases, the same non-stock code is repeatedly used.  I have attached the XML, also including some inactive lines where I tested doing this by Purchase Receipt Line (it works for Bills but not Debit Adj.).

Does someone know if Acumatica is planning something to handle the catch-up contributions for 2026? Standard contributions will be pre-tax, and catch-up will be taxable. Thanks,  Andres  The 401(k) employee contribution limit for 2026 is $24,500, with catch-up contributions of $8,000 for ages 50–59 and $11,250 for ages 60–63.Standard Contribution LimitsFor 2026, the maximum employee deferral to a 401(k), 403(b), or 457(b) plan is $24,500, up from $23,500 in 2025 (IRS Notice 2025-67). This limit applies to the combined total of traditional pre-tax and Roth 401(k) contributions.  IRS+2Catch-Up ContributionsAges 50–59: Eligible to contribute an additional $8,000, bringing the total possible contribution to $32,500.    3 Ages 60–63: Under the SECURE 2.0 “super catch-up” provision, participants can contribute an additional $11,250, for a total of $35,750 if their plan allows.    3 Starting in 2026, catch-up contributions for employees aged 50+ who earned more than $150,000 in FICA wages in

Hi there, Wondering if anyone has any experience doing bulk asset transfers between companies. For example, the current Transfer Assets screen (FA507000) only allows the transfer between branches or departments of the same company: Instead, I’d like to transfer between two companies, e.g. ABRVL to ABSLL, and for multiple assets at a time. My only thoughts on this would be to either:For single transfers, dispose of and then bring back the asset (at NBV) to the new Company (very cumbersome) In the case of multiple transfers, do the above one-by-one, or create a negative asset in the source company and then create a positive asset in the new company (looses asset information granularity, must be same asset class and depreciation %)More often than not, we will be transferring multiple assets at a time. Additionally, given the number of moving parts for Fixed Assets, I was keen to hear from the community on the best practice. Thanks very much. 

I’ve generated my T5018 efile and while reviewing it there is a vendor who shouldn’t be on the report as they only supply materials.  I’ve reviewed their vendor record and confirmed that they are set up as “none” under CRA Reporting Type.  Is there any where else that I should be looking?

I wanted to take a minute to share this with the community. If you have the following feature enabled on Microsoft Edge, it breaks the ability for Acumatica to export to excel ( the little excel buttons on every grid in the system ) if you are using Modern UI. Disable it and you can export to excel again.  

Using Acupay in 25R2, we are able to get the payment links to create and show up on the standard sales Order invoice but when generating a Prepayment Invoice, there is no payment link tab on the record and it is not showing up on the Prepayment Invoice.  Does the payment link not work with Prepayments or am I missing some configuration or checkbox?

Hello all,I’ve created a GI on a tenant with the Modern UI, and I’ve created a pivot.How can I transfer the GI and pivot to another tenant?I’ve tried: Customization Package - just packs the GI without the pivot. Export the GI to XML - again, doesn’t pack the pivot. Looked at the GI code - can’t see anything about a pivot view.I don’t understand, you can pack a filter into a customization but you cannot pack a pivot view. Thanks,Ewan.  

Hello,Attempting to update item classes via Import Scenario.This requires answering the following dialog: The import scenario is having trouble answering the dialog  Any of the selected ‘Dialog Answer’ Screen fields results in the same error where the dialog is not being answered successfully.  Does anyone know exactly which ‘Dialog Answer’ to select here: I have seen other threads discussing this but not on 2025R2 Modern UI which changes how fields are selected in the Import Scenario. Thank you!!!

Hello,We are using Acumatica to manage VAT on payment / cash-basis VAT.Our requirement is to recognize or track VAT on payment, especially through the screen TX503500 – Recognize Input VAT, but without generating additional GL transactions.This is a one-time / temporary requirement, only until December 2025. Starting from January 2026, we would like to return to the standard Acumatica behavior, including the normal generation of GL transactions related to VAT recognition.From our understanding, the standard VAT recognition process generates GL entries to reclass VAT from suspended VAT to recognized VAT. However, during this transition period, we only want to track or report this information for tax / reporting purposes, without any additional accounting impact.Is this possible in standard Acumatica?If yes, how can we configure it or handle it correctly?Thank you in advance for your feedback and recommendations.Best regards,

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);" />        &

I'm trying to dynamically change the display name of a DAC extension field based on another field value in the same extension, but PXUIFieldAttribute.SetDisplayName() does not update the UI even though the code executes.DAC Extension:public class LocationExt : PXCacheExtension<PX.Objects.CR.Standalone.Location>{ #region UsrGSTRegistration [PXDBString(16)] [PXUIField(DisplayName = "GST Registration")] public virtual string UsrGSTRegistration { get; set; } public abstract class usrGSTRegistration : PX.Data.BQL.BqlString.Field<usrGSTRegistration> { } #endregion}Inside RowSelected:PXUIFieldAttribute.SetDisplayName<LocationExt.usrGSTRegistration>( e.Cache, displayName);The code compiles correctly, the event hits during debugging, and displayName gets the expected value — but the label in the UI does not change.As a workaround suggested in another post in this community, I tried creating an unbound field to act as a dynamic label:#region UsrRe

From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly?  Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious?  Appreciate any insight others have in this area   

If you are in the prepare replenishment screen a line item will not show up as Qty on Supply if an SO is linked to a PO for that item.In my case I link SO transfers to PO’s for all or some of items I know will have to be shipped to our satellite offices once it comes in. The problem comes in if you were to check the Prepare Replenishment after that, it does not show any of that item as Qty on Supply or at least until the SO is posted.To me it seems logical that the Prepare Replenishment should still show an item as having a Qty on Supply even if there is an SO for that item.If this topic has already been discussed let me know and I will check it out.

Hello, i am trying to adjust in a part, which is not set as serial tracking..when I adjust in as inventory count reason, it asked me for receipt nbr.. can someone shed some sort of light please?Thank you Zoey 

I’m attempting to display an image from the currently selected detail line, beside the grid, and I cannot get it to work without database manipulation.The detail lines are a custom Photo record that have some details about the photo, and an image uploader shown in the element below. All on a simple form. This custom photo record is working as expected.<div id="divColumnC-Img" slot="B"> <qp-image-uploader id="ImageUrl" state.bind="Photo.ImgUrl" width="100%" height="100%" caption="Image"> </qp-image-uploader></div> Now, beside this other grid, I want to display the photo from the currently selected line. See below. However, it doesn’t load the image, and when I open developer tools I see this message on the console.“app.ts:222  GET http://localhost/<SiteName>/Shedworks%20Photo%20(PHO-00009110)/login_bg3.jpg 404 (Not Found)”qp-image-view element with the system generated value as the Image Url in the databaseHere’s that image viewer element. <div id="divCo

I’ve created a variable to sum the total amount shipped of an item during a specific time period.  However, if zero of this item are shipped, the variable is blank, instead of outputting 0.  Can someone review my code and hopefully point out what I have been overlooking? Many thanks in advance. =IIF($DateDiff > 2,CInt(SUM(IIF([SOShipment.ShipDate] >= CDate(CStr(Month(DateAdd(@EndDate,'m',-2))) + '/1/' + CStr(Year(DateAdd(@EndDate,'m',-2)))) AND [SOShipment.ShipDate] <= @EndDate,[SOShipLineSplit.Qty],0))),0)

Version 25R1I am trying the set access rights for a specific role for File MaintenanceThe primary goal is to limit ability to Add fileAt System Management level the access right for role is Multiple RightsAt File Maintenance  level the access right for role is EditUser with role can still addWhat is wrong here ?Should access rights for File Maintenance work the same as other data screens?