Discussion Forums

I have a sales order which has partial shipments.  My understanding is that If something in the order has shipped but not everything in the order has shipped, it should be in backorder status.So in this case the SO should show as ‘Back Order’, instead SO shows status as ‘Open’.   

Hi Community,Can you please help me with the sample to know which tab is selected. 

Hello!I want to update notes of Approvals tab in the Invoice form through and Import Scenario.  Is there any possibility doing this? Amanda 

Hello! I am using the formula below to calculate kit availability: =Floor((IsNull(  [INSiteStatus.QtyOnHand], 0 )  /  IIF( [INKitSpecStkDet.DfltCompQty] >0, [INKitSpecStkDet.DfltCompQty],1 )))I have a parameter for InventoryCD so user can search for the inventory ID if needed. The GI would run fine and there are records that show up, however, every time I click to search for an inventory ID, I receive the following error: I’m not sure I understand the error and what I need to change in the formula. Any help would be appreciated!Another note: originally the formula looks like: =Floor((IsNull(  [INSiteStatus.QtyAvail], 0 )  / IsNull( [INKitSpecStkDet.DfltCompQty], 1 )))This formula does not give me the above error, instead it gives a different error saying “Divide by zero error encountered.” 

Hi, I have a requirement where the values entered in the Attributes form need to be pulled into a custom form I make. So, I basically need a way to have a custom line level drop-down list field which contains all the values that are previously entered in the Attributes form. Any help regarding this would be appreciated.

Sorry for posting so many questions lately.  in my command, I want to get the first two characters of the screen ID. If it is SM, I want to exclude the record from the selection. cmd = new SelectFrom<UploadFileRevision>       .InnerJoin<UploadFile>.On<UploadFile.fileID.IsEqual<UploadFileRevision.fileID>>       .InnerJoin<ICSUploadFileView>.On<ICSUploadFileView.fileID.IsEqual<UploadFile.fileID>>       .LeftJoin<ICSSystemFiles>.On<ICSSystemFiles.systemFileName.IsEqual<UploadFile.name>>     .Where<UploadFile.primaryScreenID.IsNotNull.And<ICSSystemFiles.systemFileName.IsNull>     .And<Substring<UploadFile.primaryScreenID, int0, int2>.IsNotEqual<SMScreenConstant>>>     .View(this);I know Substring can be used in the predicate, but do you know of a way to do it in the subject of the Where? I am using a SQL View since you can do a field not in ("SM") in the where in SQL. I want to get rid of the need for

