Solved

 Hello,There is a Acumatica customer that is about to reach the end value of their ARINVOICE sequence.   What is the best way to expand this sequence number range and what are the pros and cons? 

Saw this really great video (https://www.youtube.com/watch?v=weBglqXkBpA) from ​@Doug Johnson on Automated AP Bill Approvals with 3-way matching and he had 3 great side panels on the bills and adjustments screen that I would love to replicate. Related purchase orders Related REceipts Unbilled Vendor ReceiptsHe briefly showed the generic inquiries required to make the side panels but didn’t fully show them. I am trying to replicate it but was hoping someone had something similar that I could piggy back off.

We’re integrating with a multi-tenant Acumatica (MYOB Advanced) instance. There are two companies (CompanyOne and CompanyTwo). For each tenant, I created a separate Connected App with its own client ID and secret.Setup: Using OAuth Authorization Code flow Generating an access_token for each tenant’s Connected App Using that token to call the REST API Issue: REST API calls sometimes return data from the wrong tenant. For example, calling with CompanyOne’s token occasionally still returns data from CompanyTwo. Behavior is inconsistent: if both tokens have expired and I refresh them, tenant separation works correctly for a while, but later the API “sticks” to CompanyTwo again.

Hi, I am new to Acumatica and just did the T200 and T210 Training.  My customer needs a field that shows all the Vendor Contacts in a Selector (like e.g. when choosing the Vendor in a new PO). From here: So tried building a field that builds a selector in the POOrderExt of the POOrder DAC. Unfortunately nothing works out for me. I tried it with the following code so far:     #region UsrVendorContacts    [PXDBInt]    [PXUIField(DisplayName = "Vendor Contact")]    [PXSelector(typeof(Search<Contact.contactID,        Where<Contact.bAccountID, Equal<Current<POOrder.vendorID>>>>),        SubstituteKey = typeof(Contact.displayName),        DescriptionField = typeof(Contact.phone1),        Filterable = true)] public virtual int? UsrVendorContacts { get; set; } public abstract class usrVendorContacts : PX.Data.BQL.BqlInt.Field<usrVendorContacts> {} #endregionI also checked the datatypes which seem to be int just as my custom field. I also used foreign keys

Hi Acumatica!In my row sets → data source section, I chose expand code-description for a range of GL codes.How can I remove the spaces between the last digit of the GL code and the dash? The way it currently displays the GL codes looks awkward.selected code-description to expand the GL codes for a range of GLsOutput places 4 spaces between last digit of GL code and first letter of GL Description. I'd like to remove these spaces.Thanks!

Good Morning!I am currently working on a few forms and one of the requests is to make sure that if the discount is showing 0% to remove it from the form. The title “Discount” can still be there but the number needs to go away. Currently I have =IIF (Null ([ARTran.DiscPct]) ,'',  [ARTran.DiscPCT]) . I feel like I’m close but I know I’m missing something. This is being done on the Sales Order invoice but will also be applied to others.Any help would be appreciated.Thanks,Brent

Does anyone know if it’s possible to pass a reference number from Acumatica to UPS? I’m looking to pass an order number or some other field that can handle free text to UPS “Reference 1” and “Reference 2” fields so that it prints on the label.I’d be open to using any integration option (ShipEngine, EasyPost, and standard Acumatica Shipping integration) as long as I can pass a reference number.

Hi Team,We are trying to sync the open shipments from Acumatica to Shopify. while syncing facing below issue."The shipment has been filtered because it is not confirmed."So, we disabled the SOOrderShipment.Confirmed field under result grid in BC-Shipments GI and verified still seeing the same Issue.Can I get help on this how to do this.Thanks in advance.

We’ve processed a shipment for the full line quantity but needed to only ship a partial.  The shipment is now in Confirmed status.  No invoice has been created as yet.  We tried the Correct Shipment link under the ellipses but get an error “The line cannot be deleted because it is linked to a purchase order.” (even though it is not linked to any purchase orders).   How do we correct it?  Thank you in advance

Hi everyone,as fas as I understood there is no need to use Visual Studio to implement a customization.However, to extend the featureset the following guide tells me that Visual Studio should be used.Is it possible to add a featureset without Visual Studio? 

Hi guys,do u know how i can display the Primary Contact (from vendor) in purchase order ?Just like in Sales OrdersI Hope u can help me.

I am trying to create a new instance from a large snapshot. I have to do it through the configuration wizard due to its size and am using this method which states that it does not import custom columns. How to import a large snapshot using the Acumatica ERP Configuration Wizard | CommunityI have additionally found this information which claims that using this method will allow you to import custom tables and columns. Using this method, I have been able to create and fill custom tables and create custom columns on existing tables. However, the custom columns on the existing tables are all filled with NULL values rather than the imported values from the snapshot. Does anyone have a workaround for this? I don’t understand why the values aren’t being copied over.Snapping the Acumatica Snapshot Restrictions | Acumatica Cloud ERP

Hello!I am required to view the items and Subaccounts which are not included any restriction group,but I cannot create the relationship to view those as a bulk (Standard inquiry shows individual items but not all at once)Is there any way that I can create an inquiry for this?Thank you in advance!

Hi everyone,I have a custom webservice-endpoint so user can access vendor locations via REST-API.This webservice-endpoint is part of our customization project.I wonder if there is any possibility to show or enable the custom webservice endpoint only if our feature (defined in the feature.xml) is activiated.Thanks in advance!

Is it possible to use PXDefault to make a Customers Primary Contact the default selection when creating Service Orders? If so, how?

Our team is preparing to upgrade our system. While reviewing some release documentation, we came across a licensing change that we are concerned about.Our question: We would like to confirm if this change applies to ALL generic inquiries or only those that are set for the Anomaly detection?We use this feature regularly and it would be very concerning if there is no flexibility with this. 

Hi Team,I am working with 24R2 Build 24.210.0019.And created custom table that has some data in it.But while snapshot creation getting error like: “An error occurred while importing data into the 'CustomerPriceRepository' table.”Can you please suggest the possible root cause and fix for the error.Thanks,

I am attempting to use PXForeignReference on a DAC extension to ensure the field is set to null when the referenced document is deleted. It published fine but doesn’t work. Is this possible?(NOTE: at the moment, ReferenceBehavior is ‘Restrict’ which should throw an exception upon deleting)public class DSDPMCostBudget_Ext : PXCacheExtension<PX.Objects.PM.PMCostBudget>{ public static bool IsActive() => true; #region UsrPDPOType [PXDBString(2, IsUnicode = true)] [POOrderType.List()] [PXDefault(POOrderType.ProjectDropShip, PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField(DisplayName = "PO Type")] public virtual string UsrPDPOType { get; set; } public abstract class usrPDPOType : BqlString.Field<usrPDPOType> { } #endregion #region UsrPDPONbr [PXDBString(15, IsUnicode = true)] [PO.RefNbr(typeof(Search2<POOrder.orderNbr, LeftJoinSingleTable<Vendor, On<POOrder.vendorID, Equal<Vendor.bAccountID>, And<Matc

Is there a way to add the Case Packaging Dimension by UOM in the Packaging Tab under Stock ItemWe have full cases at a specific dimension and weight then we have single items at its own dimension and weight.

I’m working on some testing of the fixed asset module and have come across a scenario that I can’t figure out.We have a handful of assets that we disposed this year and are looking to bring them into Acumatica with its correct disposal information.  When running my import scenario, it does not allow me to modify the disposal date, disposal method and disposal amount.  I have already done GL transactions directly for the disposal of these assets, so I do not want to post again. Has anyone does this before?

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

For example: A pay-in-advance Medical deduction of $150 was deducted from the employee paycheck for the upcoming month of coverage. The employee quit or was terminated.  We need to refund the $150 on the next/final paycheck. What is the best approach to accomplish this refund? 

I’m trying to do an import that will support updating existing records and creating new onesNew records only is pretty straight forward using the Auto Number KeyWe want to use Auto Numbering because we do not want to make the Serial Number the primary key because there are other factors down the road where the same Serial Number could be used multiple times across multiple customers/vendors, etc.  We are only importing records with a unique serial number right now.  But they will need to be updated.I’ve done some searching which seems to be involved with the concept of simulating the UI where you would use the Lookup Selector for the Reference Number and try to find a record with a matching Serial Number but I can’t get the right syntax down specifically for the Field Service Equipment FS205000The example from the training references a “CurrentCustomer” in the Source Field Value in the first line.That seems be an internal reference and I can’t quite figure out how to translate this exa

We have had this issue with 23R1 and it is still happening now that we have upgraded to 24R2. We have some products where we introduce new versions of them with new SKUs while keeping the product name the same.To do this, we have to delete the old product from BigC before we are able to sync the new product since BigC does not allow multiple products to have the same name.When we do this, we sometime run into an issue where if we include the deleted product as a related item on that new product, then it causes a syncing error that is unrecoverable. Essentially, Acumatica just keeps trying to sync the product, gets the same error from BigCommerce API that the product doesn’t exist, and keeps trying to sync without updating anything or giving an error message to the user.Has anyone else run into this issue?

Good day Is there a way to add a condition to a style in the Sales Order screen or a similar screen where the Sales Order gets highlighted if there is not enough stock available ship completely.