Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
My aim is to edit an entity which is selected by a Filter.The Filter DAC contains only unbound fields and does not have a DB table. It is marked with [PXHidden]In the graph there is the Filter, a View for the entity and the Save action: public PXFilter<FilterDAC> Filter;public SelectFrom<EntityDAC>.Where<EntityDAC.name.IsEqual<FilterDAC.name.FromCurrent>>>.View FilteredEntities;public PXSave<FilterDAC>; In the ASPX file I set Filter as PrimaryView of the DataSource and also as DataMember of the 1st form. A 2nd form with DataMember FilteredEntities to edit the entity.The Filter works fine and I can edit the entity. The error occurs if I press the save button. PXGraph.ExecuteUpdate with viewName = ‘FilteredEntities” throwsError: The table with the name 'FilterDAC' does not exist in the database.That’s true, but shouldn’t this be ignored if the DAC has atribute PXHidden? [PXHidden] public class FilterDAC : IBqlTable { [PXString(IsUnicode = t
Hi Experts,I have a data view called ‘ReportCredential’ in my PXGraph. I set ‘ReportCredential’ as a primary view for a PXFormView. Also I have a funtion called ‘reportCredential’. When the form is loading, I find the function will be called several times. Since I will call external web services in this function, I need this function to be called only once. Is there any other event handlers for the screen loading? The following is my code. Thanks,
Hello,I trying to add filter on subledgerID in report designer but always im getting an empty list (there is data in DB) Thanks for your feedback.
Hello!We created a extension pack for the screen EP305000 - Employee Timecards for the register “details”We renamed time to “Start” and added “Pause” and “End” as UsrFields which work fine so far.They are defined as dateandtime fields so that u can select a time from a list like 00:00 - 00:30…We would now like to add - inside of the grid right next to the “End” field - another field called “Summary” that calculates the actual Work time (UsrEnd - Start - UsrPause) for each added row.How would that be possible?I searched for it on Google but couldnt find a way. Yet i am a Rookie and don't know much about c# and coding til now. So any help would be appreciated that might lead to a solutionGreetings
Eg: I am trying to create a “Customer” related field in “Invoices” screen. Dear Friends,I am trying to create a custom “Related” field and it doesn’t work for some reason, so need your input. I created a new Customization Project, and in the Data Access section for Invoice, I created a new field: Lets say the Field name is “Shipping Customer”. I added the following as part of field attributes:[CustomerActive(Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName),Filterable=true, TabOrder=2)][PXUIField(DisplayName="ShippingCustomer")]Once the field is created, I added it to the Invoice Screen, and it appears fine (woohoo!). But when I save the Invoice, the field value is not getting saved into the DB. Any clues why? Thanks for your help!
Hello, I met an issue, I don’t know how serious it is. Because the system behavior looks OK. But It is indeed strange. Luckily, I got this issue on a test environment, but I still need help. I did some test on shipment workflow days ago. And it seems like something is broken. When I try to create a NEW shipment, the status is disappear, so the new shipment can not be saved. In Order to solve the above issue, I unpublished the issue customization projects and import a backup right 1 and republish. The status issue has solved. But Unfortunately, the “default workflow” is disappeared How can I add the default workflow back?
Hello Is Multi-Combo Select Available in Parameters in Report Designer? Thanks
I wrote a customization to add a link for any files uploaded to a SO Line item into a Production Order.It works, but I am breaking all kinds of rules. I am not supposed to update a cache or do BQL statements in the RowSelected handler. The goal is that each time a Production Order is opened on screen AM201500, I do a check against the SO Lines related to the Sales Order for that Production Order and create links to the “Files” on the Production Order. Each SO Line could have multiple attachments and we want those attachments available on the Production Order. Also, there is most likely a better way to accomplish this regardless of which handler I use, but this is the only way I know to do it. I would appreciate any inputs/critiques you might have. protected void _(Events.RowSelected<AMProdItem> e) { var row = (AMProdItem)e.Row; if (row.OrdNbr != null) { using (new PXConnectionScope()) {
Hello,Regarding the Attributes screen and setup (CS205000). This is a great way to add custom fields to something, such as business account profiles.However there a way to make attributes an option on the Activities screen, and for the individual Activity types?So that if Activity Type X is chosen, there is an option to add an attribute regarding that Activity Type.Is this possible?
I have created a Custom Filed on the Production Order called Job Number. Historically we have used this work with complex Parent Child issues (Yes I know we could use Product Number however we manually assign these job codes) I want the Job Number to auto populate on the linked order. What is the best way to accomplish this?
Hello,How do I customize the behavior of Role and Type under Relation tab of Business Account? I add new role via Automation Steps below but how can I default a Type based on Role selected? For example if IT Consultant is selected in Role the default Type is Prospect.
Hello, With other’s help, I was able to add a selector of employees on shipment screen.I’ve created an employeeclass (Which is referred to VendorClassID in DAC) named “PICKER”,I’d like to limit the selector only shows the employees from “PICKER”,I write the below code, but it gives out errors: [PXSelector(typeof(Search<EPEmployee.bAccountID,Where<EPEmployee.vendorClassID,Equal<"PICKER">>>), typeof(EPEmployee.acctCD), typeof(EPEmployee.acctName), typeof(EPEmployee.vendorClassID),SubstituteKey = typeof(EPEmployee.acctCD))] What is the right way to write the codes. Please advise. Thank you.
Hi,I developed one new Screen Consist of OrderNbr and RevisionNbr fields as two Primary Keys(Same as Kit Assembly/Specification revision Functionality).For first time I am able to save the data with OrderNbr -0001 and RevisionNbr-1.If I change the RevisionNbr as 2,Then I am Inserting Data of RevNbr-1 to RevNbr-2.But When I am saving OrderNbr -0001 and revisionNbr-2 error is getting ”Another Process has Added To TableName,Your changes will lost”.This error is Getting only in 20R2, But Its working in 19R2.Could you pls provide any solution to resolve this ?ThanksGiri.
Hello, Previously, I’ve added a caculation field on shipment, and it is non-persisted.Now, for reporting purpose, I’d like to make it as a DB persisted field. Is there an easy way to do it?
Hopefully this isn’t a repeat of something but… is there a way to add multiple Activities to a Sales Order’s Detail Line?In this particular case, I’d be inserting the data via an API so I’d have access to information not normally attainable by a user, like the actual id of the line and not just the sort or row number.It would be grand to be able to see/access this information by clicking on a custom icon per Detail Line but it would also be acceptable if the records were simply accessible by the Activity feature at the top of the SO screen. Thoughts? Has anyone already done something like this? ;-)
I have created a screen to change items in a sales order using a processing screenThe top of the form has two fields, the “From” item and the “To” item.When you kick off the PROCESS ALL, I need to have the values in those fields available to the process delegate. Since the UpdateOrders delegate is static, I don’t know how to get the from and to item numbers. I’ve tried creating public properties and setting the values of the properties on the rowselected event. But when UpdateOrders fires, and ultimately fires the UpdateOrder method, the properties are null. In the code below, I hard coded the inventoryID’s just to verify the code actually changes the sales order and it works great. I just don’t know how to access the values in the top of the screen in the code. ItemNumberToChangeFilter filterValues = Filter.Select(); returns nulls. Other than that, I’m almost done! :-) public PXFilter<ItemNumberToChangeFilter> Filter; public PXFilteredProcessingJoin<SOOrd
I have searched this forum and stackoverflow but I cannot find anything on how to hide the “Schedules” button on the processing screen. Does anyone have any way to do it?This has no effect:
Hello Everyone,We have specific requirement to increase the TaxZoneID length from size 10 to 30 from TaxZone table.Since, this field is having dependency with many table fields, unable to modify the length and giving SQL error is ALTER TABLE ALTER COLUMN taxzoneid failed because one or more objects access this column.. I know that we can drop the Foreign Key relationships and make it work but I don’t think this proper way of doing in Acumatica database. Hence posting this question here and seeking for help.Can you please help me with this?
I am going to create a program to allow a user to change an item number on all open Sales Orders. They want to do mass updates to change item numbers on SO’s.My plan is to create a process screen that would allow the user to select the item number to change in the header of the form as a filter. Then, a grid would be presented showing all SO’s that have that item number on it. They will have the option to select individual orders to change or “process all”.I think I should create a DAC that is made of all unbound fields as this does not require any custom tables and I will not be writing to any tables directly as I will be using the SO graph to do the changes. My DAC would just be used to create the view for the grid.Does that seem like the way to do this? Or, does anyone foresee any issues I would have creating a DAC using just unbound fields?Thanks!!Joe
Has anyone played around with tooltips and doing multiple lines. We want to add some helpful information for new sales reps to understand the different statuses of sales orders (and other fields). To do that, we want to put each status on a line of the tooltip for status along with a definition. The problem is that we can’t get any new line trick to work. We have tried all of the following without any luck. Any other suggestions? <br />&#013;&#010;\n
When we add a link to the “other information” field of an appointment, it is not clickable in the mobile app. It appears in the comment section, but when you touch to open the comment section, the entire field is editable and the link is not editable? What we are trying to do is provide a link to a project collaboration web tool that we have within the corresponding appointment in Acumatica (for the techs). Is there a way to do this at all without customization?
Hello Everyone,We are unable to login to Acumatica instance due to this error: The type initializer for 'PX.Data.PXCache' threw an exception.Can anyone help me to resolve this issue.Thanks in advanse.
Hi,I developed new screen. Inside that added one new Field “Labor Time Hrs” which consist of PXTimeList Attribute.Currently PXTimeList is showing up to 24:00 Hrs.How to customize that Field to show More than 24 Hrs in a Time dropdown.ThanksGiri.
Hello all, How would I go about changing the default value in the customization project for a specific field on a form? I though it would be under this section, but I haven’t had any luck so far.
I have created a new form tab screen(Project Sub Tasks) which consists of two tabs, Bill of Quantities and Sub Contractor quotes.What I would like to achieve is, when I have added a new record to one of the tabs, to write it to the project’s cost budget it’s associated with. I have tried the following code: // 1. Create an instance of the BLC (graph) ProjectEntry graph = PXGraph.CreateInstance<ProjectEntry>(); protected void _(Events.FieldUpdated<PMBillOfQuantity, PMBillOfQuantity.amount> e) { var row = (PMBillOfQuantity)e.Row; // 2. Create an instance of the DAC, set key field values (besides the ones whose values are generated by the system), // and insert the record into the cache PMCostBudget CB = new PMCostBudget(); CB.AccountGroupID = 35; CB = graph.CostBudget.Insert(CB); // 3. Set non-key field values and update the record in the cache CB.Amount = ro
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.