Discussion Forums

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?

Hi All,When providing service, technicians must answer a set of questions regarding the equipment's condition or the service provided.Once completed, the answers will be sent to the customer as a reportI have seen some posts about the Acumatica Survey. However, this feature has been built like a form, that will be sent out to collect feedback and it doesn't work for people using Field Service.So I question how the other companies are using the Field Service Feature facing this issue.Are there any solutions for the Field Service Survey? because this is not a special business process.Best regards,Yên Chi 

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 =

The Custom Field in BigCommerce could be added using the Commerce Connector from the Entities form(BC202000). Imagine you would like to map a attribute or custom field or any field from Acumatica Stock Item form to a custom filed in BigCommerce product page and this custom field in BigCommerce is not yet created. Go to Entities form(BC202000), select Stock Item Entity.  Go to Export Mapping Tab Click plus (+) button In the Source Object, select the required Acumatica object. Eg: Attributes or Advanced  In the Source Field/Value, select the required Field.  In the Target Object, select the object as Product->Custom Fields. In the Target Value/Field, select <<Automapping>> as shown in the screenshot. Now when the stock item is exported next time, connector will automatically create the Custom Field in BigCommerce with the same name as in Acumatica. If the field alread

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. 

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.