Discussion Forums

Hello all,I have a column for Qty in my import file and the goal is that value to be imported should by Qty/3.I entered the same forumla in Import routine but it triggered the following error:Cannot perform the '/' operation on System.String and System.Int32. How to resolve this?

Hello-With the Subitems feature being phased out, is there anything in the product pipeline to replace this loss?Primarily our manufacturing customers are looking for Revision tracking at the stock item level.Cheers,Chad

When there are multiple estimates on a quote and only one or two of the items estimated are ordered, you have to remove the estimates for the items not being ordered from the quote before raising the sales order.  This means losing the connection to the quote which can create problems if the customer subsequently wants to order those items.  It would be better if you could simply select the won estimate at the point of raising the sales order so that the quote remains as it was when sent to the customer. Have we understood this correctly or do others have this same problem? if so how do you handle this.

Per the documents I am trying to compile one screen, however I get the following error.PS C:\Program Files\Acumatica ERP\ACU-1\FrontendSources\screen> npm run build-dev -- --env screenIds=AR301000> screen@0.1.0 build-dev> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack --progress screenIds=AR301000[webpack-cli] 'screenIds=AR301000' is an invalid value for the --progress option. Only 'profile' is allowed. I have tried both folders  “FrontendSources\screen\” & “FrontendSources\” Attached is all text from my console with many different attempts, some successful when “npm run build-dev” is run, others not.

I’m trying to add a currently existing tables to a screen as a new DAC. I’ve got it added in the code tab, but it is still not appearing as a option to add its fields.  

I need to delete a certain replenishment class from about 5K items. I want to do it via import scenario. My issue is that I don’t see the delete row command in the import builder. Is there a way to do it? 

I understand the Schedule recurring sales orders is a future consideration so wondering if anyone has come up with a workaround or customization?  A supplements company (prospect) needs the ability to setup an order for a subscription that ships the items on the subscription based on predefined ship dates.

Hi, Have you anyone migrated service contracts with a new implementation? We need to migrate service contracts but we face an issue which is if we create a service contract for a past date, and when we run billing the system creates invoices from the starting date. Since the contracts have been billed in the past, we don't want to create past invoices in the system. Does anyone have any idea about skipping invoice creation for the past period for the service contracts migrated? Best Regards,Dulanjana

Business case:Quote includes a return (Trade-In).  Equipment Manufacturing and Distribution companies - sell equipment, sometimes will take a trade-in of a used equipment.  Want to be able to put the negative qty on the quote to include the credit.  Then convert the sales quote (CR304500) to an order of type = MO.Can’t enter a negative on the sales quote Can’t convert to an MO order typeDoes anyone have a process for something like this?  Put a negative on a sales quote to include a credit/return in the quote?  

Hi, I am trying to save CustomerLocation including LocationContact.Address, the CustomerLocation gets saved but not the child object LocationAddress. I am using PUT.how to save CustomerLocation with Child object LocationContact.Address? var customerLocation = new CustomerLocation {        AddressOverride = new BooleanValue { Value = false },     ContactOverride = new BooleanValue { Value = true },     Customer = new StringValue { Value = accountingData[0].EntityId.ToString() },     LocationID = new StringValue { Value = accountingData[0].Addressid.ToString() },     LocationName = new StringValue { Value = accountingData[0].Addressline1.ToString() },     LocationContact = new Contact(),     Active = new BooleanValue() { Value = true }, }; customerLocation.LocationContact.Address = new Address() {     AddressLine1 = new StringValue { Value = accountingData[0].Addressline1.ToString() },     AddressLine2 = new StringValue { Value = string.IsNullOrEmpty(accountingData[0].Addressline2) ? str

I created a simple new screen. Its pretty much the same as the T210 screen from the open university with some different field names. I reviewed it with my team in my local test environment and they want to add another field to it. i added it to the sql table and then tried adding it to the DAC and it errors out saying that the table already contains a definition for that field. error message CS0102. is it possible to add a field to this DAC after publishing, or will i have to start over? i can add the field using “add a field” in the customization project and it contains USR at the front, but when i do it that way, it wouldnt let me use that field in the field updated event where i was adding information for the other fields. i tried adding it to the DAC in visual studio and in the customization project. Can someone tell me what i am doing wrong? 

A client has the following requirements:All work centers have finite capacity except the Drying process the drying process can continue all day without any restrictions to how much product can be dried in a dayI have tested Finish Time, Move Time and Queue time - but these times only consume from the available capacity of the work center. I have read the Wik and whitepaper on APS, but not quiet sure how to setup for this requirement. Anyone has a similar process working?   

We have recently started using PO approvals which work great except that anyone can print the PO before it’s approved and then send that to the vendor which defeats the purpose of having approvals at all. Is there anything our of the box that can restrict printing a PO until it has been approved?

Did the credit memo process change with version 2024 R2?  I can’t add return lines as previously done in R1 version.  Thanks! 

Hi. Is there any Rest API in Acumatica that returns the AP Vendor Balance? This value is not available in the vendor table so not sure how to expose via a GI and can’t find a Rest API that has it.  Thanks!

Hi Everyone,Is it possible to print: 1x pick ticket, 1x packing list, 2x Shipment Confirmation , 2x Label per order ?Thank youJennifer 

For a particular screen in the user interface, is it possible to see the currently active graph extensions? I am trying to see how a particular field behaves but there is nothing in the graph code that seems to implement this behaviour, so I guess it must be an extension somewhere, and finding extensions is difficult.You can see currently active DAC extensions in the DAC Schema Browser, so I hoped there would be something similar for graphs.Thanks,Ben.

Hello All,  We are trying to figure out if there is a way to switch the cash accounts for all existing vendors in Acumatica? We have all new vendors set up to default to this new account but need our existing vendors to also be switched to this new default account. Thanks! 

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!