Other Developer Topics

Hi,I have to convert my translation of acumatica from English to Spanish(Mexico).I have a translation string file which has (1500 approx.) strings.Then I have import the excel sheet in the acumatica through translation dictionaries string.It get imported and converted.( after this I have save and log out from the acumatica)I have select the language Spanish at login page and again login in the acumatica.When I checked if all strings are converted or not, some of the strings where not converted which was mentioned in the excel sheet. When I try to convert this string in another language the same strings got converted in that language. Is this is problem regarding steps which was performed for translation stings (miss some steps)  or the format of excel sheet is not proper or if we import the large string files acumatica skips some of the strings or any other problem is there.I have checked in my code which has proper attributes , also Dac fields where properly given.As in Spanish some s

Attributes on DAC Field Properties Aggregator Attributes Aggregated Attributes ​Best Practices Use Cases and ExamplesHi Community,In this post I want to share with you an article on the attributes aggregation in Acumatica. Attributes on DAC Field Properties  In Acumatica, we use attributes to store common business and platform logic that does not depend on any particular screen or DAC. This post describes only Acumatica attributes derived from the PXEventSubscriberAttribute attribute. It is based on Acumatica ERP 2023 R1 although most approaches described in it could be applied to other versions of Acumatica ERP.You can view Acumatica attributes as features which you can add to DAC field properties. For example, attributes can add one of the following features:Specify data type for the field's interaction with the database and runtime using data type attributes like PXStringAttribute or PXDBStringAttribute Configure UI representation of the field with PXUIFieldAttribute Provide defa

I am doing a unit test of a customization for the accounts receivable module but I get the following error, I have already done the exercises of the pdf T280_Testing_Business_Logic_2023R2, can you help me? 

Does anyone have a solution for this? Very frequently, it will hang here and never finish. 

We have a user that recently had his email changed in Active Directory (the @ portion).This caused the users account in Acumatica to have all of it’s custom filters, favorites etc.. to be wiped out. As the user now has a new ‘login name’Is there anyway to get them back? Or apply them to the new account?

Can u plz help anyone tell me how to learn event handlers in Acumatica development side ? i am new to Acumatica. 

 Hey Acumatica Community,I'm looking for a way to customize the app theme so that only the color of the left menu is black, and the text and logos are white, but I'm not sure how to do it. Could anyone help me with this?  Please see the attached picture where I've highlighted the left bar in green. I want to change this section to black with white text. However, I'm unsure how to modify just this section without altering the background colors of other sections.Greetings

Hi everyone,In the SO301000 screen, I want one of the customised fields to remain accessible (enabled) for quotes, even when this document has been processed (Completed). I thought I could deal with this by using an event handler implemented in one of our SOOrderEntry graph extensions. public virtual void _(Events.RowSelected<SOOrder> e, PXRowSelected baseMethod) {    if (!(e.Row is SOOrder soOrder)) return;    baseMethod?.Invoke(e.Cache, e.Args);     if(SOBehavior.QT.Equals(soOrder.Behavior))     {         PXUIFieldAttribute.SetEnabled<SOOrderExt.myCustomField>(cache, soOrder, true);     }} Unfortunately, as you guess, it doesn't work. I suppose it is due to the workflow of this screen that disable all fields of SOOrder table when the status Completed is reached.           Is it possible to make my field accessible despite these settings?

How can I validate the tenant change to show a message, which class should I overwrite, because I have reviewed the login.cs since I thought it would check the logs and roles the same way, but it does not enter that way.

