Distribution

Hello! We have 15 different locations that need to be set up under one company and we are thinking of either setting them up as 15 different branches or as different subaccounts. Any best practices or pros and cons for doing either branches or subaccounts?We are open to any suggestions!Thanks!

Hi there!  I saw a post on this topic from 2 years ago so looking for a refresh.   We do not use inventory...most of our projects are special order.  That said, we palletize materiala and put them on racks in our warehouse until we can ship them to the job site.   We have a new warehouse assistant.  He would like us to get a printer to print these labels….I am assuming we should also get the capability to read barcodes.  1) Any ideas based on the situation I just described 2) what has everyone else had success with  3) what am I not thinking of :)  Thanks in advance! 

Hello Everyone,We have a multi-company client that makes intercompany sales/purchases for the same items between multiple different companies. Intercompany Sales Order generation requires a default warehouse for the creation of the Sales Order.  Customer and Stock Item default warehouses do not work becuase the same stock item could be sold to multiple different intercompany customers.Is there a way to default the warehouse by the selling branch?   Thank you!Luke

Hi Community  I would like to Pass the channel Information as Text from Shopify to Acumatica. I created a UDF Field in Acumatica, could you please some one help me with the Importing Mapping? 

 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

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