I made a processing screen.  In the grid, the file name is not selectable because it is read only (Inquire skin).I want the user to be able to copy the file name into their clipboard.  I’ve tried every trick I know and I cannot find a way to make that field so that you can select the text in it.  I’ve tried enabling the cache for the grid, enabling the FileName field in the grid, adding the field to the Fields in the project editor.  The reason this is important is that there might be 40 revisions of the same file and by copying/pasting the file name into the filter will limit the view to just those files/revisions.For example, I want to put “SO Import Sales Order Template.xlsx into the filter but I don’t want the user to have to type the name.I created a work around by creating an action to get the current row and set the file name in the filter to the file name in the grid.protected virtual IEnumerable copyFileName(PXAdapter adapter){ UploadFileRevision ufr = (UploadFileRevision)F

Hello,I have grid of DAC Collector on a custom screen Survey as following:I want the field Collector ID should be clickable as hyberlink and open record in related screen when clicking.The bahavior should look like same as Generic Inquiry: Field Collector ID is clickable and open screen Survey Response in details Any idea would be appreciated.Thank you

I have a Tab form. The main form and first tab sho details from DAC1. Tab 2 contains a grid for records from DAC2.I have the following views in my graph public SelectFrom<DAC1>.View DAC1;public SelectFrom<DAC1>.Where<DAC1.dac1ID.IsEqual<DAC1.dac1ID.FromCurrent>>.View DAC1Detail;public SelectFrom<DAC2>.Where<DAC2.dac1ID.IsEqual<DAC1.dac1ID.FromCurrent>>.View DAC2; The foreign key referecens in DAC2 is defined as #region Dax1ID[PXDBInt()][PXUIField(DisplayName = "DAX1 ID")]        [PXDefault(typeof(DAX1.dax1ID))][PXParent(typeof(SelectFrom<DAX1>.Where<DAX1.dax1ID.IsEqual<DAX2.dax1ID.FromCurrent>>))]public virtual int? Dax1ID { get; set; }public abstract class dax1ID : PX.Data.BQL.BqlInt.Field<dax1ID> { }#endregion If I add a new DAC1 and then save it and then edit the DAC2 grid all works well.If I add a new DAC1 edit it, then add details to the DAC2 grid and then save it, the DAC2 records are assigned to the wrong dac1ID.

hi All, we have 35 items on a sales order and we need to create a production order of 35 qty ( all in one production order). when creating a production order system only creates 1 qty production order. on the create production order pop up screen I have made sure it is 35 but still only creates 1. is there any setting we might have missed? ThanksGhazal 

I am not sure what I have done wrong but when I try to enter a new record for this custom DAC the key field blanks as soon as I am done entering and change focus to any other field.My expectation is that the value entered would be the new key for the new record. Is this field annotated improperly ? Attached is the whole DAC      #region AssetCD [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC")] [PXDefault] [PXUIField(DisplayName = "Asset")] [PXSelector(typeof(Search<assetCD>), new Type[] { typeof(assetCD), typeof(assetTypeID), typeof(assetStatus), typeof(description), }, DescriptionField = typeof(description))] public virtual string AssetCD { get; set; } public abstract class assetCD : PX.Data.BQL.BqlString.Field<assetCD> { } #endregion 

We set up a REST API integration with our Acumatica account using Zapier and it works fine. We then tried connecting it to our sandbox account as well and it stopped working after a day. The error is that the connection timed out. We cannot connect from Zapier or web based Postman. Interestingly, we can connect from Postman desktop. The version on our sandbox account is 2022 R1.Is there some sort of setting on the sandbox that is blocking the requests?

Hi,I have an existing Generic Inquiry which provides a breakdown of employee costs by subaccount.  Please see the attached screenshot. The Inquiry currently displays a column with the amount by subaccount and the total for each employee.  I would like the total for each employee to exclude where a subaccount is equal to 1. I still want to retain the rows where the subaccount is to 1 so I don’t think I can use Parameters and Conditions to achieve this.I have been trying to use IIF and SUM in formula in the Results Grid but without success. Any assistance appreciated !

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share What you may have missed in the Acumatica Community! October, 2024 Acumatica Community Webinar - Managing Construction Budgets with Acumatica: From Setup to Execution - Wed, Nov 20, 9:00 AM - 10:00 AM (PST)Managing construction budgets doesn’t have to be complicated! Join us for this webinar to learn how to set up, monitor, and adjust your budgets to keep financial control in check. We’ll cover configuring budgets, tracking actual costs, making revisions, and setting up Acumatica’s budget alerts to help you catch overspending before it happens.Presented by @iqraharrison  How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is nee

We often have purchases orders which will have multiple shipments going to many different addresses (warehouse, jobsite, hotel, contractors), depending on the current situation. We don’t know where each item will be shipped when we set up the PO, and I don’t see any functionality to handle this though the ship to address anyway. My team’s request is to have a field on the line item to note where product will be shipped (not full address), and also a field for the tracking information. I searched and did not see anything that dealt with this particular issue. It seems like the only option is to add two individual text fields to the PO detail line that can be extracted for reporting and research.I don’t believe the line note function will be adequate as each would have to be opened individual when you are in the PO. Has anyone else had to deal with this and come up with a solution? 

Our Lien Waivers have two trailing zeros.

Hello! I am looking to use import scenario to restart the Full-Text search feature daily during non-production hours. I believe I can create an import scenario for the ‘Restart’ button in More menu in the Rebuild Full Text Seach index screen. What would my data provider be in this case since I’m not importing from excel and I don’t have a GI to use? Do I need to create GI for this?  

Hello, Is there any way to delete a discount line from a sales order that has been imported from Shopify? I have full permissions in Acumatica, but the X is greyed out. Very rarely, discounts are duplicated during the import from Shopify, such as the example screenshot. This also may be an issue with the connector, but I’m not seeing anything on how to fix that either. Any suggestions are appreciated! 

Hello Esteemed Partners!ProjectManager is hosting a partner-facing webinar on 11/19. ProjectManager is the project planning and resource management tool that is now included in the new Acumatica Professional Services Edition.Register here: Live Acumatica Webinar - ProjectManagerJoin the webinar to explore the native ProjectManager and Acumatica integration and how it enhances project planning, resource management, and financial tracking. Discover how this powerful tool streamlines operations and empowers teams with real-time project insights for smarter decision-making. Don’t miss out!Thanks!Lauren

I am trying to make another version of the Multi Level Bom as a SQL View. The multi level bom doesnt have all the information that we need on it and I cant join tables on it. So I am creating a Sql view with a recursive statement to explode the boms. It needs to have a parameter in the anchor for it to work correctly and to keep it from bogging down the system with trying to do it for everything. How would I go about loading it into acumatica with a “Blank” for this field so that it could be filled out using the parameter from a report or a GI parameter? Screen shot below of my sql statement with the area im talking about highlighted. Doing it this way, would give me the ability to have any or all information from the tables in the joined in the below query. The information is currently limited to make it easier for testing. 

I have a customer with over 157K files in the UploadFile table.  For reasons they know, they upload a LOT of files.  They also send thousands of invoices per month which creates PDF files as well.They are running out of diskspace and they asked me for a way to purge files in masse. I created a screen to do this.  But, I see that system images are being listed in my grid.  I have tried very hard to find a way to identify these image files as “system files” so they cannot be accidentally deleted.For example: I thought about restricting files created by admin, but that would mean they wouldn’t be able to purge attachments to emails from many years ago.Further down in the grid shown above, there is a file that I think they should be able to delete without any issues being created other than losing history: Strangely, the File Maintenance screen will let you delete these files.  They look to me like files that are needed by the core Acumatica site.  This is the “finger print” image.I will r

I have created a move transaction using moveentry in the manufacturing endpoint. The transaction is still open, I need to update the amount produced and update some of the attributes with additional information. When I send json through postman, I receive the response below.  The error states that “Line 2 of Move Transaction  requires Attribute ADDLSCRP”, the attributes are being sent in the proper order. Request:{ "BatchNbr": { "value": "MI000623" }, "Details": [ { "TransactionAttributes" : [ { "rowNumber": 1, "AttributeID": { "value": "OPER2" }, "Value" : { "value" : "2" } }, { "AttributeID": { "value": "ADDLSCRP" }, "Value" : { "value" : "8" }

Does anyone know how long it takes to implement the Acumatica Field Service Module? Anyone know of an advisor that can do it quickly and cost effectively? Thank You

I have a customization for the Sales Order graph that affects the Add Invoice process used by return orders. When a user selects an invoice line to be added (by checking the checkbox in the grid) it will automatically select additional lines that are related to the line selected.This is achieved using the FieldUpdated event for the InvoiceSplit.Selected field and a RequestRefresh() call on the invoiceSplits view. Everything was working fine in version 22R2, but in updating the package for 24R1 I am running into an issue with the select all grid control.When the select all check box in the grid header is selected, it selects every line but then it deselects the lines my code would select. Something similar happens when all lines are selected and the select all control is deselected. In that case it deselects all lines then selects the additional lines my code would select.I know I can turn off the select all option for the grid, but is there any other way to override how the select all

Does Acumatica allow us to bulk print the Pro Forma invoice? I would like to use the Created On date to generate a pdf file with all the Pro Forma’s from that date. I added it as a parameter and filter, but the form comes back blank.