Discussion Forums

Hey, Does anyone know if it is possible to display just the time of a transaction on its own in a GI? I am trying to use a filter to show what was done during normal operation hours and what was done on overtime. But with the current date/time display, I cannot filter the time portion, without filtering the day as well.  I want to have the time by itself so that I can group things within that week that were made during normal hours, not just on a specific date, if that makes any sense.

Hi,What is the option available to roll-back/reverse depreciation for a specific fixed assets or a class of assets.  Thanks,Dulanjana 

We’re trying to send a FedEx order with multiple boxes in one shipment, however, we keep getting this error. Is this a way to fix this issue? 

I have a selector that, after you select a value, only shows the “CD” of the field.  I want it to show the “CD - Description”.When you click the lookup, you see this:After you select a row, you see this:I want it to show T1 - test1Note that if I add DescriptionField = typeof(SSGCRServiceType.description))], the field clears out after the row is selected.  I don’t know why that occurs.  Maybe because the field value in the table is int?Does anyone know what I need to modify in this select statement to make this happen?#region UsrServiceTypeID[PXDBInt][PXUIField(DisplayName = "Service Type", Required = true)][PXDefault(PersistingCheck = PXPersistingCheck.Null)][PXSelector(typeof(Search2<SSGCRServiceType.serviceTypeID, InnerJoin<SSGCRServTypeRecTypeXR, On<SSGCRServTypeRecTypeXR.serviceTypeID.IsEqual<SSGCRServiceType.serviceTypeID>>>, Where<SSGCRServTypeRecTypeXR.recordTypeID.IsEqual<CRCaseExt.usrRecordTypeID.FromCurrent>. And<SSGCRServiceType.is

Hello all,Can we apply access rights or restrictions to the Notes?highlighted below.  

Driving myself bonkers.  We are using 24R1 and trying to get sales taxes set up.  Here is the setup:Tax ID: NYSTATETAX = 8.875%, NYNOTAX = 0%Categories: Taxable, ExemptTax Zone: NYTAXABLE linked to NYSTATETAX and TaxableTax Zone: NYNONTAX linked to NYNOTAX and Taxable and Exempt All inventory items are set to taxable. When I create a sales document for a customer with the NYTAXABLE tax zone and a Taxable item ($99.60) and an Exempt item ($25), the correct taxes are calculated, but the tax breakdown is incorrect - the NYNOTAX tax id is missing.When I create a sales document for a customer with the NYEXEMPT tax zone and a Taxable item and an Exempt item, no taxes are calculated and the tax breakdown on the taxes page is correct. 

Good day i have this one last problem on my report it duplicates the taxID on every invoice there is a one data that duplicatesactually its not really duplicating it adds a tax ID even though its not on the transaction like here it diplays wc158,wc120  

I don't know which function we use and how to use it. Please kindly share any guideline and advise me. Thanks so much for helping and supporting.

