Solved

hello, I'm trying to set up an event to receive notification when payment details change.I've set up the audit trail, a generic query showing updates and the event, but I'm not getting the notification that a new change has been made. Some help please..Thank you in advance. 

Is there a video or webinar on crew time entry?

On some of our sales order, we have large system orders (perhaps 1% of orders) where are controller has the requirement that we post to a different subaccount than a common replacement or re-ordering of a part order. We default our sales account - subaccount to our prevalent replacement/re-ordering account (99% of orders). Our posting class for our items defaults to the inventory item entry for the sales account and the sale account subaccount.Questions: 1. I see a couple of "out of the box" actions available for sales orders where one can modify the sales order lines systemically (e.g. recalculate pricing). I suppose there is no other way than to have our order entry staff to manually enter the subaccount for these system orders manually on each line, right?2. We do our quoting of our large system orders on an Excel spreadsheet even though we our using the Project Accounting module within Acumatica with a line by line breakdown of items and their quantities. We envisioned loading thes

Hi  Team,We would like to override below base method (ConfirmRow()) from INScancount graph (Scan and Count ) ,we have tried below but its not working, Can you please advise how can we achieve this, [PXOverride] public class ConfirmLogicExt : ScanExtension<CountMode.ConfirmState.Logic> { public static bool IsActive() { return true; } public string Prompt => Basis.Localize(Msg.Prompt, Basis.SightOf<WMSScanHeader.inventoryID>(), Basis.Qty, Basis.UOM); public CountMode.ConfirmState.Logic Mode { get; private set; } protected FlowStatus PerformConfirmation() => Basis.Get<Logic>().Confirm(); public class Logic : ScanExtension { protected Func<FlowStatus> var1; public static bool IsActive() { return true; } public virtual FlowStatus Confirm() { if (!CanConfirm(out var error)) return e

Hi ,Could you please anyone let me know for one customer, how many Acumatica open university accesses can be given? Best Regards,Dulanjana

Hello, in this screenshot, how can I either delete these records or mark them as sent?  That’s question #1.  Question #2 is why are they there in the first place?  We are emailing these, I can look at the Activities tab on the customer and see that it was sent.  I do have “send user emails immediately” checked in Email Preferences.  Is that causing it?Thanks.

Within the APContact table there is an Attention Field, this field is on the Vendor > Payment Tab > Remit-To Info section - Attention field.  I am trying to pull this field into our Checks that we print, however, when I pull in the table into the ReportDesigner I only see the following. Nothing that i have seen yet aligns to this field. Any thoughts on this?   

How do we release retainage on multiple invoices at one time and reference 1 retainage billing invoice rather than each individual contractor pay application, that would then go through the approval process once, rather than for each contractor pay app? 

How do I clear STATEMENTS TO EMAIL from the AR Clerk Dashboard? We have already emailed these statements and still they do not clear from this card.   

When running reports, for example, the Customer Summary Report I cannot get it to sort by name. It always sorts by the customer ID. I change the sort in the Additional Sort and Filters and  I’ve tried to change the sort in the report designer but it still won’t sort it the way I want. Any help will be appreciated. Thanks,

Is there a way to apply and Open Debit Adj to an Open Credit Adj?

Getting an error when trying to open Documents Not Posted to Inventory. Error occurs as follows - The Documents Not Posted to Inventory button is disabled. If anyone has any idea about it please let me know. Thank you

I don’t know how I got a Debit Adj in “reserved” status.How can I get rid of it? Sue

Hello all,I have been working on importing some non-stock items but the system is triggering the following error:The import scenario:So here i am using the same column from my excel sheet - PACKAGING and mapping it to all the 3 fields: Base Unit, Sales Unit & Purchase Unit.What is it that I am doing wrong here?

We are using the Time Card system, but NOT Payroll.  Just this week, the Week ID is no longer showing up.  Where do I go in Acumatica to set this weekly ID?  See screenshot below for reference.  

Hi,@Laura02 This is an urgent Issue.We had a an issue with not all our some of Invoice not having the correct sales tax agency and now need to file and Amendment. In doing research we discovered that total sale on P&L Is a good bit less than Income we have recorded on Invoices for 2023. I exported all in AR Invoices and this total is good bit higher then what is showing on P&L. Is this normal?

Not sure what this one is about… I tried clearing sync data for this Entity and Preparing + Processing again but the same Error occurs. 

All,I’ve created a basic Vendor Score GI based on 6 user defined fields of price, responsiveness, quality, etc. I would like to have. a final visible column that averages the user defined fields for an average score.I have something like this:=[VendorR.AttributeVSCOREDELV]+[VendorR.AttributeVSCOREPRIC]+[VendorR.AttributeVSCOREQUAL]+[VendorR.AttributeVSCORERESP]+[VendorR.AttributeVSCORETAT]+[VendorR.AttributeVSCOREVARI]/6I actually get a value calculated, but it’s not right. :DI tried changing it to =sum(1+2+3/3) etc but it throws an error of “Cannot perform an aggregate function on an expression containing an aggregate or a subquery.”Help, I’m lost lol!  

Good Day Everyone!   I am working on my Benefit reconciliations, and need to run a report that gives me the summary by employee of their monthly deduction totals.   I can only find a report that gives me this information by detail for each transaction date.  In other words, not summarized.  Short of exporting this into excel and sorting, does anyone know of a “summary” report?    Thanks!  😊

In a Purchase Order, could the ADD ITEMS button be made to look at both Stock and Non Stock Items? Currently it only looks at Stock Items. 

I have a business event that I am trying to make so that it creates an opportunity and a quote for certain business accounts on a regular basis. I have set up the business event to run an import scenario on a schedule and everything seems to work fine, except there is no actual opportunity or quote created.I set up the import scenario separated from the business event with the exact same settings and source and it runs perfectly. The automation schedule runs correctly and both the schedule and the business event say they run without any errors. I have tried setting up a task template (using the business account id as the related entity) as a second subscriber and it creates the task successfully, just without the related entity. This makes me think that there is something wrong with my generic inquiry that is not passing the business account ids properly to my business event. Any input would be appreciated!Thanks,Drew

I am playing  in our test (sandbox) environment and found out I don’t have access to run this report .

I am looking to create a Chart for a dashboard that displays labor hours by project. I am trying to run the DB Project Time Detail report and I am getting this error message. Does anyone know what this means? 

This is a unique encounter in our system. On the bigcommerce side (where the orders are created) the customer purchased 14 different products upon syncing on Acumatica only the 13 products are in the SO because of that the total is different. Note: All products in the list are already synced and active.Error Message: The status of the SC014658 order does not allow modifications. Please synchronize records manually. What do you think is the problem?

Hi everyone, I am having screen with Supplier (Right) Grid.Having fields Vendor Ref, Ref Nbr.When i will select Matched Vendor ref. selector the related record should populate in Ref Nbr.But in my case, i am having same Vendor reference nbr with same datatype so there is no unique field.Ref Nbr     Vendor RefA               000011158B               000011158C               000011158When i am select  B  - 000011158 it will populate A - 000011158.   Selector Code:     #region MatchRefNbrExcel // working here commented below n added my code WIP    [PXDBString(255, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Matched Vendor Ref.")] // Rajani changed on 29 Jan 2024                                                       [PXSelector(typeof(Search5<APInvoice.invoiceNbr,    InnerJoin<BAccountR,        On<BAccountR.bAccountID, Equal<APInvoice.vendorID>>,    InnerJoin<APRegister,        On<APRegister.refNbr, Equal<APInvoice.refNbr>>,    InnerJoin