Discussion Forums

I am trying to integrate a 3rd party address validation rest service into acumatica, is there any documentation on how to do that to using  the same workflow as avalara or vortex  plug-in 

I have been able to create an import scenario to save credit memos, but I cannot apply the credit memo to an invoice.I get a message“An error occurred during processing of the field Reference Nbr.: Error: 'Reference Nbr.' cannot be found in the system.”even through I am able to apply other credit memos to that invoice.Any ideas?  

In sales order I have the freight cost but freight cost is 0 in both shipment and AR Invoice.   

Hello,I wanted to add a custom column in SO3030PL that any invoice due date smaller than today’s date plus 5 days and the status of the invoice is “Open,” then it should say Past Due, otherwise it should say “Current.” Here is my IF statement that is working normally without considering the invoice status:=IIf([ARInvoice.DueDate] + Day( 5) < Today(), 'Past Due','Current') I just need help on how to add the invoice status to the statement. Also, I could not name the column. 

I am trying to compress the size of the content showing in the remittance area of the Check Form with Remittance.  I have that task completed.  My employer would like for me to squeeze as many lines into that section with smaller font sizes as possible, ideally between 30 and 40 entries being displayed.  I have the structure of the layout completed on the ap641000.rpx form in Designer.  I've checked all the field values and incremented them according to the pattern in the "canned" items on the report.  However, I am only successful in getting a total of 12 invoice item values to display.  The remaining items do show up on the form output, but "Invoice Date" shows zero, "Invoice Number" shows zero, and Invoice "Invoice Amt" and "Payment Amt" both show "0.00" instead of the appropriate values.  I have adjusted the Payment Method "Lines per Stub" to 33 since I have 33 items ready to be paid with a single check and listed in the remittance area.  Can the form not be manipulated in this way

Hello! Is there a way I can delete a new field I created in a customization project before it has been published? I tried to publish it but received the below error message and then tried to redo it by using the same field name and am now receiving duplicate error messages:  

Is there a way to block project insert when a customer is on credit hold status?

Not all stock items are showing on the IN2025PL.  They are visible on the IN202500 form.  I cannot figure out why this is happening.  I do not see it as a known item in 2024 R1, the part appears to be set up exactly as the visible parts.  The client is on 2024 R1 Build 24.111.0011. New stock item -Not on GI 

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?