Solved

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 instance from 2022 R1 to 2023 R2 work? On this installation it is on VMWARE as a way of testing the upgrade in the actual production environment.Also on this installation I do not have .NET 4.8 framework could it be the issue?

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]        public PXAction<ICSFSSScheduleLine> AddNew;        [PXUIField(DisplayName = "Add New", Enabled = true)]        [PXButton(DisplayOnMainToolbar = false)]        public void addNew()        {            var

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 units Now I have 9 in the warehouse, whereas I should have 11 in the warehouse. I have adjusted down the Item X by 2 units during t

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 Length3() : base(ICSConstants.Length3)        {        }    }If you enter 010 (which is valid), you still get an error:I could try

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/   

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 = ScheduleView.Current; BqlCommand query; //plan to do stuff here to change the query based on other factors query = new SelectFrom<ICSFSSScheduleLine> .Where<ICSFSSScheduleLine.scheduleID.IsEqual<ICSFSSSchedule.scheduleID.FromC

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. 

hello all,I am looking for ways to let Acumatica run the Reverse Allocation automatically whenever an AR Invoice is generated or released. I setup the following allocation rule, but I am not able to see if any reversal trxn has been generated anywhere. I would like to run the reversal automatically like it does to create an allocation Project trxn.

Hi there, we got duplicate Vendor appeared in Vendor list. Not sure which generic inquiry duplicates in the relationship tab. I have exported AP vendor in xml. Could you please review and advise? Thank you.  

hi, I am trying to get login using python code. My code is working fine in localhost. But when I am trying to do it with my company testing env . The login is raising Max retries error. I think This is because of logout. I tried same api in post man and it works fine over there.    HTTPConnectionPool(host='acusb.mycompany.local', port=80): Max retries exceeded with url: /entity/Auth/login (Caused by NameResolutionError("<urllib3.connection.HTTPConnection object at 0x000001FB3A068BD0>: Failed to resolve 'acusb.mycompany.local' ([Errno 11001] getaddrinfo failed)"))

Is there a way to have two companies in the same tenant have two GL accounts of the same account number and use sub-accounts to assign for different account numbers?For example, in SWEETLIFE there is GL account 10200 - CASHASSET, and I want to use a sub-account code to assign to “Company Checking Account” and use the same GL account 10200 - CASHASSET for TOADGREEN BUT I want the cash to flow to different sub-accounts which are two different bank accounts.  I know that Acumatica does not allow duplicate GL accounts in the same tenant.  (see screen shot below)  

What is/was the first Acumatica version that supported multiple base currencies for Taxes, Projects and Time Management? 

We have a custom report related to a custom table linked on a Project record.  We want to (in an automated way) run this report for a project and attach the report as a PDF to the project.  Ultimately this attached PDF file will be pulled into an external system via an API.  But we need the PDF attached first.  Anyone ever done anything like this?

Does anyone know how to show the GP % total as a % for a group of records by date periods?The individual lines work across Sales/Profit/GP% but we need a total of the %. We tried AVG (in screenshot below) but it doesn’t work.