Get inspired and gain all the knowledge you need
Recently active
Hello, I’m looking for a way to count the color with the Generic Inquery, for example here, I want to count all the green case per line. Line 1 : 2 , Line 2 : 3 … This is the query for the green and orange color : I try a COUNT() but it didn’t work. Do you have an idea ?
Hello,I’m using the Salesforce Sync Provider and running into an issue with Person Accounts. Because they don’t have the Account Name field, but instead have Last Name as a requirement, when these records sync to Acumatica, they fail to sync any changes back up to Salesforce because this error. Has anyone who has used the Salesforce Sync had/solved this problem? I was thinking setting up some If’s in the export scenario with a boolean would work but I did not have any luck with that.
I am trying to create a new customer in Acumatica using the API URL https://acumatica.ipaas.com/AcumaticaERP/entity/default/22.200.001/Customer. The request body that I am using is as follows:{ "CustomerID": {"value": "Checking2"}, "CustomerName": {"value": "Aurangzeb"}, "CustomerClass": {"value": "LOCAL"}, "StatementCycleID": {"value": "EMO"}, "DiscTakenAcctID": {"value": "CHECKING"}}However, I am getting the following error message:"error": "Inserting 'Customer' record raised at least one error. Please review the errors.; DiscTakenAcctID: 'Cash Discount Account' cannot be empty."The DiscTakenAcctID field in the request body is set to the ID of a valid cash discount account. I am not sure why I am getting this error.Can anyone help me troubleshoot this issue?
Is there a way or method in Acumatica that can prevent people from backdating documents? I know closing periods prevents posting in past periods, but our Controller wants to prevent the dates from changing. He does daily reconciliation and it’s messing him up. For example, in AP. AP created a check on August 8. They did not process the check until August 14. When the controller runs the ending cash account balances on the 8th that check isn’t in there. Then it throws off his numbers when she posted it on the 14th.
Hi All, I am trying to update more than 2000 record of projects > mailing and printing tab> Mailing ID= Invoice to a specific email account. would you know the reason for my error? Thanks in advance for the helpGhazal
Where does the data such as ‘Qty on Hand’, ‘Available’ and ‘Available for Shipping’ come from and is there a way to highlight the verbiage if something is below a certain amount?
I'm curious if there is a way to offer this via PowerShell or otherwise. Essentially, if we were to need to shut down the application for whatever reason (upgrades, updates, etc) can we avoid having to cancel and re-adjust the times of automations that were missed during that time? The goal is to have the system come back online less stressed by a list of long running processes starting back up all at once.
In process of upgrade planning and was curious if anyone has an existing GI they could share that would list all of the GIs within the system so they can be quickly verified for upgrade testing?
hi! i have Client A who’s going through implementation and the first financial year starts on 1/1/2018 (monday) and Client B who’s financial year starts on 1/1/2021 (Friday). i was referring to the info related to custom week config which led me to believe that it’s related to the financial year but that’s not consistent with what i’m seeing between the two clients:on the time and expense preference screen, Client A’s week setting has a start date of Monday and Client B has a start day of Sunday. does anyone know what settings i need to change for the start day to change to Sunday for Client A without using the custom week configuration? i thought this was related to the work calendar however, Client A has work calendars that have Sunday as a working day and Client B does not have sunday as a working day. also, i want to add that Client A has Acumatica Payroll and Client B does not
Where do I put my Acumatica into Maintenance Mode so I can get a clean, no error snapshot?
Hi,Is it possible to hide a screen from the workspaces where it is displayed if a given feature is not enabled ?To describe my situation, I have a graph A and its extension B. public class A: PXGraph<A> { public SelectFrom<EAPInvoice>.Where<True.IsEqual<False>>.View emptyView; } public class B: PXGraphExtension<B> { #region Properties public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSetExt.myFeature>(); ... }A screen has been created using graph A and has been added to the “Payable” workspace. It uses fields from a DAC that also depend on the feature. public class MyDAC: IBqlTable { public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSetExt.myFeature>();…}When “myFeature” is disabled from CS100000, none of fields from the DAC are displayed ; that’s OK. However, the screen is always available in the “Payable” workspace whereas I’d like it not being
Is there a built in way to manage the Printers associated to User Profiles that doesn’t require the user themselves to do it? We have 7 shipping lanes with two printers each. One is for the Shipping Label and one is for the Shipment Confirmation (i.e. packing slip.) A warehouse employee may be assigned to different lanes (i.e. printers) day to day. It seems like I need to log in as each user, change their default printer (for the labels) and change the printer associated to the Shipment Confirmation in order to move them around. I created a GI against User / UserPreferences / NotificationSetupUserOverride, but I’m not able update the specific Printer fields. It looks like I’m going to need to write a customization to manage this in a scalable way, but before I went down that road, wanted to see if anyone had any better ideas. Thanks- Jacob.
are user rights required for outgoing email permission? if so, what are the steps to assign rights to user?
Does anyone know how or if it is even possible to set the Comments when uploading a file via the API?
Hello,I noticed that there’s an updated customization for lot/serial attributes for the 2023R1 Acumatica version:https://github.com/Acumatica/Acumatica-LotSerialNbrAttribute-2023R1-ONWARDHowever, I can’t find the file to download. What am I missing?Thanks!
