Distribution

 Hello,There is a Acumatica customer that is about to reach the end value of their ARINVOICE sequence.   What is the best way to expand this sequence number range and what are the pros and cons? 

We have a situation where we agree to credit and refund a customer for a faulty item but we don’t ask for the item back.For reporting purposes we want to process this through sales orders rather than in AR as we want to track the stock items, quantities & values of these.Is there a way to process such a return that does not generate a stock receipt transaction ? Does anyone else have this kind of process to deal with and if so how do you handle it ?Many thanks !

Hi Everyone,I am working with Shopify Connector with Build 24R1 version 24.121.0004.On initial order sync, the details are updating as expected.But on order edit sync, the discountable amount is not updating properly (Detail Total - Line Discounts) under Discounts tab.Can you please suggest the possible root cause and fix for this issue. Thank you,

Is there a way to add the Case Packaging Dimension by UOM in the Packaging Tab under Stock ItemWe have full cases at a specific dimension and weight then we have single items at its own dimension and weight.

How do you have a distribution addition and not include DRP in it? I find it curious that if this is such a need functionality, why is it not core to the product? Thoughts?

Has anyone leverage an ISV to assist with customer billbacks short payments for promotions, rebates or etc?  

Hey folks !I create SO Invoice by adding lines from a sale order.(I would like to invoice partially some lines of the sales order, So I created a new invoice, add the lines I wanted and change the quantity from 5 to only 1.)But after that, the status SOLine statut is automatically change to “completed” even if there is unbilled qty .Why ? I would to do multiple invoice from a same SO Order ? Thanks for your help.  

When looking up a Location in forms like an Inventory Issue transaction, make it so that locations with inventory on hand show up first.  The current lookup in an inventory Issue sorts purely by Location which usually forces the user to filter on the on hand column.One idea I had was to add a check box at the top of the Location lookup screen that is labeled something like “On Hand Only” that is checked by default, which would filter the listing down to locations that have inventory on hand.Another idea is to just sort first by On Hand descending, and then by Location.This idea has been in my head for years, but a new customer that is about to go-live asked me about this today.

on the following order the subtotal is $2154.72. But on the SO there is no section for it. Is there a way to have it appear in the top section of a sales order?  

I was asked by a client to change the Sales Order status “Completed” to “Shipped” because they found “Completed” misleading. (Completed orders may or may not have been invoiced.) I didn’t find a way to change the workflow status description in the customization workflow, so I looked for a different option. I changed it in the Translation Dictionaries, which I find even simpler. This value was used in multiple places and I could choose to change it globally or by screen. In the example below, I changed the status description for Sales Orders but left it as Completed for Purchase Orders.Hopefully this is helpful for someone looking to make a similar change. 

Hello,I am trying to format a date field on the results grid on a GI to be MMDDYY with no dashes or slashes I.e.06/01/2022  should be formatted 060122, is there a way to convert with formatting or function?Any help would be greatly appreciate it.  

Hi Team,I am encountering an issue when attempting to import a refunded order into Acumatica. Below are the steps I followed: A sales order was created in Shopify and successfully imported into Acumatica. A shipment and invoice were created for the sales order and released in Acumatica. The order was refunded in Shopify. When trying to import the refunded order back into Acumatica, I receive the following error for all refund orders "Inserting 'AR Payment record' raised at least one error. Please review the errors. CashAccountID: Cash Account 'TT' cannot be found in the system. Please verify whether you have proper access rights to this object." We do not have any customizations deployed in this instance and I have reviewed all relevant configurations related to Cash Accounts. The payment has the appropriate branch Cash Account set up, and everything appears to be configured correctly.Build version: 25R1Could you kindly share your thoughts on why this might be happening and how t

How do I get a list of all contacts listed in Acumatica? We do not have the CRM module. 

Hi Team When I send an email using below actions> Purchase order> Print purchase order> send- When I click send I am getting only signature in the email body, however the subject line shows as expected. I am unable to reproduce the issue in another instance or local instance. 

Hi Acumatica,Is there a way to set up Sales Prices based on the credit terms used in the Sales Order Screen?Thank you!

We have a lot of customers that have no recent activity, either open sales orders or invoices.  I know I could report on this by doing a group by GI with Customers, grabbing the max order date from SOOrder and the max invoice date from ARInvoice, but I really want to get this in front of the users both in the Customers GI as well as on the Customers screen.I see there is a “LastActivity” date in the Customers DAC, but it’s marked as Obsolete (we’re on 23R1, upgrading to 25R1 later this month).  Are there any other “In DAC” values that would help me avoid adding yet another set of joins (and the complexity of needing to group by the relevant customer fields) to the Customers GI?I’m going to post another thread in the Development forum about adding a DAC field, but before I write up a customization I wanted to see if I was missing something obvious already in the system.

