Solved

I guess this may require a customisation. Is it possible to restrict Shipping Rule in a sales order (making it read-only) if the Term of that order is X only for people who have user role Y?  

I’m currently creating a generic inquiry to create a CSV upload report to a third party portal. CHEP (specially treated pallets that are ‘rented’ by our customers). Every week we upload a report to the third party with a count of these pallets with pertinent info - such as which customer and their CHEP account. This also includes quantity. The conundrum I have is that there are 8 item codes. One item code is for a single pallet - so this quantity is 1 to 1. The other 7 item codes are 1 pallet per unit - the unit count is different on them. Example: Customer orders 1 unit of CHEP - qty is 40. They also order RPCs (reusable plastic containers) that are stacked onto 1 CHEP pallet. The customer orders 10 units of the RPCs, so the qty of CHEP pallets is 10. Their total quantity is 50.Where I’m having the issue is coming up with the formula in the results grid to report the quantity of the CHEP for the invoice. I am using ARTran.Qty. I need to translate the unit counts of the 7 item codes to

Hi there! We have been facing an issue related to MYOB Advanced ERP (Accumatica) Filter($filter) option.When used $filter parameter in REST API, pass multiple conditions with 'or' operator.Like this in URL '$filter=CustomerID eq '21FEBUSER' or CurrencyRateType eq 'SPOT' which gives us this error:"exceptionMessage": "Only AND logical operator is supported","exceptionType": "System.NotSupportedException"Is there any solution/api/help available to get multiple record in single request to pass multiple condition from Acumatica ERP in REST URL.  

Hello, I'm new to API development and I need help with a specific query. In my current project, I can successfully retrieve all employees from the top list using $expand=Employees.My goal is to get the results from the bottom section (Overrides) which are linked to specific employees. In the UI form, when I click on Employee #1, the bottom window changes to show their specific overrides, and similarly for Employee #0.I've tried using $expand=Employees/EmployeesOverrides, but this returns Employee #0's overrides for Employee #1, which doesn't make sense.How can I properly query the API to get the correct overrides for each specific employee? I need to establish the proper parent-child relationship between each employee and their corresponding overrides.I've attached screenshots showing the UI interface and the API endpoint configuration for reference. Any guidance would be greatly appreciated!employee 0 overridesemployee 1 overrides 

Hello,I am working on a customization for the Stock Items Inventory. I am trying to add an action to the page that would create a new Purchase order and fill in the vendor fields and insert a line into the Details section for the Inventory Item. I have been able to open the form, and add the vendor, but cannot figure out how to insert the detail line.So I want to take the part that is circled in red in the first image and create a line where the red is in the second image.

I have an report in Acumatica that I have customized and when I run the report withing the Acumatica software the formatting is exactly as I designed it but as soon as I print it the formatting is lost. I am not sure if there is a setting that I need to change in order for the formatting to stay when the report is acually printed. Here is what the section looks like in the report writer:  Here is what it looks like when I run the report in the system: But as soon as I print it the red past due box and the yellow highlighting of past due amount is gone as is the formatting of my aging fields as shown below:  Am I missing a setting or something or is the report designer really limited in what can be formatted when the report is actually printed. Any help on this would be greatly appreciated. 

Hi Community,I’m working on a customization related to the Create Purchase Orders screen and need some guidance with vendor defaulting and updating custom fields on the POFixedDemand DAC.Customization Details:I’ve added the following custom fields to POFixedDemand: Shipping Destination Type Ship To Shipping Location Scenario: In the Sales Order, we have a Configurable item (parent) and IsSupplement (child) items. When creating a PO from this sales order: The Vendor and VendorName on the parent (Configurable) item in the POFixedDemand should default from the child item (where IsSupplement = true). and also on Parent Item (Configurable = true) What I’ve Tried: POFixedDemand_VendorID_FieldUpdated: I added logic here to assign values to the custom UDF fields. The values seem to be set in the code but do not reflect on the screen/UI. Overridden EnumerateAndPrepareFixedDemandRow delegate: I tried to default the vendor here based on the child (supplement) or stock item’

Can I use files of Different Customization Project into my current customized project?

