Solved

Hello experts, Does anyone know how I can have the GI defaulted to a specific tab programmatically when it is executed? I have a GI that I am running it through an action with some default parameters. The GI has a PivotTable on it called “Employee Activity by Day” displaying Employees in Rows and Days of the Week in Columns. I would like when GI is executed through the custom action, is defaulted to this Pivot Table instead of the granular time activity of the default result tab.How can I do that?​@Dmitrii Naumov 

We are updating our products and would like to remove large groups of stock items from their associated template IDs, modify the Item Class and Template Items, and then re-attach the stock items to their updated TemplateIDs.  We understand how to associate products to the template IDs, but cannot determine how to delete the Template IDs from each Stock Item to remove them from their templates. We have tried setting the value of the Template ID = NULL, = (nothing) , and =String.Empty .  Does anyone have some pointers on how to remove these via import scenario? Patrick 

I am trying to create a printable report with  Service Contract information. I am specifically trying to filter the data in the FSContractPeriodDet table by CreatedScreenID. I am able to filter this data from EDIT REPORT after the report is open, but I can not get a filter to work for this directly in the report it’s self. The ScreenID I am trying to filter is FS.30.57.00. I am assuming there is a different ID value or something that is actually saved in the database and not the actuals ScreenID.Does anyone have any insight they can share?

Hi everyone,I’m currently working with Acumatica and trying to expose a custom table via REST API. I created a custom API entity and endpoint, but the API Create Record doesn't work.I'm using   Post {{url}}/entity/webOrderTaxComparison/22.200.001/webOrderTaxComparison/Save  Body:    {  "Entity": {        "WebOrderTaxComparisonID": { "value": 2 },        "WebOrderID": { "value": "WEB006" },        "AcuOrderID": { "value": "ACB006" },        "AcuTaxTotal": { "value": 95.50 },        "WebTaxTotal": { "value": 95.75 }    }}    or     Put {{url}}/entity/webOrderTaxComparison/22.200.001/webOrderTaxComparison  Body:  {        "WebOrderTaxComparisonID": { "value": 2 },        "WebOrderID": { "value": "WEB006" },        "AcuOrderID": { "value": "ACB006" },        "AcuTaxTotal": { "value": 95.50 },        "WebTaxTotal": { "value": 95.75 }    }    response issue is:  "message": "An error has occurred.",    "exceptionMessage": "Sequence contains more than one matching element",However, I delete "w

Added a button, and somehow typed in the wrong view name apparently, then when i switched to a different object on the form to set another property, the entire form broke and i could no longer access any property and now the entire form will no longer open in the customization editor.. Can anyone suggest how I can get this resolved so i dont have to rebuild the entire form?  I am not an aspx expert and have been on a steep learning curve ever since we started in with Acumatica and frankly its disappointing.

Hi Acumatica Community, I just want to ask if there is a way to default the Inventory Source from Free Stock to Project Stock?Issues:Receipts : Transfers Thank you!

Hi guys,I’d like to use the report of “employee hours by project and task”, but when I choose an employee here as the owner, and click run report, what I got is an empty sheet. Does anyone happen to know how to use it? Or is there somewhere else I can extract the information of employee hours with detail in the form of report (I’ve tried the report of “employee hours”, it doesn’t contain the detail information I need)? Thank you all. 

Hello, I’m trying to create an import scenario that can update the kit specifications for some products. I have a generic inquiry that returns the current specifications of a stock item kit. I want to add these stock components to another kit and remove this line. The issue I run into is that there may be 3 items I want to add, yet the import scenario wants to remove the existing line for each row, but it doesn’t exist for 2 of them after the first one runs. Any way to work around this?  Business Case: We have non stock kit gift boxes we sell all year. During our busy holiday season, we pre-make a bunch of these kits and use a Stock Kit as the 1 “component”. When these premade boxes run out, I want this process to automatically change the stock components of the kit back to the individual components and not the stock kit. In this example, the 60005 SKU is a Non Stock Kit. The 40005 is the Stock Kit. In the import scenario, I want it to remove the 40005 item as a component and add these

Hi,How can we configure the Vendor Portal and what are the initial functionalities of the Vendor Portal? Thank You 

I don’t even have the Outlook plugin activated... C:\Program Files\Acumatica ERP\AcumaticaERP\FrontendSources>npm run build> build> node build-and-clean.jsexec error: Error: Command failed: gulp build[16:19:36] 'build' errored after 680 ms[16:19:36] Task finished with errors[16:19:33] Requiring external module ts-node/register[16:19:35] Using gulpfile C:\Program Files\Acumatica ERP\AcumaticaERP\FrontendSources\gulpfile.ts[16:19:35] Starting 'build'...[16:19:35] Starting 'outlookPlugin build'...[16:19:35] Starting 'screens build'...> outlook-plugin@0.1.0 build> webpack --env production> screen@0.1.0 build> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack -- --env productionnode:internal/modules/cjs/loader:1252  throw err;  ^Error: Cannot find module 'C:\Program Files\Acumatica ERP\AcumaticaERP\FrontendSources\outlook-plugin\node_modules\webpack\bin\webpack.js'    at Function._resolveFi

