Solved

Hi! has anyone experienced this where for the same item if you create a GI with table INLocationStatus it returns a qty on hand different than querying for the same table using SSMS. I’m not doing any joins or anything complex. Simply selecting Inventory ID, Qty on hand from INLocationStatus: 

Hi, All I am trying to update the UDF in the customer form. But when ever I am trying to use PUT API. It showing me the the Customer.AttributeAGDCRAN is not available in data set. I have also extend the API and populate this field in customer>>Attributes As you can see in below screenshot. I create AGDCRAN from attributes.   Can anyone help or guide me how can I update this UDF using PUT API.   http://accumaticaInstance/AcumaticaSB/entity/AGRAN/22.200.001/Customer?$select=CustomerID&$custom=Customer.Attribute.AGDCRAN” but this query is not updating the UDF. There are other Attributes also.Below is the body AGDCRAN is the udf{ "CustomerID": { "value": "0018293851" }, "custom": { "Customer": { "AGDCRAN": { "type": "CustomStringField", "value": "Apple jam 8 oz." } } } }  

When cycle counting, we were under the impression that there was an option to create a physical inventory type that would include all items in a location every time even if they are newly created item.

I have Develop two reports as CA650000 (main report) and CA650001 (sub report) Both the reports has Date parameters. CA650001 report is used as a sub report inside the CA650000. This sub report takes two parameters as CashAccount and DueDate.  when I run the sub report individually it works fine. when I add the DueDate Parameter it did not pass the values to the main report. when removes the DueDate Param it works fine. DueDate which is get as a parameter in the main report passed as a parameter of the sub reportThis is how I pass the parameter to the sub report. Following i have attach the reports also 

