Discussion Forums

In a report I had add a parameter as bellow. Here I need to list only the Vendors which Vendor.VendorClassID = ‘xyz’. But currently it loads all the vendors. How to apply a filtering condition to a parameter

Hello, I can see the Bill To on the Report Layout, and there are visible expressions.First header has:  =[FeaturesSet.VendorRelations]<>1 or [POOrder.PayToVendorID] = [POOrder.VendorID]Second header has: =[FeaturesSet.VendorRelations]=1 and [POOrder.PayToVendorID] <> [POOrder.VendorID] I understand the =1 and not =1, but can someone please explain what these mean? And what do I need to do to get the second header to show up with the Bill To? Thank you!

Hi All,This is basically just a curiosity. We noticed that Acumatica automatically pads the InventoryCD field out to the maximum length in the database. We have the standard nvarchar(30) datatype for this key, so we typically have 15-20 characters of trailing whitespace.Is there a reason that this is the default functionality? It isn’t a really big deal since I can clean strings downstream, but it seems like an odd choice to me for a key field.Since it’s so easy to “fix” this, it seems like there must be a reason why they haven’t. Does anyone know if this feeds other functionality?Thanks,Aaron

We have a bunch of stock items that are physically stocked in multiple locations between our Warehouse and Factory. Is there a way to create a GI that can show the Inventory ID, a totalized On-Hand qty, and its breakout quantities per the location its stocked in? I tried to use the InventorySummaryEnquiryResult table to pull in the Location IDs but no dice. Anything would help! Thank you!

Hello All, I have a custom screen that is built with a grid and allows deleting the row of the grid when a condition is met. I have had this code (sample below) for a while which worked fine but when the same code was upgraded to 24 R1 it stopped displaying the delete button on the row entirely. Can you please point out what could have changed with 24 R1? This code is both in the RowSelected of the header DAC and grid DAC:if (true) {this.Caches[typeof(DAC)].AllowInsert =this.Caches[typeof(DAC)].AllowUpdate =this.Caches[typeof(DAC)].AllowDelete = false;View.AllowDelete = false;View.AllowInsert = false;View.AllowUpdate = false;}else {this.Caches[typeof(DAC)].AllowInsert =this.Caches[typeof(DAC)].AllowUpdate =this.Caches[typeof(DAC)].AllowDelete = true;View.AllowDelete = true;View.AllowInsert = true;View.AllowUpdate = true;} 

Hi everyone,If you’re headed to Acumatica Summit 2025, we’re hosting an Ask the Experts session for the Distribution edition.  If you would like to submit your questions ahead of time, you can do so by posting them here:https://forms.office.com/r/AXBfc5E1YTYou’ll also be able to ask your questions live.Kelly and Dana will be facilitating the session this year and we look forward to meeting you in person!-Dana 

How can a Calendar Fiscal Year be changed to a Non-Standard Fiscal Year?

We are a civil construction company 80% done the implementation of our project. Is there shared knowledge on commonly used project profitability reports in construction. We dont want to reinvent the wheel here as there must already be a best practice which can be our starting point. Any help through sample files or or reosurce tips appreciated.

We purchased a new vehicle and I do not know where in Acumatica to enter it. Where do I find the Vehicle (FS203600) form?

I’m looking for ideas on a simple way to manage royalty fees that we will owe to a 3rd party licensing agent for stock items we are purchasing from a vendor (a separate entity from the licensing agent). Ideally these costs would be added to the inventory asset value but also generate an accounts payable due to the third party anytime the inventory item is received. We do this in other cases, but in those situations the licensor is supplying us with a royalty tag that is applied to the stock item and we’re using manufacturing to assemble a new stock item from the item we purchase and the royalty tagIn this new situation, the vendor we purchase the stock item from will apply the royalty tag on our behalf, but we need the liability costs to hit our AP as soon as the goods are received.  I believe we might be able to use landed costs, although that is somewhat complex to manage and I’m not sure it would automate the AP upon receipt. We could also dummy this by following the production work

Hello JAMIS Community,I am working on a project where I need to create Power BI reports based on data from JAMIS. To facilitate this, I plan to extract specific tables from JAMIS into an SQL Server database and connect Power BI to SQL for reporting.Could you help me understand the best practices for this process? Specifically:What are the recommended methods to extract data from JAMIS into SQL Server?Does JAMIS provide direct access to the database via ODBC/JDBC, or is OData the preferred approach for exporting tables?thank you!

Has anyone been able to delete GL Access Groups that were created within Row Level Security?

