Discussion Forums

I have a custom field in the header of the Process Shipments screen header called Total Selected Price.  There is also a custom field in the grid called Extended Price.When a user selects a record in the grid, I want to update the total in the header. I added CommitChanges = True to the Selected checkbox in the grid.In my code, I added the following event handler to update the total when a checkbox is changedprotected void _(Events.FieldUpdated<SOShipment, SOShipment.selected> e){ SOShipmentFilter filter = Base.Filter.Current; var row = (SOShipment)e.Row; GTISOShipmentExt extLine = PXCache<SOShipment>.GetExtension<GTISOShipmentExt>(row); if (extLine == null) return; SOShipmentFilterExt extHeader = PXCache<SOShipmentFilter>.Get

Hi, I close a month in the system. But my colleague can still post a journal entry in that month. Have I not close the month correctly?Thank you.Regards,Raymond

There seems to be something wrong with import scenarios to update existing customers.  The customer exist in the system and I only had two columns in the excel file, Customer ID and Price Class ID.  When importing, the error is “Legal Name cannot be empty”.  When I add the Account name into the excel spreadsheet, I get “Email address must be specified if “Send statements by Email” option is activated.  The account already has an email address.I do not want to introduce more fields into the excel spreadsheet as I am just updating the Customer Price Class but it just seems impossible.Why can’t I just update one field?

Hi Experts,I've requested to restrict edit access to only the custom role 'Project View Only'. For all other roles, the 'Value' column on the project screen should be set as not editable. Any assistance with this matter would be greatly appreciated. Thanks in advance.Sagar

I am in the process of desiging a new invoice and my question is what and where are the SOLine.DiscPrice and SOLine.CuryLineAmt. I have SOOrder and SOLine in the relationship and have tried a Left Joiin, Right Join, Inner Join and the report doubled up the line items, as there should have been two line items, there is now four. I do have ARTran and ARInvoice and have been experimenting with those, but I’m still a noob in Acumatica.

Hi, What’s endpoint version for Acumatica 2024R1, is it 23.200.001 ?

hi All, I am dealing with a client to help them fix the financial year which had been set incorrectly and they have been transacting in the system for at least a year. the issue is where it has to show 2024 as a financial year for the year starting from 1/7/2023 it shows 2023.  ( we are using the MYOB Advanced Australian financial calender) , we are missing this tick box which should have been enabled at the start. has anyone dealth with this issue before or can this be fixed? it is just annoying for the client to always see the incorrect year. ThanksGhazal   

Hello - Is it possible to grant users the ability to create and save Journal Transactions, but not allow them to take it off of hold or release them? I am able to restrict the ability to create new transactions via the access rights by screen, but I have not been able to figure out how to allow the creation of them without release. Thanks!

I am trying to expose a Generic Inquiry as a REST endpoint. This Generic Inquiry has a filter parameter of date. When I try to call the endpoint from POSTMAN, it keeps on erroring out.I followed the instructions in acumatica help that tell you to encode the datetime   You should encode date and time values in URL format before passing them as the value of the parameter. For example, you can encode the current date and time by using the System.Net.WebUtility.URLEncode() method as follows: WebUtility.UrlEncode(new DateTimeOffset(DateTime.Now).ToString("yyyy-MM-ddTHH:mm:ss.fffK")).I have tried to call this using different syntax, but it looks like it is erroring out.The parameter is ReportDate and is of type datetime.  I have tried  1) $filter=(ReportDate eq datetime '2024-03-01T00:00:00.000')2) $filter=(ReportDate gt datetimeoffset '2024-03-01T00:00:00.000')3

Hello all,A probing question first:Does anyone use OpenID Authentication with a multi-company setup?The real question:How can I use OpenID Authentication in a multi-company setup AND NOT have to fully log out from a company to switch to a different one?My current status is I have OpenID Authentication working in multiple companies, BUT to switch company one needs to fully log out and make a new copmpany selection on the Login Screen. The company selector, once logged in is not even available.I am willing to even make a customization to achieve this.Caveat: We are currently on version 21R1.We are upgrading to 23R2, as I type, so I am looking for h

Hello community,I am wondering how can I write a delegate for a method that has "params" argument considering the params argument is needed to be the last parameter in the formal parameter list? public delegate void RunLogActionBaseDelegate(string action, string logType, FSAppointmentDet apptDet, PXSelectBase<FSAppointmentLog> logSelect, params object[] logSelectArgs);[PXOverride]public virtual void RunLogActionBase(string action, string logType, FSAppointmentDet apptDet, PXSelectBase<FSAppointmentLog> logSelect, params object[] logSelectArgs, RunLogActionBaseDelegate baseMethod){ baseMethod?.Invoke(action, logType, apptDet, logSelect, logSelectArgs);}I tried to override the method Any help is appreciated.

I am working on implementing project accounting.  I set up a project template and am now working on the project template tasks.  Do you need to set up the Project Template Tasks for each Project Template or can the tasks be shared between the Project Templates?  

Hello Community,I have been looking to display the values from PMBudget & PMRegister tables in a single GI, but the rows & values are getting duplicated from the PMRegister table. How to resolve this? Thanks in advance.

