Distribution

Is there a stock report/GI that will show me past due POs? I’d like to be able to look at all POs for a given vendor and see who delivered late against their promise date. This will be helpful for supplier reviews. I’m less worried about what is late TODAY and more worried about looking at performance over a time period. As Always, my thanks to the community! -Jordan

When cycle counting, we were under the impression that there was an option to create a physical inventory type that would include all items in a location every time even if they are newly created item.

We have a customer that is fast approaching 9999 on their auto incremental value numbering?  I would like to know what happens in Acumatica when this happens.  Does auto numbering stop? Does it continue counting?  We want to have a plan in place if needed?  

Just as in Advanced manufacturing and for the same reasons, it would be useful to create a Kit Assembly from a Sales Order.  i.e. Mark for Kit.

Hi EveryoneI am currently facing a scenario where the same lot number is being received across multiple purchase receipts for the items. We need to implement validation to ensure that duplicate lot/serial numbers are not entered in multiple receipts, while still allowing the same lot number to be received in different receipts.Could you kindly clarify if there are any existing validation configurations or methods in the system to prevent duplicate lot/serial entries in Purchase Receipts? Additionally, I would appreciate any guidance on how to handle this scenario effectively. 

I am hoping someone can suggest something for this rounding issue in PO Receipting. POs are normally in Purchasing Units, but Drop Shipment POs created from Sales Orders are in Selling unit for some reason.  So create a PO with UOM of EACH and Qty 2 for an item set up like this. Then create the PO Receipt from the PO. The receipt qty is correct by there is a decimal open qty calculated. You have to do a second PO Receipt for the remainder. Is this really necessary? Even if you increase company qty decimals you will get the same problem in the last percentile.    

Sales Order - > Create Purchase OrderIn the Create Purchase Order screen , click ‘Process ALL’Error: Inserting 'Purchase Order' record raised at least one error. Please review the errors.Error: 'Owner' cannot be empty.       at PX.Data.PXUIFieldAttribute.CommandPreparing(PXCache sender, PXCommandPreparingEventArgs e)   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.<To>b__0(PXCache cache, TArgs args)   at PX.Data.PXCache.OnCommandPreparing(String name, Object row, Object value, PXDBOperation operation, Type table, FieldDescription& description)   at PX.Data.PXCache`1.PersistInserted(Object row, Boolean bypassInterceptor)   at PX.Data.PXCache`1.Persist(PXDBOperation operation)   at PX.Data.PXGraph.Persister.Persist(Type cacheType, PXDBOperation operation)   at PX.Data.PXGraph.PerformPersist(IPersistPerformer persister)   at PX.Data.PXGraph.TransactionalPersist()   at PX.Data.PXGraph.RetryTransaction(Action persistBody, Int32 maxRetries)   at PX.

Can a sales order has multiple lines of document discounts? Acumatica only allows one line of document level discounts. There is a requirement from my client to enter two lines of document discounts. How can this be handled in Acumatica? Is there a workaround to cater the above requirement. 

Hey folks,Looking to get some information for our Data Warehouse and came across a funky little calculation discrepancy that we can’t seem to figure out.  If you look at the SO Totals page in this example and you read the documentation it doesn’t seem that Unbilled Balance and Unshipped Amount are correct.   And can’t really figure out how these are calculated…   Also not sure how Order Level Discounts are factored in here, but any insight would be helpful.  We are trying to siphon out the unbilled/unshipped amounts for reporting and they do not match the SO values… 

Is anyone else using the True Commerce EDI solution with Acumatica 23 R1?  Our integration is being logged off constantly...sometimes once per day, sometimes once or more per week.  So far, no real solution from Acumatica support.  True Commerce support says this is not an issue on their side.  Any insight is appreciated.Thank you.

Once a reason code is used in a transaction; it becomes a permanent record.  Need the ability to deactivate reason codes; especially those used for special one time purpose.  

Hi, We have a large number of Warehouse locations (over 500) and at present we are having to manually Transfer Receipt Transfer Orders into those warehouses.  Is there a way of completing these Transfer Receipts in bulk (same as Confirm Shipment) or an automated process that can be scheduled? Thanks in advance, Ben

How to get production URL end points?  The documentation leads us to UPS developer site.  I have spent an hour trying to figure out where to find the URL Endpoints.  Can someone please help!  Thank you

Hi,In one of customer’s environment I do not see the line level discounts in the sales order document summery area. But all other , and Local environments shows the Line discounts at the document summery area. Is there any place that I can enable it? Thanks,Dulanjana

Hi Acumatica community members, In one of my customers environment , I have created a sales order for a customer .In the customers screen I have defined the shipping rule as ‘Back Order Allowed’. In the sales order screen when creating a new sales order for this customer , the shipping rule in the sale order shows as ‘Back Order Allowed’ which is the expected behaviour.Then I created a shipment for this sales order for partial quantities , and confirmed the shipment . The sales order status shows as ‘Back Order’ which is the expected behaviour but the Shipping rule in the shipping tab  of the sales order and also the detail tab shows as ‘Ship Complete’ which is not the expected outcome. This should be ‘ Back Order Allowed’.I tested this in the default local instance , the behavious is the shipping rule kept ‘Back Order Allowed’ when the sales order is in the ‘back order’ state.In other words , I could not replicate the issue in my default local instance.Is there any reason for this beh

