Distribution

Very Cool new surprise for 2021 R1.  Dead Stock inquiry screen lets you see non moving inventory. Here’s a quick video.  https://youtu.be/vkh6yhUK1qA 

Topic: Measuring LTL Rate Quote Accuracy Between Customer Charges and Actual Freight CostsWe are currently evaluating the accuracy of LTL rates quoted during Sales Order entry in Acumatica compared with the final freight cost incurred when the shipment is processed. We use ShipHawk TMS for the rate shopping and freight cost. The customer is quoted and charged based on the rate shop within Acumatica/ShipHawk integration prior to shipping. Then the actual freight charge is saved in a data field on the shipment after booking within TMS. NO updates are made to customer charge/billing. Our initial target was for the customer freight charge and actual shipping cost to be within 5% of each other. However, we are encountering some challenges:Customer Service does not always quote the same carrier or service that the warehouse ultimately selects. Smart Pack does not account for void and occasionally “packs” multiple pallets when rating.  Even when the quoted and shipped services match, we are s

 I want to ask, is it true that the “Available for Shipping” can be negative ?  

In the past few weeks we’ve had two different users report the same issue.  Of course, we can’t duplicate it.They are reporting that, when they have a sales order with lines marked for PO, and they create the purchase order using the “Create Purchase Order” option/screen, the Vendor location selected for the items is not always the default vendor location for that item.  When it’s not, the system seems to randomly choose a vendor location, sometimes locations that aren’t even set as the default location for any product.Since we can’t reproduce this, I’m leaning toward user error, but I’m curious if anyone else has experienced it.

Update Stock Item Attributes When Last Cost Is ChangedI need help creating a Business Event / automation in Acumatica for the following requirement.RequirementWhen the Last Cost of a Stock Item is updated from:Stock Items → Price/Cost tab → Last CostI want to automatically update two attributes in the Stock Item → Attributes tab:Attribute ID Attribute Value ILANDEDCST Cost Landed Cost IMARGIN Cost Margin The values for these attributes are currently available through a Generic Inquiry.Expected Process User updates Last Cost on the Stock Item. The Business Event should detect that the Last Cost has changed. The Business Event should trigger an Import Scenario. The Import Scenario should update the corresponding attributes on the Stock Item: Attribute ILANDEDCST Attribute IMARGIN The updated values should then be visible in the Stock Item → Attributes tab. IssueI have already created the Generic Inquiry and Import Scenario, but I am having difficulty getting the

Hello linkies,Hope y’all doing well.I have been trying to create Wave Picklist for a Shipment with multiple locations.So here’s the scenario: I am looking to assign multiple pickers to the wave lists - one wave list for single shipment - with inventories from same warehouse but different locations - for those different locations different pickers to be assigned.I have created a Shipment as shown below:  And now when I try to Create a Pick List by filtering the values on the basis of the Location, the system doesn’t display the results in the table as shown below:  Also, upon creating a Wave Picklist, when I proceed to assign, the system displays me only 1 picker for one wavelist. Whereas, I have not been able to assign the same picklist to different pickers-as the locations are different:    Can anyone please guide me what I am missing here? Thank you in advance.

I have enough stock item to adjust but after releasing it show the error message about

Hello all,Recently while implementing Punchout feature for Acumatica for a customer, the users showed us how they utilize the replenishment functionality to create multiple orders for different vendors.While designing the Acumatica feature we focussed only on the Vendor site connection and bringing CART back into Acumatica and create either Requisition or a PO for approval and then sending order directly to Vendor.Now this replenishment order creation caused us delay in our implementation. So the question is how many of you actually use this feature to create orders. If you use “PUNCH OUT” feature how useful this feature to you to place orders directly from replenishment to approved Vendors?  We would like to hear this from the users who are heavily purchasing and have to either entry in Acumatica and then the vendor order site or sending the PO to their order system via email. We appreciate your feedback as this helps us plan and address this issue better. Thank youVivek Vemunoorivive

Getting an Error at the time of releasing the inventory receipt document.Error Code is like “caused cost to quantity imbalance”