Are we able to set up a Create Shipment automation schedule that creates a shipment based on the sched shipment date/request date earlier than the actual shipment date? Ex.Sched Shipment Date/Request Date is June 20th.We want the shipment to be created on June 18th with a shipment date of June 20th. So when June 20th rolls around, we just have our warehousing team confirm the shipment on its way out. I’d expect this to be easy to set up but seems as though this processing screen only works on the day of shipment? I must be missing something here.

Is there an OOTB way to pass the customer po number to the shipping label - UPS or FEDEX? Feels like there should be a mapping somewhere but I feel like I am missing it.  

I have the Invoices and Memos GI exposed to the mobile app.  The summary screen is dreadful.  I find it dreadful for pretty much any list view.  Once you click the record, you can make the details look really nice with headers etc.Also, what defines the fields that show up in the list view of a GI that is exposed to the Mobile App?  I can modify the fields in the Details view, but not the list view.  This may be in the help, so I will look, but since I am bugging folks with the primary question, I thought maybe someone had a quick answer that might save me a bunch of publish-wait-repeat.  :-)This is just not very helpful.  Especially if I were to add a custom field SO Order Nbr to this list.  You would not be able to tell which is the invoice number vs. Sales order number.I WANT LABELS!  😁 

Sales Order had UOM of “EA”.  This is correct.Shipment details line has UOM of “EA”  This is correctWhen I add contents to the BOX on the shipment, the UOM in the contents screen changes to the Stock Items Base UOM.   ***This is NOT correct**It converts the QTY correctly, but the UOM  on the contents subscreen should not be different than the Sales Order UOM and the shipment’s UOM.

In our warehouse our lower shelves are Forward Pick locations and upper shelves are Reserve Stock. We keep a supply of all inventory in the Forward Pick locations but any overstock that won’t fit below will go to the Reserve Stock locations. Both location types have their respective inventory marked Include in Qty Available but only the Forward Pick locations are marked as Sales Allowed. This allows a sales order to be created regardless of inventory location but will prevent the Shipment/Picklist creation if doing so would direct a picker to a Reserve Stock location.This is where the pain point is introduced. We currently utilize the “Tasks” feature in Acumatica to direct our warehouse mobile users to transfer items from Reserve Stock to Forward Pick so that shipments containing affected items can be created.Ideally we would like a proper means of creating a Transfer Order which would direct a warehouse user to transfer the items between locations.I’m wondering if this is already an o

Hi Acumatica People, Can I create nonstock Kit with a stock item component that has a serialized lot which has a serial lot class that has an "when received” assignment method and a “User enterable" issue method? Details: I have a problem with a set of kits which needs to be fixed.  A good example is kit, 1000-9117K, which is a non-stock item and one of the components has a serial lot number (lot serial class of SUPPFORKIT set-up as pictured below).It throws this error when trying to save: Warning 2025-09-03 17:47:31 UTC IN Error: Components with the 'When-Used' assignment method and 'User-Enterable' issue method are not allowed in non-stock kits   Here is the lot serial class. The error is informing me that the components lot serial class needs to have an assignment method not of “When Used” and issue method of “User Enterable”.   *******************question************************ Can I not use the lot serial class, “SUPPFORKIT” which has the assignment method

My client is looking for to send customers a prepay Invoice or a Proforma Invoice.  Basically Enter an SO and generate an invoice, and once payment arrives they will process shipment and invoice. I set them up using credit terms with prepayment required and it works great. My question is if there is a way to do proforma invoices? I’m thinking I can create a second version of the sales order acknowledgement form and make it look like an invoice. Any other ideas?

In the mobile app, I can open a sales order and i can attach a file to a sales order. I have exposed the Shipment screen to mobile, I can open the shipment in the mobile app, but i can not attach a file in the mobile app. What needs to be done to allow a file attachment in the mobile app on a shipment record. The use case is the customers delivery driver is onsite delivering product and wants to open the mobile app, open the shipment and take a picture of the delivery and attach to the shipment.   It appears the exposed SHipment screen is inquiry only.    

Based on an older article and the lack of answers when people asked this question, I’m guessing the answer is “They are not”.When an invoice is created using an installment payment terms type, the invoice is initially created for the full amount, but immediately closed.  Subsequent installment invoices are created right afterwards for the individual balances.  If I use a “3 equal payments” terms type, the system creates INV001 for the original invoice, closes it, and then creates INV002, INV003, and INV004 for the installments.I see nothing in the system or in the DAC that gives me a link from INV002, 3, and 4 back to INV001.  The usual “ARTran to SOLine” join logic doesn’t exist either.  Outside of a description, these three installment invoices seem to be related to nothing else.