Discussion Forums

Hello, can we integrate the PageCount and PageIndex/PageOf variables into a Subreport? We aim to develop a Footer-Subreport for inclusion in all our reports. However, we encounter a challenge where the Page-Count consistently shows as 1 of 1, regardless of the actual number of pages in the report.So Main Report => Subreport  Inside of the Subreport: = Switch( [@Locale] = 'de-de', 'Seite'+' '+[@PageIndex]+' '+'von'+' '+[@PageCount], TRUE, 'Page'+' '+[@PageIndex]+' '+'of'+' '+[@PageCount] )  

Hello.Is there any way to eliminate by import scenario the warehouses whose source is none?I'm not familiar yet with how to delete things.Regards.

Hey all,I’m trying to work on the Lot/Serial Numbers report but its broken. As soon as I click on it, it gives an error message. I can’t even download a version. Any ideas?

Hi there, We wonder if anyone successfully set up gmail with OAuth2 method?  We have created the gmails credential, got the Client ID and the Client Secret. However, we get this error when sign in: Not sure, what step(s) we have missed?  Any advice would be greatly appreciated.  Thanks….

 I am trying to create a payment and apply it to a select Invoice. When I attempt it, I get the error message “The system failed to commit the Adjustments row.” Would love it if someone could help point out what I’m missing here. Below is a slightly edited version of the JSON request body...{ "ApplicationDate": { "value": "2021-01-16T00:00:00.000+05:00" }, "ApplicationHistory": [], "AppliedToDocuments": { "value": "73.07" }, "CardAccountNbr": { "value": "8888" }, "CashAccount": { "value": "" }, "CreditCardProcessingInfo": [], "CurrencyID": { "value": "USD" }, "CustomerID": { "value": "7656TSGDB" }, "Description": { "value": "" }, "DocumentsToApply": [ { "AmountPaid": { "value": "73.07" }, "BalanceWriteOff": { "value": null }, "CustomerOrder": { "value": "" }, "Description": { "value": "" }, "DocType

I have this customized selector attribute to filter Projects to the current customer on CRActivityMaint:public class DSRestrictActivityProjects_CRActivityMaint_Ext : PXGraphExtension<CRActivityMaint>{ [PXRemoveBaseAttribute(typeof(EPProjectAttribute))] [CustomerProjects] protected virtual void _(Events.CacheAttached<PMTimeActivity.projectID> e) { } public class CustomerProjects : PXCustomSelectorAttribute { public CustomerProjects() : base(typeof(PMProject.contractID), typeof(PMProject.contractCD), typeof(PMProject.description), typeof(PMProject.status)) { SubstituteKey = typeof(PMProject.contractCD); DescriptionField = typeof(PMProject.description); } public virtual IEnumerable GetRecords() { CRActivity activity = (CRActivity)_Graph.Views["CurrentActivity"].Cache.Current; if (activity is null || activity?.RefNo

Hello community. I had a question on a customization project I am working on. I have the code below where I am joining to quite a few other tables. When I am working in the code, am I able to reference the joined data or only the primary table? When I try to get Orders.Current to work it is only for SOOrder. Hoping I can somehow reference the data from the joins in my Orders view.        public PXFilteredProcessingJoin<SOOrder, RecertificationFilter,           InnerJoin<SOLine,               On<SOLine.orderType, Equal<SOOrder.orderType>,                   And<SOLine.orderNbr, Equal<SOOrder.orderNbr>,                   And<SOLine.orderType.IsEqual<SOOperation.receipt>>>>,           InnerJoin<SOShipLine,               On<SOLine.orderType, Equal<SOShipLine.origOrderType>,                   And<SOLine.orderNbr, Equal<SOShipLine.origOrderNbr>,                   And<SOShipLine.inventoryID, Equal<SOLine.inventoryID>,     

Hi.. new user to Acumatica. Does anyone know if Acumatica can print item labels and that sort of thing? I’m not talking shipping labels but something more like a tag for a product. Example… we have a part number for a product and we want to print a custom label that would have the part number, maybe a bar code and the price on the label… stuff like that. Is this possible? I have been looking all over the place in the software but can’t find anything like this.

Hi Everyone,I have added a Barcode field in the mobile app, but after successfully scanning the barcode, the cursor remains on the same field instead of moving to the next one.In the desktop version, I’ve implemented TabIndex, and it works as expected. However, this functionality is not working in the mobile app. Could you please provide your insights or suggestions on how to resolve this? add field "InventoryIDInventoryIDForScan"    {       special = BarCodeScan    }  

Hi, I am using cstr() function on Document column in generic inquiry as filter is not working on the column, but when I use cstr() GI is showing rows with a null value in the column. Below is the screenshot for reference of cstr() followed by GI screenshot Kindly suggest to resolve.  Screenshot of GI without using CStr()  

Any ideas how to prevent invoice from printing unless it is released?

Hello.We are having issues with barcodes generated from Report Designer.While we are able to scan these barcodes locally, the client cannot consistently scan them.For instance, on the production order form, they can scan some, but not others.And in General, the barcodes being printed are not crisp and clean.The client does not like the aesthetics of these slightly blurry barcodes.We have played with all of the barcode settings.  The image below is not the current settings, I am just including it here to show where we have been working. Are there any other settings/properties in Report Designer that could allow us to improve the quality of the barcodes being printed?

Hi,There is a way to enter multiple value in a filter?I tried , and ; without success..Thanks!

I have processed a PO Receipt via WMS and released it. I have exited the app and returned later to perform the Put Away transaction. This is not working for me. While in Put Away mode, I am prompted to enter the PO Receipt number. I do that and the system recognizes the number successfully. It prompts me for the item number so I enter it.When I enter the item number, I get the error below.  On the other hand, if I move to the Put Away transaction immediately after receiving, everything works appropriately. However, if these could happen sequentially in the receiving process, why would I not just receive to the final put away location?

I have created an import scenario to create matrix items automatically from the Template Item since the OOB import is not very good, especially for simpler single-variant scenarios and multiple classes with different attribute sets.However, I am having issues with the Custom Key created to lookup the Attribute Value ID on the ITEM CREATION grid (the line above and below Line Number row).Current Result:When I try to create a matrix item for the “OS” (One Size) attribute for an item, it simply selects and creates the first attribute value in the list:When I disable these two lines and hard code the Line Number row, the import works fine.Any issues noticed with the way I created the custom key? 

Hello!We’re migrating to Acumatica and trying to import contacts via an Import Scenario with an Excel spreadsheet as the data provider.Since we’re pulling these contacts from multiple sources, we don’t have a dedicated ID for each contact. Instead, we’re using the email address and account ID to identify “unique” contacts. Email addresses are non-unique across the set of contacts, but are unique for a particular Business Account. Basically, the same email address can be used for multiple contacts, as long as each of those contacts belongs to a different business account.We’re also still early in the migration, so it’s likely that we will need to import the spreadsheet multiple times as it is updated with new contacts or additional data for previously imported contacts.Unfortunately, I’m having trouble building an Import Scenario to accomplish this.Custom keys seem to be the way to go, but I get the following error when doing a test import of a single contact:Error: 'Contact' cannot be

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 How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. Aleks Iwan - Acumatica Community Featured Member for September 2024Meet Aleks Iwan our Acumatica Community Featured Member for September 2024. It’s great to have you as part of the Acumatica Community @aiwan! Upcoming September | October 2024 Acumatica User Group MeetupsSeptember 11th - Join the Utah Acumatica User Group a

Hi there,We can’t release AP retainage due to error message of “Error: Inserting  'AP Transactions' record raised at least one error. Please review the errors.Error: 'Subaccount' cannot be empty.”Below is the retainage image from original invoiceThe journal entry from original invoice. Could you please advise? Thank you. 

Based on the attachment provided, the "Select," "Prime," and "Enterprise" modules allow for a maximum of 5 additional tenants to be included. Given that we have 14 tenants, it seems we exceed the allowable number for any of these modules.Could you please confirm if there is any flexibility or exception that would allow us to include all 14 tenants in a single quotation under one of these modules ("Select," "Prime," or "Enterprise")? Alternatively, we would appreciate any guidance on the best approach to accommodate all 14 tenants within the current framework.

Is there any way to use the unit rate specified in Project Revenue Budget below as billing rate in TM billing? 

Hi everyone,I have a client who operates with an Acumatica SaaS with two tenants in a single instance: Tenant 1 (the trading company) and Tenant 2 (the manufacturer). The current setup is as follows:Tenant 1 purchases products from Tenant 2. Tenant 2 manufactures the products and makes them available to Tenant 1.Currently, Tenant 1 needs to view information on all shipments prepared by Tenant 2. I understand that it is not possible to view data from another tenant using a Generic Inquiry in Tenant 1.Users can only access their own tenant, so having them log into both tenants is not a viable option.Given this, what would be the best way to manage and view shipment data prepared in Tenant 2 from Tenant 1? I appreciate any suggestions based on your experience.Best regards,

I have code that I want to run after a long running operation completes, if a method in the long running operation returns ‘true’, to show a simple error message popup.PXLongOperation.WaitCompletion(key);PXLongOperation.WaitCompletion(key); seems to be what I need, but I can’t figure out what to use for the key. When I use ‘this’ as shown in the screenshow, it doesn’t find the long running operation and proceeds to skip over the error message code since the variable value will be null.What am I doing wrong here?

Hi, Is there a way to change the Placed-in Service date for several newly created assets while converting them from the purchase screen? I know you can manually change them, but when you are creating multiple units, it would be nice to have a way to do a mass update. :)  Any suggestion? Thank you

Is there a Monthly Sales Report by Ship to State? 

We need to build Import Scenario to upload Sales Categories to screen IN204060, but the screen is not available for selection in build 23.206, as you can see in this image:This is the screen in build 23.112, where we were able to import data to the Sales Categories:The screen itself is fully functional for manual data entry.Thanks for looking into this.