Distribution

I have a report designed based on the historical inventory valuation and I would want to introduce a date range parameter instead of using the Period as is with the standard Acumatica forms. I have the report date field selected via the filter but when I run the report on data is extracted.Has anyone worked with an inventory valuation report where one can draw the date parameter range instead of using a period?

Hey all!I want to understand how the dead stock inquiry is calculated. We are in a manufacturing setting so our consumption of inventory are “issues” instead of sales.  How is the “dead stock quantity” and the “In dead stock (Days)” calculated?  Thanks for your help!

Is there a best practice to setting up cycle counts? No matter what I try, the cycle count is selecting too many items. I tried a couple of different configurations for one of my company’s warehouses. The warehouse in question has about 13,000 items and I want to count every item 3 times per year spread out over the full year. I tried setting up a single cycle with a count frequency of 3 and assigned it to all items in the warehouse. I also set up multiple cycles, all with a frequency of 3 and randomly assigned them to items. Lastly, just for testing I created a cycle with a count frequency of 52. In every case Acumatica returned over 5,000 items to count in the first cycle count. This many items defeats the purpose of a cycle count. I would expect at a frequency of 3, the system would return 3,250 items to count [(13,000 * 3)/12]. What am I doing wrong?

Has anybody figured out how to show multiple tracking numbers per shipment, so we can have that populated in an email template to notify our customers with all tracking numbers along with the URL linked. Just looking for an example if somebody has cracked this code. Scenario: Shipment document might have few line items which needs to be shipped and the shipper packages into multiple boxes and gets tracking number for all those boxes, the tracking number gets stored against each package. How do we show those tracking numbers in the email template with looping so it has the tracking number and URL to click. Appreciate the response.

I’ve discovered an issue with the way Acumatica is managing the `POVendorInventory.IsDefault` field We have a number of items that can be purchased in multiple UOMs which are set up on the VENDORS tab of the stock item. When removing we remove one UOM from the POVendorInventory table, the other purchase units are updated with the `POVendorInventory.IsDefault` field unchecked, leaving the item with no default vendor! This error happens whether we manage the item from the stock item listing or the Vendor Inventory (PO201000) table. The most confusing issue is that when you remove a UOM and save, the isDefault checkbox remains checked as True unless you refresh the page or hit Esc. This gives the appearance the the vendor remains the default vendor for the other listed Purchase Units As I’ve noted elsewhere, this is a very odd field as it’s critical to a lot of purchasing and yet i

Hi All,Has anyone encountered this issue before where no customers are showing up when we add a new SO. I am using a demo dataset. I appreciate all the help.Thanks.

In the case where an employee sometimes is reimbursed for Employee expenses (Travel, Living, Lodging and Entertainment come to mind) but also provides services which are not part of their employment contract, i.e. Advertising.When entering the bills for these activities, is there a way to indicate for each item whether it is reportable as a 1099 reportableactivity as opposed to an employee expense re-imbursement, which would not be considered income, and should not be reported on a 1099.

After hearing a lot of feedback around the number of scans and some confusion around the Set Qty feature during picking, we are designing an enhancement to the quantity entry for the Pick, Pack, and Ship screen. The following four sections are what we consider to be potential modes of behavior. Each section contains a Click Count which summarizes the actions required for each Mode. We will use an example of a shipment for five (5) units of one item.Legacy Mode: Quantity increases by 1 per scan. Using the Set Quantity button replaces the picked quantity with the number entered on the screen. To pick our example shipment, we would need the following steps: Scan the Shipment Number Scan the Location Scan the Item => (Quantity Picked: 1 of Quantity 5) Click Set Qty Enter 5 => (Quantity Picked: 5 of Quantity 5) Confirm Shipment Click Count: 6 actio

When creating a shipment from a sales order, is there a setting or configuration that does not automatically populate/allocate the Warehouse location? We would like to leave that blank/unallocated and give the picker all the qty on hand on the pick list.Once they pick, then they choose the location before confirming. 

Hello, we need to help in getting report using API.From screen, when we click on report button, we are executing some logic and then opening up report. So we would like to know how can we achieve this using APIs.

We have a customer seeking “sales order automation”.  Essentially they want something similar to AP automation to read a customer PO and create sales order / quoteIs there a third party that could provide this functionality ?

I have a WIP import scenario that works if and only if the serial number that is being allocated is Available for Shipping, with is correct, but if one of the serials I am trying to allocate is not available the whole import scenario fails and no serials get allocated at all even the available ones.I get this error “ The record was not processed because of an error during processing of the previous record” Thank you for anything that might help me get to the bottom of this. 

Does anyone know why it is no longer possible to print shipping labels using Screen “Shipments”, ScreenID “SO302000” or Screen “Process Shipments”, ScreenID “SO503000” after shipping is confirmed or invoiced? → “Print Labels” is inactive → Only Shipments with confirmed status are listedAre there any settings that make reprinting possible in the cases described above?Thanks in advance.

