Discussion Forums

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.

We have two Acumatica Tenants.  The first Tenant is our live Production Acumatica Tenant.  The second Acumatica Tenant is our “test tenant” we use to train employees.   Our live Production tenant is connected to our live production Big Commerce Website.  I want to connect our second Acumatica Test Tenant to a second Big Commerce Sand box.  And leave this connection permantly in place to do testing.  Can I connect my Second Acumatica test tenant to a second Big Commerce website Sandbox?  Is there risk of polluting of messing up my orginal live connection?    

Hello Experts, I am stuck on one of the process and i am not getting a clear idea how to create a issue transaction  from a request. Actually i thought of using Business event but was unable to create, can anyone help me out from this .

Hello, I recently made a copy of a report and uploaded it to the server and it broke both the original and new report. All I did in the new report was hide fields. The steps I took are listed below. Am I missing something critical that would make both reports break? I would appreciate any advice you can give me.  -Download original report (PM651500)-Rename it and save it to another file location (new name PM651550)-Hide fields-Upload to the server with the new report name -Create the site map location copying the original except for changing the screen name to PM.65.15.50 and the URL to match the screen name -Grant access to the new screen  Thanks!

hello, I am trying to see a history of exports done by a user as well as see what data users are exporting is there a feature in acumatica that allows this.  

Is there a function that can be used in Import Scenarios to return the ISO 8601 Week Number (equivalent to Excel’s ISOWEEKNUM function) for any given date in the import file - or better still, the Acumatica WeekID , being the ISO week number in YYYYWW format for a given date?I’m trying to create an import scenario to append lines to Equipment Time Cards, but the source data only has date but not week ID.(Site is not using custom weeks).I’d rather not have to write a complicated nest of DateAdd this, DayOfWeek that, Year this, DateDiff that if I can avoid it!  

Hello Community, I had a question while performing a customization to auto update inventory during shipments of certain types. I thought I could just set the condition for Update IN during the confirmed state to true, but it doesn’t seem to allow me. How do I go about getting the “Auto-Run Allowed” enabled for me to set that auto run condition to true?Thanks,Adam

How to add link from Sharepoint’s file to Acumatica in every transactions. Please see the snip attached for your reference. Thank you. 

This seems like one of those simple requests.  I actually did this for the same client on SOLine but on CROpportunityProducts I’m not having any luck.This works when new line added to CROpportunityProducts: protected virtual void CROpportunityProducts_Quantity_FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e, PXFieldDefaulting baseEvent) { baseEvent?.Invoke(sender, e); CROpportunityProducts row = e.Row as CROpportunityProducts; if (row == null) return; if (!row.Quantity.HasValue && Base.IsImport != true) { e.NewValue = row.Quantity = 1M; } }But when inventory item is selected, quantity goes back to 0.  I saw there is an attribute (PXDBOpportunityProductQuantityAttribute) so I’ve attempted every combination of removing/overriding this using CacheAttached.  This doesn’t work: [PXDefault(TypeCode.Decimal, "0.0")] [PXUIField(DisplayName = "Quantity", Visib

When creating a Bill from a PO Receipt, sometime the PO Receipt Number hyperlink exists and sometimes it does not, and I cannot work out what causes it to be sometimes missing: