Discussion Forums

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: QRCode Source: Barcode Value: =[CCPayLink.Url]   Configure the size and position of the barcode. Add a new textbox and configure it the following way:Value “Click Here To Pay!” or any other label Navigate Url: =[CCPayLink.Url] Visible Expr: =[CCPayLink.Url]<>nullSave the report back to the server!Done! You now have a report with a barcode and a link that navigates customer to the pay link!  Troubleshooting:If you’ve configured the code and it still does not show up (or rather show up as

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;                objPayment.CuryOrigDocAmt = filter?.PaymentTotal;                docgraph.Document.Cache.Insert(objPayment);                SOAdjust adjnew = new SOAdjust();                adjnew.AdjdOrderNbr = order.Orde

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, bool newlyCreated, Func<SOOrder, SOShipment, int?, DateTime?, string, SOOrderTypeOper

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)] [PXUIField(DisplayName = "Selected Item", Enabled = false)] public string UsrReadInventoryNbr { get; set; } public abstract class usrReadInventoryNbr : PX.Data.BQL.BqlString.Field<

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\AbstractServiceGate.cs:line 241 Status code: InternalServerError Does anyone know how to resolve this? We've gone through several iter

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.Current Workaround:To make the extended DAC fields visible in Modern UI: Open Customization Project Editor Open the specific screen Click on Modern UI Editor Click A

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?

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.Reading the Form Reference, I can see it get’s populated from the Item Class, but still not sure why the Inventory Planning doesn’t use it.

Hey, team - looking for some advice on Write-Off best practices used in conjunction with automation schedules.  I’ve got a client who has 3 specific customers whom they will consistently write off small amounts for.  There are instances when they have many invoices applied to a payment and we’ve instructed them to simply manually enter the Balance amount in the Write-Off Amount field.This isn’t a big deal, but I’m interested in automating it since it’s a literally just them copying one field (Balance) into another (Write-Off Amount.)  However, there may be invoices where the Invoice Amount is less than the Write-Off.  We would NOT want these to be automatically written off.  In a perfect world, we would only display those invoices that have been partially paid on the Write Off Balances and Credits screen. The issue, though, is that there doesn’t appear to be a condition or filter element on the Automation schedule that would segregate invoices that have been partially paid, i.e., a bal

Hi,I’m working on an ARM P&L Monthly report. My Column Set currently uses fixed Data Source periods (01, 02, 03 … 12).I want to add StartPeriod and EndPeriod parameters and make the column values (not just headers) adjust dynamically based on the selected period range.Example:If StartPeriod = 2025-03 and EndPeriod = 2025-06, the report should only calculate/show Mar–Jun.What is the correct way to achieve this in ARM?Should I modify the Data Source, use Visible Formula, or handle it in the Report Definition?Thanks in advance!

Hi Everyone, I’d like to pass a list of values instead of calling out the items 1 by 1. There are many options in the conditions drop down. But the documentation does not specify how they should be used, or provide limitations.