Distribution

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

I want to know about benefit for using cross reference with barcode type on Stock. i realy tanks for helping me.

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?

Trying to figure out how I can enforce entry of a lot mask of format NNNNN/AAAANNNNNN-N where N is numeric and A is alphanumeric. We will receive the AAAANNNNNN-N part from a vendor and after performing inspection of the product will prefix it with NNNNN/ denoting that it’s an inspected received part. None of the parts of the lot number are auto-incremented, and there seems not to be a way to define the length of the segments, or the acceptable data for the segments. Is this possible to achieve without customization and if so what am I missing?

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

I create business event to auto hold my saleorder but some records process holds successfully but some record show error “0 records of 1 have been processed. The last error was The Hold button is disabled.”. But I checked the order number the hold button is not disable. I can hold it manually with the order that alter error. 

Hi there,We have a client who completes a monthly material stockcount, but they have distributed sites and often the stock count sheets aren’t received until the midway through the next morning or even a day later i.e., 1st/ 2nd.When the PI Counts are entered in Acumatica, it is hard-set to force the day of the count being the system date i.e., the current local date, and there is no way to adjust this from my understanding, unless going down the customisation route. This obviously causes issues because the count sheets will all be say the 31st of the month, but Acumatica will be calculating the balances as at the date of entry i.e., the 1st/ 2nd, which can causes Acumatica to attempt to incorrect adjustments.Is that correct, and/ or has anyone seen any way to handle the above scenario?  Thanks in advance.B

Hi Team,I am working with 2025 R1 (25.101.0153). I want to customize Inventory ID selector, to load template items too along with stock items, under Related Items tab on Stock Items screen.I tried with Cache Attached on Stock Item graph but that did not help. Can you please suggest best possible way to do that. 

In 2024R1, the help indicates that a credit card payment method can be used to with the Cash Sales sale order type.  But when I add a credit card payment method to the order, I get a blocking error stating the credit card payment method is not supported by the Cash Sales order type.  Is the help incorrect?

The Customer Order Nbr should list all customer orders (POs) rather than leaving it blank. Does anyone know of a way to make this work?  I can’t find anything in preferences to control this. Of course we can do a customization and/or business event.. but it seems this should be standard.Ideas?  Thanks!  

Hello,I have a customer who uses document level discounting on sales orders and when they do this, Acumatica is taking the discount off of the freight charges.Is there a way to not include freight/shipping charges in document level discounts?Thanks!

All of my Sales Orders in the Details tab show <SPLIT> in the Sched. Shipment Date and are empty when checking Line Details. The Sales Order has a Sched. Shipment date entered in the Shipping tab and the Purchase Order has Promised On date entered. I’m trying to understand why they are always showing <SPLIT> instead of the dates provided?

Description:  Saw the discussion on duties for Shopify orders (thread #33785) and thought this might help others facing the same challenge.  We've built a customs intelligence add-on that connects to Acumatica and calculates the full landed cost for every purchase order involving  international trade.  THE PROBLEM  Acumatica doesn't have native fields for customs duties. Most teams either email their customs broker (and wait days), use spreadsheets (and get it  wrong), or create workarounds like tax IDs and non-stock items for duty amounts.  HOW IT WORKS  1. Click "Import from Acumatica" — select any open PO  2. Each line item is auto-classified into the correct HS commodity code  3. Full customs cost calculated: import duty + VAT/GST + anti-dumping surcharges  4. Required border documents listed (Bill of Lading, Certificate of Origin, etc.)  5. FTA savings flagged — if a preferential rate exists for your t

What are my options for connecting Shopify to ACM? We have a Distribution license and from what i can tell, it is an additional cost to do the integration if you dont have a Retail license. What is the best and most cost effective way to get this set up?Thanks in advance! :)

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. 

Good day.  This is shot in the dark question.  However, we have SPSS EDI for fulfillments of our purchase orders.  We are getting this weird occurrence with the Vendor Cross reference duplicates and also it seems to make up alternate IDs as well.  Has anyone experienced this phenomenon?We are on 2025R2.  If we delete them they just reoccur.Thank you.Evan  

