Solved

Hi All,I would like to ask if there is a formula or method in the report designer that allows a random number to be generated each time a report is run. For example, when generating a customer statement, I would like the report to display a unique number each time it is executed.Is this possible, could you please guide me on how to implement it?Thank you in advance for your support.

Hello,We use Pick, Pack, and Ship in our warehouse to process packages which ship via UPS.Recently we noticed the declared value on these packages is $0.0.Where does the system look for the value? (It would make sense for it to default from the MSRP field in the stock item.)I cannot find a setting/documentation that helps; Can’t imagine that the system expects it to be entered manually every time. Thanks for your help.

Hi Acumatica Community,We are using the Prepare Physical Count screen (ScreenId=IN504000) to manually generate physical count documents every day. Currently, we use a specific Physical Inventory Type with a predefined list of items and warehouse filter.Our goal is to automate the process by scheduling the system to generate a physical inventory document every day at 2:00 AM, using a specific Type ID.My questions are: Is there a supported way to do this with Automation Schedules, Business Events? Can this be done using a custom import scenario, API, or customization project? Are there best practices or samples from other implementations? Any insights or guidance would be highly appreciated.Thank you! 

Good day communityI need to do a bulk reversal of batches created by FA which can’t be deleted. I have posted all the batches and created an import scenario to reverse. Error message is “Batch Status invalid for processing.” Can anyone help? Thank you 

We have a customization project that creates a SQL view, DAC, and GI But since upgrading from 2021 R2 to 2023 R2 the GI is empty but looking on the SQL server the fields are not empty.I’ve tried to recreate the DAC, GI, and View with no change. Attached are images for reference as well as the customization project. Can anybody help shed some light as to why these are coming back empty? Thanks,

is there a way we can get Acumatica to give us a ‘Mark All for PO’ option on Sales Orders?this is so we don’t have to go line by line to mark for PO

Hello,how can I add LotSerialNbr from SOShipline (SO302000) in SO303000 (Invoice) in detail grid ? Thanks in advance

