Discussion Forums

I am trying to get a delta of modified customers to synchronize to an external system. The LastModifiedDateTime filter seems to be ignored, and all records are returned.. My query is{{baseUrl}}/entity/DefaultExt/22.200.001/Customer?$fitler=LastModifiedDateTime ge datetimeoffset'2024-06-03'I have also tried the date format like 2024-06-03T00:00:00.000-04:00, but that too returns all records. Any idea why this won’t filter? It has to be something ridiculously simple...

Consider the following scenario:Customer places an order on a website and chooses their shipping method Order is injected into Acumatica as a Sales Order.  Ship Via exists here. At the time of order injection, we determine that it will be fulfilled via DropShip and automatically set the Order Line up accordingly. We have Automation that “creates purchase orders” for all of those orders.Now, a human needs to go and touch every single PO and set a shipping method. I saw this rejected idea from four years ago: When we transmit a DropShip PO to a partner, it must include a shipping method.  Our partners are shipping 3rd Party on our carrier accounts and we need to specify the class of service.  Requiring that value to be set manually when it’s already been

Is there a way to schedule the export the Excel results of a GI to a local folder? If not, if I made the GI into a report would I be able to schedule an export of the Excel format to a local folder?

Good day,I have a customization project that a part of it consists of establishing a control of line creation on the Purchase order and the Bills and adjustments based on the costcode, if the costcode entered by the user does not belong to the combination of the project, project task and account group the line should not be saved, and an exception should be thrown, but my issue is that in the PO it is working, but in the Bills and adjustment is giving me an error: Error: Another process has added the 'APInvoice' record. Please try again. I don't know if there is a validation or something I need to change, I will appreciate suggestions. Thank you.[PXOverride] public void Persist(Action del) { APInvoice apvar = Base.Document.Current; var BillsCache = Base.Caches[typeof(APTran)]; foreach (APTran apTran in PXSelect<APTran,

I am trying to upgrade another persons code from 2023 R1 to 2024 R1.  There is a line as follows which compiles in 2023:In 2023, the decompiled code shows it is part of PX.Data.PXAutomation  In the 2023R2 developer release notes, I see it was removed:NetTools/PX.Data/Process/Automation.cs PX.Data PXAutomation Is there a replacement for this?  I’m not sure what that line of code even does. 

I'd like to inquire about the "Scan & Transfer" option. It appears to be a one-step transfer. Could you please explain how a user can acknowledge a transfer receipt (Two-Step Transfer) using a mobile device?  One of our customers wants to be able to execute two-step transfers on the mobile app. Thanks Ram 

Hi Team,After I upgrade my instance from 2022 R2 to 2024 R1, my existing webservice endpoint throw the below error. I tried to publish the customization package for this webservice, but still no luck.Please help me to check on this. Regards,Ramya Krishna

Are we required to use Account Groups for Project Accounting?  Since only one Account Group can be assigned to a GL Account, we’re finding that it’s requiring another level of detail on projects that we’re not really wanting.  Trying to determine if we can stop using Account Groups.

I am trying use the Login to Acumatica Rest API with Postman. ​​According to the documentation I have found in the web, I should be using http://MyCompany.acumatica.com/entity/auth/login as URL The body as detailed below:{"name":"johnd","password":"johndpassword","tenant":"mytenant"} I get an error in Postman as detailed below:{"message":"An error has occurred.","exceptionMessage":"Error: Invalid credentials. Please try again.","exceptionType":"PX.Data.PXException","stackTrace":" at PX.Data.PXLogin.LoginUserImpl(HttpContext httpContext, String userName, String password)\r\nWhat am I doing wrong?

We have several customers who would like to hide a specific tab on a screen by user role.For example, on the Projects screen, they don’t want certain user roles to see the BALANCES tab.Is there a way to do that?

Hello, we have a prepaid insurance expense that I wanted to setup a amortization schedule to expense monthly over the life of the policy. Is this possible with the out of the box solution?  thanks