Hello. I have a problem with my Split Container. I can not see second graph in this containerASPX code: <px:PXSplitContainer runat="server" Orientation="Vertical" AllowResize="False" SplitterPosition="640" ID="gridContainer" BorderColor="Transparent" BorderWidth="14px" BorderStyle="Solid" Height="50%" Width="100%">    <Template1>        <px:PXGrid runat="server" SyncPosition="True" SkinID="DetailsInTab" ID="gridPackageDetailSplit" Caption="Contents of Selected Package">            <AutoSize Enabled="True" />            <Mode InitNewRow="True" />            <Levels>                <px:PXGridLevel DataMember="PackageDetailSplit">                    <RowTemplate>                        <px:PXSegmentMask runat="server" DataField="InventoryID" ID="edInventoryIDSplit" />                        <px:PXSegmentMask runat="server" DataField="SubItemID" ID="edSubItemIDSplit" />                        <px:PXTextEdit runat="server" Enabl

Anyone familiar with this?The correlation name 'InnerQuery_INSite' is specified multiple times in a FROM clause. 

Can we display images from Stock Items in Power BI? I have an OData feed that sends me the image URL, but all I get are the broken image tile symbols in my Power BI Reports.I am sending over links like: https://<MY INSTANCE NAME>/Frames/GetFile.ashx?fileID=668331C4-23A0-423F-A394-FD01CC97E868I’d love to have some fancy inventory reports come out of here if possible. I’m reading some stuff about images needing to be public, but I’m passing credentials already with OData, so I’m not quite sure where to go from here or if this isn’t an option at all with Acumatica.Hopefully someone else has had success wtih drawing an image from Acumatica into Power BI.Here is my column format:  Here is my broken output:  Thank you for your time and assistance!

On Purchase Orders Preferences Screen we wants to set manual number for Receipt Numbering SequencePurchase Orders PreferencesBut this settings give us an error while we click on Enter PO Receipt in purchase order screen.Purchase OrdersActually we need to enter customer number under under Purchase Receipts screen.Purchase ReceiptsVersion: Acumatica Cloud ERP 2023 R1 Build 23.115.0031

I am doing the T280_Testing_Business_Logic_2023R2 exercise but I get the following error:If I installed all the references that the PDF said, please help me.

Hello,As Acumatica grows and the needs of our customers and partners in the ecosystems, Acumatica has created an exclusive team to support your development needs. As a result, it is important to notify you that the policy guiding the rules of engagement for Development Support are no longer the same as they are for Product Support.To clarify when you should submit a request for Developer Support, versus Product Support, please visit this new Developer Support Policy page on the portal. Additional information such as SLAs and links to the related case type may also be found on the Developer Support Policy page. Helpful LinksDeveloper Support PolicySubmit a Case Requesting Developer SupportSubmit a Case Requesting Acumatica’s Assistance Creating Customization (a paid service offered by Acumatica) Thank you,The Developer Support Team

Hi everyone,I added a custom boolean field, say "myField", to the DAC ARDocumentRelease.ARInvoice in an extended DAC (ARInvoiceExt). Now, I need to customize in a graph extension the view "ARDocumentList" from the graph "ARDocumentRelease" so that it provides only the records (among the ones it natively returns) for which "myField" is not true.The problem is that this view has a delegate in the Acumatica ARDocumentRelease graph.I had overriden this delegate in my graph extension like this :public delegate IEnumerable ArdocumentlistDelegate();[PXOverride]public IEnumerable ardocumentlist(ArdocumentlistDelegate baseMethod){            var list = baseMethod();            return list.Cast<PXResult<BalancedARDocument, ARDocumentRelease.ARInvoice, ARDocumentRelease.ARPayment, Customer, ARAdjust>>()                .Where(it => true != it.GetItem<ARDocumentRelease.ARInvoice>().GetExtension<ARInvoiceExt>()?.myField);}This works quite fine but there is a perverse effec

When an Acumatica database table includes the DeletedDatabaseRecord field, records deleted from within the application are not removed from the database, but rather that field gets set to “true”/1 and the record is ignored by the application from that point forward.  At the time the record is marked as deleted, the LastModifiedDateTime field also gets updated, but to local time rather than UTC.This is causing problems for an incremental data extract job that uses the greatest last modified date/time from the previous extract as a filter on the next extract.As I look through our data, I see that this has been happening since we went live in 2020.Here’s a test I ran this morning:  Created 3 Time Activity records.  Then updated one and deleted one.  Note how the Created & Modified dates and times are as expected except that the Last Mod date on the deleted record is 5 hours earlier than the Created DateTime (I’m currently 5 hrs behind UTC, in US Central time currently under DST).FYI -