Hello. I have one question. How to better make next logicWhen pressing Create Shipment on Sales Order screen i want to create for each package row in right grid with quantiry that this package have  

Hello all,I have been working on a report - AR Aging (AR631000) and I am looking to put up a condition where the report should not display the rows that have 0 figures as highlighted below: How can I apply the condition? Thanks in advance.

I have BOM and materials are fetching from multiple warehouse. Those warehouse are defined in the BOM and in the BOM cost is displayed perfect but when coming to the Cost Roll, cost is rolling to the same warehouse defined in the header portion of the screen. Anyone faced this kind of situation?

I created a custom field to go in the grid in the Line Details dialog on the Purchase Receipts screen.I looked at the solution in the following post, but resetting the defaults on the grid did not make the field show.EDIT: I found out why this is happening.  See my next comment below. 

One of our most common causes of inventory discrepancies is items being removed (unallocated) from service orders in Acumatica, but not physically making it back to the shelf. In a previous system we had visibility in the form of a (-1) to leave a trail of breadcrumbs of sorts.Is there any way to leave a “trail” or something similar to give us visibility on items that are unallocated from service orders? This gives us a huge head start when chasing down lost inventory during physical counts. For example: Inventory in question came out of “Technician X’s” job last month. Check his toolbox and truck for the lost part. Just seems like an area where software could lend a helping hand to a very common “human” problem.Thanks!

Hi,Recently I faced with such problem :Earlier such request worked : https://abcd.acumatica.com/entity/ARTSDocEndpoint/20.200.001/PurchaseReceipt?$filter=ReceiptNbr eq 'PR001383' and VendoriD eq 'PP1'&$expand=DetailsBut now it loading all set of data from Acumatica and I get timeoutI set timeout at 10 minutes and after that Acumatica returned all Receipts that are present at Acumatica.I doublechecked data that I am trying to get via filters and tried to get another data from Acumatica - noting worked. I tried to perform similar request with PurchaseOrder and Vendor entities - everything worked. Also, I checked endpoint and all fields are present for Purchase ReceiptPlease help, maybe some addtional configuration should be checked 

When Adding shipment to the SO Invoice by Add Order action we are getting this subjected error.Below is the trace.LINQ fallback! Consider rewriting your query. Graph: Wrapper.PX.Objects.SO.Cst_SOInvoiceEntry LINQ Model: value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.SO.SOOrderShipment]]) => Concat(value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.SO.SOOrderShipment]])) Base BQL: Select2<SOOrderShipment, InnerJoin<SOOrder, On<TypeArray<Field<SOOrderShipment.orderType>.IsRelatedTo<SOOrder.orderType>, Field<SOOrderShipment.orderNbr>.IsRelatedTo<SOOrder.orderNbr>>>, InnerJoin<SOOrderType, On<TypeArray<Field<SOOrderShipment.orderType>.IsRelatedTo<SOOrderType.orderType>>>, InnerJoin<SOShipment, On<SOShipment.shipmentNbr, Equal<SOOrderShipment.shipmentNbr>, And<SOShipment.shipmentType, Equal<SOOrderShipment.shipmentType>>>>>>, Where&

Recently, I’ve been seeing a bunch of blank warnings when I publish projects.This is happening with projects from different instances of Acumatica.  It starting happening about a week ago.  It is showing these warnings even on older projects that haven’t changed.The only changes to my system are that I added .Net 8 and a preview release of Visual Studio 2022 so that I could follow along with an online training course.  The version of VS I am using to compile the libraries is still in the release version of VS.I do not have any idea what might be causing this.  The projects seem to work fine in production.Has any one else seen this before?

Hi,I have a request to add a Customer Status and have it act like one of the existing status.  The purpose is to call out certain credit situations.I can add the new status, but how can I attach the logic form one of the other statuses to it, so when selected, it acts the same?So for instance, create a new status that mimics Credit Hold.  So this would not allow new orders to be created without approvals, etc. but would be a different status to alert Customer Service to a particular situation.Thanks in advance.

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 James Harris - Acumatica Community Featured Member for March 2024Meet James Harris our Acumatica Community Featured Member for March 2024. It’s great to have you as part of the Acumatica Community @jamesh! 

I am trying to update the Required Date Column through and import scenario.  I keep getting error   Error: 1 items have not been processed successfully. View name: Document.  I have tried deleting and readding everything from scratch.  I thought this was going to be something simple but Im missing something.  Not sure what its adding in that paramter or why I cant just specifcy the keys on the POline table and the date and call it good.  

Good afternoon! I wanted to share with you a snippet of code that has helped us tremendously with our credit hold process. We have times when a check is created, or a credit memo is left on the account, but not yet applied to documents. These customers would have invoices that trigger credit hold, but a negative or 0 balance, so it should not. Sometimes, there is a lag time in the processing of these credits/payments, so I had to write a modification to assist. Sometimes tracing through the Code Repository and finding the correct functions to extend or events to inject than writing the actual code! The customer credit verification is held in the CustomerCreditExtension graph extension. This extension is overridden by the SOOrderCustomerCreditExtension with custom logic overriding the base logic for the SOOrderEntry screen. The class SOOrderCustomerCredit is an extension that applies the logic to the screen through extending SOOrderEntry.This uses PXProtectedAcce