During one of our Move transactions we received the following error.The label printed along with the attributes being passed through to the label and the associated Move transaction did release. This is the first time this has happened since our upgrade and our transaction volume is very high. Is this an error to be concerned about? If so what is needed to resolve this? 

Hi everyone! I wanted to share some thoughts about the challenges we’ve faced with syncing Template-Matrix items as Product-with-Variants in Shopify. As many of you know, we’ve run into a couple of limitations:Shopify can only support 3 options. There’s a cap of 100 variants per product.The first limitation has already been addressed in a previous discussion here. However, our Template item has 4 options and nearly 4,000 variants, which has been quite a challenge.We’ve tried breaking down the Template items into new ones with 3 options, but we’re still hitting the second limitation with some Template items exceeding 100 variants.The really exciting news is that Shopify has recently announced their new GraphQL product APIs, which now support up to 2,000 variants! 🎉 This is a game changer for us and anyone facing similar issues.I’m curious to know: when can we expect to see this new capability available in the Acumatica-Shopify connector? Any insights would be greatly appreciated!Thanks

PS D:\TCourseInstances\SmartFix_T290\FrontendSources\screen> npm run build-dev  modules=RS> screen@0.1.0 build-dev> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack --progress modules=RS[webpack-cli] 'modules=RS' is an invalid value for the --progress option. Only 'profile' is allowed. 

In report designer, is there a way to have a where clause of sorts on a parameter that is searchable?We have a report that sales reps run for their customer by selecting their customer as the parameter. I would like to limit the searchable parameter to only show them their customers instead of every customer.

Can you have the menu which appears on the top right of most screens, appear in the side panel view. These above menu options do not appear when screens like an invoices, purchase orders are viewed in the side panel. 