I’m trying to create a generic inquiry which should display the attribute values of a specific attribute. I left joined the Customers table to the CSAnswers table and added a condition to limit attributes to the specific attribute I’m interested in.However, I’m only getting customers that have a value for that attribute. How can I get a list of all customers including ones that don’t have any value for that attribute?

We’ve been working on an integration to Acumatica utilizing a mixture of Web Service APIs and OData queries. After some testing we seem to be running into some issues with concurrency. We seem to hit our limit of 6. This seems unusable considering if we have 10 people view an item on the site the first 6 api calls would succeed but the other 4 will have to wait.Is there a way to get more concurrent requests with this license? e.g. would having multiple api users increase concurrency? Do OData calls count towards the limit? How hard/how expensive for our clients to get a license with 1000+ concurrency? or is that something Acumatica even offers

Does anyone notice this? If we have an Unit Price entered first in Change Request and then enter the Unit Cost, the Unit Price will be overriden to the same as Unit Cost. 

Out business is a seed company and by law we are required to track 15+ “attributes” for each seed lot that we receive from a supplier. On top of that seed needs to be retested every 6 months and those attributes updated.Is there a way to track this info in ACU in such a way that allows us to easily import/export information, update test results, and NOT have 15+ “attributes” for each lot of seed?

We wants to hide Create Payment button on sales order base on Finance TermsIn sales order we have Create Payment toolbar button  This should be hide if Financial terms = PP (Pre Payment)  I cannot able to access button in graph. So I try to add condition but I don’t know how to access in action. But this is not working.Can anyone suggest changes?

Is it possible to consolidate different companies in one statement report of receivables?The customer has multiple accounts but specifically wants to include just a few in the report, how is this possible

This software is from https://www.seagullscientific.com/ and it supports XML input.  Client needs to print various types of product labels and currently they use BarTender.  Do not want to write code or API’s.

Hi,I wanted to localize acumatica into another language. I followed steps in the below blog post and attempted to accomplish it in my local instance.https://asiablog.acumatica.com/2018/01/how-to-translate-acumatica.htmlHowever, in translation dictionaries, the operation is already completed but the string file is not downloaded to translate.I tried again by clicking collect strings but the string file wasn’t downloaded. I tested this in my local instance. Was that the issue or will there be another reason for that? Can someone help me with this?Thank you.

How would I go about updating user defined fields programmatically?I can’t find any examples or any documentation on how to do this. Found a post showing the below, but I need to update UDF fields on IN Issue, IN transfer and IN Receipts, and none of  them has Answers view.  // iterate attributes on case to set valuesvar answers = caseGraph.Answers.Select();using (var ts = new PXTransactionScope()){ foreach (CSAnswers att in answers) { if (att.AttributeID == "MYATTRIB") { att.Value = "My attribute value"; } } caseGraph.Answers.Cache.Update(answers); caseGraph.Task.Cache.Update(caseGraph.Case); caseGraph.Actions.PressSave(); ts.Complete();} 

We have a consolidation company which has a different calendar to the master calendar. When running the allocations for the branches in this company, the allocation process is using the master calendar and not the company calendar.For example: The company calendar period 01-2024 is the period 10-2023 in the master calendar. If the allocation is run for the period 01-2024, the batch period created from the allocation is  04-2024.When running these allocations one needs to use the master calendar relating to the company calendar: i.e. for period 01-2024 in the company, the period selected when running the allocation needs to be 12-2023.Is there a setting where one can specify which financial calendar should be used for the allocations in the selected company?

Hi, I need guidance in modifying the GI for Checks and Payments to include the remit to address information and invoice number that was paid on the check. Does anyone have a sample GI they can share or provide guidance on what table relations and data fields link to use to get this information. Thank you,Frances  

When I add a field to the ts PXView I get the following error. Sequence contains more than one matching elementAll other fields work as expected except the Template field. I am assuming it has something to do with the PXSelector but am not sure. Below is the PXView def@gridConfig({ preset: GridPreset.Details, syncPosition: true})export class Inspections extends PXView { CreateInspection: PXActionState; DocDate: PXFieldState; ProjectTask: PXFieldState; InspectionCD: PXFieldState; Template: PXFieldState;}  snippet from DAC defining template       #region Template        [PXDBInt]        [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]        [PXForeignReference(typeof(FK.Template))]        [PXUIField(DisplayName = "Type", Visibility = PXUIVisibility.SelectorVisible, Required = true)]        [PXSelector(               typeof(Search2<GPProjectInspectionTemplate.templateID,                   LeftJoin<GPProjectInspectionTemplateAssociations, On<GPProject

How do you create a default part in the product configurator?