Distribution

I am wondering if anyone else has seen the Account details disappear on inventory allocations once the allocation has been filled?  We see on items that are marked as SO to purchase that the account details show, but once the item is received these details disappear.  At this point the allocation is still valid as the items have not been shipped.  See screenshot 

After updating from 2020R1 to 2021R1, i went to create a quote in the mobile app and this is what popped up. Does anyone know if this is something that needs to be fixed at the inquiry level or customization level? I am not sure where to start.Thanks!

Anyone knows how to make it automatically to export inventory to csv and send to sftp server? I know I can export to csv and manually upload to sftp. I want to know if Acumatica has anyway to do it automatically. Even execute a command line after export file.

We have a customer that would like to default Shipping VIA and FOB Point fields.  Does anyone have an idea of how to do this?

In our process, we buy product from a vendor. However this vendor is able to offer product produced at various locations. We need to be able to identify the producing location for regulations. Right now we add locations but in order for the purchase order to print correctly as being purchased from the main vendor all addresses have to be the main vendor and not the location. Is there a current way to add a vendor location with it's address but be able to have the purchase order report print the "corporate address"?

We have Acumatica 2020 R1.  We offer free shipping if the totol purchase of items in select Item classesst is over $500.  It appears we cannot configure Acumatica to give free shipping by Item Class.  Is there another way to achieve our goal of free shipping for customers that purchase over $500 in select items classes?  Can we achieve our goal in 2021 R1? 

Acumatica Distribution Edition Overview WebinarMay 11, 2021 10:00 am - 10:30 am PSTJoin us for a 30-minute webinar where you will hear an overview of Acumatica Distribution Edition and discover real-time visibility into sales, order management, inventory, purchasing, production and services—and accounting information. In addition, discover new Acumatica 2021 R1 features.Speakers: Eric Moreau, Director of Partner Enablement and Presales, Acumatica 

We are currently using the Landed Cost feature to accurately cost our inventory. The inventory valuation report shows the updated average cost of the item, but we would prefer a report that displays the total cost of each PO receipt, with the cost per item shown. This is particularly important because our costs shift each time we receive inventory.Any tips on creating this report?

We have customers and prospects with their own fleet of delivery vehilces.  They are interested in using Workwave route optimization to help facilitate the deliver of Acumatica generated Shipments.   Has anyone integrated Acumatica and Workwave for Shipments?  I understand there is an integration for Field Service.  This request is for Order Management Shipments only.  

Hi, Everyone. Newbie here. How can I please make the line discount added from Sales order available to the Sales invoice printed forms pls? Below screenshot refers to the same SO document but I cant be able to make the discount line item appear on the 2nd form: 1. item 2 for discount - that's the same line I'd like to be visible on the printed form; 2. This is the actual from wherein discount is not reflecting but computation should be good, we only need to have it visible here same as the above: Thank you in advance!Jay Note: ARTran.DiscPct cannot populate it

Hi everyone,I have item1 at location A and B.A has 5 pcs. A is primary location and sales allowed.B has 100 pcs. B is storage location and sales not allowed.I got an error message when I submit a 10 pcs order. It asks me to transfer item from sales not allowed location. I understand that but does anyone has any ideas to ignore this error? For some big orders, user may ask 2000 pcs. But the primary location only can put 500 pcs. How to you guys working on this case? 

Currently, when we use the ‘Correct Invoice’ action, it creates a new invoice with a new reference number. Is it possible to retain the reference number from the corrected invoice?

How can I setup Acumatica so that I can scan a barcode, not necessarily through the mobile app, that will auto update inventory received on the document details of a Purchase Receipt, after identifying the vendor ID, and looked up the Open Purchase Order. This being required when you don’t have the Manufacturing module. I though this was standard out-the-box functionality?

Drill down to Accounting entries for the Purchase Order - where can that be found?

Hello Everyone,Can we change the Sales Order screen tab sequence order without changing the UI fields order?Currently, in the Sales Order screen when we click on the tabs, the sequence will be..Order Type → Order Nbr → Date → Requested On → Customer Order Nbr and etcWe would like to this change to below sequenceOrder Type → Customer → Order Nbr → Location → Date and etc Can anyone help me with this? 

Acumatica Distribution Edition Overview Webinar Tuesday, May 11, 2021  10:00 AM Pacific Daylight Time  30 minutesRegister Here.Acumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.Hear a company overview followed by a product demo highlighting Acumatica Distribution Edition.Find out why more mid-sized companies are choosing Acumatica as their ERP solution. 

