Solved

Hi Acumatica Community,I want to create a report using a Generic Inquiry based on Issues Transactions.One of my requirements is to add Reason Codes as parametersPlease refer to my Generic Inquiry Configuration.But when I checked the report, Reason Code filter is not working.May we ask for your suggestion for the correct mapping for the Generic Inquiry?Thank you!

This should be easy but just can’t figure it out. How do I initiate a full database export of my acumatica instnace? 

Hi Team,We are experiencing an issue with the AR (Sales) Invoice Report. Whenever there is more than one tax, the total is not displayed. Please see the screenshots belowAs shown in the image below, when only GST is applied, the total is displayed correctly. However, if another tax is added, the total is not shown.Note: The taxes are coming from a sub-report.Could anyone please assist with this?

Hello, I am building a report to information on Qty needed for WO. Everything looks good when i join inventoryitem and Insitestatus. i wanted to get material uasage from AMMTran. the moment i join that all my totals begins to increase to a high figure that is impossible. 

Can we change the new color-coded statuses for those with color vision deficiency or is this something that would be able to be changed at a later date?

Hello Acumatica Community! We’ve run into a not good experience, issue with the latest Shopify connector for Acumatica (25R1). I’m hoping to get some insights from others who might be experiencing the same or confirm if this is an isolated problem on our end.What we observedBackground: We rely on metafields in Shopify and map another metafield from a Stock Item attribute via the connector.Normal behavior (pre-25R1): If a value existed in Shopify for one metafield, and another metafield was mapped from a Stock Item attribute, the “unmapped” metafield retained its value while the “mapped” metafield was updated as expected. Current issue (25R1): The connector now tries to update each metafield. And if there’s no mapped attribute for a metafield, connector clears it. This results in unintended data loss across the board, not just the mapped fields. Has anyone else experienced metafield data being cleared or reset by the 25R1 Shopify connector?

I am attempting to reprint a check using the same number in 25R1. I follow steps below but it reprints with the next number, not the same. What am I missing?After printing (without releasing), select “Reprint” action on the Release Payments screen, select the payment, and process. Status is changed to Pending Print.  Print / Process the payment again. Next number is assigned instead of the original. If I try to manually change, it errors saying the number already exists. Thanks in advance!

Hey y’all. I’ve been working in Acumatica for 2 years now and have really gotten a handle on GIs, Import/Exports, Reports, Business Events, etc. Now I’m working through the T200 pdf training and my lack of web dev experience is making me have to dig far too deep into every code snippet to fully get it. My background is in Panorama Classic (a dead language) and Python, so I understand the basic structures of a language. However, I find myself constantly going, ‘but why?’ in the training in a way that I know means I’m NEARLY there. Do you know any videos or other tutorials that might help me get up to speed on doing my first solo customizations? Do you have advice for getting through these trainings from nearly zero? -- Lunar

Hi community, I am trying to setup a few financial reports to email weekly out of the system, and I know I need to save the template and then schedule the template. The issue I am running into are the financial period parameters. Is there a way to set a template that dynamically pulls in the current financial period so that I can then put that template on a schedule? Otherwise, I don’t see a way around having to create a template for each period which wouldn’t work in the long run. Thank you,RJ

We’ve found a part on Create Purchase Order suggesting a order of 50 parts under IN Replanned. However, this part already has 88 units in stock, and SS is 10 and Reorder point is 20. Why is this part appearing here, and what does IN Replanned even mean?

Hi,We would like to disable the access to the (+) button for manual addition of new lines in Purchase Receipts. All lines should be linked to a PO.However, we do not want to take away the (x) button for deleting lines, since the Purchase Receipt may require amendments after being created from the Purchase Order.I have not been able to disable the (+) button without also disabling the (x) button, as the Delete access right also gives access to creating new lines. Any ideas on how to implement this restriction?

