Discussion Forums

Hi team,We need to increase the length of the 'Equipment Type' field. Currently, it is set to 15 characters, but we want to save up to 30 characters.We replaced the code as shown in the attached screenshot.After making this change, we successfully added the 30-character limit. However, if we select an attribute in the Attribute tab, the value automatically becomes blank after saving. Please provide a solution to address this customization issue. Regards,Sagar

I have a Projection DAC (HCLEPEmployeeTraining) that only has 3 bound fields (EmployeeID, CourseID, ExpiryDate). What I would like to do is to show the EmployeeID in Rows, value of the CourseID as Columns and ExpiryDate as value in the intersection of EmployeeID and CourseID. This is a Grid and not a PivotTable but basically, I am making a PivotTable from these three columns. I am not using Acumatica’s Pivot Table because I have further developments on this screen. So far, I have added the CourseIDs as Columns dynamically to my grid.See below screenshot from the Screen columns dynamically are added in my Graph Constructor and Code-behind the Page.Init.Also, I have written a view Delegate that loops through the existing records and sets the Dynamically Created Columns values from the ExpiryDate. See the below Delegate: protected IEnumerable HCLemployeeTraining() { List<HCLEPEmployeeTraining> result = new List<HCLEPEmployeeTraining>(); PXRe

Is there a way in Acumatica to create a Shipment without a Sales Order? For example, we want to create a shipment for a personal item - could be a nonstock item or stock item but no sales order just a request to ship to a location. 

I'm experiencing an issue with field level auditing in the account payable preferences. I have enabled field level auditing in the enable/disable feature and also checked the related table of AP preferences. However, when I try to tick and untick some setup, there are no changes shown. Here are the steps I've taken so far:Enabled field level auditing in the enable/disable feature Checked the related table of AP preferences and set it to active Despite taking these steps, I'm not seeing any changes when I make updates to the setup. Has anyone else experienced this issue? Are there any additional steps I need to take to get field level auditing working in account payable preferences? When I tried another preference, specifically the Tax Preference Setup (TX103000), and made changes to it, the field audit is working.  

I have setup a BE with a GI so when the appointment closed status,  it will email a notification. It is working fine if the appointment changes to Closed status. However, if after Closed, users Unclose it and Closed it again for multiple time and it will also trigger the BI multiple times. How do I make it to trigger only 1 time? I tried using Once for all records but it is not working. Can anyone explain how do we use Once for All records? and what is the difference with For Each Record? Thank you. 

I am using MYOB Advanced (Australia’s Acumatica).  I have setup and successfully tested SMS notification which is based on Service Orders (FS.30.01.00) on a user defined field called “Service Status”.   I was able to get an SMS for the change in the status.However, the SMS notification only worked once and does not get triggered after this.  There are 3 Business Events.  One where the Phone type = Cell, Old value = New and New Value = Booked in.  Another Business even is Phone type= Cell, Old Value = Booked in and New Value = Repairs in Progress.  The last business event is New Value = Ready for Despatch/ Pickup (this would be from any other status as this is the last status).Business Event History doesn’t show any errors and there is nothing for the business events.

Hi, there are a few options for defining the format of a lot number but I need to try and extend the options. The screen shot below shows a date based setup. This leads to a lot number like 2408In the INLotSerClass table on the database you can see the format, which is : {0:yy}{0:dd}I want to add a new option called DayOfYear, there are a few challenges to getting this into the UI but if this worked I might end up with a format like {0:yy}{0:w} and this would provide a lot number like 24221w isn’t a valid datetime formatting string so I would need to adjust the Acumatica code. In the Acumatica source code in class Attribute.cs I can see that GetNextNumber is how the format is translated into a value to create a lot number. The code is below.public static string GetNextNumber(PXCache sender, INLotSerClass lsClass, ILotSerNumVal lotSerNum){ string numval = new string('0', GetNumberLength(lotSerNum)); return string.Format(lsClass.LotSerFormatStr, sender.Graph.Accessinfo.BusinessDate, numv

Hello Everyone, we are trying to associate Credit Memo with sales order, I have created an SO extension graph and in persist inserting the credit memo details based on the order total, with this approach if we are creating an order manually and saving, the implementation is working as expected. But when any order is synced from BigCommerce, it is not updating as expected and we observed discrepancies in Credit Memo applied to order total and balance amount.public class KNBCBRSOOrderEntryExt : PXGraphExtension<SOOrderEntry> { public static bool IsActive() { return true; } #region Views public PXSelect<Customer> CustomerUpdate; #endregion public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate del) { del(); List<ARInvoice> curyDocBalList = PXSelect<ARInvoice, Where<ARInvoice.docType, Equal<ARDocType.creditMemo>,

Is there a way to set a minimum purchase order amount per vendor with Acumatica?

Has anyone seen this error? “An error occurred while polling the print queue: Value cannot be null”This is the error shown from device hub on the end user’s computer, but sounds like the file or a related field data is just missing when device hub is trying to poll it to print.  This is occurring when trying to print shipping labels.  I may restart Acumatica to see if it clears the queue and new documents succeed.

hello all,Can anyone guide me as where can I find the Reorder level/point or safety stock in Stock Items screen. I know it can be found under Inventory Planning tab, but this tab only gets enabled if the Manufacturing feature is disabled. Now I have Manufacturing as the required one, so where can I find the reorder level or safety stock in the same screen?24R1.

EP507030 & EP507010For now someone can go and choose any other employee in “Approver” and approve, is it possible to restrict this? from the company tree or something else? Did I miss something?Thanks!

In the image below, our stock item has a base UOM of EACH and weighs 3060 LB so we added a UOM Conversion. Our Price is 3.59 per LB. When the sales order is placed for 1x EACH I would expect the price to be $10985.40 but shows up as $0. This behavior does not seem to be the same if Base UOM is LB and the conversion is to EACH.  Can anyone tell me why this setup is not working?    

Hello all,I am experiencing weird behavior with “DailyFieldReportEntry” graph events. When we have a CacheAttached Event in a graph typically it is the first one triggered by the platform to override DAC properties. As you can see in the below code on the same DAC I have two events. Acumatica triggers the RowSelected Event and everything works in my code as expected but oddly the CacheAttached Event is not triggered at all. But logically it should have been triggered before any other event. In fact, when I put a break on it to trace, it never is been hit at any point. Any idea why this is happening?namespace Test{ public class TestDailyFieldReportEntryExt : PXGraphExtension<DailyFieldReportEntry_ApprovalWorkflow, DailyFieldReportEntry_Workflow, DailyFieldReportEntry> { public static bool IsActive() => true; protected virtual void _(Events.RowSelected<EPActivityApprove> e, PXRowSelected baseHandler) { //My Stuff } //My P

I have an incoming document that has a negative amount equal to the freight from the original document in the Detail Total even when I remove all the items in the Details Area. Is there something I can do to fix this? I’m not sure where it’s getting this amount from. 

How do I change the associated email with this forum account? I’m swapping companies and wish to move it to my personal email. I went into account settings etc and didn’t see anything about changing the email.

Hello, can we integrate the PageCount and PageIndex/PageOf variables into a Subreport? We aim to develop a Footer-Subreport for inclusion in all our reports. However, we encounter a challenge where the Page-Count consistently shows as 1 of 1, regardless of the actual number of pages in the report.So Main Report => Subreport  Inside of the Subreport: = Switch( [@Locale] = 'de-de', 'Seite'+' '+[@PageIndex]+' '+'von'+' '+[@PageCount], TRUE, 'Page'+' '+[@PageIndex]+' '+'of'+' '+[@PageCount] )  

Hello.Is there any way to eliminate by import scenario the warehouses whose source is none?I'm not familiar yet with how to delete things.Regards.

Hey all,I’m trying to work on the Lot/Serial Numbers report but its broken. As soon as I click on it, it gives an error message. I can’t even download a version. Any ideas?

Hi there, We wonder if anyone successfully set up gmail with OAuth2 method?  We have created the gmails credential, got the Client ID and the Client Secret. However, we get this error when sign in: Not sure, what step(s) we have missed?  Any advice would be greatly appreciated.  Thanks….

 I am trying to create a payment and apply it to a select Invoice. When I attempt it, I get the error message “The system failed to commit the Adjustments row.” Would love it if someone could help point out what I’m missing here. Below is a slightly edited version of the JSON request body...{ "ApplicationDate": { "value": "2021-01-16T00:00:00.000+05:00" }, "ApplicationHistory": [], "AppliedToDocuments": { "value": "73.07" }, "CardAccountNbr": { "value": "8888" }, "CashAccount": { "value": "" }, "CreditCardProcessingInfo": [], "CurrencyID": { "value": "USD" }, "CustomerID": { "value": "7656TSGDB" }, "Description": { "value": "" }, "DocumentsToApply": [ { "AmountPaid": { "value": "73.07" }, "BalanceWriteOff": { "value": null }, "CustomerOrder": { "value": "" }, "Description": { "value": "" }, "DocType

I have this customized selector attribute to filter Projects to the current customer on CRActivityMaint:public class DSRestrictActivityProjects_CRActivityMaint_Ext : PXGraphExtension<CRActivityMaint>{ [PXRemoveBaseAttribute(typeof(EPProjectAttribute))] [CustomerProjects] protected virtual void _(Events.CacheAttached<PMTimeActivity.projectID> e) { } public class CustomerProjects : PXCustomSelectorAttribute { public CustomerProjects() : base(typeof(PMProject.contractID), typeof(PMProject.contractCD), typeof(PMProject.description), typeof(PMProject.status)) { SubstituteKey = typeof(PMProject.contractCD); DescriptionField = typeof(PMProject.description); } public virtual IEnumerable GetRecords() { CRActivity activity = (CRActivity)_Graph.Views["CurrentActivity"].Cache.Current; if (activity is null || activity?.RefNo

Hello community. I had a question on a customization project I am working on. I have the code below where I am joining to quite a few other tables. When I am working in the code, am I able to reference the joined data or only the primary table? When I try to get Orders.Current to work it is only for SOOrder. Hoping I can somehow reference the data from the joins in my Orders view.        public PXFilteredProcessingJoin<SOOrder, RecertificationFilter,           InnerJoin<SOLine,               On<SOLine.orderType, Equal<SOOrder.orderType>,                   And<SOLine.orderNbr, Equal<SOOrder.orderNbr>,                   And<SOLine.orderType.IsEqual<SOOperation.receipt>>>>,           InnerJoin<SOShipLine,               On<SOLine.orderType, Equal<SOShipLine.origOrderType>,                   And<SOLine.orderNbr, Equal<SOShipLine.origOrderNbr>,                   And<SOShipLine.inventoryID, Equal<SOLine.inventoryID>,     

Hi.. new user to Acumatica. Does anyone know if Acumatica can print item labels and that sort of thing? I’m not talking shipping labels but something more like a tag for a product. Example… we have a part number for a product and we want to print a custom label that would have the part number, maybe a bar code and the price on the label… stuff like that. Is this possible? I have been looking all over the place in the software but can’t find anything like this.

Hi Everyone,I have added a Barcode field in the mobile app, but after successfully scanning the barcode, the cursor remains on the same field instead of moving to the next one.In the desktop version, I’ve implemented TabIndex, and it works as expected. However, this functionality is not working in the mobile app. Could you please provide your insights or suggestions on how to resolve this? add field "InventoryIDInventoryIDForScan"    {       special = BarCodeScan    }