Good day,Right now on the RM (Order Type), the Auto Create Checkbox is defaulted to TRUE (Checked).  Is their a preference to change the default to FALSE(Unchecked).  Users need to uncheck the box to process the RMA to bring the item back into inventory.  (We don’t send out replacement items using the RMA process.I appreciate any suggestion.Thank you@Evan G 

Hi @all,when a new lead is added to Acumatica, an email should be sent to the lead’s email-address.This works well for me with the following settings. See Screenshot below.But the email isn’t linked to the lead I added.There’s a field to link an object like a lead. See green arrow in Screenshot below.What is the right syntax for this field to add a link to the lead?I’d appreciate your tips/ hints.Kind regardsMichael 

I’m trying to create two pxformula attribued on a DAC. #region UpcomingCycleID [PXInt] [PXUIField(DisplayName = "Upcoming Cycle ID", Enabled = false)] [PXFormula( typeof(Search< CycleDetail.cycleID, Where< CycleDetail.cycleMajor, Equal<Current<SeriesDetail.cycleMajor>>, And<CycleDetail.cycleMinor, Equal<Current<SeriesDetail.cycleMinor>>, And<CycleDetail.date, Greater<Current<AccessInfo.businessDate>>>>>> ))] public virtual int? UpcomingCycleID { get; set; } public abstract class upcomingCycleID : PX.Data.BQL.BqlInt.Field<upcomingCycleID> { } #endregion #region UpcomingCycleDate [PXDate] [PXUIField(DisplayName = "Upcoming Cycle Date", Enabled = false)] [PXDependsOnFields(typeof(SeriesDetail.cycleMajor), typeof(SeriesDetail.cycleMinor))] [PXFormula( typeof

Hi,I tried to export a scenario for stock item and I am getting a issue. I have defined conversions on stock item , but when I prepare for stock item export scenario , it is fetching the conversion which is not define on stock item. ( the conversion is also not define on  item class, unit conversion as well)The conversions which are define on stock item is getting fetching along with the conversion which has not been define .Please anyone has solution or suggestion for this.??

Hi Community,I’m working on building a summary report in Acumatica that consolidates key metrics from six different reports. Each of these reports has its own unique filters, such as different CompanyID, TaxAgencyID, and date parameters. Here's what I want to achieve: The main report should act as a summary sheet. Each subreport should return one or more calculated values (like CuryDocBal total from OTP Purchase Report, or LineNbr = 1 value from Tax Summary Report). These totals should be displayed in specific sections of the main report.Any suggestions, best practices, or a guide/document that could help me design this correctly?

Hi good day can you help me i want to show detailed transactions and balances. Can be run per customer or consolidated by parent. 

We have a Business Event that triggers once a month and executes an Import Scenario. The Import Scenario references a Generic Inquiry that pulls from the PMProject and PMTran tables. This process automatically generates and posts project costs.The Business Event is scheduled to run on the second Wednesday of each month, but we need the Transaction Date on the generated records to default to the last day of the previous month.For example: If the scenario runs on July 9th, the Transaction Date should be 6/30/2025.Currently, we are manually adjusting the Transaction Date after it runs. I’m looking for a way to automate this so that the Details → Transaction Details → Date field defaults to the correct value.My assumption is that the best approach would be to add a calculated column to the GI, but I haven’t found the right expression or combination to make it work reliably. 

I created a custom Pack Slip, attached it to the Pick List and it prints as expected.I went to do the same thing for a second customer and the border for one of the header sections is in the parent header section and the footer is missing, but only while it is in the Pick List form.  When it is printed separately it works fine.  Previewed as the raw report When it goes to the sub report it gets weird. I used the standard pick list we use for our default pick report, and the other custom pack slip report.  If I turn off the header border the box goes away, but I need the box around the column headers.  I just replaced a working report in the sub report box.

Hi All, I have a question regarding the inventory report: I checked on my Inventory Transaction Detail for Beginning and Ending Qty. Please refer to the first page on period August 2022 screenshot document below:The beginning balance is correct because I just created the stock item so the beginning balance is zero and the ending balance is also correct because I purchased 400 item in August 2022.However, when I changed the next period, instead of reflecting the ending quantity from last period, the beginning quantity begins with zero again. Thus, the ending quantity is minus. Please refer to the second first page on Period September 2022 screenshot document below:The beginning balance starts with zero again, resulting the ending qty balance become minus. When I checked the report, it reflected right quantity balance. Please advise how to fix the information regarding beginning and ending balances in Inventory Transaction Detail. Regards,Nadia

Hello Acumatica Community, How can I enable the Email Sales Order for Sales Order Type - RM? It is currently greyed out and our customer is using a temporary work-around.   

Hello,I would like to know how I can display the Alternate ID in the Invoice detail grid.Could you please guide me on how to achieve this?

I’m trying to create a customization so that when orders get created from the acumatica commerce connector. I want too modify the Warehouse ID for specific stock items on “SP” order types.I created the customization and extended the sales order screen but no luck so far. I thought I could listen for RowInserted event for order Details but nothing is working and when I add trace logs I don’t see them.using System;using System.Collections;using System.Collections.Generic;using System.Diagnostics;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.DR;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.IN;using PX.Objects.PM;using PX.Objects.PO;using PX.Objects.TX;using POLine = PX.Objects.PO.POLine;using POOrder = PX.Objects.PO.POOrder;using PX.CarrierService;using PX.Concurrency;using CRLocation = PX.Objects.CR.Standalone.Location;usi

I have a processing screen that works perfectly.  After processing, all data is updated correctly and the screen looks and functions exactly as it should.However, when the processing is complete, the results window is screwed up.When I click POST ALL, the code posts any entries that are unposted (based on the drop down filter) and does not post entries with a batch error.  WORKS GREAT!When the processing delegate fires, if the batch has errors, I throw an exception on that recordPXProcessing<ICSPendingHDR>.SetError(entriesToProcess.IndexOf(entry), e);On the web site, the processing screen temporarily shows an item in the ERROR box which is what I expect: Then, when both records have been processed, the results changes to 2 process successfully When I click the 2 Processed button, I get results that are messed up.  The Batch Has Errors column should show a checkbox and not True or False.  It is pushing the columns to the right.  Also, the descriptions on the Messages are in the wr

I have a purchase order with lines that are set to complete “By Amount”.  Min Receipt = 0%, Max Receipt = 102.5%, Complete on = 100%.I understand this to mean that any amount below and including 102.5% of the amount can be receipted, but once the amount of the receipt line = 100% of the amount on the PO line, the line should complete.Amount on PO line = Amount on Receipt line, so why would it not set the PO line to complete?  Am I missing something else here?

I have a local instance with a snapshot of client data on build 25.101.0153. After installing the instance, I ran the npm run getmodules and npm build.  I have custom screens.  I can npm build my screens and they look great in my local instance.I added the custom Modern UI files to the Modern UI files section in the Project Editor screen.When I publish the project in the same instance that I created the MUI files, I get errors. I think this is the main reason for the errorts-loader: Using ts-patch/compiler@5.5.2. This version may or may not be compatible with ts-loader.I have about 20 instances of MANY build versions as my snapshots are being restored into the build of the client’s snapshots.In google, the AI tells me that I should use NVM to manage my active node.js version.  The error seems to have something to do with typescript.For sake of argument, say I am able to get my active version of node.js / typescript to match the instance I am publishing into.  Before I spend hours tryin

We want to create a BOM that one of the materials required is the same as the finished part.  We need to issue the part to the production order, along with additional parts to repair it.  The finished part comes out of production with the same InventoryID as it went in, but with a new Lot or Serial number.Currently, It seems I cannot add the finished part to the materials.  Is there a way to identify a BOM as a rework BOM that will require this?

When recording, a dedicated button should appear, but it doesn't because there's a warning on the screen. Can anyone help me resolve this? Here is my action codepublic PXAction<PX.Objects.AR.ARInvoice> LoadDocumentsPro;        [PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Load Documents")]        protected virtual void loadDocumentsPro()        {                                  }Here is my code where I do the validation to show the action, it works when there is no warning, if there is the event does not work.  protected virtual void _(Events.RowSelected<ARInvoice> e)        {            var row = e.Row;            var cache = e.Cache;            if (row != null)            {                bool validacionPro = false;                bool validacionPro2 = false;                PXResultset<XTProformaInvoice> value_1 = this.proformaView.Select();                foreach (XTProformaInvoice item in value_1)                {                    if (item.L

Does anyone know if you can pick and choose what users see the Modern UI? I know to customize it, you have to have certain roles but can it be turned off for certain users? Specifically, the SPS tabs are not available on the Modern UI. Does anyone have a workaround?