Solved

Hi All,I want to remove warehouse guy access from some warehouse id.So I create a Restriction Group called BRVT Warehouse type A Inverse - this group will have access to all warehouses except DN, HCM, LMX, HN as imagedThen I assign user TEST for this group. As my understanding about Restriction Group Type A Inverse, User TEST cant see anything about DN, HCM, LMX, HN.When I sign in User TEST, it still can seePlease advise any things wrong with my setting.Thank you,Yên Chi

Hi, I have an unusual error message on the license maintenance screen that I have spent several hours testing and trying to resolve. The error is appearing on 3 locally hosted sites on build 2022.114.203.2690.  I don’t believe that this is related to any customisations as it exists on a newly deployed site before any customisations are applied. What is the error?Immediately after applying the license key and revisiting the Licence Maintenance screen, I get:  followed by a locked up screen that you can’t do anything with: The trace shows:   I have worked out that you can restore the system to an unlicensed state by going 1) delete * from Licensing and, then 2) repairing the website.  After reapplying the key the error appears again. Aside from the above the sites function normally (for example you can access stock items, customers,...), but anything associated with a license doesn’t work (eg you also get the error on the user screen and can’t change permissions) Any Ideas? I’m beginning

HiWe have very strict controls in place around purchasing, and have realised that users can receipt lines that do not come from a PO (direct purchase receipts).  How do we prevent this, is there a switch that we can switch off to prevent it, or is our only option to remove the “+” off the line using roles?

Our standard protocol for new users has been setting a default password but required the ‘Force User to Change Password on Next Login’ checkbox under each user profile. The issue I’m discovering is that the mobile app does not like that. It will say invalid credentials instead of popping up some type of interface allowing them to set the password. This is troublesome as users then have to use a web browser for the first login, set password, then can begin using the mobile app. Has anyone else discovered this?

I want to create an export scenario which includes order summary and line details. Is this possible?  I created an export scenario (XML attached), however it doesn’t work correctly. 

Hello!I am attempting to add some conditional formatting on the SO Order Details grid where the SO Lines are viewable when looking at a Sales Order.I have implemented a customization on the SO Order Entry graph which calculates the mark up of each line amount over total average cost of the line, which then puts this number into a custom field on an SO Line DAC Extension.I want to highlight the SO Line rows in red where the the custom field(usrMarkupPct) is less than 0.1.Everything I am finding says to edit the ASPX file of the Sales Order screen but I am not sure that is the best way to do this.Does anyone have any experience with applying formatting conditionally to SO Lines?As always, any help will be greatly appreciated!!

Hi,I need create a user which i want he have access to only two G.I. in the 37 total G.I. of the system, how to acheive this?I created an user who i gived ODATA role + NewRole(who have view setting in Acces by screen on these two GI). But it’s don’t work.Thanks

Dear ALL,For example: on the screen "Invoices and Memos" > Customer item > Clicking the selector > Creating new “filter settings” > entering the filter name > and new TAB is created then.Please guide us How do users only see the data on the new TAB of the generated filter settings. Users must not see the “ALL RECORDS” TAB.Regards,NNT      

Hello,I am adding a parameter to a working GI.I check the box “From Schema” on the parameter.There ARE records and values for this field and I show them on the output.If I set a default value on the parameter it works for the default.I simply cannot select a value for my parameter from the database which is the whole purpose of “From Schema”.Any thoughts? 

Hi all,I have a new customized screen . I’m adding sales orders to the grid of the screen taken from sales orders screen line level. To select sales order lines, I use a custom smart panel as below. As highlighted above,  I need to avoid loading sales orders when the status is ‘Cancelled’ to my smart panel. To accomplish that, can someone help me to modify the below view definition which I already use to get values form both SOOrder and SOline DAC’s to the smart panel or any other suggestion to do it?public PXSelectJoin<SOLine, InnerJoin<SOOrder, On<SOLine.orderNbr, Equal<SOOrder.orderNbr>, And<SOLine.orderType, Equal<SOOrder.orderType>>>>, Where<SOLine.customerID, Equal<Current<APProforma.customerID>>, And<SOOrder.customerLocationID, Equal<Current<APProforma.locationCD>>>>> POrdersView;Thank you.

