Discussion Forums

Hi Acumatica Community,May I ask for documentation on migrating fixed assets in Acumatica?From uploading of GL and FA Balance (SL)?Thank you!

I’m trying to add the primary contact’s name to my email notifications when emailing AR Invoices, e.g. Dear John Smith.But when I try to add a data field, I only get the Primary Contact ID number, e.g. Dear 6689In an earlier version I was able to use the “Attention” field, but now that field is greyed out in the Billing section. I have to manually override the settings and add the contact. Is there a way to add the greeting without having to override all my contacts? It’s too easy to overlook that tab. Thanks

We are a division of a user of Acumatica .  It’s hoped that our division will start using Acumatica  sometime next year.Our parent company is primarily a plumbing/HVAC/electrical installation and repair company.  Manufacturing was a sideline with non-repeating work, small quantities, and flexible due dates.  We are a tier one manufacturer and we were bought (in part) to expand the parent company into large quantity, repeating work .We have been using another ERP program for decades (with occasional upgrades, of course).  We’ve created inhouse solutions that fit our process better or add features that aren’t available yet; all built on the ERP data to expand capabilities.I had little to do with the roll out to our parent company – except for providing some tricks for data extraction and compilation.  I am new to Acumatica . Questions and plans (sorry for the length and I don’t know what I don’t know) :Would two instances be needed?  Our present ERP system allows multiple sites, but in a

Client would like to enter notes as they are creating/adding to sales order via matrix items and have these carry over to the SOLines when they click Add & Close.  Is this even possible?As far as I can tell, the notes/attachments on the matrix table view don’t actually do anything currently.I’ve done many customizations, including to matrix items (with much help from ​@Zoltan Febert) but this one looks like another tricky one where I need to override the AddOrderLines method somehow.After clicking Add & Close I can’t find this in the CSAnswers table using:SELECT * FROM Note WHERE NoteText = 'Test Note 123' 

I have a report, attached below, that has several filters. However, One of the filter, Customer, can be selected, but doesn’t filter the report. Any reason why the report wouldn’t be filtering correctly?

I have been working on creating a very simple report. Based on a single view which has 1000 row.To Start I tried adding adding a single column.But only 10 rows are getting printed with the same dataI am attaching the images for the reference 

Hi all,I was wondering if there is a way to get the system to calculate the unit price/cost by updating the ext price/costUpdating the Unit Price to $700 calculated the Ext. Price to $4,200However, updating the Ext. Price did not automatically update the Unit PriceIs it possible for this to happen?Thanks

