Distribution

HI, I have created a Item with UOM as CTN. I need to change this to BOX. I checked this, if I have any Transactions system allow me to change Sales and Purchasing Units. Then system created a conversion between both two unit of measures.  Tested scenarios attached with screen shots. 01). As mentioned Item Base unit is “CTN” and Sales and Purchasing UOM are “BOX”.Created a sales order and Order line has taken UOM as BOX then Shipped. Shipping Lines Considered UOM as BOX.  My Questions are:(01). If I change this over to a conversion rate of 1, and change the Unit of Measure, what will the implication be when we sell and purchase this item? Is it going to create a mess in the background with regard to the costs, or the average cost? (02). Is there any other validation or concerns about the UOM changes? RegardsNethupul   

Hi, I want to ask , is it available for input batch number of product in stock items menu ?

sd

Needing to change all customer profiles FOB point to a certain ID. We were able to change the description but need to change or delete the ID. Any suggestions? Thanks!  

Customer created a Credit Memo with an Inventory Return.  They need to reverse this Credit Memo and associated inventory receipt.  Is there a way to initiate the inventory issue with a Debit Memo, or does the inventory have to be handled with a manual adjustment? Thanks!Luke

Hello everyone,I get a error on the Pick, Pack and ship screen for unit of measure items. On my Stock Item my Base unit is CANS, Sales Unit and Purchase Unit is BOX.   Created a Sales Order with BOX UOM Shipment is showing correctly The Pick pack and Ship screen defaults to CAN UOM and converts the quantity but i get the following error. Pick Pack and Ship screenIf i change the UOM on the Stock Item to be the same for Purchases and sales then i don’t get an error on Pick Pack and ship. The problem with this is that will cause problems with the Procurement dept. and Sales Dept. has they will have to change the UOM every time to BOX.  Can we have Sales and Purchasing unit of measure different from my base unit when using Pick Pack and Ship?  

When receiving on a handheld in Acumatica (receive and Put Away). There is not the ability to change the unit of measure. That would be fine - except that we find that the quantity shown on the handheld as received always show in the base unit of measurement and not the received unit of measure. This is confusing to our warehouse staff.Does anyone know if there is a way to expose on the handheld the quantity received in the purchase unit of measure - in addition to the base unit of measure?

Hello, I cannot get a KitAssembly, Type=Disassembly to create through the REST API.  I am able to create a KitAssembly, Type=Disassembly through the Acumatica Kit Assembly user interface but a similar transaction through the REST API fails.  I am also able to create a KitAssembly, Type=Production through the REST API.I am making an assumption that a Disassembly type REST API call would be rather similar to the Production type REST API call.  I am using the same data structure just changing the Type to Disassembly. There are two errors that I get back that stick out:[LocationID] ‘STERILE’ cannot be found in the system.KitAssembly.ReasonCode. ‘Reason Code’ cannot be empty.Both of the above properties are being set in my API call and they do exist.

Hi All, we updated to the latest build and now scan gun when you do scan transactions, the “set qty” is not working any more.  So you can only add qty of 1 every time.  This is very bad.  Anybody else has this issue?  know how to fix?  Thanks.  Alice

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,

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? 

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. 

In a report I want to highlight/ change the background color if the value is greater than 1. I understand i need to put two fields on top of one another. One with the default state and one with the changed state. my questions are as follows:=[POLine.BaseOpenQty]=[POLine.BaseOpenQty]               Do I use visible expressions for each field? Can you help me write the expression?I am leaning towards an IIF, but that is as far as i got.

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

After confirming the shipment in the Shipments (SO302000) screen and then click on Print Labels option under the Actions button, it is not getting redirected to the Carrier Labels (SO645000) form. Kindly guide us as to where are we missing in the step. Thank You.

Does the Hubspot integration bring quotes from Hubspot into Acumatica?

Hello,Can anybody guide me the reason and how to resolve the below attached error ?  Thanks in advance.

is there a way to insert vendor catalog items into Acumatica without creating a stock item record but instead of catalog item that then converts into a stock item when sold or purchased? Thanks,Nirav Shah

Hi All,After we issue an Invoice, there are some cases we have to cancel the Invoice & SO, or adjust the price, we create RM & RC from SO Screen for current. But there are no identification signs on the Original SO that show the Original SO is canceled.It seems we can not know which SO is canceled and which one is processed successfully.Do you have any idea about this?Thank you so much,Yên Chi

Does Acumatica have a build-in tool to reconcile a Vendor Statement of Account? 

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.  

Hello Everyone,I’m wanting to allocate items to a production order but 99% of our inventory is lot controlled. It looks like this feature isn’t currently available for lot-tracked items, do we have any idea when this feature will become available or if there is a way to allocate lot tracked items to production orders?  

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

Hello, On Hand, Available, Available for Shipping, and Allocated quantities are visible at the bottom of an inventory transaction screen.  The Allocated quantities seem to always show 0.00, even if items are listed on the “Inventory Allocated Details” inquiry.  Does anyone know what field the Allocated quantities is pulling at the bottom of the screen? We need to add it to another screen and also understand why it is 0.00.  Thanks so much!  

HiIs it possible to one-step transfer a stock transfer to multiple warehouses at once?