Discussion Forums

Good day,I am having an issue making available a custom field on the grid of Bills and Adjustments. I made the field available for the Workflow and I added an Event that has worked for me on other projects, but this time is not working properly. Even if I have PXUIFieldAttribute.SetEnabled the field is not available after closing a bill, but if use the line Base.Transactions.Cache.AllowUpdate = true then it will make available the custom field plus some other Acumatica fields that should not be available when the bill is closed, How can I make only my custom field available? protected virtual void _(Events.RowSelected<APTran> e, PXRowSelected baseHandler) { APTran line = e.Row; if (line == null) return; APTranExt fieldExt = line.GetExtension<APTranExt>(); if (fieldExt == null) return; baseHandler?.Invoke(e.Cache, e.Args);

Is there a way to connect a single scale, maybe two or three in time, to Devicehub without having to purchase "Automated Warehouse Operations"? It seems kind of silly that we can’t even connect one.Will we ever purchase "Automated Warehouse Operations"? Likely in time but we have a long way to go before getting into the Manufacturing and Warehousing aspects of Acumatica and we’d like to be utilizing this in Shipping now.Is there a compromise or work around anyone’s thought of that works? Thanks ;-)

Adding an operation to an existing production order.  This is the only operation for the production order.  The following image is from the Production order details screen.The following image is from the Companies screen. 

How do I go about making another field visible depending on the value of another field. I would like to do this with Acumatica Tools as I’m not familiar with Visual Studio.

When a customer sends an email for the support portal and when some one(including sender) reply to that email, it creates a new support case rather than looping with the first case.Email account settings are as attached.Has anyone got this issue any found a solution.

Hello all,I have been trying to fix the change ID error for the stock items. So I have 2 items with the same inventory IDs but under different classes.eg :3032 - item description A - item class A3032 - Item description B - item class BI created a PO with 3032 - item description A. And then i changed the Item ID for “3032 - item description B” to “B3032 - item description B”.But these changes got reflected in my PO too as:B3032 - Item Description A.How can I resolve this?I even tried to interchange the values as “A3032 - Item description A” & “3032 - item description B” but then my PO got changed to 3032 - item description A whereas the PO should get changed to “A3032 - item description A”. Thanks, 

If ACU processes an inbound email it can associate it with a contact. However, the activity is not visible in the opportunity activity for that contact. From the opportunity you can see the Lead’s activities, but not the contacts.How would you associate inbound emails with an opportunity?Or how would you include/merge the primary contacts activities in the opportunity’s activity list?

I find it cumbersome to have to open each project and update the % complete on each task, then move to the next project, so I want to make sure that I am not missing something obvious.  Questions:Is there a way for the system to automatically calculate and update % complete based on actual costs/budgeted costs?   Most project accounting systems seem to have that feature out of the box. Is there a way to update % complete for multiple projects/tasks at a time?  Perhaps via some sort of importing function?Thanks in advance!

Is it possible to add multiple tasks to a revenue line on a project? For example one revenue line consists of a quantity of 5 and there are 5 tasks that need to be completed to fulfill it. As they are completed project billing would be run to capture the payment and update the revenue budget  We are new to Acumatica and trying to trying to take advantage of the project functionality any guidance or suggestions would be greatly appreciated. 

I have a customer that has multiple tenants, and I wrote a SQL view to view all of the users across all of those tenants for administrative purposes.I would like to add a Navigation to pull up the full screen User (SM201010), as a Side Panel link.  However, two things are stopping me. I can setup a relation to pull these data and display it by linking in the PX.SM.Users to a Key in the SQL View. However, I can only pull the users data from the “active browser tenant”. In the SQL view I do store the CompanyID for all the users over all of the tenants, but I do not know of any way to pass that value to the Navigation link so that I can pull any user information from across all of the tenants, unless I have changed the browser into that tenant as a session.Is there any way to pass the CompanyID over to that navigation link?(and I can accept the answer of “NO”. LOL)

Hopefully I am missing something obvious - Is there a report or GI that can show unbilled project lines for all projects and their expected billing amount when project billing is run?   I supposed I can build a new GI or modify existing Project Transaction Details GI to allow filtering on the Billable and billed fields, but don’t see a way to show the expected billing amount based on billing rule and rate table on each task.Also I need to see available Progress Billing lines too, which are available in Project Transaction DetailsThanks in advance.

