Solved

Has anyone had success in building a report to identify the system users that were disabled over a period of time?  I’m looking to find a way to identify the date when a user goes from the “Active” status to “Disabled” status. 

Good day, I have a custom field to indicate if a voided payment is type non-sufficient fund, if it is, when I press release in the voided payment, I have to create a debit memo and redirect from the payment and applications screen to the invoice and memos screen. The problem is that if I try to redirect the screen, the voided payment does not release and does not save either, because the RedirectException interrups the process. Do you have any idea how can I make the transition from one screen to another having the voided payment released? invMemo.Actions.PressSave();throw new PXRedirectRequiredException(invMemo, true, "Invoice");                }                    return Base.release.Press(adapter); public virtual IEnumerable Release(PXAdapter adapter) { ARPayment row = Base.Document.Current; ARRegisterExt rowExt = PXCache<ARRegister>.GetExtension<ARRegisterExt>(row); var invMemo = PXGraph.CreateInstance<ARInvoiceEntry>();

Hi All, I have encountering an unexpected problem from report desginer.  The report is made by the exported G.I., and the G.I. actuallly have no problem at all. However, when I do the same setting in the report designer, finally there are 2-3 items cannot be grouped.  I have really no idea about it.  The grouping data is normally including Inventory CD, LotSeriesNbr, Site ID, and Location ID.  I have checked many times the data is not problem, referring to the screenshot I highlighted it in yellow, the data is matched and same, but it comes up not grouping. Is there anything I missed out or something I need to setup in the report designer (which is different with G.I.)?   I surely the original G.I. is working like a charm, but just report result is not the same. Appreicate if someone can help or advise to fix this problem.  Many thanks.    (Exported Excel, the data is not grouped.) 

Change BOM Attributes QTY Required from 2 to 3 decimals.I know this is done in the ‘Companies’ section ‘Quantity Decimal Places’ However, this changes multiple fieldsIf we are looking to change only the ‘QTY Required’ in BOMS field, and not Machine Units, Run Units, etc. Is this possible? If not, are there any other units I’m missing in my list to determine impact? (Machine Units, Run Units, QTY Units) Thanks!

As per subject, I have tried to use Max & Min Aggregate function in Report Designer.  Screenshot like below, no matter I use Max or Min, the resulted value is same, it does not capture Min or Max value, but just the first data value. Also, I tested with same formula in GI, it is no problem at all.  Seems this is the Report Designer bugs.

Hi,We broke something when setting up a UDF in Shipments Form - the UDF is now referencing an invalid selector table. However, we are not able to click ‘Customizations > Manage UDF’ action on the Form to remove the invalid UDF, since the Form throws a trace error in load due to the invalid table.Similarly, we are unable to delete the attribute since it is currently being used in a UDF. The Attribute is greyed out and stuck at the Selector.Is there any way of removing UDF from a screen through a customisation project or other screen? Or prevent the form redirecting to the Error Trace screen, so I can invoke the Manage UDF action?

Hi, I have a refresh problem with a container Link.When I open the container (PIPELINE & CRM) the first time, the values ​​are good, if I go to another customer, the container (PIPELINE & CRM) takes over the data from the previous customer. When I add a record to the container the screen updates good. The screen works perffectly in the ERPThanks Xavier… Sorry for my english langage so poor ;) update screen AR303000 {    update container "CustomerSummary" {    add recordAction "save"    update layout "CustomerHeader"      {     remove field "CustomerSummaryBalance#PrepaymentBalance"    remove field "CustomerSummaryBalance#Balance"    remove field "CustomerStatus"    add field "CustomerSummary#PanierCumulé"    add field "CustomerSummary#Sleeping"          add field "CustomerSummary#Provenance"  {forceIsDisabled = False}          }    update layout "OtherTab" {      displayName = "CRM"                  add containerLink "PIPELINE"    add containerLink "CRM"           add container

Good morning, We are evaluating some CPQ platforms to handle made to order products, is anyone aware if Acumatica has ever or has plans to integrate with more advanced CPQ tools like ConfigureOne, KBmax or ThreeKit?

Hi,I just want to confirm if there is any setup for this.As noticed there is a “/” on the calculation of the inventory but in some acumatica instance, this is a whole number.I am seeking your assistance with this.Thank you!

1. Receipts not processing with functions unresponsive - can't release.2. Can't complete shipments3. All 'export to excel' functions are not working4. Can't create POs5. Can't download postings or run reports. This all occurred overnight with no changes to our env. Only occurring in our PROD env. the DEV. env. is working fine. The error in the trace is the same for all:at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 

We want to create a new order type that can go through the whole process, get shipped, but not have the invoice created until X days (30 most likely) later by the user. We would create a report or GI that lists all the invoices that need to be created for that day. Is something like that possible? Thanks in advance for any insights. 

I would like update the screen AR30300.When I open a customer, The field is disable, in the ERP, we can update the fieldThanks Xavier

When I create a snapshot for the purpose of installing the snapshot in a sandbox or for an emergency back up, should I create an “XML” or a “Binary” snapshot? Which is the most appropriate or better? We are on 2022 R2 so soon moving to 2023 R2.

During the processing of bank feeds there was a transaction that we thought was a duplicate entry. The entry was “Hidden” by click the “Hide Transaction” on the Process Bank Transaction (CA306000) screen. It was then discovered that it wasn’t a duplicate and we need to now bring this transaction back so we can process it normally.Our question: Is there a way to view this hidden transaction and is there a way to “Unhide” this transaction?Thank you!

@Naveen Boga solved this problem for me before on the SO Lines gridHowever, that was to enable native fields.  I’m using the same logic to try to enable two custom fields on the GL entry details, but I am unable to make them editable.I’ve added what I think is the necessary code and changes to the workflow.   namespace PX.Objects.GL{ public class JournalEntry_Extension : PXGraphExtension<PX.Objects.GL.JournalEntry> { #region Event Handlers protected void GLTran_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (GLTran)e.Row; if (row != null) { //Allowing caches to update with below code Base.BatchModule.Cache.AllowUpdate = true; Base.GLTranModuleBatNbr.Cache.AllowUpdate = true; GLTranExt glExt = PXCache<GLTran>.GetExtension<GLTranExt>(row); PXUIFieldAttribute.SetEnabled<GLTranExt.usrLoan&

Hello everyone!My apologies but I need your help again...I tried to debug the native code but couldn't run it on Acumatica 23R1. I'm wondering... Could you tell me if I'll need a new setup please? 

Hi,I use the Resource Owner Password Credentials Flow to call the Acumatica API.as the 1st step I generate a token and using this token I call the API.My scope is api.I need to know after calling the api should I log out or close the session.

Hi there! Looking to get some guidance on task descriptions and how to properly make sure theyy show up correctly on revenue and cost budgets respectively.  Our tasks are of course shared between cost and revenue but they are not one for one.  We put the task descriptions in based on the cost side just to make it easier for the PM’s to code.. see below However, in the revenue budget I change the descriptions to match what my Schedule of Values is supposed to say:     When I go to run my project billing - they all revert and it causes a headache for the PM’s … can anyone help me fix this problem??  

Is there a way to prevent invoices being created without a customer tax zone?  

Hi Community.!!I've been successfully working on an app for Acumatica. I've managed to implement functionalities like logging in, logging out, and retrieving data using the API and endpoints.Now, I'm looking to implement the "forgot password" feature. In Acumatica, this involves sending a password reset link to the user via email, allowing them to reset their password.I'm wondering if it's possible to achieve this password reset functionality through API calls or webhooks and is there is any specific way we can trigger the emails? I've checked the available endpoints, but I haven't come across any related to this specific feature.Please let me know if there is any way to do that.Thanks in advance.

HiI am wanting to do a mass update for a large number of purchase order lines, for a specific branch, to set them to “closed” = yes.I have created a generic inquiry, and was hoping to use the mass update functionality in it:  But my problem is that the fields that are available in the mass update tab, are only for the purchase order itself, and not the purchase order lines.  That’s not surprising, since I am not sending a unique identifier to the screen, for it to know which line to update.Is my only option here an import scenario?  And does anyone have an example for me of an import scenario where only transaction lines are being updated? 

Hi Everyone  I’m having an issue updating a purchase Order in Acumatica by using Rest API, So my process is to create a purchase Order skeleton by enteringOrderNbrVendorOwnerDescriptionin the next step I add line items to that existing purchase Order  using OrderNbr (Not Auto-generated)  1 Step - Create Purchase Order PUT /purchaseOrder   2 Step - Add line items to the existing Purchase Order    "exceptionMessage": "Operation failed", "exceptionMessage": "Another process has added the 'POOrder' record. Your changes will be lost.",Request :{  "OrderNbr": {    "value": "PPO-00007"  },  "VendorID": {    "value": "VD000001"  },  "Description": {    "value": "DummyDescription"  },  "Date": {    "value": "2000-01-01"  },  "Location": {    "value": "DUMMYLOC"  },  "ShipToAddress": {    "AddressLine1": {      "value": "123 Dummy St"    },    "AddressLine2": {      "value": "Suite 100"    },    "City": {      "value": "Dummyville"    },    "Country": {      "value": "XX"    },    "PostalCode":

I have a customization that creates a CSV file and stores that as an uploaded file in Acumatica.Is there a way to automate so that when that file is created that it will automatically be downloaded to a shared folder?Alternatively, is there a way I can connect to Acumatica via web api and have my external web api connection automatically download a file?  (the file name varies based on the creation date)I tried setting Synchronization of File Maintenance, but that does not work the way I want it to.BTW, a second question is : In WHAT table are all uploaded files stored in Acumatica? Below is a screen shot I took of where I located the “name” of the files I want to automatically download from the [dbo].[UploadFile] table in Acumatica.  However, I do not know where those actual files are stored and how to pull them down in an automated way.  It is highlighted in the screen shot, and there are multiple files of this again, based on the date in the file name.(yes, I actually want to DL all

 From the Invoice screenshot below you can our user can create invoices but invoice data is not visible. Is this a permission issue?  Thanks,Tom  

We have a scenario on hand.   Assume that we have a Template Item SKU as Parent001 with three combination SKUs as follows: Child001Child002Child003Each of these products is being sold at a base price of $20Next let us say on the Sales Prices screen we have defined a quantity break of 5 and a price of $16.  On the Sales Order, if we add Child001 with the quantity as 10, then the price reflects as expected to show it as $16 each.   Our customer has a requirement that if someone buys 3 qty of Child001 and another 3 qty of Child002, thus exceeding the break qty of 5 defined at the Template parent level, the Sales Prices should kick in since the discounted break qty price is based defined at the parent level.   Any thoughts here to achieve without a customization?   Thanks in advance !!!