Inventory, Orders Management, Warehouse Operations
- 924 Topics
- 3,494 Replies
Hello all, I wanted to ask if there is already a transit process in Acumatica or planned?The process looks like this: A company from Germany orders e.g. metal in China. This metal is brought from the supplier in China to the port and shipped on a ship. The ship is on its way to Germany for at least half a year. In Germany, the goods are transported from the ship to the company, which then ships the material to the customer. In the ERP this should look like this: Purchase order to the main warehouse-> Stock transfer to fictitious storage location "Transit", as soon as the goods are loaded onto the ship in China (these transit transactions are to be displayed in an overview, from which the goods receipts can be created) -> As soon as the goods have arrived in Germany, a goods receipt is to be created from the above-mentioned overview, whereby a stock transfer from the storage location "Transit" to the storage location "Main" is triggered in the background and the goods receipt can
Hello Everyone.I would like to understand the functionality of Avg cost in sales order I have reviewed the Stock Item Price cost and observed that avg cost is 256.85 but in My sales order when the SKU is selected it is showing 303.50Further, I verified and observed the avg cost value is coming from the inventory summary- Estimated cost columnJust want to understand why the estimated cost value is not updated on the avg cost details under that SKU or else do we have functional calculations on this?Any thoughts on this? Also, share the article if you have anything related to this. Notes: All receipts are released, No pending transactions for this item with the respective purchasing side
Hi Acumatica Community,At the time of customer creation , Customer ID is a mandatory field. Is there any settings to make this field system generated? I have got this requirement from user, they dont want to manually enter customer id, rather it should be a system generated chronological ID.
We haven’t even started using the system at work but we’re supposed to test it out and both times I tried logging in I got locked out. Why do you lock people out if they are using the password that was set up, then they have to reset it but can’t. Why, because they are locked out. This is terrible and I cannot be the only person who has been locked out of the system.
I’ve found that the non-stock kits default in a qty 0 shipped qty on the shipment. The allocation of the kit items do not occur until the shipped qty is manually updated. At that point, the items display on the pick list. Does anyone know why normal items bring over the shipped qty from the order while non-stock kits require inputting in a qty before the kit components allocate and show on the pick list? In order for the components to display, this flow is requiring users to manually updated the shipped qty on the non-stock kit item to get the components to allocate and display on the pick list.
Hi All,I got 1 item that has no customer price class, no customer price, and only 1 base price - 1 carton = 3 usd.item convert - 1 carton = 3 canswhen I create SO and pick 1 can - it will automatically key unit price = 1usd even though I haven't imported that price.So it means when I update the sale price for 1 unit, and that item has more than 1 convert, the system will auto calculate the sale price I import to other converts.Thanks for your advise,Yên Chi
Consider the following scenario:Customer places an order on a website and chooses their shipping method Order is injected into Acumatica as a Sales Order. Ship Via exists here. At the time of order injection, we determine that it will be fulfilled via DropShip and automatically set the Order Line up accordingly. We have Automation that “creates purchase orders” for all of those orders.Now, a human needs to go and touch every single PO and set a shipping method. I saw this rejected idea from four years ago: When we transmit a DropShip PO to a partner, it must include a shipping method. Our partners are shipping 3rd Party on our carrier accounts and we need to specify the class of service. Requiring that value to be set manually when it’s already been determined earlier in the order lifecycle is not at all scalable.I’m honestly a bit shocked that I’m going to have to develop (or pay for) a customization to handle what truly is a bug.
How to add consulting item to Invoices screen (SO303000) when creating Invoices from Prepare Invoices
I want to add non stock consulting item(See below figure) to invoices screen details tab when creating prepare invoice from shipments screen. I tried override shipment screen “CreateInvoice” action as well as fire Row Persisted event and override Persist method in Invoices screen too but unbale to do. I saw when fire Row Persisted event or override Persist method just executing(looping) no end point. Please give me any answer or suggestions.
An error occurred during processing of the field Lot/Serial Nbr. value Error: Lot/Serial Nbr. cannot be found in the system.
During picking a handful of times, we are getting this error. I’ve checked each time and the lots are correct, the correct qty is allocated/picked, but the system will not let us move to a sorting location. Is there anything I can do that doesn’t involve adjustments?
I have set up an approval in request with 3 steps: Approval Level 1 (<1K), Approval Level 2(1K-2K), Approval Level 3(>2K). How can I also set up the notification such that after level 1 approve for <1K (request status becomes open), level 2 and 3 does not need to approve, but system will send notification to notify the level 2 and level 3. And also, after level 1 and level 2 approve(1K-2K), level 3 does not need to approve, but it will send notification to notify level 3 that request has been open.
If alternate IDs with the Global and Vendor part number types were specified on the Cross-Reference tab on the Stock Items (IN202500) form for a stock item and a purchase order was created for a sales order with this item, the system inserted the global alternate ID instead of the vendor part number in the Alternate ID column on the Details tab of the Purchase Orders (PO301000) form for the item Fixed in 22R1 Update 10 Build 22.110.0018.
Food Distributor working on Acumatica 2022 R1 Build 22.110.0018 The scenario:We have items that we are running low we assign a substitute for them.We have 2 types, mandatory and regular.Mandatory means that if the original item is on a sales order, our current system knows that we should fulfill the order with the sub item without further human intervention. The system shows on the invoice:Item A Qty Shipped: 0Item B: SUB, Qty Shipped: 1Regular means that if the original item is on a sales order, our current system waits for a human to apply the sub.If the human decides to allow for the sub, the system shows on the invoice:Item A Qty Shipped: 0Item B: SUB, Qty Shipped: 1If the human decides to NOT allow for the sub, the system shows on the invoice:Item A Qty Shipped: 0 I have been testing with Acumatica but I cannot make it behave the same way:Under Stock Item > Related Item I set the item as follows:I am expecting this setup to behave like what I described as the mandatory sub but,
Hi All, I have another question about Inventory Summary and Inventory Valuation Report. I just realized that the amount in those two reports are not the same. Please refer to the screenshot documents below:In Inventory Valuation Report, the total cost is $80,109.09 which is the correct. However, when I opened Inventory Summary to see the Estimated Cost per unit. Instead of the total cost is $80,109.09, the total cost in Inventory Summary is $80,108. Please refer to the screenshot document below: Please kindly advise why is the amount of total cost is different between two reports. Thank you Regards,Nadia
Hi All, I have a question regarding the inventory report: I checked on my Inventory Transaction Detail for Beginning and Ending Qty. Please refer to the first page on period August 2022 screenshot document below:The beginning balance is correct because I just created the stock item so the beginning balance is zero and the ending balance is also correct because I purchased 400 item in August 2022.However, when I changed the next period, instead of reflecting the ending quantity from last period, the beginning quantity begins with zero again. Thus, the ending quantity is minus. Please refer to the second first page on Period September 2022 screenshot document below:The beginning balance starts with zero again, resulting the ending qty balance become minus. When I checked the report, it reflected right quantity balance. Please advise how to fix the information regarding beginning and ending balances in Inventory Transaction Detail. Regards,Nadia
Hi All, In a dropshipping instance, A sales order had been received for a 1000 quantities and based on that PO order and GRN were prepared. Is there a way to increase the sales order quantity in such a scenario? The scenario can be summarized as follows,Sales Order original qty 1000 (drop ship) PO created PO Received – Qty Received 900 Customer increase the order qty to 1200What is the best way to handle this, without creating a new SO Line or another Sales Order?Thanks
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.