Distribution

Hello all,I would like to know the purpose of Calendar under Customers (AR303000)→ Shipping tab. I’m looking to setup the calendar where whenever the sales orders is created the Shipment should be generate for Monday. How can I set this up out of the box?

25R1added SOPackageDetail to SO-Shipment Primary List GI added Tracking number to GridThe field does not show in grid, not blank - no column Note only one package on every shipment here is Relations and Girdwhat is issue ?  

Hi,I was trying to find out what could be the possible reasons for the mismatch between Inventory Valuation report balance against the Inventory GL Account. I have noticed that there were manual entries posted to the GL Account with inventory movement. Howvere, after the reconcilation with these GL entries there is some more mismatch. What could be the any possible reasons for these. 

We are SFP authorized by Amazon so cannot afford to lose this. As such when you buy shipping on Amazon (using our own accounts) we are protected should the carrier fail to meet its obligations. However this is not the case if we buy the shipping in Acumatica (even if selecting exact service Amazon recommends). This is a unique flaw with Acumatica.As such our workflow was we Buy Shipping and complete the shipment in Amazon, then we copy over package details, cost and tracking into Acumatica and complete the order. This then just created a lot of shipments daily that failed in the sync becuase Amazon was already showing as shipped. We just created a schedule that skipped these at the end of each night.Now though with 25R2 this workflow no longer works and despite us completing the order in Acumatica the same way the shipment fails and the new error is not enough information. Trying to figure out a new solution in 25R2 as this is now also preventing payments to sync under Amazon’s new pay

I have a question about the following scenario with Shopify ...Stock of item x in the warehouse = 1 piece Stock of item x in the store = 1 piece Customer 1 orders item x in the store (Order 1) Stock of item x in the store is now actually = 0 piece Order 1 is not immediately imported into the ERP system due to errors, etc Stock of item x in the warehouse and in the store remains = 1 Piece Customer 2 orders item x in the store (Order 2) Order 1 from customer 1 is imported and order 2 from customer 2 is backordered or rejected or Order 2 from customer 2 is imported and order 1 from customer 1 is backordered or rejected only after the import of one of the two orders is the stock in the warehouse = 0 pieces and article x is not available in the storeThe problem is store orders for item x, which actually no longer has any stock.Does anyone know a solution for this?Thx in advance.

Hey, Team - curious if this is even possible.  I’ve got a customer who is attempting to perform an RMA referencing a migrated invoice.  When I create the RMA and try to find the invoice, it is not available.  Any thoughts? 

Does anyone know if it’s possible to disable scanning of serial numbers during the picking process? Our client is also prompted to scan the serial numbers at the packing process, which is preferable, but it is duplicative work to also be required to scan during picking.If not, does anyone have any workarounds or solutions? Ideally our client can still pick using scanners but just not be required to scan serial numbers at that time.

Hello,How can we set the Form View as the default view for a Grid? By default, the grid displays in Grid View, but we would like it to open in Form View instead.Please refer to the screenshot below for reference. We are using Classic UI on Acumatica 2025 R2.Any help would be appreciated. Thank you!  

Hi,I would like some help with following scenario.I’m getting sales orders via an integration. Prices are agree with the external party, and the same is defined on the sales prices form. There are promotional prices as well as standard prices. I want to check and notify if the price entered via the integration is not agree with the sales prices. I’m trying to make a GI to show the sales order when the applicable price is not equal to the SO price. Having challenges in finding the applicable price when there are promotional prices. That is because the system shows the each price in the sales prices as rows which makes unable to compare.Have you done something similar of have any ideas to overcome this?Thank you,Dulanjana

There are some items which has been loaded to the create transfer order screen for the transfer order creation. however, those items are old stocks and currently we do not have stocks for those. How can we remove the item lines and does it affect any allocation in the system? 

Looking for options to move inventory between locations in Acumatica but using a handheld device thats super easy.  Do not need full WMS at the moment, just very basic internal location movements.   Open to suggestions.   Thanks! Nirav S.

I created a Prepayment Request for 50% of a PO and processed the prepayment payment. After that, I received the goods, created an AP Bill for the same 50%, and applied the prepayment to the bill to close it.Now I’m trying to create another PO Prepayment Request for the remaining 50% balance, but Acumatica shows $0.00 remaining and won’t let me request any additional prepayment. It looks like Acumatica is reducing the PO’s remaining amount by both the prepayment and the AP bill.Is this expected behavior? If not, what’s the correct workflow to prepay 50%, receive and bill that portion against the prepayment, and then prepay the remaining PO balance?

What is the proper way to record Sales to Lessors for your Customer?  For example, ABC Services Inc. (the “real” customer) is planning to “buy” a Trailer (the product) from us but have XYZ Leasing Inc. purchase it and lease to ABC Services.XYZ Leasing is instructing us to record them as the Customer in Acumatica and reference ABC Services in the Ship To address.  I think this is wrong - I feel the “real” customer ABC Services should the Customer in Acumatica and XYZ Leasing should be in the Bill To address.Does anyone have a creative way to do this and satisfy lessors requirements?  Should we be looking at parent-child relationships, Customer Locations, etc.?

Hi all,Is there any possibility to assign the Inventory Management method to FEFO (First Expiry, First Out)?Thanks in advance!

Our customer is trying to sync orders with Shopify connected to TicTok.  The orders from TicTok are fulfilled by TicTok (similar to Amazon FBA process).  With only one Acumatica Shopify connector, the orders are coming in as standard sales orders not SO IN orders to be able to process the standard Shopify orders.My plan is to setup a business event based on a GI that detects any new FBT (fulfilled by TicTok) orders and run an import to run the Quick Process action.  I need some help getting the Import Scenario configured.  I have tried several variations on the mappings but have not had any success.  The default settings when the Quick Process action is initiated are satisfactory instead of setting the date and warehouse. The current error message is ‘The Save button is not enabled’.  Thank you in advance for your time and support,John

Hi All,I came across a situation where I see Acumatica changed quantities based on applying a filter to a column within the Transaction History. When I apply a filter on "Tran. Type" to only show adjustment, it changes the ending quantity amount. It seems to remove the 10/2/2025 issue transaction from the math. I am not sure why it changes the math. It should only change which types of transactions are viewed correct?  Does anyone have any ideas what is going on here? Thanks

Hi everyone,We have a custom portal integrated with Acumatica, where customers can place orders and select Credit Card as their preferred payment method. These sales orders are then created in Acumatica via API.We’re trying to understand the best way to ensure consistent behavior on the Sales Order:If Payment Method = Credit Card, we want the system to automatically apply Payment Terms = “Credit Card” (which has 100% prepayment required) This should result in the order going to Awaiting Payment and triggering pre-authorizationBefore going the customization route, we wanted to ask:Is there a standard way in Acumatica to default or override Payment Terms based on Payment Method? Has anyone implemented similar logic using Automation Steps, Business Events, or configuration? Are there any recommended best practices for handling CC-based web orders coming from external portals?If this cannot be handled natively, we are considering passing Terms explicitly via API, but would prefer a standar

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.