Distribution

Hello,We are new to Acumatica, and we are using Replenishing for our purchases. We ran into an issue, and it looks like it does not take into consideration UOM or conversion factor. For example, it asks us to order 20 each of a part or product, and we enter a PO for one case. It still asks us to order 19 more even though the conversion factor is already defined on the item profile to 1 case = 20 each. We cannot enter a PO for 20 each because our supplier does not sell it by each.In addition to that, it does not round the UOM. For example, if it asks us to order 30 each of a part and the conversion factor is 1 case = 20 each, it creates a PO for 1.5 cases. It does not round it to 2 cases. Is there any option or field in ACUMA to fix it?

Good day,I am looking for some advice and directions or suggest on how to automate the updating the Item last cost with the tariff %.  It is important the salesperson realize that the cost of the item now includes a tariff amount/percent that needs to be included in the sales quotes pricing to customers.Any thoughts or questions.  The company management is discussing it.  The current environment seems to expect this not to change any time soon;  we order from Canada, and China mostly.  Our vendors are starting to pass on the tariff on the purchase order/freight, etc.Logic.Add a checkbox on the stock item profile to identify the specific items. ( We will need to identify the specific Canadian items or other countries.) Write the script to update the last cost with the tariff percentage after it the product is received into inventory. (Last cost is updated after each purchase order/purchase receipt is released) The script updates the last cost plus the 25 percent tariff. (Temporary chang

Hi Acumatica,Is there a way to restrict the order type per user or the default order type per user? Thank you!

Hi Everyone,In a Single Tenant Multi Company Environment, I’m trying to create a row-level security for item restrictions based on the item classes. Wherein company A will have visibility to all other item classes and related items and Company X will have access only to the X item class and items created for through the same class. Based on row level security set up in Inventory Item Access form (Referred document:  https://help.acumatica.com/(W(330))/Wiki/ShowWiki.aspx?pageid=09c9c94d-1707-4e24-bb2c-29343e18864f) I was successfully able to restrict the item visibility for the companies as shown below. However when creating orders i can still see all other items in the tenant.Have I missed any steps during configurations? or otherwise, how can I ensure that the user will only be able to select from the list of items restricted to the user? Thank you in advance!

Hi Acumatica Support,Is there a way to tag a limitation of Warehouse Capacity?For example, Warehouse A is limited to 100 KG     When in Warehouse A, Item 1 has 50 KG                                          has Item 2 with 40 KG      When we receive an additional 30 KG for Item 3, the system will warn that this item will exceed capacity.Thank you!  

I want to map workgroup from company tree with customer directly. In employee we can map to company tree workgroup but customer module cannot find where to map workgroup. Can we make or not ?Because I want to configure approval in sales orders I see this  

We recently learned about the “Automatic Packaging” feature in Acumatica.  We want to learn about it before we implement it.  We would greatly appreciate any suggestions about where we can learn about Automatica Packaging and the ways it can be set up and configured. We are on 2024 R2 and will be moving to 2025 R1 soon. 

Hello!I’m creating Purchase Orders based on a Sales Order, and in some scenarios, I’m purchasing goods from only one Vendor. Is there any way that I can select the same Vendor for multiple lines in Create Purchase Orders form or enter the Vendor I’m selecting on the Sales Order form itself than selecting the Vendor manually for each line separately. Best Regards  

On purchase receipt Release getting this error Version is 24R2Its working fine in local getting error on sandbox Note: Its not a space issue in database already check that #region UsrLocation// Acuminator disable once PX1023 MultipleTypeAttributesOnProperty [Justification][PXDBInt()][PXUIField(DisplayName = "Location")][Location(typeof(usrWarehouse), DisplayName = "Location")]public virtual int? UsrLocation { get; set; }public abstract class usrLocation : PX.Data.BQL.BqlInt.Field<usrLocation> { }#endregion#region UsrWarehouse[PXDBInt()][PXUIField(DisplayName = "Warehouse")][PXDimensionSelector(SiteAttribute.DimensionName, typeof(INSite.siteID), typeof(INSite.siteCD), DescriptionField = typeof(INSite.descr))][PXRestrictor(typeof(Where<INSite.active, Equal<True>>), PX.Objects.IN.Messages.InactiveWarehouse, typeof(INSite.siteCD))][PXRestrictor(typeof(Where<INSite.branchID, Equal<Current<AccessInfo.branchID>>>), "You can only select warehouses from your

Hello! Have anyone created an Import Scenario to link Purchase Orders to Sales Orders in bulk. If so, can you please share.  Thank You!

Hi, Is there a way in Acumatica to look up pricing for a customer?As in the customer calls and asks how much is an Item and you can check? Without having to open a Sales order or Quote to do this?Something similar to the “Catalogue” in the portal but where you could select the Customer. Think writing a GI to do this would be over complex due to the different types of discount a customer could have  CheersAndy

I have a customer that needs to set up pricing per customer (which we can do).  This issue is that the vendor (manufacture) has established a specific customer price and a specific cost for the distributor.  How do I set up vendor contracts for the same item with different cost (not price) ExampleI am a distributor.  My vendor sets up contract pricing for my customer for Item A for $10.  Normal price is $12.  My new cost for this item for this customer is $5 when my normal cost is $6.  I may have several contracts with different customer prices (which effects what the distributor pays).  I need Vendor contract by item by end user.  Any ideas? 

When trying to confirm a shipment using integrated shipping with the option in Delivery Settings to “Use Customer’s Account” we get the following error:We only get this when the “using customer’s account” is on. Turning it off has the shipping confirm. What can be done to fix this issue?

On the Sales Order page. We want to be able to open a sales order, then once in that sales order, click on the locationand then add a new location. When the pop up window shows up, we don’t have the “+” sign to add a new location. I’ve spent a ton of time looking for the option to add it, and cannot find it. Can someone please show me the way? :)Thank You all! Have a great weekend!Brent

Hi Team,We're running into an error it I believe is related to the inter-branch mapping. See screen shot below. We are not able to transfer beer from BLBREW to BLREST. This is a critical process in our operation that needs to be rectified ASAP.

I am trying to add one custom field in Purchase receipt Line details dialogue 's split grid but that field is not visible on screenbelow is the dacpublic class TSPOReceiptLineSplitExt:PXCacheExtension<PX.Objects.PO.POReceiptLineSplit>{#region UsrTSLineKitNumber [PXDBString(100)][PXUIField(DisplayName = "KitNumber")]public virtual string UsrTSLineKitNumber { get; set; }public abstract class usrTSLineKitNumber : PX.Data.BQL.BqlString.Field<usrTSLineKitNumber> { } #endregion}  

Hi, I need some assistance on editing my Stock Item GI to track the # of FG that are currently allocated.I was able to add these in the image below but I can’t seem to get a table to work.  

The total cost on the on the purchase receipt is not taking in to consideration the line discount of an item. For example 10 items  @ 10 less 20% line discount will come to 80.The total cost on the PR shows 100 instead of 80. The total cost is helpful tocompare the receipt with the vendor invoice totals.  

Customer needs to link their Open Bills with Sub Contact . How to upload "Open AR Documents " linked with "Sub Contract " in migration mode.? Any idea ?

Scenario:Client sells a "Travel Kit" with the following components:Kit Code Kit Name Components Alternate Items KIT-001 Travel Kit Toothbrush, Towel, Bottle Towel ↔ Microfiber Towel   If Towel is out of stock, Microfiber Towel is used instead. If Toothbrush is out of stock, the Kit is not shown as available. 💡 Output Expected: User adds KIT-001 to a Sales Order. System checks current inventory. If all items are available → Kit is assembled on the fly. If Towel is missing but Microfiber Towel is in stock → user gets substitution option. If Toothbrush is missing and no alternative → Kit cannot be assembled.  Please assist with Out of the box functionality

I'm trying to identify the type of inventory—whether it's project-related or free stock. Could you please let me know which table stores the inventory sourcing details.

Is there a way to default the current employee/user as the Owner on a PO receipt similar to a PO? I don’t see any settings or preferences that control this. Was hoping to accomplish without the need for a customization.  Thank you! 

I have a business event created that fires off of a generic inquiry that pulls from the PO.POOrder table.However, in the Generic Inquiry throws a warning in the results grid. The warning is a known bug that is suppossed to be fixed in 24R2. Link - https://community.acumatica.com/retail-113/issue-admin-access-rights-to-customers-object-in-gi-22253The error does not cause any issues with the results of the generic inquiry. But when a business event is built based on the generic inquir, the business event fails to run. Is there a known workaround, or am I forced to upgrade for something so trivial?  Bad! 

Hi! I have a sales order with an item with FIFO valuation that is being drop shipped. When I invoice the customer it uses the cost from the linked PO, which is correct at $100. However, when trying to figure out margins on the SO, I can’t find the correct cost. Both the Unit Cost and Average Cost fields show $18 which is wrong. Also, the margin calculation fields don’t populate. Any ideas where I can find the correct cost on the SO? 

Hi, Does anyone know of a way to automatically add a drop ship fee to an order that is coming from a 3rd party such as SPS?The item is a Non-Stock item and they want it added just for certain customers.  Thank you.