Discussion Forums

How can, I prepare a GI showing Item, Qty Sold, Qty on Hand, and days of stock in Acumatica ERP

I am posting this topic as a discussion because I am doubtful there is a answer to this issue that can be provided in the forum, and I don’t want to post a topic that will not have an answer.  This drives Chris crazy.  :-)I customized the Projects screen so that I can “filter” the results that show up in the Attributes tab.My customer has over 2000 project attributes.  Yes, you read that correctly, over 2000.I created a cross reference table that links project attributes to the Project template.  When a template is selected, I overrode the Answers view to discard the attributes that are not linked to the template.In my override, I get the current PMProject from the cache.  I then store the template ID from that record into a variable to be used later in the override to do the filtering.When the screen is first loaded or refreshed, there is only one record in the PMProject cache.If you make a change to an attribute value and save the screen, another project gets added to the cache.In my

When querying the Activity entity I am able to retrieve the RelatedEntityDescription field.However, filtering Activity by RelatedEntityDescription leads to an error as shown below.http://52.168.110.150/AcumaticaNew/entity/Default/23.200.001/Activity?$select=RelatedEntityDescription&$filter=RelatedEntityDescription+eq+%27Test+Value%27&$skip=0&$top=1000This looks like a bug from the API. Is there any solution to this? If not, is there a way to detect such fields? The swagger definition does not contain any information on such columns.{ "message": "An error has occurred.", "exceptionMessage": "Invalid column name '[Activities_CRActivity].[Source]'\r\n", "exceptionType": "System.Exception", "stackTrace": " at PX.Data.PXSqlDatabaseProvider.throwInvalidColumnName(SqlException e, IDbCommand cmd) in C:\\build\\code_repo\\NetTools\\PX.Data\\Database\\MsSql\\MsSqlDatabaseProvider.cs:line 483\r\n at PX.Data.PXSqlDatabaseProvider.<ExecuteReaderInternalAsync>d__24.

I am trying to add line items to an existing order via the API.  I am able to create orders with line items via the API, but I have found that if the number of line items is too high, the process times-out/fails.So I am attempting to create the order header, then loop through the line items and add them in batches of a certain # of lines (TBD, possibly 100).  My script is creating the order header no problem, but I can’t get it to add any line items.  This is the error msg:Specified argument was out of the range of valid values.\r\nParameter name: Invalid uri structureThis is the URL:  https://xyz.com/entity/Default/22.200.001/SalesOrder/1712261/DetailsI then modified the URL to be: https://xyz.com/entity/Default/22.200.001/SalesOrder?$expand=Details&$select=OrderType,OrderNbr,Details/OrderQty,Details/InventoryID,OrderedQty,OrderTotal I do not get an error with this 2nd URL, but it just hangs.  My script hangs and I do not see activity in Acumatica.  This is the request payload: {"

-I am trying to do as the book guild and video. I am testing it many times but it still the same error. why in the video and book, it shows can import. Please advise why I am can't do. -If all of have the excel file sample about AR, Customer, Vendor that can import successful in system May I, have it? because I have customers that need to import excel file to show them for demo in the next week. Thanks so much

I am getting errors on a few move transactions in an environment that just went live. This is only happening for a few orders. Ideas? 

I add more role though combo box value. but it seems not working.Please advise on how I can add more role~

Im trying to import 1 decimal value (a quantity of a kit at a particular location) from a GI table that has parameters. I dont know how to convert from the result to a single value? The below code doesnt work.   Dictionary<string, string> parameters = new Dictionary<string, string>(); parameters.Add("SiteID", row.SiteID.ToString()); parameters.Add("KitID", row.InventoryID.ToString()); PXGenericInqGrph gi = PXGenericInqGrph.CreateInstance("KitBuild3", "KitBuild3", parameters); PXResultset<GenericResult> results = gi.Results.Select(); GenericResult result = results.FirstOrDefault(); //var kitQtyList = results?.Cast<GenericResult>()?.ToList()?.Select(r => r.Values["KitQty"])?.ToList(); decimal? kitQty = Convert.ToDecimal(result.Values["KitQty"]); 

