Other Developer Topics

Just I upgraded my local dev instance to 24.207.0011 and my site landing page (and subsequent pages too) is displayed corrupted. See the below screenshot. I have tried re-installing Acumatica, resetting browser, using different browsers but still shows corrupted. Does anyone know what is happening?  

I already enable external file storage in my Local Instance. The problem is that when I’m going to move files to AWS S3, it cannot continue because there is an error (See attached file). Do you have any idea how to resolve this issue?  

Always Current tells me that I should update to 24.203.0023 from 23.211.0017 but when I do so I get an incompatibility error, what would be the jumps needed to end up in 24.203.0023?? Please help

Hi everyone,I wanted to take a moment and share some updates to the MVP program: Streamlining the Acumatica MVP Programs In the dynamic world of Acumatica, we have always valued the myriad talents that fuel our ecosystem. Over time, we've celebrated these contributions through two MVP programs: one for our skilled developers crafting custom solutions and another for the versatile professionals in roles like consulting, sales, and implementation. However, as we keep growing and adapting, it’s become clear that a more unified approach can better serve our community. So, we're excited to announce that we’re combining our two MVP programs into one. Why This Change? Unified Recognition: By merging into one program, we're acknowledging the diverse range of expertise within our community. Everyone, whether a developer, consultant, or sales expert, plays a pivotal role in Acumatica's progress, and this shift allows for more holistic recognition. Increased Networking Opportunities: A single MVP

Hi Everyone,I am currently facing an issue when inserting values into the database. The DAC has default values for certain fields, but whenever I insert new data, these default values are being overwritten, even though they should be retained automatically.Could you please advise on the best approach to ensure that the default values are respected during the insertion process, and are not affected by the data being inserted?Any assistance or guidance would be greatly appreciated.this my code int linenum = EstimatePriceBreaks.Select().Count(); AMEstimatePriceBreak PriceBreak = new AMEstimatePriceBreak {     EstimateID = row.EstimateID,     RevisionID = row.RevisionID,     LineNbr = (linenum + 1),     OrderQty = Total_Qty,     UnitCost = Total_Price,     CuryUnitCost = Total_Price,     CuryExtCost = sum,     ExtCost = sum }; EstimatePriceBreaks.Insert(PriceBreak); Base.Actions.PressSave(); Base.Caches.Clear();Thank you in advance for your time and support.

I am trying to create a business for when an Invoice is added to the SO-Invoice screen (SO3030PL).  The business event will check for a few conditions related to the invoice.  If those conditions are met, the Do Not Email checkbox for that invoice should be checked.  Here is what I have so far.The Business Event:Trigger Conditions:Subscribers:Action Execution:Keys:Field Values:Executed By Events: Any advice you can provide as to why the invoice will not update the Do Not Email field properly would be most appreciated.  Thank you guys in advance.

how to use ‘belong to’ filter in acumatica report design

 Trace:-CommonServiceLocator.ActivationExceptionActivation error occurred while trying to get instance of type IDacDescriptorProvider, key ""   at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args)   at CommonServiceLocator.ServiceLocatorImplBase.GetInstance(Type serviceType, String key)   at CommonServiceLocator.ServiceLocatorImplBase.GetInstance[TService]()   at PX.Common.ServiceLocatorExtensions.TryGetInstance[TService](IServiceLocator serviceLocator, String key, TService& service)   at PX.Data.PXGraph.GetDacDescriptor(IBqlTable dac, DacDescriptorCreationOptions customDescriptorCreationOptions)   at PX.Data.DacDescriptorUtils.GetNonEmptyDacDescriptor(PXGraph graph, IBqlTable dac, DacDescriptorCreationOptions dacDescriptorCreationOptions)   at PX.Data.DacDescriptorUtils.GetNonEmptyDacDescriptor(PXGraph graph, Object row, DacDescriptorCreationOptions dacDescriptorCreationOptions)   at PX.Data.DacDescriptorUtils.GetDacDes

I have create a new screen and showing wiki help of it, when I click on the (?) help button on my screen getting error ‘Object reference not set to an instance of an object.’   

