Discussion Forums

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.   

Dear All, I just joined the community and wanted to say Hello to everyone here. Heard great things about the community from others. Global PayEX is a Acumatica certified ISV that provides #Account Receivables and #Account Payables automation from an integrated platform. Customers can pick and choose components that serve their needs. We are JP Morgan invested B2BPayments finctech , we work very closely with VARs to bring combined value to our customers, and very importantly, we have live & happy Acumatica customers. I lead the business in the US, so feel free to reach out if you / your customers are looking to bring world-class automation in their B2BPayments areas i.e., Collect money faster, reduce #deductions and #disputes, apply cash faster to realize reduced DSOs and improved #Working Capital

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? 

I have created a customization that adds a tab to the Stock Item screen. The tab contains a grid with a field with autonumber  attribute. Manually everything work find I can add multiple lines to the grid, but imports only add one line and then stop. The grid has a custom dac and view. Below is part of the dac:public class PAFactoryQuote : IBqlTable{  #region RefNbr  [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")]  [PXUIField(DisplayName = "Ref Nbr")]  [AutoNumber(typeof(PAQtSetup.numberingID), typeof(AccessInfo.businessDate))]  [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]  public virtual string RefNbr { get; set; }  public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { }  #endregion  #region InventoryID  [PXDBInt(IsKey = true)]  [PXDBDefault(typeof(InventoryItem.inventoryID))]  [PXParent(typeof(SelectFrom<InventoryItem>.              Where<InventoryItem.inventoryID.IsEqual<PAFactoryQuote.inventoryID.FromCurrent>>))] 

Hi, I need help.I have create Inventory ID and Linked with formula but when I want make production order I fill the code but cant pop-up    Thank you

Is the Source Restrictions tab on Import Scenarios ignored if the import scenario is fired by a business event?  I have an event that is triggered by an action on my GI.  The event can do two actions.  One of those actions isn’t always necessary (if the BE detects a cost discrepancy, it creates a cost adjustment).  I have the cost adjustment import scenario set with a Source Restriction of the cost difference field being anything but 0, but it continues to create $0 cost adjustments when the event fires.It’s not the end of the world; the $0 cost adjustment does nothing other than create unnecessary adjustment and batch documents.  But I’d like to have it stop doing that if it doesn’t need to create the adjustment.

I've created an import scenario to generate shipments to suppliers in connection with a business event, but it doesn't work. I also tried using a data supplier (Excel file) and got the same error message. However, the supplier has been created in the database, and I can create the shipment manually without any problem. 

Hello all.I have been working on ARM report & I have an individual GL Account that has figures in both Debit & Credit but different set of trxns. I’m looking to post the debit side of the amount under Expenses section & the later into Credits - Income. Kindly lmk how we can achieve this?

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.

The COGS for a drop ship sales orders is the purchase price received.  But is the vendor invoice is received with a different amount  we would like the PPV to be applied to the COGS of the sales order.  We have setup COGS to use the customer location sales subaccount and set the PPV to apply to the Inventory Account,  When we process the AP Bill it creates the Inventory Adjustment but it cannot be released until the Sales Invoice is released   - no idea why this is required because the COGS was the PO cost and not the PO cost + PPV.

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?  

There are several S3 Compatible Providers as alternative to AWS for significantly lower costs.   Has anyone had any success is enabling one as an external storage provider in 2024R1+ SaaS environment? I am specifically looking at Wasabi or Vultr as alternatives to AWS or Azure.    

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