Hello, How can I solve this error when trying to create a generic inquiry and display the site, but encountering the message: "generic inquiry This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled"? Thank you in advance.

Hello,I was wondering if anyone knows if there is a resolution for this issue:The following error appears when attempting to create a shipment for an order for which the Sched. Shipment date is greater than the current date.This would be considered a bug to us, as there is no reason you should be prevented from shipping an order earlier than requested.This is a required field that is pre-populated from the SO Requested On field, and results in an additional unnecessary and confusing step of manually altering the scheduled shipment date to the current day before creating the shipment.We are shipping non-stock items, back order allowed, allow negative quantity, but that should not matter.I know this was previously a known issue but we are using 2023 R1 where it was supposedly resolved years ago 

Many Acumatica users in field service, manufacturing, and distribution are manually chasing vendor warranty recoveries using PO Return Receipts, Cases, or spreadsheets — with no automated entitlement checks, approval workflows, or clean AP settlement.I’ve designed ( not coded, just designed ) with:Claim Candidate Detection Queue (auto-flags in-warranty items from Service Orders) One-click claim creation from SO/shipment/receipt with entitlement engine Vendor Claim Entry + Approval Queue + line-level vendor responses Settlement Workbench (AP Credit, Refund, Replacement PO, Off-invoice, etc.) Warranty Policies, Vendor Recovery Rules, dashboards, and full audit trailIt lives inside the standard Service Management, Purchasing, and AP screens (no external tools).Quick questions for the community:How do you currently handle vendor warranty claims and recoveries today? Would a d

I’m hoping someone can help us with a workflow hang-up we’ve run into several times. We are a contractor supply store and often place custom orders for customers or drop ship and/or ship material from our location to a jobsite.When we custom order products, we pass the our vendor’s shipping cost along to the customer unless we can add it to one of our normal stocking orders.When we drop ship, we add the shipping expense to the Sales Order.When we ship from here, whether it’s using the UPS integration within Acumatica or LTL freight, we add that expense to the Sales Order. What is the recommended workflow from Acumatica or something that works for YOUR company for charging customers before the exact shipping amount is known? I see a “create pre-payment” button next to the “create payment” button, and when we create payments there are options for “authorize” and “capture.” My understanding of these 4 is as follows - “create pr

There are a built in plug ins for both EasyPost and Ship EngineDoes Acumatica recommend one vs the other ?At one point I thought EasyPost was the go to integration that Acuamtica was developing but I do not see EasyPost set up as part of the Sale Demo...Suggestions?  Only looking at one of these two since the integration is “built in”   

Has anyone successfully configured a ShipStation connection with 25R2?  I imported the customization package, entered the configuration in Acumatica, then created a store in ShipStation. I received the message that the connection was successful, but no shipments are imported even for a manual refresh.  In fact, I don’t even see login activity in the request profiler.  The account information and credentials are correct, and I can hit the web service endpoint from Postman to receive shipment details for the date range.  I am working with ShipStation Support, but response time is slow with little helpful information provided.  I’m aware of the currency rate issue that can break the connection attempt from ShipStation if not configured, so that’s not the issue.  I don’t know if it’s a design flaw or a bug, but if you attempt to edit the connection details after setting up a successful connection, the screen is blank.  I’ve repopulated it many times and each time it comes back blank.

Hi,I have an SO Order Type that is Invoice and there is the Mark for PO box, but it is greyed out. I have created a new item with no items in stock and made the replenishment warehouse the same as on the order. There is also a default vendor for that item. Does anyone have a workaround or thoughts? 

I have a client who is attempting to import open POs and open Appointments/Service Orders. Is there a way to create a PO who’s lines are linked to demand (mark for po)from specific appointments? Currently if the appointment demands items be purchased the po will be linked to the appt. Can I do that retroactively? Can I import an appt. which has line items marked for PO, then import a PO with those requested items and link them together?

Hi all,I’m trying to write a generic inquiry to calculate the total purchase $ for an item by warehouse by period. My first thoughts were to go at it using INTran and just check the Tran Type. Is this the correct route or is there a better source? Also, what transaction types do I need to check for in order to ensure i’m aggregating ONLY vendor purchase $?thank you!Joseph