Im seriously struggling with trying what i think is quite simple. Ive posted several times a similar question but none of the answers have worked.. I’ve built a farely basic GI “KitBuild3” (though it does reference other GI’s per the 2024r1 changes)which returns Im trying to read the single value KitQty(later I will work out parameter based on SiteID/InventoryID of the SOLine if it ever works)PXGenericInqGrph gi = PXGenericInqGrph.CreateInstance("GI640596", "KitBuild3"); PXResultset<GenericResult> results = gi.Results.Select(); string test = ""; foreach (GenericResult resultRow in results) { object oformula = (Dictionary<string, object>)resultRow.Values; foreach (KeyValuePair<string, object> kvp in (Dictionary<string, object>)oformula) { if(kvp.Key.ToString() == "KitBuild2") { test = tes

Ive created a PXProjection DAC and Im just trying to multiple a field by a constant (for now). The PXFormula field of DfltCompQtyCalc keeps returning null no matter what I try? It works when I remove the Multiply<> operator. Also if I just define the PXFormula<index1>.. I get a list of 2’s so the constant is fine also? Why cant I multiply the two!!  using System;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data.WorkflowAPI;using PX.Objects.CM;using PX.Objects.Common.Attributes;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN;using PX.Objects.PO;using PX.Objects.SO;namespace AutoKitAssembly{ [Serializable] [PXCacheName("KitAssy_Sub2")] [PXProjection(typeof(Select2<INKitSpecStkDet, InnerJoin<KitAssy_Sub1,On<INKitSpecStkDet.kitInventoryID,Equal<KitAssy_Sub1.kitInventoryID>,And<INKitSpecStkDet.revisionID,Equal<KitAssy_Sub1.revisionID>>>&gt

We’ve created a simple BLC object named SOShipmentMutex. We are editing it via a listview page with a custom DAC.When we delete a row from the Shipment Mutex grid via the UI, it deletes successfully.  However, when we try to delete via the REST API, the delete is not performed.  The RowDeleting event is hit when using the UI, but it is not hit via the API.We are able to successfully add a new row via the API, but delete is not fired.Can someone help us figure out why we can’t delete via the API?  public class SOShipmentMutexMaint : PXGraph<SOShipmentMutexMaint> { public SelectFrom<SOShipmentMutex> .View ShipmentMutex; public PXSave<SOShipmentMutex> Save; public PXCancel<SOShipmentMutex> Cancel; protected virtual void _(Events.RowDeleting<SOShipmentMutex> e) { var row = e.Row; } }  [Serializable] [PXCacheName("SOShipmentMutex")] public class SOShipmentMutex : PXBqlTable, IBqlT

Please kindly advise about error case. Thanks so much 

Good day When uploading images on the mobile app, sometimes the images will not sync. There is also no option to sync the uploaded files. It looks to be a caching issue. Has anyone seen this issue before or know if I can implement a setting on the phone to resolve this?Please see below video.  This is a custom development screen, but as far as I know the image upload is built in.Acumatica version: 23.106.0050 

Once an opportunity is created, the corresponding business account is no longer editable.I would like to customize this to allow that to be changed in certain circumstances.can I do this by just overriding the field with an allowupdate=true or something similar? will this break anything? And as a general question, is there a good way to determine if a change like that will cause problems? I understand sometimes Acumatica does this sort of thing as a dependency, and other times they’re just enforcing a workflow preferenc Thanks! 

Hi,I have observed in 2024 R2, when we provide the parameters to Run report, it has to provide the parameters by searching it in the list of values. Previously when using report filters, while entering data the system would show a dynamic drop down box with applicable items. Now it shows as if no applicable items are available even though when the search icon for the filter is clicked the pop up table shows the applicable item. As an example, when we run the inventory balance report for a particular item or a particular warehouse, when we type the warehouse name halfway it will not suggest the existing warehouses with the types key letters even though it is available in the system. Instead we have to click on the search icon and select the warehouse from the list. Is there way we can get the warehouse or items suggested like before.  Thanks!

Hi! Is there a GI or report in Acumatica that shows all transaction type by vendor? All transaction including purchase order, bills, payments, etc. Similar on the customer side as well. The goal is to be able to filter by vendor name and the transaction type, then the GI or report will display all transactions related to that vendor. I tried creating a GI that links the purchase order table and bills and adj table together by vendor but that did not work. Any suggestions or ideas would be appreciated!Thanks!

I am trying to create the move transaction (AM302000) automatically when the release button is clicked in the materials screen (AM300000) On release of this materials transaction the development will create and release the Move Transaction with the below populated from the Materials ScreenThis is the override of the release button I have attempted below but it is not creating the new move transaction but there are no validation errors. #region Release Override public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);[PXOverride]public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod){ // First, execute the base release method to ensure original functionality var documents = baseMethod(adapter).Cast<AMBatch>().ToList(); // Process move transactions after base release foreach (AMBatch batch in documents) { if (batch.Status == "R") // Check if the batch is Released { CreateMoveTransactions(batch);

Prior to our 2024r2 upgrade we were able to relate these tables via:INCostStatus.costSiteID = INLocation.locationID.Now the INCostStatus.costSiteID field appears to contain the INSite.SiteID instead.Anybody know how to relate the INCostStatus table to the INLocation table?Note - We are FIFO costed.Thanks,Brett    

Hello, I was looking to build a GI replica/version of the data that the Inventory Summary inquiry screen provides. Basically, the same data but not filtered down to only one stock item at a time. I need to see this data for all stock items at once, and the stock item GI is not simple to add these additional fields to since the tables are so different and it’d increase the rows. The inventory summary screen however, which, see below:  When inspected for customization, it has a “filter” table and a “results” table:  And both of these tables I can’t figure how to build off of since they expect a filter in order to populate data. But I need to see the same data (all warehouse locations of the stock item + their on hand QTY and the unit cost in that location) WITHOUT the filter down to one stock item at a time applied. I tried guessing from documentation and pulling INsite and INtran both those didn’t give me the right cost or locations.  Does anyone have guidance on how to recreate this to

I have an item on a Sales Order that we are trying to ship out. I created a move transaction and completed it with no issue but it does not show up in the Allocated qty on the sales order. When I went to go manually allocate this item, I see that the Related Document is still the Production Order itself and not the move transaction and the item does not allocate manually through the Line Details either. How do I go about getting this onto the shipment? We have shipped 4/5 already and are looking to ship the final 1. Line 8 is the line in question.Thank you! 

Hi,We are a construction company that job costs everything. We were set-up to have our non-stock items like Materials and Equipment to require receipt and shipment but it seems like it would be easier since we job cost everything to take off those requirements and just create an AP bill against the PO when it’s received.Is that what other construction companies are doing and/or is that best practice? Any adverse consequences that I’m not thinking about changing our set-up/process?Thanks for any insight anyone can provide.

The end result it to be able to filter the converted field using the built in “From, To”” calendar function provided for data fields of date type. Not sure what's not allowing the from and to functionality since the field has been converted to a date type. 

We’ve had a request from our QS to see all new change orders in a period.  We wants this in addtional to the substantiated billing report.  But, I can’t find anything that does this.  Do I have to manually find each change order created in a period and then print them out to a PDF one at a time?This kinda feels like something most QS’s might want and I’m a bit surprised I can’t find anything to produce this.  It must be a user problem, right?

Hi there,Does anyone know if Acumatica is utilized in Norway?and/orIs the Acumatica product compliant with Norwegian taxation requirements ?Thanks

I’m looking for input from other end users of Acumatica. We currently use Century Business Solutions (or EBIZCharge) for our credit card processing. For various reasons, we’re not real happy with their service.What 3rd party processors, that integrate with Acumatica, are considered the best? I found a few others (REPAY and ERP-VAR) that also integrate, but I know nothing about them. I hesitate to just jump in with another processor before doing some research, which is what I’m attempting to do now. Ha!