Solved

I added the State field (part of Address DAC) to the Customer lookup GI. It shows fine in the GI view, but not in the Customer lookup inside the Sales Order lookup screen. Does anyone know how to make the State field show up inside the Customer lookup in the Sale Order screen?

Absolute Path problem when launching Database for training servers.I cannot get my database to launch to run Accumatica. I have all IIS settings correct. I think it is a Microsoft SQL express or Windows admin permission issue  

Is it possible to have different letterhead populate on forms (Sales Order Confirmation, Shipment Confirmation) based on order type? We are acquiring a new brand and would like to avoid having a separate branch but would still like to have the ability to have the branding different based on the order. Is this possible? 

I’m trying to add Sales Categories to my Inventory items with an import scenario using the Stock Item screen to add items to my already created categories but have had no success. Has anyone succesfully been able to add stock items to sales categories with an import scenario?

Hello,I Have two dropdown list fields. I  need to  change the second dropdown values dynamically  based on first dropdown selected value.Code below:- #region Feature        [PXDBString(30, IsKey = true, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Feature")]        [PXStringList(                new string[]                {                    SSS.SSP.Helper.Constant.Agree,                    SSS.SSP.Helper.Constant.Inspect                },                new string[]                {                    SSS.SSP.Helper.Messages.Agree,                    SSS.SSP.Helper.Messages.Inspect                })]        public virtual string Feature { get; set; }        public abstract class feature : PX.Data.BQL.BqlString.Field<feature> { }        #endregion        #region ValidFor        [PXDefault()]        [PXDBString(5, IsKey = true, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Valid For")]        [PXDependsOnFields(typeof(SSPSetupActive.fe

When we want to check button or any field’s UI attribute that is Enabled or not. how can we perform it?

Hello! I am currently working on the system admin course S100, and ran into an issue and would like to ask for your help. In the step shown on the attached pdf on page 61, I made a mistake and chose the latest version of 21.119.0030, instead of 21.101.0047. See also attached screenshots. Will this create any problems down the road? If so, can I downgrade before proceeding? I plan to go on to the Developer Track. Can you advise?

When created a navigation in a GI it wants it to be an external url.Is there a way to create a local path it will accept to a pdf with a specific file name?\\server\data\files\((Shipment.Nbr)).pdfThe pdf files would be saved with the shipment number as the file name.

I have to create an approval map where one of our salespeople is in charge of the East United States and the other is in charge of the other half.  I’m opening with the first condition being the lead class starting with DC (one of our brands) and then the states in parenthesis with all OR conditions:Any help making this work would be appreciated, I’m probably having an OR too many or too few, maybe not enough parenthesis?Thank you!

What should we do for a Quick Check that was written for a donation on 12/27/21. The check was lost in the mail and never cashed so not cleared. We need to reissue a payment but the prior year is closed.

We currently use microsoft flow to catch and transform webhooks/data from 3rd party services and post back into Acumatica. However, we would prefer to use Zapier. I know it is a bit more complicated than your standard https rest api, but does anyone have any guidance as to what might be possible with Zapier and how to do it?

We have a requirement where we need to make sure if a certain user is logged into the system, in the Invoices screen, we need the Customer, Location to be filled automatically and a custom field called Sales Channel (dropdown field) must be filled as LOCAL or FOREIGN according to the logged in user. How can we approach this development. I have attached a screenshot for reference.Thank you. 

Are there any users experiencing strange behavior in the Generate Forecast screen in v2020r2?  We’ve found the following issues:If an existing calculation is displayed in the Generate Forecasts screen, and the user wants to create a generate a new calculation with different parameters, the system throws an error regarding a “circular” reference.  This requires the user to delete all of the forecast lines from the Generate Forecasts screen so he or she can start over. If a user generates a forecast, it is displayed and cached within his or her user account but is not visible on another’s account.  In other words, it appears that each user is creating and maintaining his or her own forecast as opposed to the forecast been company wide. To that point, if one user removes all of the line on “his” generated forecast, other users will have their own forecasts on their screens, even after a web page refresh.  It appears that the generated forecasts are remaining in users’ caches incorrectly. 

It would make sense to me that when opening a Location from the ‘Locations’ tab of a Business Account, that CR Locations would open by default. However, it does not, and AR Locations opens instead.I must admit, I cannot even find where the code is that runs when this is clicked. I believe it executes an Action called ‘ViewLocation’, but I can’t find it and I don’t know how to override it.

