Distribution

Is it possible in Acumatica ERP for an RMA order type to generate two open shipments simultaneously — one outbound shipment and one return shipment?The scenario is that a customer is receiving a replacement item while the original item is collected during the same driver visit. This is for bulky furniture items, where separate collection and delivery visits are operationally inefficient.The key requirement is the ability to create:an outbound shipment for the replacement item, and a return shipment for the item being collected…both generated together from the same RMA/replacement process, so they can effectively be treated as a linked operation operationally.Has anyone implemented something similar? At the moment, it looks like you have to complete the return shipment before you can create the second shipment. 

Hello everyone,I’m trying to calculate the selling price of my stock items (IN202500) using LLM prompts.Specifically, I want to multiply the field AvgCost (INItemCost) by a factor of 1.72, which accounts for the following costs: 10% Storage costs 2% Transport costs 20% Personnel costs 5% Marketing costs 5% Miscellaneous costs 30% Profit margin Unfortunately, I’m struggling to get the correct price calculated. Do you have any tips or advice?Here’s one of my test prompts: ## Context InstructionsYou are an AI assistant working with ERP data.## Instructions with Input DataCalculate the field ((InventoryItemCurySettings.BasePrice)) based on the following input data and formula.Input Data:- Average Cost: $((INItemCost.AvgCost))Calculation formula:BasePrice = AvgCost × (1 + 0.10 + 0.02 + 0.20 + 0.05 + 0.05 + 0.30)BasePrice = AvgCost × 1.72The following surcharges are applied to the average cost:- 10% Storage costs- 2% Transport costs- 20% Personnel costs- 5% Marketing costs- 5% Misc

I have a single user, out of 125, that does not have the drop down for inventory items when entering a sales order (see below). This is incredibly frustrating to the user because he is new and doesn’t know all of our products. How can I get this drop down to appear for him? Any ideas why it wouldn’t be showing up for just him? Thank you! 

Our company raises and sells exotic wildlife and needs to be able to capture the customer’s signature at delivery of the live animals - does anyone have any recommendations on how to do this?Ideally, they would also be able to note if an animal was NOT delivered/accepted for any reason. These notes would then route back to Accounting so we can make the necessary adjustments.We do the vast majority of the deliveries ourselves and need the delivery team to be able to pull up to a ranch, release the animals, have the customer sign off, and then the delivery team can confirm the shipment and send a signed copy to the customer.

I have a user who is concerned about the Manual Price checkbox being checked on the Invoice but it is not checked on the Sales Order. From what I can see, the prices are the same on the SO and Invoice. Where is the system getting this Manual Price field from? It is the same on the other invoices that I have checked. 

Hello all,I have a requirement where if a customer wants to return an item, the replacement item is first shipped and then the older item is received. Now in this case, the replaced item could be different than the originalone. How can I process this?

Hello TeamI am trying to use the customer metafield to sales order description.I’ve done the required mapping based on the below KB Article The same entity mapping working for customer entity but it is not working for sales order. https://community.acumatica.com/how-tos-and-faqs-262/how-to-map-shopify-metafields-to-acumatica-fields-when-importing-data-30209?tid=30209&fid=262 Try to bring the customer metafield when the shopify order customer, Order> Customer> metafield the data has to pull and update in the sales order description on header level. https://community.acumatica.com/how-tos-and-faqs-262/how-to-map-shopify-metafields-to-acumatica-fields-when-importing-data-30209?tid=30209&fid=262 Could you please any one can help why it is not working on sales order description.

Does anyone know the answer to this question from our customer? We are getting ready to go live with the ability to ship internationally out of Acumatica. We were testing a shipment this morning and comparing the label that printed to the label that prints from UPS Worldship, and the Worldship label has a second label printed that is a barcode version of the commercial invoice.  Is it possible that we can get the commercial invoice that is created in acumatica to also print out as a second label to be placed on the package? We were told by our UPS rep that the second barcode label needs to be on the box so customs can scan and bring it up electronically. 