Like the title says, I am trying to create a GI that shows all late shipments, whos orders didnt contain any shipments prior. This may be too much to ask for. I am new to GI’s and am trying to figure this all out. Any direction towards if statements within GI’s would be helpful and any help on this particular question would also be appreciated. Thank you! Attached is the GI I have been working with.

After running allocation, the user finds out that they didn’t update/enter certain rates in the rate table.  Once they fix that, is there is a way to correct previously calculated allocation results?  Or does that have to be done manually?This question would apply to changes made to Allocation methods after the run as well. Thanks.

Currently we are storing the JSON Object Body in a column which is [UsrJsonBody] [nvarchar](MAX) of a custom table. But sometime the whole JSON is not properly storing. That means for quite big JSONs the later part is getting missed. Can I know is there any issue with this approach. Please check the below code snippets. Thank you.//Custom table creationCREATE TABLE [dbo].[XXPOCreateHist]( [ID] [int] IDENTITY(1,1), [CompanyID] [int] NOT NULL, [IntegrateDate] [datetime], [PONumber] [nvarchar](50), [IntegrateStatus] [nvarchar](2), [ErrorDesc] [nvarchar](256) , [IntegrationType] [nvarchar](50), [UsrJsonBody] [nvarchar](MAX) ,....//JSON Storing approach in the Graph filevar options = new JsonSerializerOptions { WriteIndented = true }; var json=JsonSerializer.Serialize(obj,options); PXTrace.WriteInformation(json);....XXPOCreateHist toBeInser

I could not find any native report/menu that contained actual service level performance per SKU in a given timeframe.  Not sure if a GI is needed.  We’re currently on 2023 R2 upgrading to 2024 R1 next quarter.Is there any native reporting of service levels or is a GI needed?

Hi, I have been doing a lot of tests and I realized that when I map the Branch field at Order Level, the value is not changed but when I do it at the detail level, it does:**the 2 lines within the mapping are just an example, I ran the tests with one of them only. Does anybody found the same issue and a solution?  Thanks!  

Can attributes be deleted? Can they be modified? I have made some errors in setting up attributes and wish to modify or delete the incorrect Attributes. 

Currently the Payroll Direct Deposit amounts are posted to the Cash account in detail instead of batch total.  I do not see a setting to update this nor can I find a document addressing this behavior.  I am sure I must be missing something… Thank you 

My client needs the ability to have multiple shipment open on a sales order simultaneously. The create shipments to tell the warehouse to prepare configuration of the shipping items, prepares a pro-forma invoice, and creates a shipment to send to US Customs.What have others done for their clients to achieve this or this type of need, workflow customizations?

I’m able to filter on any string mapped field but when I filter on a DateTimeValue mapped field, I get this error:"exceptionMessage": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'Equal'." Question: is there a specific way to filter on a datetime field? Here’s the URL I’m using in Postman:https://sandbox.com/entity/INStockItem/22.200.001/POReceiptPackages?$filter=POReceiptLine_lastModifiedDateTime eq '2022-08-30T18:39:55.813+00:00'

Hi Good Friday! I am trying to pull the UNIT of measure conversion details into GI. I am able to generate the GI as needed however I identified every stock item showing false even SKU does not have unit of conversion.For example Below SKU has no Unit of conversion  Another SKU has conversionsit shows two time in GI  During my Observation every SKU has one record sa

Hello, in production:If I have a work step (0020), the next work step (0030) has a completed quantity, but it is not yet completely finished.And then I want to change the description or the setup time in work step 0020, for example. An error occurs. (Shown in the image)If I have changed an entry and then click on another field or save, the following error message appears and the system deletes the operation ID.#but if the following work step does not contain a completed quantity, I can change everything.Is that normal or is it a bug? initial SituationError Message 

Is it possible to delete irrelevant UoM conversions at the stock item level? Some of our stock items have a huge list of possible UoMs that are not relevant to that particular stock item.Thanks! 

I’m trying to Receipt a Purchase Order but Acumatica can’t find it - I suspect it’s because a colleague has created this particular PO with a type of Standard, when we always use Normal? 1) Does that sound correct? 2) How can I fix this whilst maintaining the original PO ID?

What predefined User role gives access to the Storage Details By Item Warehouse Location screen in the Data Views workspace? Is there an easy way to find this information out (e.g. what role gives what permissions) without having to guess ‘what role does what’ each time?