Hi Team,Hi,I’ve just received a landed cost invoice (dated 2026) for goods on a purchase receipt in 2025. If I enter this bill at it’s current date in 2026, but assign the costs to the goods on the purchase receipt dated 2025, will it change our inventory value at Dec 31 2025 Year end?

Item in available in 2 locations at warehouse.  They shipment is created to pull from location “A”Using Pick Pack Ship the customer wished to be able to change the location to pull the product from location “B”I this possible ?  

If an item is setup as base Unit Cases and Purchase Unit Pallet, the PO cost information does not convert properly if changed from one to the other.  Changing the unit cost first, then changing the UOM or Qty causes the ext cost to be incorrect 

We create a lot of BL orders and would like to email our client the full order so they know when to expect their product to be shipped to them. When we attempt to email that order. I get the following error. Is there something we are missing in our process to be able to send the whole BL order? This is just the initial BL. The ST send fine as they order is created. Also, if we want to change the options within each line, can that be changed via the options up top or will a new line have to be created with the new information?Thank You!Brent 

Hello, we are in 2024R1, can anyone please suggest the best way to hide this side panel. We are able to hide the actions inside the side panel but not the entire panel.   

Hi,Have noticed that when it comes to shipping our manufactured items, the Shipment document will split one shipped item ID into multiple lines, which corresponds to one for each quantity we produced under Move/Labor under Manufacturing.I presume this is because an allocation is created for each Move/Labor document, as opposed to the gross produced quantity as a whole.Needless to say, this can get rather messy when shipping, if for example we manufacture 1 units per day for 60 days. When we ship the 60 units, we end up with a long Shipment document of 60 lines of the identical item with 1 qty each and a puzzled freight carrier.Is there any way of consolidating the Shipment document to present this as one shipment line based solely on the Inventory ID?Thanks in advance!

Ex. I need to set up work flows in my interwork like below:Step 1: Sale Order creates a Sale order.Step 2: The SO is sent to the accountant for review.Step 3: If approved, it moves to the Financial Manager for verification.Step 4: If approved, it moves to the General Manager for final approval.Step 5: Once approved by the GM, the PO status changes to Approved and can be processed further.Please kindly help me to show how to set up it and I don't how to set up correctly and chose. Thank so much for sharing  

Hi,  I’m trying to set up an approval map for orders based on the terms in the financial section of the SO. See attached image. However the orders don’t go into approval mode. It goes straight to open.   

Hi everyone,We’re running into an issue with Amazon ASNs generated from Acumatica that is currently blocking Amazon shipments, and we’re looking for guidance or best practices.Scenario: We use Acumatica integrated with TrueCommerce for Amazon shipments. Transaction Manager is configured for Pick & Pack. However, ASNs generated from Acumatica are still coming through as ASNType = No Pack. When Transaction Manager expects Pick & Pack but receives a No Pack ASN, the import fails with “Import Format Not Found” (understandably, due to the ASN type mismatch).What we’ve observed: Shipments can be confirmed even if the Pack step is not fully completed. In some cases, a package row exists, but: No contents are assigned to the package, and

Hi We have 9 warehouses and use average cost.  We want the same stock item to have the same average cost across all warehouses.  Unfortunately, this isn’t working for us, and each warehouse has its own average cost. This makes sales margin reporting a nightmare.  Our auditors are also questioning our inventory costing method.Can Acumatica do the same average cost for an item across all warehouses?  The help manual says “yes”,If the Average valuation method (also known as average moving cost) is assigned to the stock item, the unit cost will be calculated as the average weighted cost of all items at the warehouses—that is, the total costs of all quantities of the inventory items at the warehouses divided by the total quantity.but our support company says “no”. thanks

A number of ERPs have the option run weighted average costing at a Stock Item level. While Acumatica has an average cost on the price/cost tab of a stock item, cost of sales on invoicing and stock valuation uses Item Warehouse average cost or Location average cost (if costing at location level). Is there a solution to achieve Item level costing? I am considering running standard cost and using a business event triggered by IN Receipts to recalculate a stock level average cost; update the Pending cost ;and then use an import scenario to run the Update Standard cost process. What I need is a GI that does the right calculation. Unfortunately when standard cost is used the average cost stored on a stock item is the standard cost and the actual average cost is not recorded. If any one has tried and would share the GI, this would be appreciate. 

We have a customization that displays a warning popup with Yes/No buttons when an item is added to a Sales Order with a unit price of 0 or 999.99.If the user selects Yes, they can proceed with the line item at 0 or 999.99 and save it. If the user selects No, the system cancels the added line.This functionality works correctly when users manually add or update items.However, when we copy and paste a Sales Order that includes items with a 0 or 999.99 unit price, the system displays a browser-level alert (with only an “OK” button) instead of the expected Yes/No confirmation popup.Could you please help us achieve the same Yes/No confirmation behavior w