Solved

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 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 

The client has a large number of non stock kits with stock components. They require allocation before the shipment is created. I was wondering if this was a setting in Acumatica itself, or if it requires customization to achieve.

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?

How to override Receipt Nbr in adjustment for stock without receipt 

Has anyone ever been successful importing the postal codes. I understand Acumatica has the option to upload the postal codes like it does for Journal transactions, but I would like an import scenario to upload the postal codes based on each tax zone. It takes a long time to do it the way Acumatica has it setup. Thaanks

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?

Hello all,I would like to know if I mark the below employee as Inactive & deactivate the line items under the Delegates tab, would the delegation become inactive? Also how can I add date under Expires On field?  

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