Discussion Forums

I’m trying to import  an inventory adjustment file and continue to receive an error message when importing that says “ReferenceNbr cannot be empty”.  I’ve tried with <NEW> as well as inputting a new number .. neither is importing.  Advice? Thanks,Sandy

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Taha Yab Ali - Acumatica Community Featured Member for May 2025Meet Taha Yab Ali our Acumatica Community Featured Member for May 2025. It’s great to have you as part of the Acumatica Community ​@tahayabali! Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumatica User Group, NorCal Acumatica User Group Request to join today!Upcoming meetup! SAVE THE DATE: SE Acumatica User Group Meeting | May 14th, 2025 Note - You need to be a member of the group in order to access/RSVP. If not a member, go to the SE Acumatica User Group site, Request to Join, once approved, RSVP there to the event.All Acumatica User Groups How to Answer Questions on Acuma

We recently upgraded from 23R2 to 24R2. It has been a very smooth process with almost zero issues.However, users have mentioned that on the Lot/Serial Numbers report, when they start typing the warehouse name (SiteCD) in the report parameter, the value no longer auto-completes.To select a value, you have to click an extra time to open the selector, which functions as usual.I’ve tried changing the schema field for the parameter in report designer, but it doesn’t make a difference. Does anyone have any ideas? 

We use the parent billing account/child account structure for customers that have a parent billing account and numerous employees that order online from us. This structure works well for being able to roll up the invoices for all child accounts to the parent, and for applying parent payments to the parent and child customer account invoices.Some of our parent accounts want to pay by the same credit card for all parent and child account invoices. Is it possible to use the parent customer credit card payment method to auto-process credit card payments for its children as well?Patrick

I would like to know if it is possible to send payment links to customers so they can pay their invoices through Stripe, integrated with Acumatica. Unfortunately, Acumatica Payments is not available in my region, so I am exploring alternative options to collect payments efficiently.thanks.

import {    PXFieldState,    PXFieldOptions,    linkCommand,    controlConfig,} from "client-controls";import { POOrder } from "src/screens/PO/PO301000/PO301000";export interface POOrder_UsrSalesRepID extends POOrder { }export class POOrder_UsrSalesRepID{    UsrSalesRepID: PXFieldState<PXFieldOptions.CommitChanges>;} <template>    <field after="#fsColumnB-Order [name='OwnerID']" name="UsrSalesRepID"></field></template>This is my code. It doesnot show on the UIBut this other code  similar shows the field on the UI import {    PXFieldState,    PXFieldOptions,    linkCommand,    controlConfig,} from "client-controls";import { POOrder } from "src/screens/PO/PO301000/PO301000";export interface POOrder_Requisition extends POOrder { }export class POOrder_Requisition{    @controlConfig({allowEdit: true, })    UsrRelatedRequisitionCD : PXFieldState<PXFieldOptions.CommitChanges | PXFieldOptions.Disabled>;} <template>    <field after="#fsOrderInfo-Othe

Hello,We’re trying to process a Credit Return where some of the returned product goes back into inventory, while the rest is damaged and should not be restocked.What is the recommended process in Acumatica to return only part of the product to inventory and exclude the damaged portion? Is there a way to split the quantity between what’s restocked and what’s written off, all within in the same return?Thanks in advance for your help!

We have a modified version of the Dispatch report that we have been running for the past 2-3 months.   The hyperlinks have always worked,  however this morning when we tried to follow the hyperlink for the Production Order# and received the following error:  [A]PX.Objects.AM.AM_AMProdItem_ExistingColumn cannot be cast to [B]PX.Objects.AM.AM_AMProdItem_ExistingColumn. Type A originates from 'jps3kegx, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' in the context 'LoadNeither' in a byte array. Type B originates from 'rseahp0x, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' in the context 'LoadNeither' in a byte array. What is really odd is that we have never had any issues following the hyperlink until today.  The Report has not been revised for at least a month.       Does anyone have any ideas on what is causing this new issue?

