Solved

Does anyone know how to make the Project selector visible in the Purchase Order screen PO301000?In the PO301000 screen, I can see Project in the 2nd columnBut when I go to the screen, Project is not visible after Owner as shown below Thanks Mark

Hi, I was trying to run the FA list at the FA module to see what we have in hand, but nothing shows for 2022. And we have been booking FA in ACU. What could we have done incorrectly here?Thanks ahead for all your help!

I have a form with two selector fields.  I want to store the two values in a custom table.  The selector fields work and I can select values and save the record.  But when I click + to create a new record, the first field still contains the previously saved value.  I THINK that the cache is not being cleared when I click +.This is the form after selecting values:Click Save and the record saves.After clicking +If I lookup a value (any value) for the service type field and click save, I get If I click Refresh on the browser, I get a clean screen that will let me add a new record.Note that if I navigate to existing records and make changes, they do get saved properly.Is there some hack I can do to clear the cache when I click the + ? The graph only contains one thing, the view: public class SSGCRRecordServiceTypeLinks : PXGraph<SSGCRRecordServiceTypeLinks, SSGCRServTypeRecTypeXR> { public SelectFrom<SSGCRServTypeRecTypeXR>.View ServTypeRecTypeLinks;This is the DAC for the tab

We are working on upgrading two clients to 22.106 and this version seems to have removed the ability to use the keyboard copy (Ctrl-C) to copy the value of a cell into the windows clipboard.  This issue does not exist in 22.105.  Can someone confirm if this is a bug because will will have clients that will complain about this loss of functionality?Thanks,Kurt

I have noticed that when I add custom columns to SQL Server (I know not officially supported, but it’s for testing purposes), that when an Acumatica upgrade is done, these custom columns are dropped. It’s not a huge deal (that’s why we do RDS SQL Server backups before upgrade), but it seems a little counterintuitive that a drop operation is run on a column that the system doesn’t know about. This is probably the result of a complete table drop and refresh as part of the upgrade process.Does anyone have any strategies for seamlessly moving over custom columns when an upgrade is run? I like the ability to manage the table structure at the SQL Server level, so if there is some way to do that which also plays nice with the Acumatica framework, that would be the best of both worlds...

Hi everyone. Looking for users who have a Sales Department and are on a softphone solution that pairs well with Acumatica. Any feedback on the phone system you are using and the ways you are unifying it with Acumatica is appreciated. Thanks!

Hi,On event handlers, like for example RowSelected, apart from doing a simple check like if RefNbr equals the defaulting value “<NEW>” or something like that. is there a standard / correct way to check if the row is new or if it’s an existing row being selected for different classes like ARInvoice, ARTran, APInvoice, APTran, Batch, GLTran, etc.?

I am getting the following error when trying to add new materials to a production order. This occurs when trying to put the order on hold. An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.  Any thoughts?

 “Next Billing Date” for one of my leases says  06/01/2022. I am trying to advance it to 7/1/2022, or even better 8/1/2022, since I ran July invoices already.On the LEASE page, I tried to run Contract billing, but I get this error message: Unable to cast object of type 'PX.Data.PXCommandPreparingException' to type 'PX.Data.PXOuterException'.I also tried to change the dates on my Charge Schedule, but it didn’t work.

Hi guys I am not able to login in new instance of Acumatica 2022R1 

Hi Team, I have some query on how to set the base currency in a tenant.Case 1 - We have a company in the United states, India, Europe. All have their own company currency i.e., Base currency - USD,INR,EUR. If I set the Company Currency for United states, the base currency is taken as USD. If I tried to create another company for India the same USD base currency field was freezed and automatically taking USD. As per the Document, base currency once set in the system will be applicable for all the companies in a tenant. In order to have multi base currency, then we should able the multi base currency option from Enable/Disable features. When we trying to enable it, system ask us to disable some features like Contract management, Payroll, Time management etc. But we do have payroll and time management in our business.Case 2 - In the above three companies, how we can perform the consolidation. My reporting company is in US, we are in need to provide the consolidated report in USD quarterly

Hi, I am new to Acumatica, hence all my issues I post here. We have a lease that expired. I cannot seem to reactivate it or renew the lease. Any tips? What am I missing? Thank you. 

Hello,    I found Acumatica is having add on called “AcuPOS powered by IIG”, which looks like an entrie whole solution for POS and Acumatica integration.   But correct me if I am wrong, “AcuPOS” looks like also requiring the customers switch/change the POS system they are using right now, right?    If the customers prefer to stay with the POS they are now using, Is there any existed way to go?

I have added this tab in shipment screen and I am to able to get the values stored in DB. These are read-only fields.public class SOShipmentExt : PXCacheExtension<PX.Objects.SO.SOShipment> { #region usrMyField [PXDBString()] [PXUIField(DisplayName = "My Field", Required = false, Enabled = false)] public string UsrMyField { get; set; } public abstract class usrMyField : PX.Data.BQL.BqlString.Field<usrMyField > { } #endregion } 

I have added a custom field it is perfectly able to save the data in my table but when I open that record to edit field is always empty. What am I missing here ? namespace PX.Objects.CR{ public class CROpportunityExt : PXCacheExtension<PX.Objects.CR.CROpportunity> { #region UsrProbability [PXDBInt] [PXIntList( new int[] {10,20,30,40,50,60,70,80,90,100}, new string[] {"10%","20%","30%","40%","50%","60%","70%","80%","90%", "100%"})] [PXUIField(DisplayName = "Probability")] public virtual int? UsrProbability { get; set; } public abstract class usrProbability : PX.Data.BQL.BqlInt.Field<usrProbability> { } #endregion }} 

Let’s say that we have 2 different warehouses, MAIN warehouse, and another warehouse in a different city that is SECONDARY warehouse. We create a sales order with 9 items from MAIN warehouse, but one item is only available in SECONDARY warehouse. We want to transfer the stcok required from SECONDARY warehouse to MAIN warehouse, for inclusion in the customer’s order for one consolidated delivery all at the same time.Is there a way to transfer this inventory from SECONDARY warehouse to MAIN warehouse, for consolidation into the single order automatically? (the alternative of course is to transfer first, and then add to the customer’s order, but this runs ths risk that someone else grabs that inventory after the transfer to the MAIN warehouse).

I want to update UsrSendPONotifications checkbox(which is in PO screen) to true when I update a row in corresponding PO Receipt.This is the code that I tried & it is not working. So , UsrSendPONotifications checkbox remains false.Any idea about this?   protected void POReceipt_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e)    {                  var row = (POReceipt)e.Row;            if (row == null) return;            else            {                POReceiptLine receiptLine = new PXSelect<POReceiptLine, Where<POReceiptLine.receiptNbr, Equal<Required<POReceiptLine.receiptNbr>>>>(Base).Select(row.ReceiptNbr);                if(receiptLine == null) return;                  else                {                    POOrder poOrder = new PXSelect<POOrder, Where<POOrder.orderType, Equal<Required<POOrder.orderType>>, And<POOrder.orderNbr, Equal<Required<POOrder.orderNbr>>>>>(Base).Select(receiptLine.POType, receiptLine

Hi all,I’d like to use the default endpoint to retrieve the relationship between the Project & Vendor. Could someone shed some light on how to $expand that please? (Tool used : Postman)Can it be achieved by creating a customized endpoint which I have added the Vendors (screenname) but how do I expand that to link Projects?See below image for the new endpoint. 

Hello,Reading the ACU documentation and it's not abundantly clear...When you publish a Customization, do you need to have the Role of "Customizer" assigned to a user in order for them to access the screens it has created or edited?and/or is this embedded in the Access Rights portion of the customization?  Cheers!k2

@Naveen Boga  I need to create a workflow condition such that when a user creates a new service order, and does not have a service item in the details, the status on the document will change.  My issue is accessing the document details grid to use in a condition.  It seems that when doing a workflow I can use any of the FS.ServiceOrder DAC fields in a condition/action but none of the FS.SODet (details) fields.  Is there some secret method to making the details available?  Note: I am not a coder and am looking for non-coding solutions.  Thanks.  

I have removed some snap shots from our production instance and ran the “Optimize Database”  operation. However I am still seeing space being occupied by the snap shots. Has anyone else seen this? How can i keep up with the Whitespace usage and Acumatica.   

The report is only pulling data utilizing the main report parameters.  As long as there is data within the parameters of the main report it will print the main report and will then print the data from the subreport that is within the same parameters. If nothing prints in the main document due to the parameters nothing prints from the subaccount even though there is data that should print. What am I missing?

Is there away to update the BOM material items expiration date?   We just are testing some BOMs in our pilot configurations. and realized that some items have expired?  As far as I can tell you would need to make a new revision?  Does the expiration date effect using the BOM in Production.I am new to Manufacturing.  I figured you should be able to update the existing. Thank you in advance for your assistance

All I have a labor batch that Will release, create the GLBatch and Create the Cost Batch however the cost batch will not process. and the labor batch ends with an error Another Process has added the ‘AMProdEvent’ record. - The labor batch is still in “balanced” status, the Cost Transaction is still in “UNReleased” Status. My assumption is I could probably release the cost transaction. Which would finish the process. But would that close the Labor batch?  

On the payments and applications screen, type is customer refund and apply to documents of type prepayment, I’m unable to add finance charges. May I know what’s the logic behind where finance charges option is disabled for customer refund? And also, how can I process the finance charges?