Hi all, I’m looking to add UPS Ground Freight to our list of carriers/shipvia’s using the Acumatica UPS Plugin. The wiki notes carriers have various service types and lists ‘UPS Ground with Freight Pricing’ as one of the examples, leading me to believe this should be possible. Since UPS Ground freight uses a different endpoint URL for pricing and shipping, I’ve copied our existing UPS carrier that is currently working and added the freight URLs: Endpoint: https://wwwcie.ups.com/webservices/FreightRateShip Endpoint: https://wwwcie.ups.com/webservices/FreightShip I have also granted freight pricing, shipping, and pickup on our UPS account for production and have also tried this with the production URL’s. However, I keep receiving this error when doing a rate lookup:  Carrier Service returned error. 9371000:Invalid Freight Shipping Request Document Does anyone know how to correct this issue? 

How does your organization manage the use of Inventory Items in Acumatica?  Has anyone run into the issue of reaching the maximum number of inventory Items, which is what I assume is a limit of 1,000,000 records?  Plus the export functionality from Acumatica to Excel could be restricted by Excel’s maximum row limit of 1,048,576 rows.  Does anyone have any experience with or comments on this?

We have employees that use the numbering of the lines on a sales order to help ensure accuracy when entering a large SO.Our employee Lisa entered SO 102812.The line numbering was not sequential  (I guess the line numbers "skipped" from like 11 to 20 something)But I look at it today and its varied with line #s missing throughout.I then looked at the audit history, to see if lines had been deleted or something.  But honestly I can’t really make a lot of sense out of the audit history detail. Would you be able to identify why lines would not remain sequential?Not only with this specific sales order, but in general, what would cause this? 

Acumatica Distribution Edition Overview Webinar Tuesday, April 13, 2021  10:00 AM Pacific Daylight Time  30 minutesAcumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.Hear a company overview followed by a product demo highlighting Acumatica Distribution Edition.Find out why more mid-sized companies are choosing Acumatica as their ERP solution. Register hereRegister here for April 13 webinar 

Hello,      We are selling food, and we have several similar items, like: Chicken1, chicken2, chicken3, chicken4….   currently, these chicken items are handled in different individual item ids.       These items are similar only with the Brand difference.       So now the management have a need to see the inventory(Qty on hand) of “Chicken” together at once. we previously did this by manually adding different chicken qty together.       I know Acumatica having item class/item sub class,  item/sub item, matrix item, a lot of ways to define a group. But in my case, which is the best way. Can anyone give me some advice?

I’m running into some issues when it comes to the Acumatica Shipping Tool and importing the info automatically into UPS WorldShip. The issues primarily happens when it comes to foreign shipments, albeit I’ve only tested this with shipments going to Canada. Here are a few scenarios:Domestic ShipmentCompletes as expected with package info added.Foreign (postal code format ABC DEF)Postal Code → City Town → State/Province/County | Repeats 4-5 times Telephone → Email | Repeats 4-5 times Popup: “One or more required fields can not be filled: [Postal Code]. Check the availability of fields and shipment data and try again. No package data such as weight, invoice number, number of packages, etc. is enteredForeign (postal code format ABCDEF)Telephone → Email | Repeats 4-5 times Completes with package info added. After some trial and error, I was able to find that the postal code format was causing the process to error out and not finish. For whatever reason, having a space in the postal code cau

Hello!I wanted to outline an issue we’re having with Availability calculations and how to account for high volume SOs that require future stock for fulfillment. Hopefully other companies have experienced this problem and may have some good ideas.Let’s say we have 1,000 units of SKU X on hand and available in our domestic warehouse. We also have 20,000 units of SKU X on PO at one of our vendors. We don’t currently include Qty on PO in our availability calculation because it can take 60+ days to ship POs and 30+ days of transit time.A big wholesale customer places an SO for 5,000 units of SKU X, with the plan to have this fulfilled sometime in the future after the 20,000 units arrive. Right now, this type of situation drops our Qty Available down to -4,000 and it’s confusing to other sales reps whether there is any inventory to sell. Indeed, there is actually 1,000 units still available to sell.Ideas we’ve thought of:Linking this SO line to the pre-existing PO line. This resolves the Qty

Customer needs ability to have multiple line level discounts - Acumatica only allows 1 per line.  Has anyone encountered this request before and if so did you find a workaround or solution?I appreciate any feedback on this topic.Thanks!Michelle

Hi All,We come across the following customization in Sales Order screen in one of our projects.We need to open the popup upon Soline InventoryID selection. This popup has a grid where we need to add the values. Grid has three coulmns in which first two columns are selectors. Second selector has to load based on first selector selected value but these values are not loading. Used AutoRefresh='true’ and CommitChanges='true’ for both the selectors in aspx.Suppose if we open Popup in button click then second selector of my grid values are loading based on first selector.. but we should have this popup opening in inventoryID selection only.Please find the screenshots for more understanding.Opening popup in button click  opening popup in SoLine inventory selection.  How can I get the current value of Option Title selector so that Option Values selector will be loaded in the grid.Thanks in Advance.