Hi I am stuck at a very basic requirement, where i have to make this field required at screen level. Below is Original attributes for that field.Field Name : ExpirationDateData Class : PX.Objects.CR.CRQuoteOriginal Attributes: [PXDBDate(BqlField = typeof(Standalone.CRQuote.expirationDate))] [PXMassUpdatableField] [PXUIField(DisplayName = "Expiration Date", Visibility = PXUIVisibility.SelectorVisible)]I tried this by using CustomAttribute for both Required and Default : [PXMergeAttributes(Method = MergeMethod.Append)] [PXCustomizeBaseAttribute(typeof(PXUIFieldAttribute), "Required", true)] protected virtual void CRQuote_ExpirationDate_CacheAttached(PXCache cache){}and [PXMergeAttributes(Method = MergeMethod.Append)] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] protected virtual void CRQuote_ExpirationDate_CacheAttached(PXCache cache) { }but still the form is allowing blank values. Please note field is a datetime type.Please help

I am getting this error when creating a new instance, any idea how to resolve it is much appreciated.  

On a Sales Order, I am able to set an item as mark for PO and create a drop ship PO that is linked to the SO line. Am I able to go backwards - create a drop ship PO (manually, not through the SO) and then link back to the SO? 

Can I know if there is a way to print data in detail section inside a grid in a report like in the below image?Expecting grid format in the report detail section 

I have a created an assignment map for Purchase Requests and assigned it to the Purchase Requisition preferences. No matter how I configure it when I create a request it doesn’t assign it to the workgroup. I can see other areas where Assignment maps are used require a a process to be run to assign the owner and workgroups. . For example, Cases, Contacts, and Opportunities. No such process exists for assigning requests. Any idea on how I can get this to work? 

I’d like to add an import from Excel button to the Payments and Applications grid on screen: AR302000I can see some stuff online, but it’s ancient. For 2021 R1, how do you add that feature to a screen? I’m barely competent with things like PXSelect<>, so brace yourself for crazy questions :D Thanks,

Hello,I want to create new status value “Archive” to screen Invoices and Memo and enable this field when the status is Open so that End-User could change status to “Archive”I tried add new status value as instruction in topics  and use following code to enable Status fieldusing PX.Data;namespace PX.Objects.AR{ public class ARInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AR.ARInvoiceEntry> { #region Event Handlers protected void ARInvoice_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (ARInvoice)e.Row; if (row != null) { PXUIFieldAttribute.SetEnabled<ARInvoice.status>(cache, row, true); } } #endregion }}However, I can’t find new value in list dropdown valuesand fields Status is still disableCould you please help me? Regards,Khoi

When we do an inventory count, the adjustment hits 66102 - Physical Inventory Adjustments which we have specified as a COGS account. However, there are certain items (such as packaging), which, when adjusted should flow through a different account (the one specified on the stock item screen).  Is there a way to set up inventory counts that post adjustments directly to the related stock item expense account rather than the physical inventory adjustment account?  

Hi guys.I am looking for ideas on how to do the following:We have 3 different departments with their own structure in terms of sales quotes. How can I ensure notifications are sent to the correct people based on the amount? For example: Salesperson–Head of Sales- Sales Direcetor – Head of DepartmentAny quote greater than 150 000.00 Head of Sales should receive notification of quoteAny quote greater than 500 000.00 Sales Direcetor should receive notification of quoteAny quote greater than 2 500 000.00 Head of Department should receive notification of quote Please note that this is not for approvals but rather for notifications.

Hello community!I need to get the users phone current longitude and latitude information and record it into a custom screen. What library should I use?  Is there any documentation for this?I appreciate any help you could give me

Noob question, I apologise in advance.On a sales order I have these two fields that I am trying to add to a report. I reference the first field in a report with=[SOOrder.CustomerOrderNbr]and it works perfectly.However, I reference the 2nd field in a report with=[SOOrder.ExtRefNbr]and it produces an empty column.If that field isn’t ExtRefNbr, how can I determine the field ID?thanks.

We just upgraded to 23R1 and discovered that the document nbr search (within the document screen) is now searching other fields besides the document number.  Is there a way to restrict this to only search document numbers and not customer IDs, as shown below? I search for SO # 1224 and get 1132 in the dropdown.  1132 is an SO# that has a CUSTOMER ID of C1224.  My users don’t want to find a customer number in this particular search box. This same dynamic occurs in the Production Order Maintenance screen and probably other screens as well.

Hi,Do someone use this function? Seems to be a good idea,But on my side i dont receive any notification on my phone?Thanks!  

We are experiencing an issue where we run Project Billing (Construction) and as a result, the invoice being emailed is generated based upon the default (OOTB) report version.  We have a customized (simple) AR641000 version.  It is selected in the Invoice/Memo screen under report versions as the one that should be used (ACTIVE).  The correct version of the report is being used everywhere else EXCEPT when we have Acumatica send the invoice to the customer via email.   Acumatica 2022 R2, Build 22.205.0026