Solved

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 toBeInserted = new XXPOCreateHist(); toBeInserted.PONumber=order.OrderNbr; toBeInserted.IntegrateDate=DateTime.Now;

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 

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 saving in DB, How can get the exact records with out showing dummy information

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?

Hello all,I have the below Po order details & the result in PO Order report:The Inventory IDs are same for all, but have modifications made in the Line description column PO Order report PO641000When we compare the above screenshots we see that the Line description are not on the same line number as in the PO screen (PO301000). So I am looking to print the descriptions & details in the same way as they are entered in Line level in PO Order.How can I achieve this?I tried the below in report designer, but still no changes, Thanks. 

I am trying to switch to using the Odatav4 endpoint instead of the REST API for fetching order data. One thing that I noticed that it seems to be missing is the ID of the Purchase order. I am using the following request: http://localhost:40294/AcumaticaERP/ODatav4/MYSTORE/PX_Objects_PO_POOrder?$expand=POLineCollection($expand = InventoryItemByInventoryID($select = InventoryCD,Descr,ItemStatus,BaseUnit))&$filter=OrderNbr eq '000024'This works well but it does not seem to contain the ID of the order which I know to be dee069aa-a63a-ef11-9050-e848b8c82000 from using the REST API:  http://localhost:40294/AcumaticaERP/entity/Default/23.200.001/PurchaseOrder?$expand=Details&$filter=OrderNbr eq '000024'Is this not possible or am I missing something. 

 Hello all,I am getting the below error when I upgrading any of my libraries from 2023R2 to 2024R1 (24.104.0008). I have tried reinstalling the 24R1 but still have the same error. Any help is appreciated.Could not load file or assembly 'System.Security.AccessControl' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)Stack Trace: [FileLoadException: Could not load file or assembly 'System.Security.AccessControl' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)][FileLoadException: Could not load file or assembly 'System.Security.AccessControl, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)] System.Reflection.RuntimeAssembly._nLoad(

For these specific DACs:ARInvoice, ARPayment, ARCashSale, PMProject, PMQuote and PMTranI need to figure out how to hard-code around the existing lookup on the CustomerId or BaccountId (whether attribute based or uses PXSelector) to exclude or restrict selection of customers that are parent customers. eg.  exists (Select ParentBaccountId from Baccount where ParentBaccountId = this.BaccountId)I’m not sure how best to accomplish this.  My first thought is add a computed field (non-persistent) to Customer or BAccount called IsParent that runs the above query to return a boolean.  Then use that in PXRestrictor wherever we need to prevent the selection of these customers. Unfortunately, it doesn’t look like I can make it generic by creating my own attribute as it appears there are different attributes and methods on these foreign keys already being used.Any ideas?

Hello! I have configured branches in my system and each branch has its own warehouse. My main branch transfer items to other branches but adding a charge. For an example, inventory cost of my main branch is 100 and when transferring we charge 30 and consider it as my income. For the destination branch item cost should be 130. No purchase order or sales order is created. Is there anyway I can set up this?Amanda 

Hello all,Can anyone let me know how can I calculate the revenue of an Inventory Item sold for a particular month?Thanks in advance.

Hello all,How can I calculate the Gross Margin for qty sold out in Acumatica?

Is it possible to generate an invoice out of Receivables and code against a project BUT to a different customer than the project is setup to?  Right now it appears there is a hard restriction that only the customer on the project can be selected in Receivables invoice screen in order to charge to that project.Our use case as a contractor is that we occasionally do additional T&M on-site work that one of the other subcontractors request of us ( hauling off their debris in addition to ours or digging a quick trench for them) We generally like to tie any billing/revenue for this type of one-off T&M work back to the project, since its generally small and our costs for us to do the T&M work are generally lumped in within larger scope of work for the main Project/Customer.   As noted above we would generate this T&M invoice, and receive payment from the third party subcontractor and NOT the customer listed on the project.  Any suggestions on how we could do this?thanksSteve 

I am getting an error when trying to delete an On Hold AR Invoice that’s created from a pro forma invoice.  See below.  The message seems incomplete and makes no sense.  I need to recreate the proforma invoice to factor in the updated bill rate.Does anyone know why and how to resolve?BTW, is deleting and regenerating the pro forma invoice the best way to correct billing rates?   In my example, some rates have been changed and added in the rate table after the proforma invoice was processed. Thanks for your time and input in advance. 

Does someone have a import to user preferences?  specifically the default email account on the email tab?I am not sure it is possible  

I would like the “Service Orders” tab to be shown in the “Payments and Applications screen in “Receivables” as it does from the “Prepayment” tab in appointments. As you can see in both images, it says “Payments and Applications” but one screen does not have the “Service Order” tab.I would like this option when coming from the “Receivables” module so the Accounts department does not have to open an actual service order to apply a prepayment so prepayments are properly recognized from a Job and Accounting view point. Any thoughts? Screen from “Receivables”Screen from “Prepayments” tab form an Appointment in a Service Order 

Is there a solution yet for sending files attchements with a Business Event Notifcation?Cusotmer has attachments on each shipment and wishes to send email when shipment is confirmed and have the attchements included on the email.Thank youDale  

How do I enable locked fields, like we used to in Automation Steps? I’m seeing it’s under Customizations now, but I am not seeing a useful walkthrough on this. I want to unlock a date filed on the SO Header when a shipment is created. 

I have a long list of items listed in this screen but the items have already been received. Is there a way to get the items that have been received to fall off the Generate Intercompany Purchase Receipts list?

We had a Project Inventory Location GI we had created in 2022R2 we use heavily.  Now that we are upgrading to 2023R2, the GI has to be re-written because of the PMLocationStatus and PMLotSerialStatus tables having been removed in 2023R1.  I’ve been trying to get the GI modified using the table references in the Release Notes for 2023R1.  I am apparently missing something.  I would appreciate help reviewing our original GI (titled Project_Inventory_Location.xml attached here) against the version I am working to modify in our SANDBOX for our upgrade to 2023R2 titled MR_050724_Project Inventory Location.xml attached here.  The modified GI is creating duplicate rows.  I’ve reviewed the GI and am not seeing the reason for the duplicate rows being returned.  Thanks for looking and any help you might offer in advance.