Discussion Forums

Hello All, I did a low code customization to add a couple of text fields to our Vendors Location that stores some sensitive information.   I have published the customization, but after doing some research I would like to change the Field to use the PXRSACryptString vs PXDBString Attribute.   Can I go into my customization package and update this attribute?   to[PXRSACryptString(255, IsUnicode = true)]and Republish with out any data loss or corruption? Also if i change the control TextMode to Password and Commit Changes to True will that mask the field on the UI and allow a user to click on it to reveal?  I think I need an event handler for this.  

Open the report that you need to modify in the Report Designer (see more about the report designer here https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/) Open File → Build Schema… menu and make sure the CCPayLink table is added to the report   Go to Relationships Tab and Left Join CCPayLink to ARInvoice or SOOrder based on PayLinkID   Add new Picture Box control to the report and configure it the following way: VisibleExpr: =[CCPayLink.Url]<>null BarcodeType: QRCod

I was hoping to add the ability to filter by SOLine.InventoryID_description in the Sales Order Details by Customer report, but for the life of me i can’t get this field as an option. Following what online tips i could find I added this field to the Viewer Fields in the schema browser. Then I also placed it in the groupDetails section on the report itself at another recommendation. Every other writeup i can find is either putting it in as a parameter or a sorting option, neither of which is what im looking for.End result, our staff wants to be able to sort this report by keywords in the item description. Sales Order Details by Inventory Item doesnt work for us in this case because its layout is item-first instead of customer-first.I have my fingers crossed this is something simple im just not seeing as i don’t spend alot of t

I know it’s early but thought I’d ask the question now… When the Acumatica AI Studio launches, will there be a new area in these forums for us to discuss and collaborate with others?

​Hi,I’m creating the payment programmatically but payment status is showing Pending Processing.Even tried setting the status to balanced and it didn't worked.Payment is captured in the External system so we are filling the ExtranalTrsnaction table and below is the code that we used create the payment. ARPaymentEntry docgraph = PXGraph.CreateInstance<ARPaymentEntry>();                ARPayment objPayment = new ARPayment();                objPayment.DocType = ARDocType.Payment;                objPayment.Status = ARDocStatus.Balanced;                objPayment.CustomerID = order.CustomerID;                objPayment.PaymentMethodID = filter?.PaymentMethod;               // objPayment.CuryID = order.CuryID;                objPayment.ExtRefNbr = filter?.PaymentRefNbr;

How do I limit a user’s access to just a specific branch?

