Discussion Forums

Im using Process Payments / Print Checks (AP505000) screen When I Click PROCESS button It redirects to ap641000 report page. Why do I get this error? But when I run the empty report it prints.  

We have been creating statements for several months and today when we went to run statements we got an error ‘ Nullable object must have a value’ . I have checked the statement cycles and the preferences and have not found a problem.  Any suggestions on what to check next?

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

Does anyone know of a workaround to trigger a Business Event based on a Parent GI?  In reality, I want to do it based on a schedule, so I can send an email regarding the status of our Daily Field Reports.  However, an email of just info from the top-level DFR table isn’t particularly helpful; it would provide a lot more value if I can present some statistics about the DFR (but since the DFR data comes from a bunch of different tables, I grouped child queries by table and joined them to a parent table, hoping that I could send an email based on a schedule for the Parent GI Data; but was shot down). Essentially, I want to send a Daily Report summarizing the DFRs to our management staff (with a link to the actual PDFs) rather than sending individual emails when the DFRs are approved.  

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

We’re a month past go-live and integrated with Workforce Go! for payroll. We sync time activity data to them and they do hours calcs from the raw data.If there is any overlapping time in a timecard (actually in time activities), the sync will fail until it's corrected. Employees enter time via mobile app time punches or manually entering time in timecards.We’ve customized the employee’s timecard view with a calculated End Time field so they can clearly see their next Start Time doesn’t overlap and their Approvers are also supposed to be checking this.However, as with all human-driven processes, overlaps are still getting through. The problem is the entire sync will fail on a single overlap, so it’s a constantly iterative process to fix and resync, fix and resync until they’re all found and fixed.Our WFG integration specialist has said other customers have asked their partners to develop a GI that shows and/or flags time overlaps in time activities for any given pay period or pay week t

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.??

We just upgraded to 24r2 and are thinking of switching to Acumatica Payments.  With our current third- party payment vendor, Credit Card Processing fees are calculated, and these fees are being added to the Acumatica Payment screen so that the customer is paying for using a credit card.Is there a way to continue to calculate credit card processing fees and charge them directly to a customer if we move to Acumatica Payments?

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. 

Hey everyone, I’m trying to find information/training/Documentation on higher level functions of Report Designer.  I have done the Acumatica training, but looking for how to do more.  One example is how to use SubReports.  What do I need to take into account to create a sub report, link the two reports to push and pull the data that I am looking for.  I have some reports that use sub-reports in my system, and I have tried to reverse engineer, but not having a lot of luck. Any information would be appreciated..

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

We have a client who wants to use project accounting in a somewhat unconventional manner.  The client is using projects account to track manufacturing WIP and progress billing.  The client did not buy either Distribution or Manufacturing as they are using a 3rd-party solution for these features.  They want to have the ability to use progress billing, but because they recognize revenue by the “completed project” method, they need to post their billings deferred revenue.  Using a WIP schedule for this is not ideal for this client.The plan was to allow them to generate progress billing on demand, posting the credit side of the invioce to Deferred Revenue, then use the allocation feature at the end of the job to reclassify the Deferred Revenue, along with their WIP, to revenue and COGS, respectively.  I tried using a different methodology, where they generated progress billings, then offset the final bill with the sum of their progress billing to request the final amount due while recogniz

hello everyone , as per our requirement classic to converted into modern UI, while publishing the package getting errorts file code  HTML File code  please suggest how to resolve these error

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?