Inventory, Orders Management, Warehouse Operations
- 931 Topics
- 3,529 Replies
Is there a way in which the Quantity or Price can be checked or subjected to a threshold limit? This can prevent or reduce keying error entries. Perhaps the Limit on the Purchase Order should be enabled so e.g. If we already have a Max quantity in stock, then we should not be able to enter a new quantity to be purchased, unless their is already a sales order logged against the quantity on Stock, and then if so, that only the difference in quantity can be ordered and within a price range (otherwise requiring additional overriding authorisations).
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.
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
How to create shipment when primary location doesn't have enough stock and storage is not sales allowed
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?
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?
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?
Hi,I have been poking around Acumatica to get the Withholding Taxes to deduct from the Order Total instead of adding it or say display something like belowInstead of this:The sample picture is a P.O. with VAT of 12% and WITHHOLDING TAX of 2%. Acumatica sums up all Taxes and Line Total to get the Order Total. But we need it to be:Order Total = Line Total + VAT (12%) - Withholding TaxIs this something I can do in the Customization? Has anyone been able to do this project?
The company purchases consumables in bulk e.g. stationery, refreshments. Once received into inventory, employees request these items with the employee's manager approval. The request also should specify the expense subaccount. Inventory clerk should then be able to pick up the request and issue quantities on request or less but not more.Creating an "internal" order type seemed brilliant, selling the items at zero price. The only drawback was all order types including trade orders use the same shipment numbering sequence. How best can this be setup?
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?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.