How can we copy the OwnerID field from rhw sales order when creating a shipment in 2025 R2? In prior versions we were overriding the method SetShipmentFieldsFromOrder in SOShipmentEntry.  In 2025 R2 there is a new CreateShipmentExtension and it looks like the override may need to be moved to the method SetShipmentFieldsFromOrigDocument(SOShipment shipment, CreateShipmentArgs args, bool newlyCreated)?Below is our existing code.  It does not compile on 2025 R2 because the SetShipmentFieldsfromOrder method has been removed.   public class SOShipmentEntry2_Extension : PXGraphExtension<PX.Objects.SO.SOShipmentEntry> { [PXOverride] public virtual bool SetShipmentFieldsFromOrder( SOOrder order, SOShipment shipment, int? siteID, DateTime? shipDate, string operation, SOOrderTypeOperation orderOperation,

We’re in the setup phase of our implementation and working through our Safe Harbor match configuration.Our formula is: 100% match on the first 2% 50% match on the next 4% Total match not to exceed 6% of eligible compensation Some employees will elect a flat dollar contribution, and their weekly pay varies.Has anyone configured this type of Safe Harbor match where the employee deferral is a flat amount instead of a percentage? If so: How did you structure the deduction and match calculation? Did the system correctly calculate the tiered match each payroll based on that week’s eligible compensation? Any issues with caps or special scenarios we should plan for during setup? Appreciate any insight from those who’ve already been through this.

This new Update Vendor Payment Methods (AP507100) screen in Acumatica 2026 R1 looks really nice. It's a way to bulk update the payment method on open Accounts Payable bills.See screenshot below from my Acumatica 2026 R1 (26.093.0239) beta environment.BUT, I have to enable BILL Integration on the Enable/Disable Features (CS100000) screen for this new screen to appear in my environment.Does anyone know why this is only available to Bill.com customers? This seems like a useful screen that EVERYONE should be able to benefit from.  

Client is using AVALARA for sales tax and ECM. Avalara is telling the client that they need to upload all customers - it is my understanding that there is funcitonality to Manage Exempt Customers and add to Avalara.  We have the tax connector working for sales tax, however when we try to create a customer in ECM provider in Acuamtica, we get an error:  Company is not found.  The company with the ID ‘0’ was not found.  Anyone have insight into using ECM? Is the Tax Provider also used for ECM? There is no option to add a separate ECM Provider in Acumatica.They are logging in through a single account and have only one company.  Thanks!

Hello Community, I am working on a small customization to simply pull up the Stock Items screen in a side panel when changing the detail row. It seemed like I couldn’t accomplish this on the POLine level and only choose header fields when adding the side panel, so I went with an unbound field on POOrder. How can I make it when changing the detail selection to successfully update the unbound field “Selected Item” below? You’ll notice I have the side panel popped up and open to the PNF item, but I have the EMP item selected. Any ideas? I did try forcing a “Note” update on change to refresh UI, but no luck. It does update by changing the side panel to something else and then back to stock item. See below for my code and screenshot: #region UsrReadInventoryNbr [PXString(60)]

Hello,We've added a new screen that displays the UserReportEx DAC in a table and created an action to move reports (with a specific checkbox selected) to another tenant on the same instance. For example, reports SO641010 and SO642000 are currently in Tenant A, and we want to move them to Tenant B.We discovered that the Report Designer uses the ServiceGate API, accessible under /api/servicegate.asmx for any instance, but we’re struggling to make it work.Here’s the code we currently have https://pastebin.com/sfd6AYdp, but it always returns the following error:Report Response: System.InvalidOperationException: Not authenticated. at PX.Api.WebServiceBase.VerifyLogin() in C:\build\code_repo\NetTools\PX.Data\Api\Legacy\AbstractServiceGate.cs:line 572 at PX.Api.WebServiceBase.ReportSave(String name, String xml) in C:\build\code_repo\NetTools\PX.Data\Api\Legacy\Ab

Haii, I want to have a Fund Transactions but when I try to Release the transaction there is an error: account and subaccount can not be empty. I also have check the Currencies and for the Account and Subaccount already fill it. Please to take a look and help me to solve about this?Might be there is an error or a missing data that I set up. Thank you.I put screenshoot bellow:   

Hi Community Team,I would like to report a gap observed during screen conversion from Classic UI to Modern UI.When custom fields are created using a DAC Extension, those fields are correctly visible and functional in the Classic UI screen. However, after converting or working with the same screen in Modern UI, the extended DAC fields are not automatically included in the Modern UI layout.Observed Behaviour: DAC extension fields exist in the database. They are properly configured and visible in Classic UI. After switching to or converting the screen to Modern UI, the extended fields are not visible. No automatic synchronization happens between Classic UI layout and Modern UI layout. This creates confusion during conversion because developers expect the existing extended fields to be carried forward automatically.

We have built AI Document Intelligence solution for Acumatica ERP. To partner this with Acumatica from where we can collaborate on this? Do we have any marketplace listing for partner or how to become a partner? ThanksRegards,Ritesh

Hi All,This is the billing rule formula I am using to pull in my project billing which is T&M. It’s excluding a project task which is fine. However, when I do a change order to the revenue budget in the project, after running project billing the line item that has a change order is pulling in a 0 dollar value to the invoice. How can I modify my billing rule to pull the correct unit price for the change order? Any guidance would be appreciatedT&M Billing Rule Formula:   =IIf([PMTask.TaskCD]='MAT', 0, [PMTran.Qty] * [PMTran.UnitRate]) Thanks,Frances  

If an item is setup as base Unit Cases and Purchase Unit Pallet, the PO cost information does not convert properly if changed from one to the other.  Changing the unit cost first, then changing the UOM or Qty causes the ext cost to be incorrect 

It looks like when putting up revenue budget in Project, the Unit Rate doesn’t populate price that is effective on the start date of the project.Wiki below suggests that the rate should use the effective rate but it doesn’t appear so. Example:Price is setup on an inventory ID for a customer price class: Item 111 for customer price class AAA: $105 expired at 14-Dec-2025.Item 111 for customer price class AAA: $110 effective from 15-Dec-2025.All other info such as UOM, currency, etc are equal.But when setting up revenue budget of a project that starts from 16-Dec-2025 for customer that belongs to the above price class, the populated Unit Rate is $105.Anyone has same issue? and if so, how do we solve this?

After an upgrade to 25R1, ShopifyxAcumatica connector is now failing to sync payments with this error that seems to be a permission access for the Shopify app.  

I am trying to accomplish the following:Store and Sell item in EAchesOrder in CARrtonsRound up to full CARton on POExample:Carton of 2Customer needs 3 EAI need the PO to be 2 CARtonsCustomer will then get 3 and 1 will end up in stock.I can get it to order 1 case if the customer only needs 1 EA. But if the customer needs 3, it will put 1.5 on the PO. I can't order half a case.How do I get the PO to round to full Cases?I tried Lot size of 1 (and of 2) neither works. 

Hi all,I’ve been trying to find a way to add the On Hand qty of an inventory item on the Job Item Requistion screen and it’s not pulling the qty. I also thought of doing a side panel of on hand qty. What is the best way to handle it? I know that it is a virtual calculation in the background.   

Does any one know if it is possible to add a transaction date to the nacha file generated from Acumatica, which would be the day of creation, and use this date as the posting date for payment entry date in Acumatica?  Required to create nacha files with next business day selected to process by requirement of the bank. This creates a bit of confusion with reconciling because of the mismatched days.

I’m trying to incorporate the amount paid into a progress report for the projects in the construction module. I have still not been able to figure out how to build the relationships correctly between the tables and have it happen.These are the current tables in the report:And these are the relationships that work so far:. This is what my report looks like, but the “Balance” Collumn is what I’m looking at. I want to show either the amount already paid, or the balance still owed off of current invoiced amount.Any suggestions?

Hello,I have a scenario where when the user navigates to Customers » Print statement and click on ‘send’ the email activity pop up is generated with the default email template configured in the Report designer Template ID.  However when the user clicks on select template » replacing email body the fields mentioned with ((XXX.XXX)) such as ((CustomerDefaultBillingContact.EMail)) in the email template is not getting populated.  This is the header of the email template the user selects when changing the default template to the custom one 

Looking for some clarification & guidance. We are testing the Inventory Planning in Acumatica and one of the things I have noticed is the Min Order Qty on the Inventory Planning Tab of a Stock Item does not seem to utilized during the Planning Regeneration.In the example below, Stock Item 68000 has Safety Stock = 5, Min Order Qty = 10. I currently have Qty On Hand = 0.I would think that when Regeneration occurs, it would look at demand (currently 0), then check Safety Stock, determine in this case we need to place an order to fulfill the safety stock demand, and then use Min Order Qty if value exists. However, it doesn’t seem to use it at all. Only workaround I have found, is to set Min Order Qty on the Vendor Tab for the default Vendor and that does seem to work. If it is intended to be Vendor Dependent, then it seems odd this setting is there.