Good day all. This is my first question here, hope i can get your help on this! is it posible to have 2 approves for a single PO? the same PO approve by 2 users. thanks!

We promote stock items to our customers on a weekly and monthly basis.  Or we encourage our sales team to focus on certain stock items for a short period of time.  How can we track these promoted items to see if we are increasing sales of the promoted items?  Does Acumatica have a build in report to track and compare sales of an item to see increases on a short-term basis? 

Hello Everyone,We are trying to make a get call for checks and payments screen to get all the checks along with application history tab details within a date range.I have provided the lastmodifieddatetime for date range filter and it is working fine but when i add the history object to the API URL, I’m getting optimization cannot be performed error in the GET call.I have used below URL.http://localhost/MyInstance/entity/Default/20.200.001/Check?$filter=LastModifiedDateTime ge datetimeoffset'2022-02-08T23:59:59.99Z' and LastModifiedDateTime le datetimeoffset'2022-02-13T23:59:59.99Z'&$expand=History Error details:"message": "An error has occurred.",    "exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nHistory.AmountPaid: View APPost has BQL delegate\r\nHistory.Balance: View APPost has BQL delegate\r\nHistory.CashDiscountBalance: View APPost has BQL delegate\r\nHistory.CashDiscountTaken: View APPost has BQL delegate\r\nHistory.DocType: View

Hi everyone. I need to know where in the BigCommerce I can configure the customer specific prices to provide to acumatica API.Thanks.

when tried to prepare invoice it was showing the following error:  Inserting 'AR Invoice/Memo' record raised at least one error. Please review the errors. Error: The 03-2022 financial period is inactive in the MUFFINS company.

I would like to dynamically change the color (“Connotation”) of the Confirm Shipment action button (Shipment Entry screen) depending on a condition in 21R2.Example use case: If the Package Weight is not within an allowable range of the Shipped Weight, then change the Confirm Shipment action button connotation to "Warning". Otherwise, use “Success”. This color change would provide another visual indicator to my fulfillment staff that a shipment is okay to confirm.I’m currently using the `SOShipment_PackageWeight_FieldUpdated()` event to raise a SetPropertyException, but the warning icon is so small that it’s easily missed. I want to provide more visible feedback to the end-user to help prevent costly packaging errors.In the 21R2 workflow editor, the color appears to be controlled by the “Connotation” selection.It does not appear to be possible to conditionally change the connotation of the Action button using the 21R2 workflow editor. How can it be done using code? Maybe using PXScreenC

Hello, we are having issue with getting Acumatica to print out the shipping label using Fedex integration. DeviceHub with printer and scale is connected to Acumatica, communicating, no issue there. everything is good until the end when we want to print the label(it is set to auto-print), it just gives us a downloadable version of label in .zplii format which we cant do anything with it. would be more convenient to have it print right away when shipment is confirmed.access rights, default printer, stock label and other settings are all good. using Zebra label printer.

I have created a generic inquiry for a custom form, but when I try to type in the search bar it does not give any results but only shows results when we use the filter functionality in the generic inquiry. Any idea why that occurs?

Hi All I am unable to see the inbuilt query in trace of any report in my 2021R2 version (21.204.0055) can  anyone help me with this issue.I am unable to the about info in this version as well. Please find attachment of video file in Trace.zip file with this postThanks and RegardsSD

Hello,Is there a way to export a specific price attached to a price code to Shopify so that the price of an item updates when the price attached to the price code is updated?Alternatively, is there a way to make the “RETAIL” price code populate the “default price” field as this would also solve the issue?  

The aspx xml file for an Acumatica screen always contains `<Page path="[path]" pageSource="[page_source]”>`.  It appears that whenever I upgrade to a new release of Acumatica, the pageSource content of any screens I have customized changes. This happens even when nothing else on the screen has been changed in my customization. Why does the pageSource change when no other changes have been made? What effect does it have? Moreover, how can I tell if the change made to the pageSource is the change I want to make? The only information I have been able to find about the pageSource is that it is “the binary content for the page”. However, that doesn’t explain to me why it changes with each upgrade and if it matters what version of the pageSource I am using. How can I tell if these pageSource changes are ones I should commit to my source code? Any explanation would be appreciated.