Hi Team, In Modern UI, how to add customization field in a existing detail grid column. Kindly guide me on this. Regards,Sakthi

Dear all,Please help us in this case:Vendor A is parent of Vendor B. Bills are issued from B, but we must pay to A (Parent of B)In Vendor Profile of Vendor B, we choose Vendor A in Parent Account field . But when we create payment to Vendor A, we cannot choose Open Bills of Vendor B.So How to set up to can pay to parent vendor for bills of child?Thanks and Best regards,

Hi everyone,I’ve been trying to retrieve data via OData using a Generic Inquiry (GI) with a parameter, but I’m running into some issues.In my GI, I’ve defined a parameter named PPeriod and when I use it in the Acumatica web UI (for example, entering "092025" for 09-2025), everything works fine — I get the expected result with EndDate as 2025-02-02, along with the correct data for document FCV002141.  GI parameter GI result enddate with 09-2025 and FCV002141However, when I call the same GI via OData in Postman using the same parameter, I receive a 200 OK response but it completely ignores the parameter and returns bad data :  Postman Odata result , dont take in account the parameter If I try with REST API, it work, but i need the odata .. Here’s what I’ve confirmed so far: The parameter is correctly defined in the metadata as: <Function Name="AR_Documents_PeriodSensitive"> <Parameter Name="PPeriod" Type="Edm.String" /> <ReturnType Type="Collection(GenericInquiry.AR_Docume

We have noticed that any payables/costs pending approval do not show under project transactions, even when the ‘Include Unreleased Transactions’ box is checked.  Is this a bug in the system or do we need to request this as a future system upgrade? 

Hi Guys, i want the Field CountryOfOrigin in the Soorder Detail Section. i tried it with a User Defined Field , but PXFormular is not working. namespace PX.Objects.SO{  public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>  {    #region UsrUrsprungsland    [PXDBString(200)]    [PXUIField(DisplayName="Ursprungsland")]    [PXFormula(typeof(Selector<SOLine.inventoryID,InventoryItemExt.CountryOfOrigin>))]      public virtual string UsrUrsprungsland { get; set; }    public abstract class usrUrsprungsland : PX.Data.BQL.BqlString.Field<usrUrsprungsland> { }    #endregion      }}   Hope u can help me.

I have a large import scenario that I need to amend, to prevent any issues while I do this I would ideally like to be able to duplicate the import scenario and then rename it to something unique so I have a backup essentially.Is this possible to do? I know I can export to XML but when importing I can’t see anyway of renaming / duplicating. 

I want to edit this bar at the bottom of the details tab of the sales order page. Is there a way to do this? I didn’t see anything in the Customization Project screen. 

I need to fill data in View 1 times when page is open. Not to reload it multiple time

Hello,Created some custom boolean fields, but they are not displaying as checkboxes in the sales order, despite the control type being checkbox…. They are showing as text edit fields, then if you put anything in there they change to 'true'

I have added a field called ‘Production Order No.’ which is meant to pull the production order number for the given line in Inventory Lot/ Serial History screen without having to click on reference number → go to manufacturing tab on issues screen → view production number. Field Production Order No. in Inventory Lot/ Serial History ScreenManufacturing Tab of Issues ScreenAccess Production Order NumberI have added the code however it pulls incorrect details for some inventory SKUs.namespace PX.Objects.IN{ public class InventoryLotSerInq_Extension : PXGraphExtension<PX.Objects.IN.InventoryLotSerInq> { #region Event Handlers protected virtual void INTranSplit_RowSelected(PXCache sender, PXRowSelectedEventArgs e) { if (e.Row == null) return; var row = (InventoryLotSerInq.INTranSplit)e.Row; if (string.IsNullOrEmpty(row.RefNbr) || string.IsNullOrEmpty(row.DocType)) return; PXTrace.WriteInformation($"

Hi all - I'm only new here and to the product.  Just hoping I could get some assistance with this.We have several filters for different things in our Invoice/Memo and Bills/Adjustment areas.  Just wondering is there a way we can get a total to that filter - screenshot below.  Thanks heaps.  

We are looking to restrict visibility to non project invoices.Looking for best practice on how to accomplish this as we are just rolling out Acumatica. Since the default “X” allows anyone to see the transactions we were looking at creating an “SG&A” project and restricting that project to only accounting / executives. Thinking we’d then have to put all our SG&A GL accounts into an account group.  But would there be a way to limit that account group to only be valid for this specific project? Maybe some sort of restriction group? Thanks!    

while creating formula in the formula master screen, qty in prod. volume unit and material type, qty. in prod. wt. unit, weight %, volume %-these fields are not auto filled. can someone help me how to fix this issue.

hello all,I was wondering if its possible without customization to fetch the Sales A/c from the Employee record instead of hard coding it to replace (Account origin)? 

Paylocity offers customized reports that can be created and exported. Those reports can then be used in a import scenario to upload into Acumatica the needed payroll information.Looking to automate the process more, has anyone had success in API connection or using other systems like Celigo to get what is needed for payroll processing?