Hi, I want to send an automated daily email of daily receipted stocks from Acumatica. I need them to be broken up between companies/branches and by item class if possible. Business event is what I am thinking, but I’d like to get your thoughts on how you would do it. Any recommendations are welcome 😊

We are having trouble with Native Acumatica, and want to see if there are any options. We receive a lot of items in Sea Containers. Multiple orders are put in to a container shipment when they are all ready to ship.Our typical work flow to place an order is:Place a main order for a container of products. We will call this PO-001. Maybe this PO takes 90 days to prepare for shipment.  During this time, we will add PO’s for smaller items, generally repair parts. So let’s say that during the time it takes to get PO-001 ready, we make PO-002, PO-003, PO-004, and PO-005. Now PO-001 is ready to ship, and most of the other open PO’s (PO-002 through PO-005) are also shipping in this sea container. But sometimes, one or 2 items will not be ready in time to make the shipment, so it will still be left on order for shipping at a later date. Our people need to see an accurate delivery date and tracking info for this shipment, and need to know that all of these shipped in the same container. So right

Wondering how others have dealt with this in the past or if there is an option or way through low code no code options to handle this - when you are shipping in Acumatica there is no requirement to pack the items or pack the shipment in full. This can lead to data and reporting not really making sense especially when things like EDI or other integrations are involved. We would like to ensure that when someone is shipping that everything that was picked on the order gets packed into packages, but there is not currently a way to set this up.It seems like something simple that there should be an option for this already. How have others handled this? 

Hi Team,I have noticed that in sales price worksheets once it is released, we are not able to make adjustments to it. However, when we click on ignore automatic line discount (Which is selectable though the worksheet is released) the entire worksheet is put back on hold for edits. Can anyone please explain to me what the intended functionality of this check box? I have tested with this and if we delete the worksheet and it doesn't remove the released prices in the sales prices form but this seems problematic for traceability. Thank you in advance on any thoughts. Warm regards,Yasali

Example :Inventory ID : B001How to i create 3 Barcode for B001 - BH, B001 - BOX, B001 - KARTON ?so, i can scan according the barcode,if i need 72 BH i can scan 1 - B001 - KARTON and 2 - B001 - BOX 

The AP Bill is generating a warning stating that some bill lines differ from the corresponding lines of the related Purchase Order. We have verified that the PO, Purchase Receipt, and AP Bill values are consistent, including the quantity, UOM, unit cost, amount, and PO line linkage. However, the detailed warning for the related PO line shows an Unbilled Quantity of 0.00 KG and an Unbilled Amount of 0.00 CAD, with a unit cost of 4.2000 CAD per KG. What else could be the reason for this. ?

I'm facing an issue with Acumatica 2026 R1 (Build 26.100.0175) while implementing hyperlink navigation in a custom Modern UI screen.ScenarioI have a custom screen generated using the Modern UI Generator. The OrderNbr column is displayed as a hyperlink using @linkCommand. @linkCommand("OrderSO")@columnConfig({    width: 250})OrderNbr: PXFieldState<PXFieldOptions.CommitChanges>; public PXAction<TSSOHistoricalData> OrderSO;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Order SO",    MapEnableRights = PXCacheRights.Select,    MapViewRights = PXCacheRights.Select,    Visible = false)]protected virtual IEnumerable orderSO(PXAdapter adapter){    Dictionary<string, string> parameters = new Dictionary<string, string>    {        { "OrderNbr", DetailsView.Current.OrderNbr }    };    throw new PXRedirectToGIRequiredException("OrderSOGITest", parameters)    {        Mode = PXBaseRedirectException.WindowMode.Layer    };}works fine in Classic UI facing issue in Mod

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! If you’re interested in participating, please complete this short qualification questionnaire.  This will allow us to consider you for the program. We will review your submission and get back to you within 5 business days to confirm your qualification. Improve 

The PO receipt screen used to show the $ of the receipt so our purchaser could verify both $ and qty.  Now only the qty is there.  Why was the $ removed and can it be included again?

