Distribution

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.PX

After upgrading to 24R1, it seems that the Total Cost field was removed in 24R1.  What was the reason?  Is this an oversight or is there some other way to get this information? 

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 m

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 s

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

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

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

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. 

Hello Community. I am looking for someone (Subject matter expert) that can help hand hold our purchasing and operations department whilst we implement the DRP within Acumatica. Is there anyone out there that charges by the hour to help two of our staff members set up all the purchasing forecasts and business events to automate what is possible and make the stock management as efficient as possible. This will have to include training on using a dashboard to manage the overview and to have a daily and weekly summary to send to the directors for their insight.In the near future we are seriously also considering integrating with a 3PL company for storage and we will need assistance with integration with their system via API’s.any recommendations, guidance or contacts appreciated.

I am sure this is a basic question, but I need to add some steps when releasing from Risk Hold.I copied my Release From Hold commands and changed it to ReleaseFromRiskHold.  Visual Studio Acuminator message:  The signature of a method with the PXOverride attribute must match the override method.I went into the Customization Project Code to have the system create the extension code for me.  I did not find ReleaseFromRiskHold as an option.   Code:public delegate IEnumerable ReleaseFromRiskHoldDelegate(PXAdapter adapter);[PXOverride()]public IEnumerable ReleaseFromRiskHold(PXAdapter adapter, ReleaseFromRiskHoldDelegate BaseMethod){    // my code here    return BaseMethod.Invoke(adapter);}Thank-you.

besides the customers screen , sales order screen (shipping tab and also line detail) and shipment screen (line detail) , where else the shipping rule is defined?

Is there a way to print a vendor bill or a cash purchase with all line item details for that matter? We pay our subcontractors but they don’t submit an invoice to us, so they need to be able to see what line items we paid out for on each check that we print. It seems like the check only shows the bill # or bill description with some report modification.