Discussion Forums

Hello,      Every time, I run export by scenario, I got a fixed file name.        Can I make the file name generated with date as suffix?

Hi all, I’m struggling to get an OData connection from excel and Power BI.Both the below urls gives me what I expect when running them in a browser:https://{site.com}/ERP/odata/{Tenant}/https://{site.com}/ERP/odata/{Tenant}/{GI}But when I try to use the same urls in excel’s OData Feed I get the following error:We encountered an error while trying to connect.Details: "The field 'Branch' already exists in the record." Our version: Acumatica 2023 R2 Build 23.206.0006Any idea on how to solve this issue?

 We are running Acumatica version 23.206.0006. Our last update was a couple of months ago. After the upgrade, we noticed that the reports were taking more time to be printed, but it wasn’t a problem.However, for the past couple of weeks, some reports have been missing images from time to time. As a workaround, users need to reprint the reports. This issue is occurring with multiple reports. Note that all the reports are using sub-reports, but the complexity in some cases is not too high – for example, a report with two sub-reports and not many tables in the schema is having the issue. This is how the images are displayed when the reports fail: We have tested on different PCs and printers, so it is definitely something in Acumatica and we believe that could be related to a performance issue. CPU and memory usage on Acumatica are at normal levels. Has anyone experienced the same issue or have any idea where to look? Any idea is welcome!Thanks!

We are needing to import data from multiple sheets in the same excel workbook. However, we have been told that all data must be on the first sheet in order pull. Has anyone else experienced this? What was your solution?  Also, once you have hit the upload button a common settings box pops up. Does anyone know what the null value field represents? We haven’t been able to get a clear answer.  Thanks in advance for any help/clarification you can provide. 

Hello!I am creating a custom GI that aims to pull the Shipment Details by a given date. I want to show what inventory ID shipped out on what shipment along with the qty shipped and the shipping address. However, I am facing some trouble when I try to pull the shipping address onto the GI.I was able to join the SOOrder and SOShipmentAddress tables by joining the SOOrder.shipAddressID and SOShipmentAddress.AddressID fields (See below).However, it seems to pull the shipping address from the customer rather than the shipping address that is on the Sales Order or Shipment. We typically have to override the shipping address when entering a Sales Order, as we are in a business where a customer has many open job sites / warehouses to ship to.Does anyone know how we can get around the override and have the user-entered Ship-To address to come up in the GI? Thank you! 

How does one return to the original width of fields after clicking "Fit to Screen"?

i am trying to export an ACH batch to upload to my bank.Using the AP305000 Batch Payments screen getting the following error:The bank routing number specified for the vendor is invalid or empty. The number must be at least 8 digits. Verify the vendor's payment settings on the Vendors (AP303000) form. The Routing number is 9 digits and set properly in the Vendor Profile.Any idea why i am receiving this error and how to correct? thank you

I am running a GI which shows all GL Transactions from a particular ledger. These branches belong to one of three company groups. I need to be able to show the company group for each branch on the line on the GI.Is there a way in which one can link the branch to the organisation company groups? Many of the ‘related’ tables are hidden.Any suggestion would be appreciated. Thank you.

I would like to delete the value for the field  "restrict visibility to" from suppliers screen via an import scenario. Anyone knows how to do that? I tried to add a formula =’Null’ but I am getting an error message: Field: Restrict Visibility To, Value: Null, Error: 'VOrgBAccountID' cannot be found in the system.Many thanks, Patricia 

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