I'm making a customization for adding export and import features to a page.I used EPPlus packages to do that.However, when I transfer my customization project file to another Acumatica website. and when I Publish, it shows the error that the project does not have  EPPlus packages. So I used the custom file feature to add EPPlus packages so it can be published on any website.However I got an error Failed to resolve method reference: System.Void OfficeOpenXml.FormulaParsing.ICellInfo[0...,0...]::Set(System.Int32,System.Int32,OfficeOpenXml.FormulaParsing.ICellInfo) declared in EPPlus.dllEPPlus.dll Failed to resolve method reference: OfficeOpenXml.F

we don’t want to show upload to role that using mobile

Does anyone add the reference number provided by the bank for ACH batch transactions to the batch payment in Acumatica post Acumatica release of the batch paymentI have to release the payment in Acumatica to obtain the export file and would like to be able to go back and add the reference number from bank to that released batch payment in a field that can be searched in the GI.I appreciate any feedback.

The form (PO505000) used to create a PO, we want to be able to apply a filter to the PONbr field, which belongs to the FSSODetSplit DAC.It exists in the database: But when trying to add this field to the screen, it is not available?  is there any way to make this visible? Anyone know why they would be hiding this field?

Hello Everyone,We have requirement to override the Print Shipment Confirmation in the Shipments screen and pass the DeviceHub parameters like PrinterID and No of Copies. Can you please help me with the code sample to override the Print Shipment Confirmation Code and pass the DeviceHub parameters. 

When purchasing through MRP, the vendor location seems to default based on alphabetical instead of the default for a SKU. Ex. Default location for SKU is MOULDINGS.Vendor location defaults to Main Any way to get MRP to consider location defaults similar to how it chooses default vendor? 

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. 

If you receiving the error: 'Field' cannot be found in the system. Follow these steps to resolve.Unpublish all Customizations Edit the ASPX and add CommitChanges = ‘True’ to the PXMultiSelector tags: <px:PXMultiSelector runat="server" DataField="Field" ID="CstPXSelector20" CommitChanges="true" />   Edit the DAC for each MultiSelector field and add ValidateValue = False to the end of the selector definition. [PXSelector(typeof(Search2<EPEmployee.acctName, LeftJoin<Branch, On<Branch.branchID, Equal<Current<AccessInfo.branchID>>>>, Where<EPEmployee.vStatus, Equal<Status>, And<EPEmployee.parentBAccountID, Equal<Branch.bAccountID>>>>) ,ValidateValue = false)] Republish all Customizations 

We are a construction and field service company.  We are currently running our own compliance software that we had custom built for us many years ago.  We have basically outgrown it, and the cost and time to maintain it has become burdensome.  We are looking for suggestions on something that will tie into acumatica’s field service and construction projects for doing hazard assessment, circle checks, inspections, etc. so we don’t have to maintain 2 systems like we are now (prevent duplicate entries and human error).  Being able to do it through mobile is a must.I have gone through the marketplace and there is nothing specific to this.  The only integrations that were close were some forms software, but they didn’t look like they talked nice to field service out of the box.I appreciate your help.Andrew

Hi,I find the setup of an GL account in my company book is wrong in Acumatica. It was setup by my predecessor as asset, but it should be a liability item. As a result, the balance sheet is not balanced. I only find out now as I use the trial balance only in the past few months. I try to change the type in chart of account but an error message pop up. It said “You cannot change the selected GL Account type because transactions for the GL Account already exist”.Please advise how to resolve the issue. Thanks!Raymond

How do we get Credit and Debit Memos to export?  I have tried numerous ways to build an export scenario to export AR Open items and when the data is prepared only the Invoices are loaded for export. If I specifically restrict the source to Credit Memos or Debit memos nothing is prepared at all.  I started this project using AR301000 Invoices and Memos with exactly the same results, credit and debit memos do not load to be exported. 

hello,I added a dialog box in one of my customization's and noticed that Address Lookup stops working. I'm not sure what I’m doing wrong.Normal.Adding a Dialog This is the result Any help is appreciated. Thank you,

Getting unexpected results.  Anyone have any insight they can share?Both planned and actual labor are incorrect 

Hi all, I want to add project ID to sales order type BL (blanket order). I have created a visible or required field in the customization project, but it's not working.Can anyone tell me where I am wrong?