In SALES ORERS/ TRANSACTIONS SHIPMENTS. Whether the shipment is unpicked, picked, or picked an packed there is a function when you used to be able to  “correct the shipment”. This feature now just returns an error, and locks the order up. If you don’t wish to finish the shipment and send to invoicing, you can’t change how the product was packed into boxes, you can’t put it on hold and delete the picklist (which allowed me, formerlly, to then delete the shipment) So reverse the order through all it’s steps, after the picking was confirmed, to delete the picklist, then the shipment. I now have a bunch of orders tied up like this due to user error (error confirming before finishing picking and the like, you know human stuff, and now cannot correct the errors.  It is super frustrating. So far I waited a week for acumatica to respond to my software vendor SWK’s issue, as the error that Acumatica was generating says “ERRORS HAVE OCCURRED” and correcting the shipment fails, the picklist doesn

Hello all,I have a basic requirement that an AP Bill should only be created if the PO receipt is 100%, else it should allow the user to even create it. How to achieve this?

Hi,In the 2024-R1 I don't see the Total Cost field on the Purchase Receipt - Summary area. Is this a change with 2024-R1?Please refer below screenshots. 2023- R1 2024-R1 Thank you,Dulanjana

For new customers the Default Payment Method is set to Acumatica Pay and works. However, I have over 100,000 customers with defaults set to Authorize.net.  I need to change them to Acumatica Pay as the default when an Acumatica Pay account does not exist for the customer.I created a GI that selects the correct customers.  I have tried the import scenario a couple of different ways, with none of them working.<Line Number> line was used to set Authorize.net as the default when we first got on Acumatica.  I do not know how to get the Line Number for the Acumatica Pay method.PaymentMethod table PaymentMethodID = TXACUCC                                    PaymentInstanceID = 58452Either way I run it the default is set to the first payment method which is the default cash option.Please Help. 

Hi Everyone,Has anyone overridden the "Generate" button in the PO Receipts > Line Details popup?I need to split a line quantity (e.g., 190) based on a custom field BreakQty (e.g., 60), so it generates lines like: Line 1 – 60 Line 2 – 60 Line 3 – 60 Line 4 – 10 Each with a new sequential lot number.Thanks in advance!

Is there any reason why Related Items is not enabled on Blanket order types? 

Hello. When we create a new item in acumatica, we fill in the Default Warehouse, Default Issue From, and Default Receipt To fields within the Stock Items screen.However, on the first use of the item the system creates an entry in the Item Warehouse Details and populates it from the warehouse settings instead of the item settings, which is just a broad catchall location instead of the specific location on the item. This would be fine if the material was coming/going from the non-default warehouse, but it shouldn’t be the case when using the default warehouse.Once this entry has been made, the system seems to entirely ignore the defaults in the Stock Items screen. How can i get the system to initially populate using the Stock Item settings instead of the Warehouse settings?Stock Item:Initial population after putting initial items into location 913-A-1 in an adjustment (adjustment did not default to 913-A-1 either): 

We are currently Drop-Ship Purchase Orders in Acumatica for Items that are shipped directly from the Vendor/Manufacturer to the job site/customer site. Is there any way to track these drop-ship Purchase Orders in Acumatica once the vendor ship them? we are looking to understand whether there is any standard integration or a third-party plug-in available to track shipment and delivery status for drop-ship orders.Any input or best practices would be appreciated.

Hi,We are using the Receive and Put Away function in Acumatica.When we scan in the Regular Acumatica Application (on our desktop), there are three distinct sounds for:Correctly scanned barcode Scanning error Release actionProblemWhen we scan in the Acumatica mobile app, there is only sound for correctly scanned barcodes. There is no sound at all for the other two (scanning error and Release action). Is there a setting in the Acumatica mobile app to enable these two sounds?

Hello all!We are looking at implementing paperless picking and I am running into a road block. I have found the topic of short shipments discussed over and over, but I have the opposite problem. Example:Item 123 has to be sold in multiples of 6. A sales rep accidently entered 5 in their sales order, and created a shipment. The picker knows this item must be picked in multiples of 6, but cannot enter 6 on the scanner. The overship threshold on item 123 is set to 999%, so that is not the issue.Is there a setting I need to change like the short shipment confirmation? (and if there is why isn’t it in the same place?)

Hello all,I have been trying to create an AP Bill via IC AR Invoice, however it triggers an error stating an IC PO should be created. Root cause is that the non stock item has been marked “IS A Kit” and an IC SO has already been created, whereas the user doesnt want to create an IC PO, instead they want to directly create an AP Bill.  Any suggestions as to what can work out? maybe a workaround? Thanks.

What field defines the default Unit Price for a STOCK ITEM on a 2-STEP Transfer? Doing international transfers and customs needs to know a value. It’s not a price worksheet (this is a warehouse, not a customer) and “Default Price” doesn’t seem to come over when making a new Sales Order of type TR.I can code around this (if price = 0, then get Default Price from Stock item), but if something already exists, I’d like to leverage that instead of attaching my Mickey Mouse code to the report. Thanks Everyone!

Hi,I came up with following issue when trying to confirm the shipments. The behavior and the re-creation steps are as below.The following dialog box appears when confirming the shipment.This can be re-created with the following steps.Create a sales order with an existing configuration version and produce the item. Once the item is produced, create the shipment and do not confirm the shipment.  Create a new configuration version for the same item, and inactive the previous version. (one used to produce the item which is in shipping) Change the default configuration ID in the manufacturing tab of the stock item to the latest revision. Now try to confirm the shipment and you will get the above message. Once the dialog box is populated, the Yes or No buttons does not process the shipment and keep generating the dialog box. This can be eliminated if the default configuration ID of the stock item is cleared. Once cleared, the shipment can be confirmed without above dialog box. I’m trying to

I have a Healthcare supplier that will need to integrate with their marketplace/commerce called GHX or Global Healthcare Exchange.  Looking to see if anyone has any details how Acumatica would work with GHX.

Has anyone ever created a new workflow or a customization (I don’t believe there is native functionality) to allow a drop-ship PO to be generated from a Project Sales Order or Transfer Order instead of only the normal SO (Sales Order)?For projects and material staging (in the warehouse and on-site) we won’t be using the regular SO due to not needing to invoice the customer as this will all get invoiced through field service or projects. The ultimate goal is to not have to make a drop ship PO from scratch, as it is important to be linked and generated directly from the order.

Is there a field where the open PO cost amount is stored, both at the line and order level?  We issue a lot of PO’s that have multiple receipts and I haven’t been able to easily run a report that shows open amount by line as well as the order total.

Hi Community,Is there a way to ship internationally using the Acumatica Shipping Integration Module?  I also have the same question about how to ship using LTL with the Acumatica Shipping Integration Module. Would love to get the Community’s thoughtsCheers,RJ