Discussion Forums

Is there a simple way to disable this functionality?  Customer is not happy with this “fun feature” while it sounds like a time saver they see it as a great way to end up with inventory shortages. We are about to upgrade to 24, so I don’t think they are currently running into this but they are not happy about it coming around the corner.  Has anyone else worked through this and disabled the automatic function?

Good day,I am getting an error message (with no information) when I tried to delete an in planning project,  The trace is showing some issues with table.  I am unfamiliar with troubleshooting these types of issues.  Please see the trace details below.Any assistance we would greatly appreciated.  These are projects entered prior to the upgrade to 2023R2.Thank you.EvanSystem.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.   at System.ThrowHelper.ThrowKeyNotFoundException()   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspect

Hi All! Looking for a solution on how to stop shipments from going out when that shipment would put the customer above their credit limit, but at the same time allow the SO to stay open and we can order Purchase to Order items against it.So in our business most items are custom and they are ordered once we get an SO. So in most cases we take a deposit and order product. Most of our our customers are set up as COD terms.  Once the product comes in, we would want a trigger so that a sales manager can collect the remaining balance, and only once payment is received, for those items to be available for the warehouse to ship. Any suggestions would be greatly appreciated! 

We are ready to do an overhaul of stock ID #s in our system.  We have tested the “change ID” function in Acumatica and from what we can tell it does a very good job.  Seems to override any and all instances of the previous id number with the new number.  However we want to have a record of what the previous number was, in case of records created outside of Acumatica printed copies, numbers in hard copy files, etc.  I have been unable to locate any location where we can find the history of what old numbers were/are.  Does anyone know if this exists and how it can be accessed?

We just upgraded from 2021 R2 to 2023 R2 and I noticed a generic inquiry that was throwing an error of: “Operand type clash: datetime2 is incompatible with int” I looked at the DB on both 2021 and 2023 and the field “RequestDate” seems to be datetime2 in both versions. Does anybody know why this statement below would no longer work? If I swap these fields to add a +1 on the “ConfirmedDateTime” it works correctly by adding a day to the date.I have a workaround but I was just curious why this is no longer working or a way to get it to work correctly. =IIf(([SOShipment.ConfirmedDateTime]<=([SOLine.RequestDate] + 1)), 1, 0) Thanks

Good dayI have upgraded from 2022 R1 to 2023 R2 by installing the file from the community website. I did a direct upgrade from built Build 22.106.0015 to the latest built on 2023 R2.After first upgrading the database and finished of updating the website and all processes were successful.The Instance I upgraded named BuffaloDB. When I then tried to Launch the application I got the error message shown below, “HTTP Error 503. Service unavailable”What could be the issue?I even did a new separate instance to see if I can login I manage to create a demo instance but the one I tried to upgrade from 2022 R1 failed.  How can I make the upgraded ins

Hi All, We are currently trying to figure out a way to restrict items per Warehouse.The company has a single Company Zero Branches setup, so we wouldn’t be able to restrict items and warehouse on a branch level for example. Is there a way of telling Acumatica in this set-up that specific items can only be used in Warehouse X but not used in Warehouse Y?Any ideas or experience would help! Unfortunately assigning Item Classes to Warehouse locations wouldn’t work here as the client has multiple item classes that would be allowed in each Warehouse and there is also some Overlap there.

Hello all,How can I setup Acumatica to automatically make a loan entry that has been paid. I came around to run an automation schedule once a month with an import scenario that would create an AP bill of the loan entry for that month.Please share your feedback and suggestions on this.Thanks.

Hello all,If I have 2 branch locations, have employees in one and employees in the other. How can I assign appointments to an employee that doesn't have that branch as their 'home' branch. Thanks.

Another developer asked this question, but there was no answer to the question in terms of actually overriding the AddNew action on a grid.When I click AddNew on the grid, I want to default a value in one of the grid fields based on a value in a filter.  When you click AddNew, it adds a blank row.  I don’t see any event that is being fired when you click that button.  As such, I think the only thing I can do is to override the AddNew action and populate the value in the override.As suggested in the above mentioned post, the suggestion is to use RowInserting.  That event does not fire when you click the AddNew button.  It fires when you leave the row.This is a custom form, not an extension.  This is my code.  In debug, the breakpoint on TEST is not hit.        [PXOverride]        publi

Use CaseMy client runs an in-house repair shop. They are using service orders to manage in-house repairs on equipment. There are open service orders where stock items are already consumed on the repair. The service order can’t yet be closed because further work needs to happen. ProblemWhen a physical count is generated, the items already used on the service order are still considered “on-hand” by Acumatica. This causes the physical count to display higher book quantity than there actually is on the bin. This can cause stock items to be reduced too low by mistake. For example:I have 13 stock item X on hand I used 2 on an open service order I generate a count, which displays 13 on hand During the count, I input 11 as Physical Quantity The system adjusts 13 stock items down to 11 I close and bill my service order This process further reduces stock item X by 2

