Inventory, Orders Management, Warehouse Operations
- 774 Topics
- 2,876 Replies
After setting the Payables Price Settings to fixed for "0" months, I can still only see the last vendor purchase price that was used to purchase from a Vendor. On the Inventory Stock Item - again I can only see the last Inventory price that was processed by the system. Since by implication the preferences indicate that the vendor purchase prices are retained, please advise where the list of those retained prices are for dealing with a vendor (It cannot be in the stock transaction history, as that does not relate to the Vendor)?
Is there a way to change settings in the Purchasing module to have any stock item that is at a negative quantity (i.e.outstanding sales order for the stock item that is not in stock or only partially in stock) to populate on the Create Purchase Orders screen? In essence, automating the “Mark for PO” check box on the sales order forms.
I have been working on a business event that triggers an email once a customer creates order from the web portal and falling short. The trigger has not worked if the portal users generate the order. If I change the business event to trigger on record change and then do any modification changes from the ERP side, it works from the portal sales orders. The New field value is set to createdByScreenID and Screen ID = SP700001. Could this be related to the customer's user's account types and users' permissions? Your support is appreciated.
Hello everyone!Is there anyway i can change the order of the tabs in the sales order screen?We are wanting to move the “ADDRESSES” tab to be in between the “SHIPPING” tab and “DISCOUNTS” tab. When i look in the customization screen, it appears that the order in the screen editor is correct but it does not display in ACM that way?Any ideas?Thanks! :)
Hello AllI would like to ask if it is possible to set Sales Orders to be generated automatically fex. every month (same Customer, same Item, same q'ty etx).For non-stock item I would do it using Customer Contract. But I have no idea how to set it for Stock items.Is it at all possible out-of-the-box?I would be grateful for any tips.Thank you.
We use Honeywell mobile hardware with the Acumatica app with the distribution module. Our delivery drivers experience an issue where the app logs out from their users when connecting to the charger. This issue happens on all the Honeywell hardware styles we use. After testing with their provisioner application and changing Android daydream settings, we reached out to Honeywell, and here is the information. There is a power state change unique to Honeywell devices; we need to make sure we are implementing the Honeywell SDK's for android.The problem exists in the coding; the hardware will report a battery change when taken out of the dock, in which case some apps will log out when they sense a battery change, which needs to be ignored in the coding. Honeywell units have technically three potential power sources: AC power/ Super Capacitor and standard battery discharge. The device is smart enough to manage it automatically but treats all power conditions as a battery change. Does anyone
I need to report some data to a supplier via ASCII files. those files have header record, details and end record. How can I achieve this with Data Providers. I tried to load the fields from the file but it only reads the first record which have a different layout than the details record and the end record. Maybe it is better to do this with the Report Designer?Please advise. Jesus.
Vendor charges Freight for Drop Ship on PO.Auto shipment created for drop ship receipt on sales order:Sales order gets completed upon auto receipt and no opportunity to charge back freight to customer on sales order:Freight can be added manually to Sales Invoice before release but the freight charge backs can be missed which happens most of the time.Any way to have freight populate on the Sales Order upon release of receipt?
Acumatica Distribution Edition Overview Webinar Thursday, June 10, 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 Here
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
Introduction:I wanted to pull a specific list of inventory items from a generic inquiry. Problem: I tried to use "Is In" operator for a condition. However, it does not seem to work as expected. (I tried various combination while profiling and could not get the SQL to translate to [column] in ('test123', 'test456', 'test789')) If there is a way to use the "Is In" operator, please share. Solution:Add a parameter to enter the list of items. (Set the Schema Field to InventoryItem.Body for maximum characters) In Result Tab, add a column that utilizes "InStr()" to search for the InventoryCD in the parameter field. (Convert to CDec() for better filtering)Paste a list of item numbers and filter the formula column “greater than” zero. I hope this helps.
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.
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.