Discussion Forums

i want to display Tag Number, so we can use it for our physical count. 

SO, in this designer report the item line is not picking from the correct path that is SoShipLine.TranDesc. The Soshipline was not in it so i join it to the table of SoShipment. I try adding it but the result was duplicating itself on every linethis was the formual that was puling the item.=IIf([SOPickerListEntry.LotSerialNbr]<>Null, Format('{0} {1} {2}', [SOPickerListEntry.InventoryID], [SOPickerListEntry.LotSerialNbr],[SOPickerListEntry.InventoryID_description]), Format('{0} {1}', [SOPickerListEntry.InventoryID], [SOPickerListEntry.InventoryID_description])) This is after I join SoShipLine to get TranDesc this is the formula i used=IIf(    [SOPickerListEntry.LotSerialNbr]<>Null,    Format(        '{0} {1} {2} {3}',        [SOPickerListEntry.InventoryID],        [SOPickerListEntry.LotSerialNbr],        [SOPickerListEntry.InventoryID_description],        [SOShipLine.TranDesc]    ),    Format(        '{0} {1} {2}',        [SOPickerListEntry.InventoryID],        [SOPickerList

Hello, Has anyone ever noticed any issues with the scan and count process when multiple users are using scanners at the same time (Full Inventory PI)? Example: 30 users have scanners and are using the scan and count process at the same time.I am concerned that many users may disrupt the process. This is our first full PI in Acumatica and any advise would be appreciated.  

Canadian payroll year-end is around the corner—make sure your team is ready.Our latest Canada Payroll Year-End Webinar is now available to watch on demand, covering the essential updates, troubleshooting steps, and provincial changes you need to close 2025 smoothly and confidently.In this session, our payroll experts walk through:Key federal and provincial changes for 2025–2026 CPP/QPP, EI, and employment standards updates T4 and RL-1 preparation essentials Common year-end pitfalls—and how to avoid them Reports and tools to help you balance faster and with fewer errors Tips straight from Support on preventing escalationsWhether you’re finalizing December payrolls, preparing slips, or validating data, this session gives you the clarity and checklists you need for a clean year-end.Watch the webinar👉 here:If you have questions after viewing, our team is here to help.Let’s make this your smoothest year-end yet.

public PXAction<FSEquipment> UpdateHours;        [PXUIField(DisplayName = Messages.UpdateHours, MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]        [PXButton(DisplayOnMainToolbar = false)]        public IEnumerable updateHours(PXAdapter adapter)        {            if (MaintenanceLogInfo.AskExt(UpdateHoursSetVisible, true) == WebDialogResult.OK)            {                DateTime date = MaintenanceLogInfo.Current.Date.GetValueOrDefault();                decimal hours = MaintenanceLogInfo.Current.Hours.GetValueOrDefault();                if (date == null)                {                    // Acuminator disable once PX1051 NonLocalizableString [Justification]                    MaintenanceLogInfo.Cache.RaiseExceptionHandling<FSMaintenanceLogInfo.date>(                        MaintenanceLogInfo.Current,                        date,                        new PXSetPropertyException(Messages.DateCannotBeEmpty)                    );         

Why do I have full access to the Customization Project screen but still cannot use the Add and Delete buttons, even though I am able to edit existing elements?

Good day CommunityI have created an ARM report which has PTD and YTD values on the same report but for some reason it is only displaying YTD in all columns and I can’t see the problem.PTD has Turnover as the Amount Type in the Data Source and YTD has Ending Balance, yet the amounts displayed are the same. Obviously the Subaccount is the same.Can someone please advise what I have missedMany thanks in advnce.

I’m trying to create a Generic Inquiry table that has all the inventory balance by location and serial number. There’s been several different tables presented on this site that can get qty by location (attached below) however, whenever I add Serial Number to them, the serial number gets attached to everything of the same part, producing duplicate results (and grouping isn’t smart enough to match deal with that). Is there a way to get the serial number to link only to the qty it belongs to?

Hello,       Our company has some vendors that we do NOT want the sales team to know about. So we’ve set up restriction groups: only buyers can view these vendors, while certain sales personnel cannot.     However, when sales staff enter sales order with items purchased from these vendors into the system, an error pops up indicating they do not have access rights to the preferred vendors for those items.I currently have a workaround: I don’t set default preferred vendors for these items. But is there a better way to achieve both of the following?The vendors remain restricted (only accessible to buyers); Sales staff can enter sales order with the items correctly without errors.

We have stock items that do not need to be checked into the system in some instances, and others they do need to be checked in. If we raise a purchase order with these stock items, is there a way to not check them in and close off the purchase order?  For additional context, when we were setting up our system, our consultant helped us set up the following manufacturing flow. We have an item that undergoes manufacturing steps at 3 different suppliers. To track the manufacturing flow, we created a BOM with the main part being machined as a stock item and then the subsequent steps are non-stock item services provided to the stock item. I have included a little table below to describe the process. Should I start receiving these goods/not backflushing them?

Hi all,We recently upgraded from Acumatica 2024 R1 to 2025 R1 and noticed that whenever a new case is created, an additional activity entry is automatically generated:Type: System MessageSubject: Case created in ERPWe haven’t been able to identify any functional value for this entry—it simply logs that the case was created. However, it is creating extra activity records that are triggering unintended side effects, particularly with Business Events that rely on the CRPMSMEmail DAC (e.g., when monitoring case-related messages).We’ve looked through different settings screens but haven’t found a way to disable this “Case created in ERP” message.Has anyone found a way to disable or suppress this automatic activity entry in 2025 R1?Or alternatively, is there documentation explaining its purpose or how it ties into the case workflow?Thanks,Dave

hello all, i have been trying to clock in on the Project tasks (PM302000) screen, but it still says : the user that i have logged has a linked employee record, have also setup the Default time log type under preferences, the project & the Project tasks both are activated, but still throws this message. is there something I’m missing in here?

Hello AllI am trying to create an approval map for expense claims that will require multi user approval.The flows are as below:Aprrovals for $20,000 limit - I have a workgroup assgined to this as it only requires one approver. Approvals for $20,000 - $50,000 limit - there is also a workgroup assigned to this as well as only one approver is required. Approvals greater than $50,000 - this is where the multi user approval is required. There are five (5) users who can approve these claims, however, they require a combination of any pair to approve i.e.: (user 1 and user 2), (user 1 and user 3), (user 1 and user 4), (user 1 and user 5), (user 2 and user 3), (user 2 and user 4), (user 2 and user 5), (user 3 and user 4), (user 3 and user 5), (user 4 and 5) at any time.I’m trying to figure out how I can get this to work. On my approval map, I set up the pairs as various options but that didn’t work as only the first pair was able to have the multi user approval and the rest just approved with

Good morning everyone. I am trying to create a new bom with a business event using a GI and an import scenario on a schedule. I am getting the error “The last error was Cannot generate the next number for the BOM sequence.”. To diagnose it easier, I exported the GI to excel and made a data provider, new import scenario, and used import by scenario to upload. i used the community post below to find a solution that worked. This post used option 1 in the below screenshot. It worked fine and created a new bom with the next autonumber with everything correct on it. I then made the change to the business event subscriber import scenario and I got the “cannot generate next number” error. I then tried option 2 below and the business event history shows that it ran successfully with no errors but it didnt actually create the bom. I saw another post where someone could only get the header to get created and had to add materials later so I tried making the GI as simple as possible and use only th

Is it possible to change the transaction description that is automatically generated by intercompany transactions?Currently the transaction description is “Balancing entry for: BRANCH” but the branch is the same branch that the transaction posts to.  It would be more helpful to people reviewing the general ledger transactions to know what branch that the balancing entry was from.  These two descriptions should be swapped to be useful:It is not helpful to see PRODWHOLE has a transaction that is a balancing entry for PRODWHOLE.  It would be more useful to the person reviewing the transaction to know that the branch PRODWHOLE has a balancing entry that came from PRODRETAIL. This issue is sort of related to these:Change the transaction description of invoices created with multiple installment credit terms (Build 2024.2) | CommunityPosting meaningful description for journal entries | CommunityDoes anyone have the code to update the Intercompany transactions? 

Hi, client has several Operation .Is there a way to restrict certain users from entering a Move trx for certain Operations or Workcenters? I tried RowData Security, no option for WorkCenters;  but I tried to use the Warehouse linked to the WorkCenter;  but it did not work. Business Case.  Op worker entering movement for the WC he is working and not a different workcenter.ie,  Assembly vs Packing vs Quality Control.

Hello  Is it possible to populate the Description (Image alt text) field in BigCommerce when uploading images from Acumatica using the Acumatica connector.  Thanks  Matt

Hi everyone,I would like to have a visual on the margin of my transports. Why can't I click on PO linked? I do click on Mark for PO, I add my PO, and it's impossible. Any solutions?Thank you.

We are a retail business using Acumatica in UK and currently have the Stripe integration switched on and working to accept payments in Acumatica, to do this we can manually type the card details into Acumatica & then the payment detail is sent to Stripe via the OOTB integration to authorise / take payment. We would like to be able to use card terminals within our showrooms so customers can insert their card into the terminal to pay but are struggling to work out what we need to do / what integration is required to allow the payment detail to get to the card terminal, the card terminal sorts the payment and then updates Acumatica when the payment has went through. Is anyone else using Stripe card readers with Acumatica and if so what extra steps / integration are you using to get it working?

We offer installation, removal and storage services to our customers. When we sell a project, the stock item is on the sales order and “Shipped” once it has been installed. We are able to track that inventory up until this point. Then the product gets removed and stored in our warehouse, but we do not have a way of tracking it since it is now customer - owned product and not our own inventory. Does anyone have any suggestions on how to go about this? 

I have two buttons that open the same dialog window. I need to set the visibility of the dialog fields depending on which button is clicked.

Hi, I’m setting up a automation schedule for recalculate customer balances. I have about 1000 customers, but the schedule only run for two customers all the time. I have tried the same schedule setup in a local environment which runs for all customers without any issues. Below is the schedule I have added. Trying to figure out why it is limited to two customers all the time. No conditions are available and here are the other settings. Thank you,Dulanjana

Instead of going to each cash purchase and releasing one by one , is it possible to release several cash purchases at once ?

I had tried not activating the EI taxes on the Employee Payroll Settings but get an error when calculating the paycheck.  How do I set up this employee so EI insurable earnings & premiums are not calculated for this employee and that their T4 will show that they are EI exempt?

I’ve setup up purchase order appovals with email notifications, but I’m only able to send the notification to the purchase order owner using ((Document.OwnerID.EMail));. I’m trying to use ((Approval.ApprovedByID.EMail)); to send the notification to the approver, but the ((Approval.ApprovedByID.EMail)) value is returning an empty string. What is the correct value to use to send the notification to the assigned approver for the purchase order. I’m not using approval workgroups, just a single defined approver. This is on version 2024 R2.