Introducing Acumatica Cloud ERP: 2026R2
Inventory, Orders Management, Warehouse Operations
Recently active
Hi Acumatica Community,We’re running into a costing behavior that doesn’t match our expectation of how Average Costing should work, and I’d like to understand how to address it properly.Scenario:We’re using Average as the costing method on our stock items. We received 5 units on a PO at $9.50 per unit. A Landed Cost was posted afterward for $9.00 per unit, bringing the total unit cost for those 5 units to $18.50. We then received 10 more units at $9.00 each, with no landed cost. The overall average cost at this point should be:((5 × 18.5) + (10 × 9.00)) ÷ 15 = $11.67 However, when we ship the first 5 units, Acumatica still uses the $18.50 unit cost instead of pulling the average cost of $11.67.My Question: How can we get Acumatica to always use the actual average cost (e.g., $11.67), not the inflated cost from the landed cost layer? Is there a configuration we’re missing? Do we need to perform a Cost Revaluation after each landed cost? Is this behavior expected even when Av
Wondering if anybody has come up with a solution to show duplicate lot/serial numbers if used in different item classes? Client needs to be able to resolve duplications of serial numbers when posted, we have the Lot Serial Class set to Share Auto-Incremental Value between all class items but it doesn’t stop you posting the same serial number to an item in a different class. I created a GI to show duplicates by joining the InSiteLotSerial to the InSiteLotSerial as an alias but have had to use groupings to get it to work, I then can’t get a business event to send an email when a new record is inserted due to grouping. I have tried other tables InItemLotSerialInfo but this doesn’t report correctly and struggling to find away without going down the customisation route of extending Dacs etc.
We currently have our sales order types set to pull from the Customer Location for the “Combine Sales Sub From” setting (so it’s set to LLLL). We are setting up a new sales order type that we’d like to hard code to a specific subaccount, instead of telling it to pull from somewhere.There are plenty of places to pull the subaccount from (and we use almost none of them), so I could plug it in on the warehouse or even the inventory item and pull from there, but if I am able to plug in a specific subaccount in this field, it would make it even easier.
Hello! We have 15 different locations that need to be set up under one company and we are thinking of either setting them up as 15 different branches or as different subaccounts. Any best practices or pros and cons for doing either branches or subaccounts?We are open to any suggestions!Thanks!
Hi there! I saw a post on this topic from 2 years ago so looking for a refresh. We do not use inventory...most of our projects are special order. That said, we palletize materiala and put them on racks in our warehouse until we can ship them to the job site. We have a new warehouse assistant. He would like us to get a printer to print these labels….I am assuming we should also get the capability to read barcodes. 1) Any ideas based on the situation I just described 2) what has everyone else had success with 3) what am I not thinking of :) Thanks in advance!
Hi Community I would like to Pass the channel Information as Text from Shopify to Acumatica. I created a UDF Field in Acumatica, could you please some one help me with the Importing Mapping?
Hello,There is a Acumatica customer that is about to reach the end value of their ARINVOICE sequence. What is the best way to expand this sequence number range and what are the pros and cons?
Hi Everyone,I am working with Shopify Connector with Build 24R1 version 24.121.0004.On initial order sync, the details are updating as expected.But on order edit sync, the discountable amount is not updating properly (Detail Total - Line Discounts) under Discounts tab.Can you please suggest the possible root cause and fix for this issue. Thank you,
Is there a way to add the Case Packaging Dimension by UOM in the Packaging Tab under Stock ItemWe have full cases at a specific dimension and weight then we have single items at its own dimension and weight.
How do you have a distribution addition and not include DRP in it? I find it curious that if this is such a need functionality, why is it not core to the product? Thoughts?
Has anyone leverage an ISV to assist with customer billbacks short payments for promotions, rebates or etc?
Hey folks !I create SO Invoice by adding lines from a sale order.(I would like to invoice partially some lines of the sales order, So I created a new invoice, add the lines I wanted and change the quantity from 5 to only 1.)But after that, the status SOLine statut is automatically change to “completed” even if there is unbilled qty .Why ? I would to do multiple invoice from a same SO Order ? Thanks for your help.
When looking up a Location in forms like an Inventory Issue transaction, make it so that locations with inventory on hand show up first. The current lookup in an inventory Issue sorts purely by Location which usually forces the user to filter on the on hand column.One idea I had was to add a check box at the top of the Location lookup screen that is labeled something like “On Hand Only” that is checked by default, which would filter the listing down to locations that have inventory on hand.Another idea is to just sort first by On Hand descending, and then by Location.This idea has been in my head for years, but a new customer that is about to go-live asked me about this today.
on the following order the subtotal is $2154.72. But on the SO there is no section for it. Is there a way to have it appear in the top section of a sales order?
I was asked by a client to change the Sales Order status “Completed” to “Shipped” because they found “Completed” misleading. (Completed orders may or may not have been invoiced.) I didn’t find a way to change the workflow status description in the customization workflow, so I looked for a different option. I changed it in the Translation Dictionaries, which I find even simpler. This value was used in multiple places and I could choose to change it globally or by screen. In the example below, I changed the status description for Sales Orders but left it as Completed for Purchase Orders.Hopefully this is helpful for someone looking to make a similar change.
Hello,I am trying to format a date field on the results grid on a GI to be MMDDYY with no dashes or slashes I.e.06/01/2022 should be formatted 060122, is there a way to convert with formatting or function?Any help would be greatly appreciate it.
Hi Team,I am encountering an issue when attempting to import a refunded order into Acumatica. Below are the steps I followed: A sales order was created in Shopify and successfully imported into Acumatica. A shipment and invoice were created for the sales order and released in Acumatica. The order was refunded in Shopify. When trying to import the refunded order back into Acumatica, I receive the following error for all refund orders "Inserting 'AR Payment record' raised at least one error. Please review the errors. CashAccountID: Cash Account 'TT' cannot be found in the system. Please verify whether you have proper access rights to this object." We do not have any customizations deployed in this instance and I have reviewed all relevant configurations related to Cash Accounts. The payment has the appropriate branch Cash Account set up, and everything appears to be configured correctly.Build version: 25R1Could you kindly share your thoughts on why this might be happening and how t
How do I get a list of all contacts listed in Acumatica? We do not have the CRM module.
Hi Team When I send an email using below actions> Purchase order> Print purchase order> send- When I click send I am getting only signature in the email body, however the subject line shows as expected. I am unable to reproduce the issue in another instance or local instance.
Hi Acumatica,Is there a way to set up Sales Prices based on the credit terms used in the Sales Order Screen?Thank you!
We have a lot of customers that have no recent activity, either open sales orders or invoices. I know I could report on this by doing a group by GI with Customers, grabbing the max order date from SOOrder and the max invoice date from ARInvoice, but I really want to get this in front of the users both in the Customers GI as well as on the Customers screen.I see there is a “LastActivity” date in the Customers DAC, but it’s marked as Obsolete (we’re on 23R1, upgrading to 25R1 later this month). Are there any other “In DAC” values that would help me avoid adding yet another set of joins (and the complexity of needing to group by the relevant customer fields) to the Customers GI?I’m going to post another thread in the Development forum about adding a DAC field, but before I write up a customization I wanted to see if I was missing something obvious already in the system.
Are we able to set up a Create Shipment automation schedule that creates a shipment based on the sched shipment date/request date earlier than the actual shipment date? Ex.Sched Shipment Date/Request Date is June 20th.We want the shipment to be created on June 18th with a shipment date of June 20th. So when June 20th rolls around, we just have our warehousing team confirm the shipment on its way out. I’d expect this to be easy to set up but seems as though this processing screen only works on the day of shipment? I must be missing something here.
I have the Invoices and Memos GI exposed to the mobile app. The summary screen is dreadful. I find it dreadful for pretty much any list view. Once you click the record, you can make the details look really nice with headers etc.Also, what defines the fields that show up in the list view of a GI that is exposed to the Mobile App? I can modify the fields in the Details view, but not the list view. This may be in the help, so I will look, but since I am bugging folks with the primary question, I thought maybe someone had a quick answer that might save me a bunch of publish-wait-repeat. :-)This is just not very helpful. Especially if I were to add a custom field SO Order Nbr to this list. You would not be able to tell which is the invoice number vs. Sales order number.I WANT LABELS! 😁
Sales Order had UOM of “EA”. This is correct.Shipment details line has UOM of “EA” This is correctWhen I add contents to the BOX on the shipment, the UOM in the contents screen changes to the Stock Items Base UOM. ***This is NOT correct**It converts the QTY correctly, but the UOM on the contents subscreen should not be different than the Sales Order UOM and the shipment’s UOM.
In our warehouse our lower shelves are Forward Pick locations and upper shelves are Reserve Stock. We keep a supply of all inventory in the Forward Pick locations but any overstock that won’t fit below will go to the Reserve Stock locations. Both location types have their respective inventory marked Include in Qty Available but only the Forward Pick locations are marked as Sales Allowed. This allows a sales order to be created regardless of inventory location but will prevent the Shipment/Picklist creation if doing so would direct a picker to a Reserve Stock location.This is where the pain point is introduced. We currently utilize the “Tasks” feature in Acumatica to direct our warehouse mobile users to transfer items from Reserve Stock to Forward Pick so that shipments containing affected items can be created.Ideally we would like a proper means of creating a Transfer Order which would direct a warehouse user to transfer the items between locations.I’m wondering if this is already an o
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.