Hello. I have one question. How to better make next logicWhen pressing Create Shipment on Sales Order screen i want to create for each package row in right grid with quantiry that this package have  

Hello, We're encountering an issue with the mobile application when attempting to import more than one photo at a time. The photos enter an endless downloading state.   

Hello,I am modifying access rights by role and ran into an issue. Under the menu for files the user can open the menu. If the user clicks on edit they will be taken to the home page if they do not have the correct permissions.  I found that under access rights by role under Hidden. There are two file descriptions. What is the difference between File Maintenance and Files.  Thanks   

I added to the Scan Move screen a save command on the lowest level of detail on the screen (you scan items, then go to list of items and open the item, I added it on what is the item section for the mobile app) I am trying to make the save button show all the time.  currently it doesn’t show until you change something.  Is there a way to trick the mobile app to show the button all the time, Kind of like setting IsDirty = true for screen customization logic. As always thank you in advance.

I have encountered an issue where one of my clients cannot push payments to Acumatica.The client uses the Undeposited Funds account. Example of the request: {    "id": null,    "rowNumber": null,    "note": "TEST2024",    "custom": null,    "files": null,    "ApplicationDate": {        "value": "2024-03-06T14:33:28Z"    },    "LastModifiedDateTime": null,    "ApplicationHistory": null,    "AppliedToDocuments": null,    "CardAccountNbr": null,    "CashAccount": {        "value": "1499"    },    "CreditCardProcessingInfo": null,    "CurrencyID": {        "value": "USD"    },    "CustomerID": {        "value": "CUSTOM"    },    "Description": {        "value": "TEST2024"    },    "DocumentsToApply": [],    "Hold": null,    "OrdersToApply": null,    "PaymentAmount": {        "value": 571.76    },    "PaymentMethod": {        "value": "ACH HQ"    },    "PaymentRef": null,    "ReferenceNbr": null,    "Status": {        "value": "03-2024"    },    "Type": {        "value": "Payment"    },   

Hi everyone,I had implemented a web hook in 23R1 using the PX.Data.Webhooks.IWebhookHandler and I now attempt to upgrade my code to 23R2. In this version, the PX.Data.Webhooks.IWebhookHandler interface has been deprecated and I have to change my code so as to implement the interface PX.Api.Webhooks.IWebhookHandle instead. Does anyone has an exemple of webhook with this new interface ?Thank you

Hi,I’m currently working with a customer regarding their integration to retrieve Labor Cost Rate via REST API. Does this API endpoint use pagination like Employees(entity)? Do you have any API documentation? 

Hi Everyone, I'm having issues writing tests for code that use SelectFrom.I’m trying to set up a Unit test for the below method. public static List<KitSpec> GetKitSpecs(PXGraph graph, int? InventoryID) { var ksl = new List<KitSpec>(); var result = SelectFrom<INKitSpecStkDet>. InnerJoin<INKitSpecHdr>.On<INKitSpecHdr.revisionID.IsEqual<INKitSpecStkDet.revisionID> .And<INKitSpecHdr.kitInventoryID.IsEqual<INKitSpecStkDet.kitInventoryID>>>. InnerJoin<InventoryItem>.On<InventoryItem.inventoryID.IsEqual<INKitSpecStkDet.compInventoryID>>. Where<INKitSpecStkDet.kitInventoryID.IsEqual<@P.AsInt>. And<INKitSpecHdr.isActive.IsEqual<@P.AsBool>>. And<INKitSpecHdrExt.usrMAXXINDefault.IsEqual<@P.AsBool>>>. AggregateTo<GroupBy<INKitSpecStkDet.