Solved

I’m looking to create an easy way for our sales people to filter sales order based on info in the order description. Since that is a free text field, is it possible to create a parameter on a GI for it? 

Looking for some help/direction on adding the CRM function or tab to the service orders. We currently have it on the Opportunities but I do not have a way (that I know of) for tracking Marketing Campaign Success for service orders Thank you in advance! 

Hi Acumatica Community,i am pretty new to the acumatica universe and struggling with a GI i need to build. I try to enhance the vendor GI and i need to show the payment details (red lined) of the vendors, but since its a grid column and i dont really get any helpful result i am requesting your help.for the GI i joined the table like thisThanks for helping.

We’re trying to adjust permissions for some of our users to allow them to void payments when needed.The administrator role has access to a “Corrections” option with the ability to Void under it. What permission role is that under?Version: 22.207.0013Screen: CST.AR.30.20.00

We want to add the option to enter a Bill on the Mobile Workspace.On the Mobile Workspaces [AU220012] the Workspace ID for Payables is not visible.Possible workaround:Add a GI on the Mobile Workspaces MainpageI create a GI and selected Expose to the Mobile Application to view the Vendor Bills. On Acumatica you have the option for the GI to create a new bill as the Entry screen settings is set to Bills and Adjustments.This entry screen is not visible on the Mobile workspaceSecond workaround:Create a Dashboard that display the GI and display the dashboard on the mobile.Again the option to create a new Supplier invoice is not possible. How can this be achieved?  

Hello all,Do we have a function in Acumatica that we pass a date and returns the WeekID which is used in EPTimeCard.WeekID? The format of WeekID stored in DB I see is “YYYY##” which ## is a sequential counter. I see Acumatica is using EPWeekRaw that has some properties including Start and End Date but I need it opposite. I have the date and I need the equivalent WeekID. I can calculate the Week # but I want to be consistent with what Acumatica does. considering Acumatica has Custom Weeks 

Hello,       Our company are planning to do 2 kinds of business, storage service and distribution.For storage serivce, the inventory are NOT supposed to post to ledger, it is customer’s inventory. For distriution , the inventory will post to ledger and will be counted as COGS when issuing and invoicing.      So , to serve this need, we are planning to maintain the 2 kinds of business in 2 separated tenants.     Here comes the quesiton, How can we combine the P&L report and Balance sheet easily,or even automatically?

We have a client who does consignments on items and I am looking to see how others have handled this or if anyone has a direction on it?Thank you in advance. 

We’ve been using Power BI to connect to Generic Inquiries via OData for the past year. All of the sudden in the past few days we’ve received the following error message in Power BI: Anyone know what might be causing this and how to resolve the issue?I found this article that references a similar issue, but none of our GIs have a period (.) in the name so the solve offered in the article isn’t helpful in this case.

Hello, I am trying to write a GI that allows me to see the Default payment method and cash account for all vendors, and I am struggling to get there.Would anyone know which table i need to relate in order to show that? I am using the default Vendor GI as a starting point.

We’re using Shopify with AvaTax both in Acumatica and on Shopify.The sales orders come in fine with the correct tax and the correct state on the tax tab (i.e. if shipping to NJ, it will calculate NJ). However when it get’s to the invoice it recalculates the tax based on our warehouse (SC)

Does anyone know what causes the error.  I am using the Change ID function in receivables and I get this GL Error when I go to save the chage.

We are having this error when opening ComboxBox for Substatus under default workflow for Cases.Initially we thought customization could be causing the issue, we have unpublished the customization but are having the same issue again. Error suggests the key value cannot be null, we have checked the values and can see a null value, but there is no option to delete it. Have looked on project.xml for deleting the null value , but unfortunately don’t see this null value.  

Debug point not hit on the acumatica maint in 23R1 Version:23.105.0016

Does anyone know if there is an end user guide for the mobile app?  We are aware of documentation on the development side, but looking for something for the app users.Thanks,Laura

\Clock Entry Screen with ErrorI have an employee who clocked in and somehow the system clocked him in over 45 days ago.  Now...we cannot clock out and get an error message saying that the value is too lage (probably) for an Int32 field.  Normally we would clock the employee out and fix the clock entries on the Approve Clock Entries screen.  Any suggestions?  We’ve had to create a temporary employee for this employee to use while we figure this out.

