Distribution

We are trying to work out how to automate the allocation of stock to orders which cannot be fully completed.There is no process to automatically “allocate” stock to orders.  It would be great if there was.Due to stock shortages and the need to keep customers happy our client has to manually allocate stock to orders which is very time consuming.  Some customers end up getting 10% of the order, some all of it if it is a very large order; there are many factors that come into play. Thanks 

I'm currently working on an integration project involving our Shipping Software and Acumatica, aiming to accurately reflect freight costs on shipment invoices. However, I've encountered an issue where despite receiving the correct freight cost data (e.g., 83.75) from our Shipping Software, Acumatica is consistently pulling the Freight Price as 0.00 onto the invoices.Does anyone know how to get the Freight Cost to pull down to the Freight Price automatically if the checkbox is set to Override Freight Price?  Acumatica Version 2023 R2  

Hi,  We’re currently exploring inventory planning software and are talking to the software companies listed on the Acumatica Marketplace. Has anyone used inventory planning software outside of the marketplace that successfully connected to Acumatica? 

I am getting an error when trying to delete an attribute value from the Lot/Serial Class.  It won’t let me delete it. I am unable to find where to “Inactivate” this attribute.  There is no option to inactivate this attribute on the Lot/Serial Class screen similar to the one on the Item Class screen.Anyone has any clues? 

I am trying to get custom labels to print an item label at a time for a Zebra label printer based on the quantity.  I used the Numbers approach which worked for all the labels on a single letter sized page. When I try to make it print a small label one page at a time like for a Zebra label printer, it prints half the quantity each time.  10 quantity received but it only prints 5 labels. Has anyone else found a solution to this? 

Hi Acumatica Community,I have this sales order come back from ‘Completed’ and it when back to ‘Shipping’ suddenly. And then when we try to ‘Complete’ the order again now it is disabled or not clickable.  

Team,I have created a new Unbound processing screen and added some basic information to the process. This screen works as expected when run manually. However, when using schedulers, the processing count is not updating.Here is complete code.  public class NewProcessingScreen : PXGraph<NewProcessingScreen>    {        #region View        public PXProcessing<SHWKImportDAC> SHWKSOOrderView;        #endregion        #region View Delegate        protected virtual IEnumerable sHWKSOOrderView()        {            foreach (SOOrder item in PXSelect<SOOrder, Where<SOOrder.orderType, Equal<SOBehavior.sO>, And<SOOrder.status, Equal<SOOrderStatus.open>>>>.Select(this))            {                SHWKImportDAC dac = new SHWKImportDAC();                dac.OrderType = item.OrderType;                dac.OrderNbr = item.OrderNbr;                SHWKSOOrderView.Cache.Insert(dac);                yield return dac;            }        }        #endregion        #

I am wondering if anyone is currently using 2D barcode for the items within Acumatica?  I have a customer that is wanting to use 2D barcode labels and they are in the auto industry.  What is being used for the 2D format by customers that are using Acumatica distribution or manufacturing.

What are the implications of changing a stock status item to inactive status?  

Hi, When we are creating inventory stock item, Item type always showing as “Finish Good Type”.It has mentioned in Item class as “Component Type”. Is that Intendent behavior or any configuration missing?  RegardsNethupul    

We are looking for a way to perform a simple 2-step transfer of inventory items between warehouses.  Ideally, in the originating warehouse we would scan the item barcode, enter the quantity and release the transfer.  In the receiving warehouse, the transfer in would be available for selection and the item is scanned and received.  Our items have default locations in each warehouse so we don’t want to scan the location…..the software should recognize the default location in each warehouse.  Is this possible out of the box?  We are exploring transfer orders in the Sales Order module as well but are not sure about them.  Thanks in advance for any guidance.

I have a site who want sales orders to auto populate with a freight charge based on the overall weight of the order and the zone of the customer.I have attached zones to the customers and setup ship via codes set with calculation method of net and under freight rates I have entered weights, volumes, zones and rates.When an order is entered it will pick up the zone from the customer and the ship via I want to auto populate dependant on the zone and order weight.and then add in the charge.I have automatic packaging switched on in the features and on the order type I have selected Calculate Freight.Development  would be pretty easy to do but trying if possible to avoid this if anyone can advise on how to do the above       

Several of our branches work as “hubs” for other locations.  For example- Branch 1 may need an item from Branch 2, but there is no direct truck that delivers between the two.  All items for Branch 2 come out of Branch 3.  So when Acumatica creates a transfer request from Branch 1 to Branch 2, inventory winds up sitting in Branch 3 for some time first.  How can we help with this process inside Acumatica, to better track items while they are in Branch 3?

Hi Acumatica community! Is it possible to do cycle counting and not freeze inventory? My client wants to continue their operations while some staff cycle count.

I am struggling to find where the Location field on the Purchase Request is coming from. These are the element properties: And this is the field description from the help screen (not very helpful): I can’t find a Location field on the employee, and there’s no setup for locations in the Request preferences.I’m at a loss.Thanks!

Hello, I've created an action that will transition the status of the supplier file from "Draft" to "Inactive".but the status is grayed out.I need the status to be editable after the action. how can i solve this problem ? 

I am looking to create a customer sales summary report where sales are summarized by year.  Column heading as follows:Customer #, Customer Name, 2022 Sales, 2021 Sales, 2020 SalesSales are define as Sales Order Invoices.  

It is not happening on every sale but periodically the sales order when we convert it to an invoice changes the ship to address sales tax to the company address rate.  the office is VA but ship to is Florida in this example. 

Good dayIs it possible to reclassify a journal  from a purchase receipt. I created a purchase receipt and the debit when into inventory, however the end user omitted the project and project task.On clicking the reclassify function I can only see the credit side of the journal, how do I make changes to the debit side of the journal.

We have users who are entering inventory adjustments for the same Inventory ID and the costing is FIFO, and with each line, you must choose a receipt. When there are hundreds of line items, it’s time consuming for users to enter each line individually. I am looking to see if anyone has a better solution or faster way. They can upload the file but if they don’t know the receipt number, they still have to manually search for it. Here is an example: 

hi, have anyone tried using iif statement or any condition expression in the ‘to:’ field to obtain the email address? As I’m using workgroup for the approval and thinking if I can use Iff statement to get the email address. e.g Iff(workgroup=procurement, ‘email’, 0) 

I am having trouble with the relationship between a Invoice and Shipment Package details from the Shipment (2023R2) Does someone have a Generic Inquiry already created that would display the Invoice number and the tracking number from the shipment package tab?  

Is there a way to show a budget warning for the issuance of the inventory related to project? Currently we can tag a project on the issue inventory. However, since this is related to a project, a budget control should also be considered when processing the issuance. Is there any answer to this?

Our specific scenario is:1. We place a Purchase Order and transmit it to our partner via EDI2. Our partner ships the product.3. Partner sends us an Invoice via EDI.4. The Invoice is entered as an AP Bill against the PO.5. We receive the inventory.We don't want to pay the bill in step 4 until we get the inventory in step 5.  We also don't want to prevent the bill from being entered because that basically eliminates the benefits of EDI. (nor do we want to put business logic in the EDI layer to not import the AP Bill) So, is there a way to configure the system such that the only items that can be paid on an AP Bill linked to a PO are those items that have been matched to a PO Receipt?

Drop is not working for the sales order type with AR document type is no update. Is there any particular reason why its not working