Hello,On my payment plugin I’m getting the errorValue cannot be null.Parameter name: source at System.Linq.Enumerable.Where[TSource](IEnumerable`1 source, Func`2 predicate)   at PX.Objects.Extensions.PaymentTransaction.PaymentTransactionAcceptFormGraph`2.GetTransByDoc(ICCPayment payment, IEnumerable`1 trans) in C:\build\code_repo\WebSites\Pure\PX.Objects\Extensions\PaymentTransaction\PaymentTransactionAcceptFormGraph.cs:line 1033   at PX.Objects.Extensions.PaymentTransaction.PaymentTransactionAcceptFormGraph`2.<>c__DisplayClass29_0.<CheckPaymentTransaction>b__0(IEnumerable`1 i) in C:\build\code_repo\WebSites\Pure\PX.Objects\Extensions\PaymentTransaction\PaymentTransactionAcceptFormGraph.cs:line 617   at PX.CCProcessingBase.RetryPolicy`1.DoExecute(Func`1 execAcion)   at PX.CCProcessingBase.RetryPolicy`1.Execute(Func`1 execAcion)   at PX.Objects.Extensions.PaymentTransaction.PaymentTransactionAcceptFormGraph`2.CheckPaymentTransaction(TPrimary doc) in C:\build\code_repo\WebSit

Hi,I added 2 new fields to Inventory Adjustment, both decimal UsrQtyThirdParty and UsrQtyUSN. I added them to the extended endpoint.I created an adjustment, the 2 fields are inserted correct, I retrieve the record and change the values of the 2 new fields and do a PUT, the values stay the same, not updated.Get the adjustmentUpdate the adjustmentResult after update 

During 2024R1 launch it was demoed an option to Offset AP and AR Documents.  Was this included on 2024R1 version?  If so, what are the steps to make it active?Image from 2024R1 launch presentation. 

Hi I have done a customization where I set the required qty to 1.00 in the material wizard 2 screen which works, I now need to make sure the release qty field also reflects this change where release qty needs to be the 1.00*the BOM, it still seems to be the original qty * the BOM with the logic I have written below.using System;using PX.Data;using System.Collections.Generic;using System.Collections;using PX.Objects.Common.Extensions;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class MatlWizard2_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard2> { #region Event Handlers // Use RowSelected to update QtyReq when the row is selected or edited protected void AMWrkMatl_RowSelected(PXCache sender, PXRowSelectedEventArgs e) { var row = (AMWrkMatl)e.Row; if (row == null) return; // Force QtyReq to 1.00 whenever a row is selected or edited row.QtyReq = 1.00m; sender.SetValue<AMWrkMatl.

I’m formatting my checks for use with AvidXchange so that up to 35 invoices show on the check stub. It’s working for the most part except that  I have this issue that the last Doc Type and Payment Amount are not showing up. If I have 20 invoices, invoice 20 won’t show a Doc Type or Payment Amount. If I have 15 invoices, invoice 15 won’t show a Doc Type or Payment (but will show the Date and Invoice Number). Any ideas? Thanks

We have a customer that is fast approaching 9999 on their auto incremental value numbering?  I would like to know what happens in Acumatica when this happens.  Does auto numbering stop? Does it continue counting?  We want to have a plan in place if needed?  

Hi, I am trying to update custom fields within the Leads aspect of acumatica.  My payload works fine for the fields listed, plus I am able to update notes.  My issue comes with trying to update multiple custom fields.  Whenever I can successfully submit my jSon, only one of the fields updates.  This is what I have:'"custom":{"Lead": {"AttributeFOLLOWDT": {"type": "CustomStringField","value": "12-10-2024"}},"Lead": {"AttributeWRSOURCE": {"type": "CustomStringField","value": "Andersen" }}},' 

Hello Experts,I have encountered a scenario where I need to export stock items from one tenant to another. To achieve this, I have successfully created export and import scenarios for stock items, and they work well. However, I now have an additional requirement to add a fixed quantity to each exported stock item.To address this requirement, I created a new import scenario to add quantities to the exported stock items. However, when I attempted to upload a file containing 200+ records, the process took an excessive amount of time and ultimately resulted in an error.I also tried using the upload file feature (Excel file) on the Receipts (IN301000) screen, but I encountered the same issue of extended processing time and failure to proceed. I have attached the file which I am using for uploading quantity.If anyone has insights or ideas on how to overcome this issue and improve the efficiency of the import process, I would greatly appreciate your assistance.Thank you in advance!Best regard

We have a report that serves multiple functions. There is a NOTE field that we would like to display if the [SOOrder.OrderType] <> ‘RQ OR [Note.NoteText] <> “”. ChatGPT search came up with recommendations, but none of them are working. The formula that I have so far is =IIF([SOOrder.OrderType] <> ‘RQ’, OR [Note.NoteTest] <> “”) then the NOTE field should appear, if the [SOOrder.OrderType] = ‘RQ’ the NOTE field should disappear. The NOTE field is showing up no matter what the condition is. The Visible condition is set to True. If I run the code =[SOOrder.OrderType] <> ‘RQ’ the NOTE field does not show up. There is only an issue when there are two (or more) conditions.

Hello all,I’m running into an odd issue with AR Invoice imports. I have tried to use the base scenario as well as created my own and I’m still getting an error stating ‘Project Task’ cannot be empty.I have confirmed, the project and task is active and that the formating is correct on the import file. I’ve even copied and pasted the project task from the task window.I can enter this sample invoice directly and it doesn’t give me any errors.Any help is greatly appreciated.  

I am just new on customization and I need to insert total row to the bottom of the Cost Projection (PM305000)  DETAIL grid, any suggestion or code I can use?  

We have over 30 service techs and they all drive a van that is stocked with parts they may need. Is there a way to set a default so when they use one of those parts it auto populates to there warehouse(VAN) when posting it to their appointment?

Trying to create cash basis P&L in Acumatica.  Has any one been able to do this without using a 3rd party add on? 

Hi All, I have created one user define field and I want to get/put from Acumatica API but the problem is I dont want other data to be look in API. I have created User Define field in Customer Screen So how can I give permission to someone to just read and write That field and nothing else. Please help

Hi EveryoneI am currently facing a scenario where the same lot number is being received across multiple purchase receipts for the items. We need to implement validation to ensure that duplicate lot/serial numbers are not entered in multiple receipts, while still allowing the same lot number to be received in different receipts.Could you kindly clarify if there are any existing validation configurations or methods in the system to prevent duplicate lot/serial entries in Purchase Receipts? Additionally, I would appreciate any guidance on how to handle this scenario effectively. 

For complex report , I am creating CTE based sql view. In my view script there are multiple CTE. I want to filter every CTE with report input parameter so that less data get read by every CTE and  report performance gets improve.To achieve this I would like to follow the same steps to create sql view with parameter. https://stackoverflow.com/questions/2281890/can-i-create-view-with-parameter-in-mysqlbut I am confused as how to pass that parameter in DAC @p1 value so that the same parameter get reads by every cte. 

We are using MRP to identify when we need to manufacture an item.   MRP is adding the Quantity Remaining to Produce from a production order to the Qty On Hand.  In the example below the Qty On Hand shows 50 but in the first line below it is adding 168 to that number making the total Qty On Hand 218.  The 168 is what is remaining on the production order to be completed. I’ve also included a screen shot of the production order showing the 168 Remaining to produce.  How can I tell MRP not to add the remainder on a production order to the qty on hand?  

I have a client with 1 Company (With Branches Requiring Balancing) setup in Acumatica and have around 20 Branches in it. The client's new requirement is to establish an additional company and transfer certain branches from the existing company to this newly created one. This is necessary in order to facilitate the submission of Group VAT for specific branches located in the UK. Since these branches have existing transactions, the ability to switch and select a different company on the Branch screen is disabled. Is there a way to reassign the branches to the new company? Regards 

I am migrating version 22.122.0019 -> 24.100.0139 and I am getting the following errorwhat solution we could apply?

We have a subreport that has been developed, and is working using data from the CRRelation table, which was submitted last week with issues. The subreport is a part of the groupFooterSection1. The subreport is receiving the parameters without any issues, but the final Sales figures are not all showing up as expected. I attempted to adjust the size of the subreport in various ways, using Custom, A6, and other dimensions trying to get the size down. Everything in the groupFooterSection1 has been encapsulated on a panel, and I’ve attempted to use a separate panel, no dice, no panel, no dice, putting the Sales figures on it’s own panel, still no dice. The user is adamant about using the CRRelation table to prevent his users from having to keep typing the same data from one report to another. On another note, I again want to thank all of the people that helped me last week to use the CRRelation for the data.Word attachment has screen shots of the work done and I’ve included a zip file of th

I created three DAC fields in a custom DAC as follows. When the user is redirected to the screen, those values are automatically filled. However, when I press save, the LotSerialNbr and Quantity fields are reset to empty and save as null in the database. Meanwhile, the  ProductionNbr field, which is PXSelectors, are working fine.  #region ProductionNbr    [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Production Nbr")]    [PXSelector(typeof(AMProdItem.prodOrdID))]     public virtual string ProductionNbr { get; set; }    public abstract class productionNbr : PX.Data.BQL.BqlString.Field<productionNbr> { }    #endregion     #region LotSerialNbr    [PXDBString(100, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Lot Serial Nbr")]    public virtual string LotSerialNbr { get; set; }    public abstract class lotSerialNbr : PX.Data.BQL.BqlString.Field<lotSerialNbr> { }    #endregion     #region Quantity    [PXDBDecimal(