Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Trying to figure out a solution to create shipments on multiple sales orders and print them all at once vs. going into each sales order individually and creating the shipment then using quick process. Ideas?
Howdy! I figured it might be wise for me to introduce myself before diving into my call for help… I’m a home brewed IT/Developer/Operations Manager that’s responsible for integrations between Acumatica and our internal systems that I’ve built over the years. I’m not a “professional” by any regard though I do great deal of practical experience with coding online applications, PHP, AngularJS, Classic ASP VB, MS SQL, etc. side note, I’m really enjoying and admire how Acumatica’s been built and functions. moving on… We’re currently in the process of rolling our Acumatica 2020 R2 for our company through a phased approach and will be utilizing multiple tenants for the purposes of development, training, etc, 5 in total including our live/production tenant. The idea is that we will, periodically, schedule a snapshot of our Live tenant and restore it into the other tenants.The users will be disabled in some tenants and enabled in other while others will have increased security access into one o
I am not a good programmer so please feel free to tell me all the things I could do better… :-)I am working in 2021R1.I have a field that I am validating to make sure that it does not exceed a total amount on the header record. My screen is functioning properly, but I should be getting a warning indicator, not an error.My RaiseExceptionHandling is set at the Warning level BUT, I get a red X on the screen. What am I doing wrong here? protected virtual void _(Events.FieldVerifying<GRGrantsCustomers, GRGrantsCustomers.allocatedAmount> e) { GRGrantsCustomers row = e.Row; GRGrants grant = Grant.Current; decimal? newValue = (decimal)e.Args.NewValue; decimal? total = 0; foreach (GRGrantsCustomers item in Customers.Select()) { total += item.AllocatedAmount; } if (total - row.AllocatedAmount + newValue > grant.GrantAmount) { decimal balanceB
Good day,I’ve been noticing some comments on database creation scripts such as 'sy_guid;' / 'si_autoincr;' / 'sy_boolean;', and have wondered what they mean/do.I think they might have something to do with easing things up when a DAC is generated via the Customization screen, but I’m probably completely wrong So… Does someone know what they mean, and more specifically, are there more ‘indicators’ like these that I can use?Thanks in advance.
Hello Everyone,I have created a custom inquiry screen with pagination, which will load the POReceipts by applying a few conditions.After applying the pagination code records are loaded very fast and working as expected expect the below scenario.Issue details.When I filter a grid column, it is filtering and showing only the current page records but the filter is NOT applying to all the records. Could you please help me with this?Ex: If I have total of 900 records and per page, if it is showing only 25 records. When I apply a filter to the grid column, it is filtering by taking only 25 records but NOT 900. When I debug, PXView.MaximumRows is taking 25 records and filtering them.Sample Pagination Code:[PXFilterable] public PXFilteredProcessing<Customer, FilterDAC, Where<Customer.bAccountID, Equal<Current<FilterDAC.customerID>>, Or<Current<FilterDAC.customerID>, IsNull>>> Records; public IEnumerable records() {
Good day,I'm attempting to select multiple shipments on the Create and Print Pick Lists (SO503050) form using the screen-based API, but only the last one in the list is ever selected when performing the Process action.I'm able to populate the Header Filter section and am getting the shipments (as per the specified filters) back in the Content result.I'm also able to generate a worksheet using the Process Action, however, it only contains the last shipment that was iterated over and not the 4 shipments that are expected.Am I missing something? What are the commands needed in order to select more than 1 shipment, so that the worksheet contains more than 1 shipment?Please see below for additional information & code blocks.Any and all assistance will be highly appreciated .--------------------------------------------------------------------------------------------As can be seen in the screenshot below, the iterative section of the code is able to iterate over all of the shipments that
Heyi would like to change a display name from a field within the attribute editorbut everytime i try to click on “Change Attributes” it shows i cant edit the attributes because the underlying field is a replacement. How can i edit it if this error message appears?i am looking since hours and cant find a solution.
Hello, I have created a new screen with a new graph, Also I have created an endpoint with this screen. The problem persists when i want to save a new record by this API. In fact if the table in the database is empty he create a new record but when i have one record he edit it. Best regards.
How can i override the process button in the Process order screen(SO501000)
As per the subject, if I create a custom data provider in a .cs file, can I ask support to place it in App_Code in the hosted environment? If not, how can I include it within a customization project so that it becomes available for use?
The grid portion of the screen is coming from APTran so I tried adding Branch to the grid. However, the column remains invisible. I tried forcing Visible to True but that didn’t make it appear.Is there additional logic that’s hiding out somewhere preventing the Branch column from appearing?
I’m looking for feedback/ideas/solutions on if it is possible in Acumatica to send out a sample order from an Opportunity without having to create a customer or business account.The goal is to not create accounts aimlessly that are not TRUE purchasing customers.
We have a requirement to scan multiple vendor lot nbr for scan lot nbr.we have design screen like thiswe have used scan material and we are able to successfully scan on the master grid and we are not able to scan data on the child grid. what is the best possible way to achieve this??
I am attempting to override Acumatica’s default Primary Item Validation logic. The base logic is done through an attribute, specifically the PrimaryItemRestrictorAttribute, which is subscribed to by the LocationAvailAttribute. So to override this, I made my own UsrPrimaryItemRestrictorAttribute and UsrLocationAvailAttributes, and figured I’d use the standard PXMergeAttributes attribute in the cache attached event in the graphs I would like to manipulate, effectively replacing the original attribute with my new ones on these screens. Below is an example of this in the INAdjustmentEntry graph. Remember the UsrLocationAvailAttributes subscribes to UsrPrimaryItemRestrictorAttribute. [PXMergeAttributes(Method = MergeMethod.Append)] [PXRemoveBaseAttribute(typeof(LocationAvailAttribute))] [UsrLocationAvail(typeof(INTran.inventoryID), typeof(INTran.subItemID), typeof(INTran.siteID), typeof(INTran.tranType), typeof(INTran.invtMult))] protected void INTran_LocationID_
Hi,We are trying to customize a screen but would like to have different versions of same screen depending on user access. But there is no command to copy a Screen as we can only select a screen to modify.Is there a way to copy a screen and save it as a different screen name? Thanks Mark
Good day,I would like to programmatically generate a Wave Pick List from the Create and Print Pick List (SO50305) screen.The idea is to fire off a push notification whenever a wave pick list’s status changes to picking, and then consume this notification in a webhook handler.I’ve managed to get the push notification setup, and the webhook handler is receiving the notifications nicely. So far I’ve managed to get some nice authentication working in the webhook handler (following the concepts in this webhook example), but I’m a little out of my depths w.r.t. how to actually achieve the goal of programmatically generating a wave picklist.From what I can gather, I would need to do 3 things in order to get this working:Set the SOPickingWorksheetProcess.HeaderFilter & SOPickingWorksheetProcess.HeaderSettings values (in such a way that subsequent requests/processes can pick the values up), so that the applicable shipments are filtered, and the number of pickers + totes are populated, etc.
Hello, We have a need to sort on shipment screen in the following way:1, fristly, sort by temperature zone, which is a customized field stands for the stocking area, like frozen area, fresh area, or dry area.2, Then in each temp zone, sorting by Order Qty, from largest to smallest. currently, as I checked, if I firstly sort by temp zone, then secondly it would sort by line nbr. ascending, like by default implicitly.Is there a way to customize on it? Thanks.
Hello Team,I did a customization for Terms (Sales Order) as below;<px:PXSelector Enabled="False" ID="edTermsID" runat="server" CommitChanges="False" DataField="TermsID" DataSourceID="ds" ></px:PXSelector>How to make TermsID Enable only for Role ‘Administrator’? Thanks,Idrus
Hello Just i wanna know, what does mean when it’s740:7499999999it’s an interval from 740 to 7499999999 ? Thanks !
Customization beginner here. How do I rename a data field on a screen? Looks like some changes were made from previous versions where this was done. In the example below, I simply want to rename this filed from the screen editor.
I would like to support barcode/cross-reference in the Inventory ID field on the Transfers screen.The POReceiptLine.inventoryID is decorated with [POReceiptLineInventory] which will do a lookup in the Cross-Reference table.The INTran table.inventoryID field is decorated with [StockItem] which doesn’t do a cross-reference lookup.Creating a field and giving it [CrossItem] will do a cross-reference lookup.I know that CrossItem and StockItem cannot be added at the same time. Is there an existing attribute that would allow me to replace the StockItem attribute on a field in a customization that would add cross-reference lookups like CrossItem allows for?
I’ve seen how I can add an inventory extension to dynamically create fields on the InventoryItem DAC for one or more attributes and that seems nice for Generic Inquiries.In my case I want to add an inventory item attribute to the SO Order Entry Document Details tab as a read-only field.I’m not sure of the best way to make that field in the SOLine DAC.
Hi,I understand that Acumatica has the ability to input batch/lot no. and expiry for products in the backend. However, i would to know how would it be possible to display it on my invoices for the various items when i print the invoices for delivery.We are in the medical consumables wholesale business, and each product or SKU has different batch/lot no. with different expiry dates.Looking forward to your good advise. Thank you.
Hello,I want to check the faisability of adding a new line typology in SOShipLine.For exemple, i want to add a TEXT typology in SOShipLine (without quantity, without price, without accounting imputation, without Business….) Just TEXT. Also I want to add different typology in the same table and keep the existing process of Line of shipment.Best regards.
Hi, I have extended Default/18.200.001 endpoint to include SubContracts like this http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/ I can retrieve all Subcontracts, but I would like to filter to get 1 SubContract back as it will hit the max size limit eventually. Is there a way to do this like its possible to do with Vendors http://localhost/[sitename]/entity/Default/17.200.001/Vendor/AAVENDOR?$expand=MainContact ? Additional notes:This is what I have currently and it works except it returns all subcontractshttp://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/ I would like to have it working like vendors to filter to a subcontract like sohttp://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/SC00001 to retrieve only subcontract SC00001and http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/SC00001?$expand=DocDetails to retrieve only subcontract SC00001 and expand DocDetails. Thanks in AdvanceMark
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.