Distribution

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? 

Hello, i am trying to work on non stock kit flows:image 1 shows the non stock kit simple two components.image 2 and 3 show the sales order and shippmentimage 4 is action print picklist, but why the pick list does not who the two components as specified in the kit spec as in image 1?  RATHER, it only shows to pick the non stock kit.. please help anyonethank you IMAGE 1 image 2 and 3 IMAGE 4  

 Hi,I need your suggest , how dissable button pay for specific role / user without customize/ coding .  

Hello,I have made some researches but cannot find anything with similar functionality to Blanket Purchase Order for Outbound - Sales Order & Customers. I know there is also Customer Contract but it seems to be only for non-stock items.What I need exactly it is a kind of frame agreement with Customer with fixed quantity to be purchased in fixed period of time. Then in relation to that frame, call offs order will be pre-set and periodically adjusted and proceeded. Then later all have to be link to MRP.I would be grateful if somebody had some suggestions or share with experience how to proceed this process or similar one in Acumatica.Thank you in advance.  

Hello,      Acumatica has its B2B online portal, which customers can place orders directly. However, for a same single portal, it looks like all orders will be assigned to the same branch, which is portal default branch.            We are having multiple branches and serving different customers.Is there a way that the orders to assigned to its specific supporting branch?   

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.

I am perusing the available out of the box sales order reports like the sales order summary.They all seem wrong and do not adjust for discounts on the orders.All of the totals are wrong on every report.Am I missing something?

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

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

Hey everyone,  need a little sanity check here.  Everything I’ve read, watched, etc. makes me sure that the Automated Replenishment process consist of starting with the Prepare Replenishment screen (IN508000), where we check items that have ‘Purchase’ as their replenishment source and a default vendor and ‘process’ them.  Then they should show up on the Create Purchase Orders screen (PO505000) where we can create the POs. Yet, on our Live site (2020 R1 Build 20.118.0007), only occasionally does one of the items show on the Create Purchase Orders screen and on two test sites (2020 R1 Build 20.109.0032) and (2021 R1 Build 21.108.0032) they don’t show up at all.  On the Prepare Replenishment screen, they get values in the Qty. Planned column.  If they are not on the Create Purchase Orders screen, where are all of those Qty. Planned items or documents?  Is there some setting that we’re missing, because we’ve gone over the end user and partner docs checklist multiple times, or do we have a