EDIT: partially fixed the issue - see my next post for the “new” issue.I have a 3 digit fixed length field on my grid. I want to ensure that the value entered is 3 characters exactly.I used a PXUIVerify to ensure the length of the value in the field is 3 characters.#region Lower[PXDBString(3, IsFixed = true, IsKey = true, InputMask = "###")][PXUIField(DisplayName = "Lower")][PXUIVerify(typeof(Where<Length<ICSFSSScheduleLine.lower>, Less<Length3>>), PXErrorLevel.Error, ICSMessages.ZipIsNotANumber, typeof(string))]public virtual string Lower { get; set; }public abstract class lower : PX.Data.BQL.BqlString.Field<lower> { }#endregionHere is the definition for “Length3”:    public static class ICSConstants    {        public const int Length3 = 3;    }    public class Length3 : PX.Data.BQL.BqlInt.Constant<Length3>    {        public Le

How do we setup discount by Customer Price Class and Item Price Class and Warehouse?Acumatica has discount applicable to customer price class and price class but it only applies when sold from a particular warehouse.

Good Afternoon,On the image below...I thought making new tabs to accommodate my monthly reports with different column orders would be a simple way to refresh each monthly (copy / paste) and update my excel files, but noticed when I make a change on one, each tab changes as well. Is there a solution for this not to happen? Do I have to make separate data views (multiples) so I do not have to keep changing my reports? Any help is appreciated/   

Hello,      I get a lot of help from other community users. Now,  I have found a trick to fulfill 1 requirement, and I think this trick might help others someday. So I’d like to share it out.      Note:  if someone has a better way to do it, please let us know.The requirement is:          To display the historic Inventory balance of a given period, could be a week, half-month, or any date frame.Solution：      Acutally，Acumatica has recorded the beg and end balance of each item on its transaction day.But only the first line’s begin qty and last line’s end qty are need to be displayed according to my requirement.          I have used report designer to fulfill it. below are the steps 1, Create a rpx file, and create 3 variables i

Is there a way to copy an endpoint that was created in a Test instance to a Prod instance? It does not appear these came over from a snapshot and I would have assumed they would.  Am I missing something or do these have to be manually recreated between instances?

We have been using service contracts in ACU since 2020. Since our new update we are no longer able to adjust the ‘Last Generated’ date on the schedules which used to allow us to regenerate after making any necessary changes to the line items. Is there another way to accomplish regenerating? Thanks in advance!!

I had to correct some sales order invoices to remove a non-stock item that was on each of them. Why do the appointments for these go back into run billing? And how do I get rid of those so that they don’t get processed again? Thanks! 

Hi,I’m creating some historical service contracts through an import scenario. With that I want to add a date to Last Billing Date to avoid creating invoices starting from the beginning of the contract when running the billing for the first time. I tried to add the last billing date through a import scenario and it didn't work. Could you please provide any suggestions here?Best Regards,Dulanjana  

hello all,I have a scenario where an appointment has been made for a technician and on the same day the technician pulls in a PTO request. How can i create a notification to notify the users that an appointment has already been created on the same timeframe? Thanks.

Hello all,I have been looking out for ways to block some days on Calendar Board, in Field Services for all the users so that the others aren’t able to make any appointments in the calendar. Thanks in advance.

I have a custom form and I want to do filtering on the View.  I’ve had a similar issue in the past which I resolved on this previous post: I’m following the same principles in my code here, but I am getting an error.In my override, my BqlCommand is EXACTLY the same as the original view select statement.  I was just ensuring that the code would work before making any changes to the BqlCommand.public SelectFrom<ICSFSSScheduleLine> .Where<ICSFSSScheduleLine.scheduleID.IsEqual<ICSFSSSchedule.scheduleID.FromCurrent>> .OrderBy<Asc<ICSFSSScheduleLine.lower>, Asc<ICSFSSScheduleLine.upper>, Asc<ICSFSSScheduleLine.cutoffDate>> .View DetailsView;protected virtual IEnumerable detailsView(){ ICSFSSSchedule currentRecord =

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. 

Has anyone successfully found a work around for Acumatica to calculate and apply sales tax on a P.O. based on the vendor location? (NOT use tax). 

When the client exports a PDF for Purchase Orders and SO Invoices, they do not get the order number in the file. When I do it on my computer, I get the order numbers. How can this be fixed for them?My export: Client’s export:  We are exporting the same way and in the same browsers.