Discussion Forums

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. 

I am trying to create an Import Scenario to import ACH information on a Vendor.  I am using Payment->Default Payment Settings->Payment Instructions to bring in the Account number, Beneficiary Name, Routing Number and Bank name.  Here is my import scenario. The error I am getting is that the 'PaymentMethodID' cannot be empty.Anyone have any ideas or have an example how you accomplished this? 

Hello,During the purchase receipt process we sometimes update the prices because during the time of PO and Receiving prices can fluctuate a little.  Is it possible to maintain the new updated prices for future orders after updating the prices. Thanks!

 HI all, I create the connected application for Gmail Integration in my tenant, and maintain the URI followed the steps in guide book.https://acumatica-builds.s3.amazonaws.com/builds/zip/software/addon/gmail/Acumatica-Gmail-User-Guide.pdfBut how come it shows 404 error when I try to authorize access in Gmail add-on?Is there any setting steps I missed or the URI is incorrect?   (In Acumatica 22R2 version) Thanks,David Lee

I want to retrieve the values of selected detail lines to invoke an action in Acumatica. Some values from the selected detail lines should be passed as parameters to open a custom screen in a popup. How can I retrieve the selected detail line information from a grid to use in an action in Acumatica?Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you!

I am trying to use a import to update emails on Contact.  What am I missing here ?I have the Contacts ID pulled from a GI21.115.0017 

Hello,I need to use an import scenario to add contacts to existing vendors.I am only adding “LAST NAME” and “EMAIL ADDRESS” for each vendor contact.My import scenario into the Contacts screen works without error.However, only the last contact in my data provider is actually added into Acumatica.I believe this has to do with the lines at the beginning with the (-1) that Acumatica normally adds automatically when you create a new import scenario.  It did not add those lines when I created this import scenario.Again, the import scenario says it processed all records and shows no errors.  However, only the last contact shows in Acumatica. 

Hello all,I have been trying to import Customer Contacts but only my last contact is getting added out of 5 of them. Below is the import scenario:FYI, when I try to search for the Contacts (CR302000) form in the Universal Search Bar, it doesnt list the screen, due to license restrictions, as its not purchased. But still I am able to access the contacts form if I click on any of the contacts from the Customers (AR303000) screen → Contacts tab.We do have the option the create a contact on the Customers screen but how shall I build an import scneario for the same? 

Hi Acumatica experts,Hope you are doing well.I have a requirement to add an auto-complete feature to a custom column within an existing selector.For example, in the Inventory ID selector, I have added a custom column to the selector. I would like this custom column to use the auto-complete feature so that when I type text contained in this custom column, suggestions will appear without clicking on search icon, just as they currently do for Inventory ID and Description. I understand that these fields are key fields, which is why suggestions are available for them by default. I’m looking for a way to make my custom column support auto-complete suggestions as well.Your insights on this would be greatly appreciated.