We have created a special field for displaying the Inventory description on the Create Purchase Order screen (ID:PO505000).The standard Acumatica form will simply show the Inventory Item’s description field. However, since for special orders our customers frequently override the description on the sales order (or service order) we created an extension which is used in POCreate Graph.Basically, it will check to see if there is a value in the soline and use that if needed, and if not, it will take the inventory item’s description.The Field is defined as: #region UsrPOFixedDemandLineDescr public abstract class usrPOFixedDemandLineDescr : PX.Data.BQL.BqlString.Field<usrPOFixedDemandLineDescr> { } [PXString(256)] [PXUIField(DisplayName = "Line Description")] public virtual string UsrPOFixedDemandLineDescr { get; set; } #endregionThis is working fine in the PS505000 screen -- on my development computer.However, at the customer site, the field i

Hello,Is there a way to set/show expiration date on the sales order of type “QT (using order template Quote)? There is a way to setup a “Days to Keep” but looks like cannot be shown on the sales order screen.

Hello,One of our customers (only in one test tenant) is having this error populate when we try to go into the customer account via AR. It is only one customer and only in one tenant. All other customers in the tenant do not have this error.We usually do most transactions against this dummy customer account. I can’t be certain when this started occurring since the system has thus far allowed us to use the customer for sales orders/invoicing/payments/etc. Any help resolving this error would be greatly appreciated! 

Hi All,This is basically just a curiosity. We noticed that Acumatica automatically pads the InventoryCD field out to the maximum length in the database. We have the standard nvarchar(30) datatype for this key, so we typically have 15-20 characters of trailing whitespace.Is there a reason that this is the default functionality? It isn’t a really big deal since I can clean strings downstream, but it seems like an odd choice to me for a key field.Since it’s so easy to “fix” this, it seems like there must be a reason why they haven’t. Does anyone know if this feeds other functionality?Thanks,Aaron

I created a console application to test the API token behavior, how it works with multiple users and API limits. The console app does the following:Calls the token endpoint by passing username/password. It receives the token and does a GET appointment 50 records API call. There is 20 second wait Because our license has Max 20 API users limit, I am running the above steps for 22 users to verify the behavior. It run synchronously for one user after another, not in parallel.Observations:Sometimes I get the 200 status and Response “<script>window.open("/Main","_top");</script>” in Appointment Get call In the screen System Monitor → Active Users, I notice it always maintains 20 users list. It removes the oldest active user from the list. But still I can use the token of the user which is not in the Active User list anymore and make API calls.Questions:What is the reason for the error “<script>window.open("/Main","_top");</script>” ? I have a use case to build app whe

Has anybody had success creation an OData connection to Google AppSheet? I’m getting an error around metadata.   