public class BZCustomerAttribute : CustomerAttribute{ public BZCustomerAttribute(Type search) : this(search, typeof(Customer.acctCD), typeof(Customer.acctName), typeof(Contact.phone1), typeof(Customer.primaryContactID), typeof(Customer.customerClassID), typeof(Address.addressLine1), typeof(Address.addressLine2), typeof(Address.postalCode), typeof(Address.city), typeof(Address.countryID), typeof(Location.taxRegistrationID), typeof(Customer.curyID), typeof(Contact.attention), typeof(Customer.customerClassID), typeof(Customer.status)) { } private readonly Type[] _fields; [PXHidden] [PXProjection(typeof(Select<Contact>))] public class Contact2 : Contact { } public BZCustomerAttribute(Type search, params Type[] fields) { Type genericTypeDefinition = search.GetGenericTypeDefinition(); Type[] genericArguments = search.GetGenericArguments(); Type type; if (genericTypeDefinition ==

I am trying to find out how to provide specific rights to user roles to allow them to create drilldowns just for their account. How can I do this?

i have an issue ..only the header of the shipment is imported without lines.Any help please ! Attached you could find the scenario.Version : Version 21.2.2303.133 [21.213.0038]Thx in advance.

Hi All, I have a scenario where GL journals have to be exported and imported in another ERP system. after the export we would like to mark these lines as being imported so they can be obvious on a GI. I can’t work out how to get the import scenario work using the same key module, batchnumber and line numbers. any hint would be much appreciated. What am I missing here ? error is not telling me muchThank you 

Users should be able to: Hover over text Select words or sentences Capture selected text for mapping to field Currently: The PDF loads successfully using PDF.js But it behaves like a static image Text hover/selection is not properly aligned or does not work correctly

Hi, I am trying to update the numbering sequence for the Projects screen, but I am running into the error shown below.  Here is what Segment 1 looks like. Is there anything that jumps out at you to justify why the above error was complaining about the format? Also, if I was to make a change to any of the attributes in the segment grid, I get the error that is shown below. Does this mean that I can’t make changes to this without making changes to the children first?  Let me know if you need any other information. Kind regards,Andrew

Hi,  I am adding a pop up note in one of the customer.  Should this pop up note can also be displayed when creating project?Currently it does not show the pop up note and wondering if this is just normal not showing up in creating project.  Thanks 

Hi, I’m trying to create a current time with =Now() and =NowUTC() for the UK time zone but GI gives me the same result for both functions. system not calculate daylight savings.I ran the GI at 11.40 am local time but GI gave 10.40 am for both =Now() and =NowUTC(). Please help to fix this.Thank you.Desh

Hi Community,I created a custom Acumatica screen, and I wanted to restrict users from deleting records.However, in my custom screen, the Delete action was not listed, so I couldn’t control it through access rights.

Hey everyone! 👋Quick question — what's the exact navigation path to access the tool Customization Project Editor in Acumatica?For context, I need to open and edit my customization projects, manage access rights, generic inquiries, and other project components.Could someone share the step-by-step menu navigation?Thanks in advance! 🙏

Hello Experts, I am unbale to figure out how to view the total number of production order with ageing category. I Tried creating GI but still facing problem how to group .Please let me know where am i missing .So my output result should look like:- 

Dear All,We are following the consigned inventory process in this articlehttps://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-1/ the default setting for the transfer receipt is transferred type 2-step, which means we have to create a Purchase Receipt for that transaction.is it possible to change it to 1-step? It means skip the step creating Purchase Receipt and auto release transferThanks in advance.Yên Chi

We are experiencing issues with push notifications firing successfully but not being received on the mobile app. This was first identified when our clients wanted to enable multi-factor authentication, and upon investigating, we found that in our demo environment we could successfully create notifications but we didn’t receive them either. Here is a test notification I created that fires successfully, but no notification is received. We tested with multiple mobile devices, all with the notifications turned on for the Acumatica app, but nothing is received and the system shows no errors??   

I’m trying to pull in the date and time a Sales Order was created for some metrics for my shipping department.  They have a cutoff time, where and order entered before the cut off time should be shipped same day.  When I look at the SOOrder table, it looks like I should be able to use SOORder.CreatedDateTime, but in the GI, I only see the date, not the time.  Is there a way to make the time exposed.  And maybe even better, a way to split the date and time?