Hello all,I have been trying to setup integration between Stamps.com & Acumatica but upon testing the connection it shows the following:How to resolve this?Update:Found the below info on Stamps.com website:I tried to test the connection using the Staging Endpoint URL as highlighted above, but now it displays “Authentication failed” error message. I also found out that i needed to register for a developer account. So just waiting to get it started and again test the connection.

we are trying to do our physical inventory count for year end.  we have about 9 count that when we try to complete we get the error “Unable to create adjustment for line ‘121’ Insufficient Qty. on hand for item ‘1234’’ in warehouse’  this warehouse hosts all our truck, so each truck is a location and all have the same part numbers.  i understand that as a whole based on the book qty the adjustment will cause the that item to go in the negative.  The solution would be to update one of the other trucks with this sku that would make this sku go positive first.  The problem is that we don’t know what truck that would be, and if we did, we get the same error with a different sku. it there for becomes one big circle with the same error. My only thought now is to make an one big adjustment dated before year end to every truck by adding 1 item of every sku to each truck, then update the physical inventory count to hopefully bring the inventory back in line. Any suggestions would be appreciated

Hi everyone,May i ask for your help/insight with regards to this kind of inquiry in Sales Order > Shipment moduleScenario:I got two different SO transactions(SO#014067 & SO#014068) in one Shipment transaction, then I made the first shipment  of SO#014068 all the way to invoicing and payment of it, then the status of shipment transaction is Partially Invoiced.Now, my question is how can I edit the Shipment QTY(because I want to ship some SO lines in a partial) or how can the CORRECT SHIPMENT field can be use in this kind of scenario?Please any insight will be appreciatedPlease see screenshot for your referenceggil SO#014067 014068 Shipment # 002064  

We ask customers to prepay for inventory items but not freight or tariffs.  Is there a way to include shipping on the Sales Order but not force the customer to pay for it till after delivery?

Can anyone assist with why this error is occurring in our our system? We are two years into implementation with SWK Technologies and are still having basic errors like this pop up as we demo the system.  An error occurred during processing of the field Location value WARRANTY IN Error: Selected Location is not valid for receipts.

I have an interesting scenario, and I’m not sure if there is a broader need for this, so I’m not posting it as an idea. We have different types of customers, i.e. Wholesale, Retail, Online Marketplace.When we buy stock items, we estimate how much each type will sell over the period we’re buying for. We want to be able to restrict the amount they are allowed to sell before replenishing their stock level. Example, we buy 300 of an item monthly, the estimation is that each division (type of customer) will sell 100 in that period. Then we get a big order from a wholesale customer that depletes the wholesale stock and some of the other stock. Now our retail locations won’t have enough, and it hurts their sales numbers. We’re currently developing a custom solution for this but would love to hear what others think. Having different items in Acumatica, or hard allocating for a specific customer, or having different virtual warehouses won’t work for us, as it would greatly impact our warehouse

Hello,Trying to deactivate a warehouse and it gives us the Unreleased Transaction error.  Can’t seem to find any transactions related to this warehouse.  any ideas?  Thanks in advance! 

​I wanted to share some code with you all, as I have not seen too much about adding custom actions into the SO Quick Process workflow. We have a custom requirement to set a shipment as delivered before it can be invoiced. I have added the workflow status of Delivered to Shipments, and updated the prepare invoice action to require the status of Delivered, and not Confirmed. We may have shipments picked (confirmed) and sitting before either truck delivery to the customer, or hold for pickup. My workflow customization works great, but we want to add the ability to set it as delivered on the SO quick process screen if it is a “counter sale.” Customers would walk into one of our stores and purchase items and walk out with their products. We use shipments for our DOT paperwork and other customizations, so it is not a order of type cash sale, but a normal sales order. I was able to add a “Set Delivered” action to the quick process, and the workflow has been working flawlessly.This is done by

Client is on 2024 R1.I have an SO line for 40 units of an item. There are none in stock.The item has a min of 50 and a max of 100. Prepare Replenishment tells me to order 140. I decide to order just 100, which will leave 60 for stock. I create the PO.I subsequently decide to Mark the SO line for PO and link the 40 units to the PO line for 100 units.This action changes the entire PO line from “Goods for RP” to “Goods for SO.”When I rerun Prepare Replenishment, the system tells me to purchase 100 because it’s not recognizing the extra 60 on the existing PO because of that flag.Wondering if I’m missing something in setup or is this just a shortcoming of how Acumatica handles this?

Hi! I have this adjustment transaction that was auto generated from landed cost that is not defaulting in the lot number although the item is lot tracked, fifo and a lot # was assigned on receipt.