On the Subcontracts screen I want to add a custom column to the Project ID selector.The value will come from the Details tab of the Projects screen (sum of Revised Budget Total)I’ve tried numerous ways to do this. This is what I am trying at the moment. I am simply trying to put a dummy string into the custom column as a proof of concept before doing any BQL selects at this point.namespace PX.Objects.PO{ [PXNonInstantiatedExtension] public sealed class PO_POLine_ExistingColumn : PXCacheExtension<PX.Objects.PO.POLine> { public static bool IsActive() => true; #region ProjectID [PXMergeAttributes(Method = MergeMethod.Append)] [PXCustomizeSelectorColumns( typeof(POLine.alternateID), typeof(USRBudgetTotalExt.usrBudgetTotal))] public int? ProjectID { get; set; } #endregion } public sealed class USRBudgetTotalExt : PXCacheExtension<PX.Objects.PO.POLine> { public static bool IsActive()
Thanks to the other topics already posted here, I’ve been able to create a wiki for my custom page! If I put my wiki on the dashboard, and click it, it opens to my default “Overview”. When I click the help button on my custom screen, the wiki opens but it does not start out at Overview. It defaults to the “root”. If you click Overview in the tree menu, it opens the overview just fine. It is just a little UI issue for me to not put the user at the “root” where there are no articles.Here are some screen snips showing what I mean.Here is the dashboard:Clicking this gives me the desired results: From my custom screen I click the help button and this is what shows up:Note that Overview is not selected by default.This is the setup for the Wiki which looks right as it does show overview by default when selected from the dashboard.I will eventually remove this one from the dashboard as I will want it used just on the custom help button. It is on the dashboard now just so I can see it fun
I added UDFs to the EP305000 screen in the Details Tab. You can see here that the data is saving to the DB as expected. (Customer, MEP ID, Advisor ID, Product Line ID)I want to take the data after the hyphen in the Customer number field and put it into the Plan ID UDF.When I added the fields, it created a DAC Extension in PMTimeActivity.In the Project Editor, if I choose to add a handler on the Field Updated event for the Customer field, It creates a graph Extension as here:So, the DAC extension is as follows as public class PMTimeActivityExt : PXCacheExtension<PX.Objects.CR.PMTimeActivity>but the graph extension is public class TimeCardMaint_Extension : PXGraphExtension<TimeCardMaint>This obviously won’t compile as the cache is not PMTimeActivity, but rather it is EPTimecardDetail.PMTimeActivityExt myExt = PXCache<EPTimecardDetail>.GetExtension<PMTimeActivityExt>(row);How can I get a reference to the DAC Extension when the cache is different from what the grap
Last week I watched a two part Acumatica training video on Unit Testing. I want to watch it again but for the life of me, I cannot find it!Can anyone find the link for me? I even went through my Chrome history and I cannot find the link.
When a user saves a Purchase Order, the LastPrice in the POVendorInventory table is updated. If there are multiple lines in the PO for the same item, they may have different Unit Costs for the same inventory item. When the table is updated, the last record in the grid is what ends up in the field.If there are multiple lines with the same inventory ID, my customer wants to update the LastPrice field with the LOWEST unit cost, not the last one to be processed.To complicate this, they want to change the LastPrice field to the lowest Unit Cost if it is overridden in the Purchase Receipts screen. Based on my testing, if you edit the Unit Cost on the Purchase Receipts screen, I don’t see that it updates the POVendorInventory table. They want it to update the table if the Unit Cost is overridden. Honestly, it seems like that should be standard business logic. On the Purchase Receipts screen, you are entering the ACTUAL cost of the item.Since the customer wants to update the LastPrice fi
I added a custom field to the Bills and Adjustments screen Details grid.The users want to be able to lookup the project id by filtering on the Task ID. They KNOW the task ID, but they don’t know the Project and the Project lookup only lists the projects.My custom lookup pulls from the PMTasks table and is joined to the PMProjects DAC. My lookup allows you to filter on the Task ID.When you select the first line shown in the print screen, it should be returning Task ID 1652.In the code, it is returning 1584 no matter which item is selected in the grid.This is the DAC Extension showing my Selector. Is there something wrong with it? the Grid shows the TaskID so I can see it is unique. I don’t plan to show the integer, but I am showing it for debugging purposes, . public sealed class APTranExt : PXCacheExtension<PX.Objects.AP.APTran> { #region UsrProjectTaskID [PXUIField(DisplayName = "Lookup Project Task")] [PXSelector( typeof(Search2<PMTask.taskID, InnerJoin<PMPro
I am working in 2022R1.I created a custom table with a default to one of the fields. I created the table in MSSQL Management Studio. After I create the table and create a script of the table it shows that the default is there. I tested it by adding a dummy record and “AV” is filled into the Module field.This is the script to create the table:CREATE TABLE [dbo].[ICSMergeLock]( [CompanyID] [int] NOT NULL, [Module] [char](2) NOT NULL, CONSTRAINT [ICSMergeLock_PK] PRIMARY KEY CLUSTERED ( [CompanyID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[ICSMergeLock] ADD DEFAULT ((0)) FOR [CompanyID]GOALTER TABLE [dbo].[ICSMergeLock] ADD DEFAULT ('AV') FOR [Module]GOIn the project editor, I ADD CUSTOM TABLE SCHEMA for the table. In Edit Project Items, this is what the project is storing for this table:<Sql TableName="ICSMer
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.