We are having difficulty finding a paid invoice report by vendor per project and given a certain payment date range.  Does anyone have a solution for this problem.  

Hi!In Classic UI, fields are added dynamically using RowSelected event.However, when switching to Modern UI, these dynamically added fields are not showing.How can we dynamically add fields in Modern UI to ensure they are displayed as in classic?Please refer the below code and screenshots. protected void InventoryItem_RowSelected(PXCache sender, PXRowSelectedEventArgs e){ foreach (KeyValuePair<string, PXFieldSelecting> pair in fieldSelectingHandlers) { Base.FieldSelecting.RemoveHandler(typeof(KNCFSiteAssociation), pair.Key, pair.Value); KNSCCommerceConfigsSites.Cache.Fields.Remove(pair.Key); } fieldSelectingHandlers.Clear(); { string fieldName = "UsrKNWHProductType"; string displayName = "Product Type"; PXFieldSelecting handler = new PXFieldSelecting(delegate (PXCache dsender, PXFieldSelectingEventArgs de) { KNCFSiteAssociation currentrow = de.Row as KNCFSiteAssociation; object value = null;

Do I have to fill out the ACA Reporting form (PR207000) if I am using Aatrix to file 1095s?If using Aatrix, is there a way to get the system to prepopulate the Policy of Origin and the months of coverage, based on the employee’s payroll data in Acumatica? When I did a trial run, all Policy of Origin boxes and employee coverage month boxes were empty.

Hi GuysHoping someone can help with this query.In some instances, we have to manually create a credit note adjustment as the standard way of reversing will not work due to the UK having CIS (UK Tax for Construction).When manually creating the credit note, we cannot add the PO number and therefore, does not deduct the credit amount off the PO to leave a remaining balance.There seems to be ‘Add Subcontract’ but we use ‘Drop-ship’ as this option defaults to the site address where the other PO types do not.Is there any way to get the PO added when manually creating a credit adjustment? Thanks  

Is it possible to override a method in a framework graph abstract class?  I am attempting to override a method in the 24R2 Sales Order entry screen for the Add button on the dialog that opens when the Add Items button on the Details tab is selected -- Inventory Lookup. The method is PX.Objects.Extensions.AddItemLookup.AddItemLookupBaseExt<TGraph,TDocument,TItemInfo,TItemFilter>.AddSelectedItems(). I have tried extending it like this including the full class hierarchy:public class KRSOOrderEntry_Extension : PXGraphExtension<AddItemLookupBaseExt<SOOrderEntry, SOOrder, SOOrderSiteStatusSelected, SOSiteStatusFilter>, SiteStatusLookupExt<SOOrderEntry,SOOrder, SOLine, SOOrderSiteStatusSelected, SOSiteStatusFilter>, AlternateIDLookupExt<SOOrderEntry, SOOrder, SOLine, SOOrderSiteStatusSelected, SOSiteStatusFilter, SOOrderSiteStatusSelected.salesUnit>, SOOrderSiteStatusLookupExt, SOOrderEntry>and I receive a runtime error:“Graph extension KRSOAddItemLocation.KRSOOr

Hi community,I have an expression that displays the orderDate and percentage data as on following screenshot. However, I want to hide the time part of both the OrderDate and DueDate, only showing the date. How can I achieve this?= 'Zahlbar bis ' + Format(DateAdd(CDate([SOOrder.OrderDate]), 'd', IIf([Terms.DayDisc] Is Null, 0, [Terms.DayDisc])), 'dd.MM.yyyy') + ' (mit ' + Format(CDbl(IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent])), '0.00') + ' % Skonto = ' + Format(CDbl(IIf($TotWithTax Is Null, 0,     $TotWithTax * IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent]) / 100)), '#0.00') +' EUR zu zahlen: ' + Format(CDbl(IIf($TotWithTax Is Null, 0,     $TotWithTax - ($TotWithTax * IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent]) / 100))), '#0.00') + ' EUR) bis zum ' + Format(    DateAdd(        CDate([SOOrder.OrderDate]),        'd',        IIf(            [Terms.DayDue00] Is Null,            IIf([Terms.DayDue01] Is Null, 0, [Terms.DayDue01]),            [Terms.DayDue

I’m trying to build a GI that ties a Business Event to the Username who triggered the Action that drove the business event. In some cases we use a ‘kiosk’ style machine to allow people to clock in, and knowing which machine they clocked in on will help us determine who should review their time clock entries.  I have the BPEventHistory table pulled, but I can’t figure out how to show the username of the person who executed the action that triggered the BE.

Is it possible to convert sales opportunities to service contracts? It is possible to create service orders, but I don’t know how to do the same with service contracts. This would save our team 2-3 minutes per contract on 1,000’s of new contracts per year.

I’ve searched here but couldn’t see this specific question asked, but I have a customer who just went live and now they want to increase the length of the inventory ID from the current 15 to 25.  Can this be done safely with items already existing in the system?  Will those items be unaffected if this is done?  Thanks.

Anyone got a working import scenario to create a Project Cost projection that contains all the budget lines from the project that has Budget / Actuals? 

I am trying to connect APInvoice and EPAapproval tables in generic inquiry but both tables can’t be directly joined. I already read some topics here 3 years ago that they can directly connect two tables with note ID. Based on this photo.Is there some kind of modification or setups do I need to do. Thanks community

Hello everyone! I would like to gather some inputs regarding this scenario:Base currency = PhpClient creates a prepayment document directly from the purchase order being created (in $). Suppose that the prepayment created would have an exchange rate of 1$ = 56Php. The prepayment created that time is not yet processed with payment since they still have to buy dollar in their local bank.Now, after a week, they were able to buy a dollar but it is no longer 56php, it was already at 58Php. in the Checks and Payments screen, the cross rate column is changed to 58php but the payment cannot proceed since the system will not allow the prepayment valued at 56php to be paid at 58php. Is there any other way to process this kind of transactions? 

Is there an option in Acumatica to create a credit memo directly from the Sales Order screen using a Credit Memo order type or other suitable order type without generating any inventory transactions?The customer prefers not to use the Invoice screen, as they want the credit memo to reflect the exact customer pricing. Their goal is to issue a credit memo without affecting inventory.

Hello,I am need to definitions for the ItemCostHistory table.  Acumatica help does not have table definitions so I am reaching out to the community for some help.See screenshots belowThank you. 

We use a Sales Order Type with Automation Behavior = ‘Quote’ for quoting Parts and Service inquiries.  We would like to start using this functionality for quoting used product that we take in on trade.  These used products have many Lot/Serial Attributes (we use the GitHub customization) that define Year, Make, Model, VIN, Color, Specs, etc. that we would like to display on the Printed Quote for the customer.  However, it appears you cannot allocate a serial number to a Sales Order with Automation Behavior ‘Quote’ (in order to get those attributes to display on the Printed Quote, you would have to allocate the serial number to the document first).  You can only allocate to Sales Orders with Automation Behavior ‘Sales Order’ based on my testing.  Does anyone have a creative solution?

We have a business event which sends a notification to the Purchase Order Approver.We want the owner of the PO to be notified also. Which screen field should be used so that the PO owners email can be copied in the CC field on the email template? Regards

How can I configure PM301000 screen permissions so that a specific role can only:-Insert new projects (header level only),-Delete lines in the following tabs: Task, Revenue Budget, and Cost Budget,I’ve tried setting “Insert” access for the Projects screen and “Delete” for the related detail screens (Project Task, Project Revenue Budget, and Project Cost Budget), but users can still delete existing records.What would be the best way to achieve this behavior?Thank you!.PM301000