Hi, I’m trying to create a unit test for my Extension Library, but getting the error “PX.Data.PXException : CS Error: Numbering ID is null”. Here is the code snippet: protected virtual OpportunityMaint PrepareGraph() { Setup<OpportunityMaint>( new CRSetup { OpportunityNumberingID = "OPPORTUNTY", QuoteNumberingID = "CRQUOTE", CaseNumberingID = "CASE", MassMailNumberingID = "MMAIL", CampaignNumberingID = "CAMPAIGN", }); var graph = PXGraph.CreateInstance<OpportunityMaint>(); return graph; } [Fact] public void CalculateMarkup() { //arrange OpportunityMaint graph = PrepareGraph(); var graphExt = graph.GetExtension<OpportunityMaint_Extension>(); CROpportunity item = (CROpportunity)graph.Caches[typeof(CROpportunity)].Insert( new CROpportunity { OpportunityID = "OP000401",

Hello all,I have been working with customization projects for some time, and I can’t quite seem to figure out why sometimes they publish to the database, sometimes to one tenant, and sometimes to multiple tenants? It seems to be almost random, and I can’t seem to find a pattern. I understand there is the “Publish to multiple tenants” option; however, when I do this in Test and publish to both Production and Test tenants, the projects sometimes don’t publish into the Production. The times they do publish into Production, they still seem to “live” in the Test Customization Projects screen and don’t update the customization projects in production. E.g.- I make edits to a side panel in Test, publish to Test and Prod. I go into the customization in Prod and the changes are not in the project; however, the side panel displays in Prod Acumatica where it needs to be.I have looked over the community, but I can’t seem figure out the best practice and explanation with these projects!Thanks,-RJ

Hi! I have this starting table which is called usrInventoryItem which shows inventory levels in my warehouse and bin locations:I want to end up with the following view which essentially shows what is on hand (any warehouse locations not equal to Hold) and what is on hold (any warehouse locations equal to Hold):  How can I create this view in SQL?

changing standard Shopify integration:I am stuck trying to find out where cbapi.Put<SalesOrder>(obj.Local, obj.LocalID)from SPSalesOrderProcessor class SaveBucketImport is defined in standard code.I can find only interfaceI need to override logic behind last line of codeClass SPSalesOrderProcessor        public override async Task SaveBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, string operation, CancellationToken cancellationToken = default)        {            MappedOrder obj = bucket.Order;            SalesOrder local = obj.Local;            SalesOrder presented = existing?.Local as SalesOrder;            BCBindingExt bindingExt = GetBindingExt<BCBindingExt>();            // If custom mapped orderType, this will prevent attempt to modify existing SO type and following error            if (existing != null)                obj.Local.OrderType = ((MappedOrder)existing).Local.OrderType;            SalesOrder impl;            DetailInfo[] oldDetails = obj.D

We are using the manufacturing edition. Reference is drawn to Transfer documents, Pick List and/or Shipment Confirmation. These documents are printed to confirm physical transfer of goods. The frequency of such transactions is quite high even on a daily basis. So, is it possible to connect a biometric device to replace a printed document in such a way that the person receiving the goods uses a biometric fingerprint signature instead of using a printed document (to confirm the transfer/receipt/handover)? These documents have to be filed and are rarely referred to again. The same can still be achieved by simply registering the transfer through an unique biometric signature attached to a particular document/record. This will save a lot of paper and print costs as well.Comments/suggestions and/or solutions are welcome!Manish

Hi,Anyone know why all DACs not showing in left side of this screen? I have tried to restart application but still its not showing. Can you help us on this? 

Hi Team,We are encountering an issue with the financial period. When we call the GetFinPeriodByDate method, the system returns an error indicating that the financial period for the specified date is not defined in the system. It suggests generating the financial period, even though the financial year is already open in our local environment.Could you please review this and suggest a solution    

Use Case: Tracking Adjusted Sales Order Line Items for External System SyncWe have a situation where customers need to view their sales orders on our website. Unfortunately, direct access to the API isn't feasible due to high traffic, so we need to sync the data. The challenge is that sales orders (SOs) are frequently adjusted — items are added or removed up until shipping. When items are "removed" from the SO, I need to reconcile these deletions in an external system.Goal: Capture deleted line items on Sales Orders to track and reconcile them with our external system. Initially, I considered using push notifications, but they can sometimes be unreliable (e.g., missed messages). Instead, I'm looking for a way to export all Sales Order Line items to an external table (Azure SQL Server) on a nightly or weekly basis. I’d then run a reconciliation job to manage the deletes.Current Approach & ChallengesI attempted an export scenario that includes NoteID, InventoryID, Branch Name, Create

Hi,i wonder if there is a documentation for the API the ReportDesigner uses to query, download and upload reports to an instance?We would like to create a tool to sync a local directory of reports with an instance. Instead of doing them one by one with ReportDesigner.RegardsPascal

I am using Acumatica 24R1 and using 'default' endpoint version '23.200.001' entity 'Customer' using Bearer token authentication using jQuery ajax method, getting error 'request has been blocked by CORS policy', Same I have tried with postman and MVC C# application it is workingwith the following payloadgrant_type:passwrd scope:api username:xx Password:XX Client_ID:xxxxxxx client_secret:xxxxxandURL:{{AcumaticaInstance}}/identity/connect/token Type:POSTget the Bearer token in response and pass the token in below GET request to get the dataURL:{{AcumaticaInstance}}/entity/default/23.200.001/Customer Type:GETWhen I tried this process with postman or MVC application using C#, above both API calling is workingWhen I tried this process whiling using jQuery ajax method getting error 'request been blocked by CORS policy'