Environment: Acumatica 2025 R1, Distribution edition with Advanced Kitting (Acumatica Labs Program). We’ve been live since July 1, 2026 so we're still new to Acumatica.Before realizing there was a Bill Separately checkbox, a consolidated invoice was created for a customer covering many sales orders in July. Because each SO has its own PO, the customer requires separate invoices. Normally this would not be a big deal to cancel and recreate separate invoices, but in this case every line on those orders was a non-stock digital item that doesn't require physical shipment. Attempting to Cancel or Correct the invoice generates the error:"The invoice ###### cannot be canceled because it includes line or lines linked to an order that does not require shipping."(This thread confirms the same constraint for Correct Invoice, but with no remedy: unable-to-correct-invoice-25053) With both actions unavailable, in August I created a credit memo manually in AR301000 for the full amount, released it, a

How to deleted Attribute setup in ItemClass Attibutes tab?

OK, this one may sound off the wall but bear with me.  The WMS Screens like Pick/Pack/Ship, Scan and Count, etc. in the mobile app (as well as the web page versions) have sounds they play on successful and not successful scans.  I just call them “Beeps” (good) and “Bongs” (bad).We have a mix of serialized and non serialized product.  And sometimes we have product that the vendor serializes but we choose not to.  When we are doing WMS operations, our crew aren’t always looking at the screen; instead they’re scanning item after item.  And so we’ve had plenty of times when operations like counts have created new serial entries, because they scan product 1234, which expects a serial, but they instead scan the next product 1234.  Or they scan product 5678, which isn’t serialized but has a serial number field on the box which they scan as the next product.  They get a Bong and wind up rescanning the first 5678 again, increasing the count.It would be great if we could replace the sounds and i

We are using MRP as the Planning Method and Inventory Planning Exceptions (AM403000) as the purchaser’s daily exception screen.Our system-wide Stocking Method on AM100000 is Reorder Point.Here is a representative purchased item:Quantity on hand/available for shipment: 4,250 Open sales-order demand: 17,000 Open purchase-order supply: 23,500 Reorder Point: 10,750 Safety Stock: 0 Min. Order Qty.: 250 Lot Size: 250 Max. Order Qty.: 0 By quantity and date, the existing supply covers the customer demand. The lowest projected balance is approximately 2,500, and the ending projected balance is exactly 10,750.  However, AM403000 produces Expedite exceptions against nine PO lines totalling 18,500 units. It appears that MRP is trying to restore the full reorder-point quantity as early as possible, rather than distinguishing between:Supply that must be expedited to fulfil an actual customer order on time. Supply that is only rebuilding inventory toward the longer-term target. This makes AM403000 d

In SALES ORERS/ TRANSACTIONS SHIPMENTS. Whether the shipment is unpicked, picked, or picked an packed there is a function when you used to be able to  “correct the shipment”. This feature now just returns an error, and locks the order up. If you don’t wish to finish the shipment and send to invoicing, you can’t change how the product was packed into boxes, you can’t put it on hold and delete the picklist (which allowed me, formerlly, to then delete the shipment) So reverse the order through all it’s steps, after the picking was confirmed, to delete the picklist, then the shipment. I now have a bunch of orders tied up like this due to user error (error confirming before finishing picking and the like, you know human stuff, and now cannot correct the errors.  It is super frustrating. So far I waited a week for acumatica to respond to my software vendor SWK’s issue, as the error that Acumatica was generating says “ERRORS HAVE OCCURRED” and correcting the shipment fails, the picklist doesn

For new customers the Default Payment Method is set to Acumatica Pay and works. However, I have over 100,000 customers with defaults set to Authorize.net.  I need to change them to Acumatica Pay as the default when an Acumatica Pay account does not exist for the customer.I created a GI that selects the correct customers.  I have tried the import scenario a couple of different ways, with none of them working.<Line Number> line was used to set Authorize.net as the default when we first got on Acumatica.  I do not know how to get the Line Number for the Acumatica Pay method.PaymentMethod table PaymentMethodID = TXACUCC                                    PaymentInstanceID = 58452Either way I run it the default is set to the first payment method which is the default cash option.Please Help.