Distribution

Hi everyone, Is there a way I can change my Item Class from being Stock Item enabled to disable without having this error? I need to change it in a lot of my Item Classes since I realized I need them to be a non-stock items for creating Kit Specifications. Deleting and recreating all their matrix items would be a big problem to me. Thank you.

I am looking for any suggestions on how to handle a common pricing issue for our company.  We are distributor of stone related products for fabricators and end users   We are using Acumatica Distribution edition 2021 R1 (soon to upgrade to 2022 R2)Specifically we want to apply a discount to a product (item id#) where discount is calculated off of default price of the item rather than the unit price entered.Assume we can setup a manual discount code to make this happen (the same logic would be applied to either specific list of SKU’s (items) or possibly and item class.  Again we want to apply a specific discount that brings the unit price down to a specific dollar amount based on the default price for the ITEM ID on the sales order form.An over simplistic but real example would be that the default price is $24.49 for Item “A” and want to bring the price down to $20.23 (which is $4.26 each or 17.4% off).  The discount code setup is easy but the application to the

With the Ship Separately feature turned off, we would like to combine sales orders shipping to the same address into one shipment, which is a feature of Process Orders/Create Shipment.Unfortunately, the combine or not combine logic appears to be based solely on the address id key, rather than the same address data (name, address, city, state, postal code). Our customer often uses the override address on sales orders, rather than create permanent customer locations. Acumatica creates brand new records for each new sales order with an overridden address, even though the address data is exactly the same. The combine shipment feature does not work for us because these override addresses will always have different address id’s, even when the address data is verbatim.Is there anyway to either:Prevent new address record if an existing customer address record matches exactly? Or  Configure combine address logic on Process Orders/Create Shipment to

Hi Everyone, Anyone knows this issue? I was trying to make a matrix items with three attribute values.  

Good day,When creating a PO Prepayment the non-stock items and cost are not being added to the Create Prepayments screen; only the stock items.Is there a setting or something that is required to ensure that both stock and non-stock items are included on the Create Prepayment.  We are using 2022 R1.Thank youEvan

Hi! I want to use the same funcionality from LINE DETAILS smart panel functionality from Purchase Receiptwhen using manual lot Nbr. As you know, in the LINE DETAILS screen panel I have the possibility to assign a specific quantity by LOT (like image above) and this give me the possibility to have record of the quantity by LOT splitted (and not summarize).I want to use the same funcionality in Receive and PUt away. This is because currently, if I select the same item with the same lot, the system sum the quantities and I cant split itiS IT POSSIBLE? Do Im missing something in configuration?Thank you!

Hi All, I am currently wondering if there is a different way of making Employee records available to show in the Employee selector box. I know that Workgroup members can select their fellow teammembers. Our use case is that the Purchasing Team needs to assign an Owner of the PO different than their Group. It can be anybody within the organization.  As they are not using the complete Request, Requisition, Order process this would not pull over. Any suggestions on how to effectively manage this by not creating a Workgroup with all Employees that needs to be maintained every time a new Employee is hired?

I want to restrict some users from creating purchase order receipts in one warehouse, but be able to do it in a different warehouse. I still want them to be able to see inventory levels and other info about the restricted warehouse.  Is there a way to do this? Restriction groups would restrict them completely. 

If I create a new tenant for our 2nd retail business can it share the same inventory with the 1st tenant. Thanks

we have a requirement to update few fields in stock Items screen, but we are facing “Field not found: 'PX.Objects.IN.InventoryItemMaintBase.Item'." error. Please have a look at below code.we are on Build 22.109.0023. using Newtonsoft.Json;using PX.Data;using PX.Data.Webhooks;using PX.Objects.IN;using System;using System.Net.Http;using System.Threading;using System.Threading.Tasks;using System.Web.Http.Results;namespace WebHooksConfiguration{    public class ObjectInventoryItemJSON    {        public string InventoryId { get; set; }        public string Description { get; set; }         }    public class KWInsInventoryItemSync : IWebhookHandler    {        public async Task<System.Web.Http.IHttpActionResult> ProcessRequestAsync(       HttpRequestMessage request, CancellationToken cancellationToken)        {            using (var

Not sure if there is option to do this.An item in SO is shipped not invoiced, but the item is issued by Update IN. What's the process to be able to return the item back to stock and use the same SO and the same item line again for another shipment? It looks like we can only create return order or IN Receipt but there is no way to make new shipment for the same item on the same SO.

Hi all, Can you help me to recognize what causes in Unreleased IN Documents makes it balanced status when the SO, Invoice, Payment is already closed   Thanks

Hi, Attached we are trying to troubleshoot an A/P workflow. Step 2 (Fleet Manager) is not behaving the way we want. For this step we want the approver to approve only bills with G/L accounts 4120,5230,4110,4150, and 4500 but exclude vendors V0307, V0546, V0077, and V0309. The condition is not working. Here is a screenshot. Logically it looks correct but the approver is still getting invoices for those excluded vendors with the G/L accounts. How can I update the condition to make this happen. The Fleet Manager step is the only thing that is not working. The condition is not setup correctly. Any suggestions would be great. I have also attached the Approval Workflow.  Thanks,@FrancesPantelidakis24    

Is it possible to create a grid on a Report, where the cells height are always the same, even if one cell has more rows of data than the others? I want to center the data vertically, but this is thrown off as the heights of the cells are different.Any help would be appreciated.

How do I get two screens to open at once in the Mobile App? For example, running SCAN AND TRANSFER, while also running ITEM LOOKUP to help me select the proper locations for the SCAN AND TRANSFER screen. Right now, leaving SCAN AND TRANSFER removes everything, so I can’t go check that I’m looking in the right locations etc. Any help is always appreciated!

Receiving the following error when trying to create a shipment for a lotted item.Not sure I understand this error because there is 1 item available in that specified lot. This error happening on all lotted items on Sales Orders.  

A user created a shipment with an incorrect quantity and prepared an invoice.  The associated Shipment 000123 has a Confirmed status.  When trying to correct the shipment the message is:Shipment already posted to inventory or invoiced for order SO 03697601, shipment cannot be reopened.The associated invoice has a Balanced status.  My understanding is that we need release the invoice, then create a sale order Credit Memo to return the inventory, and finally create a new shipment. However when attempting to release the invoice the error is:The Status for 000123 Shipment  cannot be updated The same error message appears when trying to delete the balanced invoice.  It seems like there is some corruption or inconsistency in the data.  We h

Hello,Is there a way to setup an Alert or Notification that will let us know that inventory has dropped below a certain level with Acumatica. Thanks,Nelson

We are looking for a Factoring Management Application that is or can be integrated with the Acumatica ERP. If you or your client are also looking into this, please let me know. We can work together and save money. Our client is implementing the Acumatica ERP. The client uses currently factoring that provides them a loan against their customer invoices. Because the client has to order their materials from China three to four months ahead of their sales order or demand, they need money to bridge that waiting time for sales orders. When the client creates a sales order, the sales order amount is submitted to the factoring company via the factoring private website/portal. If the factoring company approves the submitted sales order amount, only then will our client start the shipment of goods for that approved sales order.. The basic steps of the application should have the following features:Mark all the customers for which customer invoices are factored

MRP is indicating to buy 5,000 units of 173L8100 STK with the following action and promise dates. I have created two POs, one for 2,500 (promised on date of Jan 5, 2023) and another for 2,500 (promise date of Jan. 11, 2023). I have regenerated MRP but those two lines remain on the MRP Display. Why do they remain? When should they disappear from MRP Display?

We are not having a great experience using the ACM Payroll module and are looking to move to another service that integrates with AMC… Does anyone have any suggestions? We pay twice a month (15th & 30th) and commissions on the 20th. Any suggestions would be appreciated!Thanks in advance!  

Confirm Shipment on the Shipment screen: After successful confirmation, for some reason I want to change some options to match the current shipment. But all the options on the screen  are blocked I've re-edited a few locations but it doesn't seem to work and is blocked from all the default options of the information system on the screen All advice appreciated and thanks in advance..

Can we have a “Business Account” that is not a customer or a vendor?  We have a need to have in Acumatica persons and companies related to our business but that are not customers or vendors. “Regulators” are an example.  Other examples are trade associations.  Can these types of person and companies be “Business Contacts” but not customers or vendors? 

I add to Shipmentnrb and Invoicenrb in Sales Order primary list but shipment and invoice numbers are not generating. To generate numbers what i have to do.

In a sales quote, is it possible to enter in the anticipated costs of the goods on the quote? We can put in a non-stock item, but how do we show what the Gross profit percentage would be on the quote (internal info only of course!)