I had implemented a custom DAC and screen called prospect vendor. then I need to create a default vendor in the system on a button click. following is the action code. My issue is the header section of vendor page contains data from vendorR dac, which is extended from Vendor Dac, I try to create a vendor instance and saved it, action runs without error, but data is not saved to Database. when I try to save vendorR instance it gives error. how can save a BAccount instance rated to my vendor via VendorMaint graph object. public PXAction<ESProspectVendors> CreateVendor;[PXButton(DisplayOnMainToolbar = true, CommitChanges = true)][PXUIField(DisplayName = "Create Vendor", Enabled = true)]protected virtual IEnumerable createVendor(PXAdapter adapter){ ESProspectVendors vendor = ProspectVendorsView.Current; PXLongOperation.StartOperation(this, delegate { SaveVendor(vendor); }); return adapter.Get();}public static void SaveVendor(ESProspectVendors prospectVendor){

Hi , I wanted to extend  my stock item end point to include Available to Ship value of Inventory Summary screen. To do so, I Create a custom view and tried to populate the field from DAC level only. So that when called from API it will resolve the BQL and fire the data to the API. I want this field for API only so I dont have any screen level events attached to this DAC field.Below is my code public class TSInventoryItemNIExtension : PXCacheExtension<PX.Objects.IN.InventoryItem> { public static bool IsActive() => true; #region UsrAvailToShip [PXDBDecimal] [PXSelector(typeof( Search<TSViewGetAvailToShip.qtyHardAvail, Where<TSViewGetAvailToShip.inventoryID, Equal<Current<InventoryItem.inventoryID>>>>))] [PXUIField(DisplayName = "Avail To Ship")] public virtual decimal? UsrAvailToShip { get; set; } public abstract class usrAvailToShip : PX.Data.BQL.BqlDecimal.Field<usrAvailToShip> { } #endregion }In the abo

Hi,We have a client that is trading in multiple vehicles in a package deal to purchase multiple OTHER vehicles. Do we fully dispose/sell the originals and create/purchase the new? What about the NBV of the old assets being transferred to the new?Thanks.

Does anybody know if there is a native integration between Acumatica & Gusto HR? I have a potential prospect tracking time for construction projects in Gusto & they’re curious if there’s an integration, rather than doing CSV uploads

Hello,I’ve looked at a couple of other posts with similar questions, but I still can’t seem to find where my problem is.I have an import scenario to create invoices. Some customers have multiple lines on the Excel sheet, but all lines need to be on a single invoice for each customer. The import scenario, however, is only grouping the line items if they appear in sequence on the Excel sheet - I do not want to have to sort the Excel sheet before importing. If line 1 is for customer 1234 and line 19 is for customer 1234, they need to be on one invoice.Here is what I currently have for the import scenario:And here is a snippet of my Excel as an example, 8216 appears here 3 times, but it is creating 2 invoices - the first with the first two instances from the Excel and the second invoice with the third line item:Thanks in advance! 

Does anybody know if the Availability Adjustment field works? Is there any additional setup other than changing this field? I’m still testing, but upon initial update it didn’t work. See screenshots.I set it to -5 expected that if I have 40 quantity available, the commerce site will display 35 because of the -5 adjustment I have as the availability adjustment. It’s still showing 40 qty.   

I have an Export scenario that updates a Magento store’s quantity values every hour. I created a GI that will show me the current qty available to ship of all inventory that was invoiced in the last hour.At the start of the day, it will fail with the error: “Index was out of range. Must be non-negative and less than the side of the collection. Parameter name: index.”If I run it manually in Export by Scenario by selecting Prepare & Export, I get the same error.If I check “Discard Previous Result” and select Prepare & Export, then it will run. And for the rest of the day, the process will run on the hourly schedule I have it on.Until tomorrow morning when it will need me to run it manually again.Any ideas on how to troubleshoot this?

Hi Community,I’m working on the Customer Details Inquiry screen in Acumatica, specifically on the Pay/Apply Document action. I’ve overridden this action to handle multiple document selection so I can apply payments to multiple invoices at once. Here’s the code I’m using:public delegate IEnumerable PayDocumentDelegate(PXAdapter adapter);[PXOverride]public virtual IEnumerable PayDocument(PXAdapter adapter, PayDocumentDelegate baseMethod){ List<ARDocumentEnq.ARDocumentResult> selectedDocuments = Base.Documents.Cache.Updated .RowCast<ARDocumentEnq.ARDocumentResult>() .Where(shipment => PXCache<ARDocumentEnq.ARDocumentResult> .GetExtension<ARDocumentResultExt>(shipment)?.UsrSelect == true) .ToList(); if (!selectedDocuments.Any()) { // Fall back to base behavior if no rows are selected return baseMethod(adapter); } // Iterate through each selected document foreach (var doc i

Hi everyone,Can anyone please tell me the source fields of the information in label below the SOLine grid in SOOrder screen?Thank you 

Hi Everyone!!!In convert purchase to asset, I allocated a purchase to the wrong fixed asset. How can I reverse the one single transaction in order for the purchase to reappear in the convert purchase to fixed asset, to go back and allocate it to the correct fixed asset?

A positive inventory adjustment made directly to a project/task hits the project ledger as a negative qty/cost on the project ledger….  everything else in the GL and IN modules appears correct, but the project ledger is wrong. the workaround it to do the adjustment to project X (this avoiding the incorrect project transaction) and doing a transfer into the project… but in current release of Acumatica (22R1 and prior) this doesn’t completely solve the issue from a reporting standpoint, since transfers still don’t hit the project ledger at all….  would be nice to have that fixed btw… I have a business event setup to properly create a project transaction after the transfer.But this seems to be a legit a bug unless I’m missing something obvious… -Matt 

I’ve added two tabs to a tab strip.  These two tabs do not need to load unless the user actually clicks on the tab.  Is there a way to prevent the loading of a tab until it is activated by the user?

Team,We have a service that implements interface IVersionService which has been deprecated since 2023r2. Could anyone suggest an alternative for this? Release notes have no information on this.Also checked for PX.Version in later releases , only reference that I could see was PXVersionHelper. 

Hi EveryoneCould you please help me with a question regarding unpublishing customization that impacts the instance in a multi-tenant environment?For example, we tested a customization that would impact the instance in a Test tenant. It works well. We publish it in Live tenant again. Due to another test we need to do in the test tenant, we unpublish this customization in test tenant, while the same customization project in Live remains published. My understanding is that some customizations impacts the instance, not just the tenant it is published in. Does it also in term have the same effect when we unpublish?  Removing the same customization in test tenant will impact live tenant and may cause errors. What would be the best practice when we want to test customisation in a multi-tenant environment?Appreciate your insight and suggestions.Thanks.  

As an Admin user is there a nifty way to get a list of all user favourites through a GI or any other means. The plan is to audit all the obsolete reports/screens sitting in the user favourites and replace them with newly build reports/ screens etc. this is for larger organisations and it’s be difficult to so this one by one.

Has anyone ever come up with anything that "resembles" Fishbowl for inventory purposes?In regards to the color coding, red, yellow, green... ok to ship orders. I know you can do KPI's  but on an actual GI.

We are using end point to create payment for our sales order, the default Sales Order Type is “SO”, when creating payment record it works and get added correctly.We added a new Sales Order type “CL” with a separate sequence. But when sending the payment to it it returns this error:An error occurred during processing of the field Order Nbr.: The order cannot be applied, the specified combination of the order type and order number cannot be found in the systemAlthough in the request the order NBr is correct and OrderTYpe, here is the payload of the payment creation request: $data = [ "Type" => ["value" => "Payment"], "CustomerID" => ["value" => "CUST001"], "CashAccount" => ["value" => "MAIN"], "PaymentMethod" => ["value" => "CHECK"], "PaymentAmount" => ["value" => 100], "OrdersToApply" => [ [ "Type" => ["value" => "CL"], "OrderNbr" => ["value" => "CL00000001"], "AppliedToOrder" => ["