Hi.  When I am printing the schedule of values on the AIA Report, only the items that are being billed are printing.  How do I get the entire schedule of values to print (including the items not being billed on the current pay application?

We need to 0 the qty of an item that did not come in.When I create the receipt and change the Received Qty to 0, I get error: Quantity must be greater than 0.What is the right process to indicate a receipt is short?

We have a couple of business processes that require us to immediately update sales orders as new records are created in the system - not on a schedule. For example, we need to add the CRDF non-stock item to CO shipping address sales orders as they land in the system for tax calculation purposes.I’ve been able to create GI’s to filter down to the orders we want to update, and a business event that uses an import scenario to add the item to an order. The GI is configured to trigger based on record change, when the record is inserted into the search. We need to do this because we also apply filtering on the GI.I’ve confirmed all the functionality works in testing, but in a live situation the flow fails because of error: 0 records of 1 have been processed. The last error was Another process has updated the 'SOOrder' record. Your changes will be lost.As best I can tell this is happening because the business event’s import scenario is running too fast. I believe the import fails because the

I have a GI that outputs QtyAvail for each of our two warehouses on separate rows from the INLocationStatus table. I know to get the total QTY I can group the report by item.In this same GI however, I need to also output the total QtyAvail from both warehouses in the following format:Item - Warehouse - QtyAvail - Total QtyAvailABC - WHS1 - 10 - 50ABC - WHS2 - 40 - 50Is this possible?

Hi all, Does anyone know if there’s a way to pick Sales Order lines without having to create a shipment first?Right now, the only way we can pick is once a shipment’s been created, and we run everything through our WMS. The standard pick/pack/ship process doesn’t really suit our setup, and I’m wondering if there’s a better way to pre-pick stock into a designated area ahead of time?We’ve thought about just transferring the available stock into that area manually, then once the shipment’s created, reviewing the lines and updating them to the right location — but honestly, I’m hoping there’s a smoother, more efficient (ideally system-driven) method out there.Anyone come across a workaround or setup for this?

I’m creating a GI tool based on the AMRPDetail table,Users need to be able to input a sales order number into a parameter and then have the GI filter to show any sales orders “less than or equal to” that sales order number.I created a formula to parse out the SO number from the related document field. Can I use that formula field as the parameter? Thank you!

I try override the behavior of Shipped Qty on SOShipLine. from the scenario creating of sales order to creation of shipment using create shipment button. and after that there’s no changes of Shipped Quantity in Shipment Screen.  

One of my client has  business unit in UK and wants to understand regarding Acumatica’s adaptability to UK financial regulations—particularly around VAT compliance, Making Tax Digital (MTD), statutory reporting, and localized financial practices.Could you please share any documentation, case studies, or partner resources that address the above. Appreciate your support.  Thanks

Hello, I have created a new attribute for customers which will show their shipping account number (no carrier plug ins are used). I would like to add this to the shipping tab (or create an attribute tab) in Sales Orders. Is this possible?  

Context:  We are matching purchase orders to vendor bills based on the amount. Since we are not implementing the inventory, we are not using the purchase receipts. The items used are non-stock items.Scenario: In our purchase order, we have a single line item with a quantity of 1 and the full amount entered. Our goal is to perform partial billing. We attempted to create a bill against the purchase order and tried changing the unit cost, because the Amount field is not editable. After releasing the bill, the Purchase Order status changed to Closed (cannot do any AP bill) . When reviewing the PO transaction details, the Billed Amount is shown, but the Unbilled Amount is not.  Question: Are there any steps we may have missed? Is there a known workaround  for this scenario?  Thank you in advance and appreciate your help.   

Hi together, i want to import Template Items with Inventory ID Segment Settings When i import the settings will be like this:   But thats here is what i need:  I hope you cabn help me with the mapping.Thanks

Good day, we updated our item weights from pounds to KG and volume to CBM,  Currently our open PO count about 800.  I would like to a suggestion on how we can update all of them at once without have to open each one, recalculate and then close.  Anyone ideas.  Right the PO if not recalculated after open has the weight and volume from when it was created.   Thank you.Evan

On the Requisitions screen, you can select a PO Type and create a PO from the requisition.  I want to add the same Project Drop-Ship option that is available on the Purchase Orders screen to the Requisitions screen.  I’ve added the Project Drop-Ship option to the DDL.  When I go to Create Orders, it fails (obviously) because there is no project ID on a requisition.  I added UsrProjectID to the RQRequisition table.  I clicked Create Orders after selecting my custom DDL item and it looks like the code is “trying” to do what I want, but the Project ID is not provided to action.  My thought is that I can override the Create Orders to provide the custom Project ID field I added.When I look at the code for Create Orders, all the methods that do the work to create a PO are protected.  It looks like I would have to practically rewrite the entire code base just to do what I am trying to do.I think I can do an override on a protected method, but before I dive into copying 1000 lines of code, I’m

I’m sure there’s good reason, but every ERP including Acumatica that I’ve worked with loves to record all transactions as positive values.  Inventory tables line INTran at least have the InvtMult field that you can multiply your quantities and net costs by to tie out to the actual ins and outs of inventory.I haven’t seen a similar field in ARTran or APTran, so instead we’re doing a lot of “iif” statements in GIs based on transaction types.  It’s ugly, especially when you have to aggregate.We’re on 23R1 right now but working on moving to 25R1.  Is there a similar field in either version to the InvtMult field in Inventory?

Hello Acumatica:I’m writing to inquire and discuss what companies are doing to capture data which is required, and will be required in states where EPR, Extended Producer Responsibility is being discussed.  Peerless-AV is beginning a study of what products we will need to report on all of our packaging, where it is being sold, and what our cost for compliance will be in each state.   One question is, what is Acumatica researching as far as solutions for EPR.  A second question is, how are companies handling this today? My understanding of the requirement is, the material that makes up our packaging will need to be broken down into the materials that fall under the requirement.  Then, based on how much of these materials are used in packaging a particular item, we will need to extend that to a project cost we will have to pay the governing body based on how much we ship to any particular state. Here is a website that discusses the regulations: https://epr.sustainablepackaging.org/ Is an

Hello,Hoping this is an easy one, I am trying to set/change the “From” to something other than Default on templates.  When I hit the magnifying glass, the only option is Default.  Is there something I need to change to allow the selection of another email account?  I have created email accounts for all users as well and still only get Default as an option.  

Has anyone created a quote process in the service module?Quote to sales order is working well in the main system, but I am struggling to make the same duplicate process for quote to service orders. Help please

Details on Lot number attributes to use this for the Supplier Serial Number.You can add attributes for an item of a lot or serial classThe Lot/Serial Details, ScreenId=IN2096PL Show the Lot number and Manufacturing number.The value of the attribute is only visible when you select the Inventory ITEM, Lot/Serial Details Screen.All other Attributes is visible on the CS Answer DAC. I am not finding the Attributes for the Lot Serial number and need to print this number on a label.How do we access the values?