Other Developer Topics
Recently active
Dear community, We are collecting feedback about technical webinars you’d like to see.Please leave a comment for the webinar you’d like to attend. Also, if you have other ideas for webinars, feel free to suggest.
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