I am trying to add the customer order number on the add payments smart panel. I read that this can be done by using delegates, but I am struggling to get this to work.I added the dac: using PX.Data;using PX.Objects.CA;using PX.Objects.SO;namespace PX.Objects.CA{    public class PaymentInfoExt : PXCacheExtension<PaymentInfo>    {        #region UsrCustomerOrderNbr        [PXString(40)]        [PXUIField(DisplayName = "Customer Order Nbr", Enabled = false)]        public virtual string UsrCustomerOrderNbr { get; set; }        public abstract class usrCustomerOrderNbr : PX.Data.BQL.BqlString.Field<usrCustomerOrderNbr> { }        #endregion    }}  using PX.Data;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.SO;using System.Collections;namespace PX.Objects.CA{    public class CATranEntryExt : PXGraphExtension<CATranEntry>    {        [PXOverride]        public virtual IEnumerable payments(Func<IEnumerable> baseMethod)        {            foreach (PXResult&l

Hi Acu Community,Is there documentation on creating a Generic Inquiry showing the List of Pending for Approval, specifically for Workgroup Approval?Thank you!

Hello,As anyone overcome the challenge of Quickbooks’ subaccount functionality when converting to Acumatica?  Within QB, when one or more accounts is made a subaccount of another(i.e. parent) account then the balances of the subaccounts will roll up into the balance of the parent.  Many users of QB leverage this functionality for fund accounting especially with cash assets where they have a single interest bearing account at the bank but need to maintain separation for earmarks (e.g. restricted, capital projects, special events, etc).  The problem is not setting up the separate accounts in Acumatica or reporting but with reconciling to the bank statement.  From what I can tell, Acumatica only offers a one-to-relationship between a cash account and a GL account and therefore have not found a way to link the transactions in the fund accounts to the cash account.   

I got this error when i validate a Default endpoint without any extension, same with Admin user.Why?Thanks 

Is there a way to set up Automatic Packaging by Vendor? Example, 5-gallon pails automatically select NONE for the Box ID as we stopped shipping them in boxes.Except, Amazon requires their order be shipped in a box. Is there somewhere I can set a filter that if the order is from Amazon, to use 5Gal as the Box ID? 

Hi Team,While releasing the “ Inventory Receipt”, I am getting the error ” GL Error: Missing Account Mapping for Branch 'CAPITAL ' and 'PRODWHOLE '” . Kindly suggest the missing one here.

In Expense and Receipt screen (ScreenId=EP301020) “Project/Contract” field present.User can select Projects.In this selector popup we need to add customer name and service order nbr field.I can add customer name but not service order nbr. (No error - No column)Code for customization:[PXDBInt] [PXUIField(DisplayName = "Project/Contract")] [PXDimensionSelector(ContractAttribute.DimensionName, typeof(Search2<Contract.contractID, LeftJoin<EPEmployeeContract, On<EPEmployeeContract.contractID, Equal<Contract.contractID>, And<EPEmployeeContract.employeeID, Equal<Current2<PX.Objects.EP.EPExpenseClaimDetails.employeeID>>>>, LeftJoin<PMProject, On<PMProject.contractID, Equal<Contract.contractID>>, LeftJoin<PX.Objects.FS.FSServiceOrder, On<PX.Objects.FS.FSServiceOrder.projectID, Equal<Contract.contractID>>>>>, Where<Contract.isActive, Equal<True&gt

I have a need checkbox(UsrFieldName) to the Request Screen RQ301000. I need to add FieldUpdated Event to itRQRequestEntry is the main DAC  public class RQRequestEntry_Extension : PXGraphExtension<PX.Objects.RQ.RQRequestEntry>   {   #region Event Handlers   protected void _(Events.FieldUpdated<RQRequest> e) -----→ How can I update this Line   {        }   #endregion }

I’m adding a Vendor ID selector to the Stock Items screen.  I’m trying to use an existing VendorActive attribute so I don’t have to create the PXSelector from scratch.In project editor, the custom field shows a TextEdit, not Selector.  I tried editing the ASPX to make the field a PXSelector, but I get this error when I try to use the field:This is my DAC field.  I used the same “technique” as in the Acumatica training course, but does not work.public sealed class CBInventoryItemExt : PXCacheExtension<PX.Objects.IN.InventoryItem>{ public static bool IsActive() => true; #region UsrItemVendor [VendorActive(DisplayName = "Item Vendor", DescriptionField = typeof(Vendor.acctName))] public int? UsrItemVendor { get; set; } public abstract class usrItemVendor : PX.Data.BQL.BqlInt.Field<usrItemVendor> { } #endregion}Nothing is ever easy for me.

Client is migrating from Microsoft Dynamics GP to Acumatica, and we are trying to find the best approach for maintaining pricing. Dynamics GP isn’t particularly powerful when it comes to pricing, but it has a feature wherein it will calculate the selling price as a “percent of list price”. Each custom is assigned a “price level” (similar to a customer price class in Acumatica), and each “price level” is assigned a percentage for each item.Clearly, this functionality can be achieved with Price Worksheets, but that involves some additional work, and it would not reflect a change of “default price” real-time. Has anyone encountered this scenario and solved it with base Acumatica functionality? We are trying to avoid Price Worksheet updates (a lot of room for error), ISV solutions, and customizations.Additionally, we need the Unit Price to be set to the correct amount. A “line discount” is not desirable for several reasons, mostly focused on the user experience in the SO screen.

Hello,In the Web Service Endpoint screen in 2020/R1, when I click on Validate Endpoint for endpoint Default/18.200.001, it executes for about a minute, then fails with this exception:Exception of type 'System.Web.HttpUnhandledException' was thrown. PX.Data.PXNotEnoughRightsException: You don't have enough rights on 'Select'. …Can anyone please shed some light on what is happening?  

I’m hoping someone can confirm something for me.  I’m working on an import scenario to update PO Lines.  The source is a GI that brings back POLine records that meet the criteria that I want to update.  The data includes the PO Type, PO Number, and PO Line Number.I first tried using <Line Number> (turning off the automatic <Line Number> = -1, of course).  If I use this, to get somewhat reliable results I have to subtract 1 from the line number in the GI.  But then when I hit a PO that has had a line deleted (I used one that had only one line, but it was Line 2 because the original Line 1 was deleted), I can’t select the line.If I use @@LineNbr, I can use the exact line from the GI.What I’m thinking (and this is probably one of those “Duh, didn’t you know that?” things)--<Line Number> references what line in the details grid to load.  The actual Line Number value on the line doesn’t matter--in my scenario above with the lone Line 2, if I set the <Line Number> val