Good day,Logged on this morning and the infamous Acumatica Homepage is gone. See below.  It is gone also on another Acumatica users.  My users are do focused; no one reached out.  Any way to get it back for now.  I am working custom dashboards however, they are not ready yet for each user.  

Hi,I want a custom selector on my project screen that functions the same way as the 'Owner' selector on the Project Quote screen. I have provided my code, and although I am getting a selector, it does not match the 'Owner' selector Of the Project Quote screen. #region UsrOwner public abstract class usrOwner : PX.Data.BQL.BqlInt.Field<usrOwner> { } [PXSelector(typeof(Search<Contact.contactID, Where<Contact.contactType, Equal<ContactTypesAttribute.person>, And<Contact.isActive, Equal<True>>>>), SubstituteKey = typeof(Contact.displayName), DescriptionField = typeof(Contact.fullName))] [PXDBInt(BqlField = typeof(CROpportunityRevision.ownerID))] [PXUIField(DisplayName = "Owner", Visibility = PXUIVisibility.SelectorVisible)] public virtual int? UsrOwner { get; set; } #endregionThe below mentioned data I want in my custom

Hello,Our customer has set up multiple system emails for different users in Sales, Accounts etc. But a default email is not set. I am wondering how emails when recovering password would be sent. Appreciate if the importance of having a separate default system email could be explained.Thank you

Hi guys,I’ve noticed that there’s Pending Approval Notification for EMP Time Cards, but we want another notification working as following: whenever a time card is rejected, the owner/Employee should receive an email that he/she should check the reason, revise it accordingly and resubmit. So far I couldn’t find it anywhere in “Time & Expenses Preferences”. Is it possible to achieve it?Thanks.

Our customer is asking the the AP Bills and Adjustment to be added their Mobile App.I have added to Mobile Workspace AU220012 but do not see on MobileWhat am I missing?Do I need a customization project ?Can someone provide the basic outline of this process 1 - 2 - 3? 

I got this error in event log of window server. So advice me what’s happened ? Event code: 3005 Event message: An unhandled exception has occurred. Event time: 12/06/23 16:46:57 Event time (UTC): 12/06/23 09:46:57 Event ID: 4659b5c279404d9a979b5c450dfdecd5 Event sequence: 1976 Event occurrence: 6 Event detail code: 0  Application information:     Application domain: /LM/W3SVC/16/ROOT-1-133310359607128823     Trust level: Full     Application Virtual Path: /     Application Path: C:\Program Files\Acumatica ERP\Medivet2022R2\     Machine name: MEDIVETSERVER  Process information:     Process ID: 3520     Process name: w3wp.exe     Account name: IIS APPPOOL\Medivet2022R2  Exception information:     Exception type: HttpException     Exception message: The remote host closed the connection. The error code is 0x800704CD.   at System.Web.Hosting.IIS7WorkerRequest.RaiseCommunicationError(Int32 result, Boolean throwOnDisconnect)   at System.Web.Hosting.IIS7WorkerRequest.ExplicitFlush()   at Syst

Hi,We are currently trying to create an import scenario to Reclassify Transactions - depending on the external ref / transaction description, the GL should be reclassified to specific branches. Looking for some help to get the import scenario working.Note that we cannot use the screen filters normally, since they only allow for one condition at a time, and no conditional replace. Doing it manually means to load, replace and process hundreds of unique refs/descriptions each one at a time.The import scenario is as follows:Current just trying to get the Load Transactions button working, so we have deactivated the other steps, but we are running into unspecified view errors. The data provider is not used. 

Hello All, I would like to ask for your help guys. How can I show in the report designer and generic inquiry the RELEASED DATE and RELEASED By?In the > Purchase Receipts          > Bills And Adjustment          > Checks and Payments         > Receipts        > Transfers        > Adjustment       > and others, all with release function/action  Thank you. I really need your help guys. 

I have a customer with a very highly customized Sales Order Invoice form and needs to find a solution for improving the performance of printing the report.  The customizations are specific to an Order Type - format 1 prints for “RO” orders and format 2 prints for all other order types. Creating 2 unique report formats is one option however we would like a solution where the system automatically selects the correct report when the print action is selected.Please let me know if you have any ideas.Thanks!!Michelle