Discussion Forums

I have received a check from a customer and there are a couple of back charges listed on the check stub that need to be applied to make the payment amount show correctly.   I have attempted to do a credit adjustment but that does not balance the transaction.  I was told to process the credit adjustment against an open invoice but that does not help me out either when I need to apply that amount back into the payment somehow.   What am I missing here?

Hello! I am trying to add an attribute to a business account class and am receiving an error message. Here is the attribute.Here is the business account class I am trying to add the attribute and the error message 'Attribute ID' cannot be found in the system.It also does not appear in the search box Please let me know how I can properly ad this attribute to the business account class. Thank you!

When I use the following, I am able to get everything except the Details (CustomerPaymentDetail):entity/Default/22.200.001/CustomerPaymentMethod/?$filter=CustomerID+eq+'C10987654321'+and+PaymentMethod+eq+'CC Visa'+and+ProcCenterID+eq+'procID'+and+CustomerProfileID+eq+'12345678901'The Details are in the Web service endpoint.  Is there a specific URL parameter I need to pass to see it?

Hi Everyone,In the SO Invoice screen, I have overridden the Release action, and when the GL document is created, I would like to delete the GL Tran line created by Acumatica and would like to insert another 3 new lines. It has the right amounts but still getting error like saying Document out of balance.  Can anyone help me with this?Assume my invoice total is 1000. public class SOInvoiceEntry_Extension : PXGraphExtension<PX.Objects.SO.SOInvoiceEntry> { #region Event Handlers public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride] public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod) { //var res = baseMethod(adapter); PXGraph.InstanceCreated.AddHandler<JournalEntry>((graph) => { graph.RowInserted.AddHandler<Batch>((cache, e) => { Batch row = e.Row as Batch; if (row != null) {

Currently I am using CLI to spin up an Acumatica EC2 instance. I am getting this “Database could not be accessed” error despite having my Web.config set up properly. I am using SQL Server Authentication, not Windows Authentication. I believe the Acumatica instance is connected to the database server.In my Web.config:<add name="ProjectX" providerName="System.Data.SqlClient" connectionString="Data Source=[DBServerName];Initial Catalog=[DBName];Integrated Security=False;User ID=[UserID];Password=[Password];Encrypt=True;trustServerCertificate=True" />Assume all the values in brackets [] are replaced with their respective values.  When performing database maintenance, the maintenance proceeds, but I get the following error at the start: [22:23:55 ERR] The database cannot be upgraded because of the following errors:Table AppRestartRequest does not have a primary key. Primary key is required for every table in the database.Table DispatcherSettings does not have a primary key. Primary ke

If it doesn’t, is this something we can add 😀 I tend to leave my tab for one thing or another and I’ve closed my browser not realizing i finished a post so wanted to ask in case, i can go back and find my unposted post.

I’ve been digging into some freight margin details lately, and I noticed that some Drop-Shipment Shipments (that are really PO Receipts) have a Freight Cost that is hitting our ARTran table. Does anyone know how that is calculated and why Acumatica automatically applies that (mystery) cost to the Invoice? In our scenario, our Drop-Ship POs are truly not drop-ships, we are purchasing services from a vendor, not physical products. There is no freight cost associated to these receipts, so how/why is that calculated? 

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?