Loading ...

How To Block Column In Acumatica Grid Or One Value In Column

Hello, I want to share with you how to block some columns in Acumatica. You can do it with the PXUIFieldAttribute.SetEnabled method. Let's say you have DAC PRTran with column earningType and values of PRTran you get from PaySlipDetails view. Then you can block whole column wit...

Current Items In View

Hello everybody, today I want to share with everybody how to find all items in view in Acumatica. Suppose you have View declared in the following way: public PXSelectJoin<PRPayrollDetails, InnerJoin<EPEmployee, On<EPEmployee.bAccountID, Equal<PRPayrollDetails.employeeID>>, Inn...

Create New Record In Acumatica Or Which Insert Works Faster

Hello everybody, today I want to share results of my investigations of two similar pieces of functionality in Acumatica. Have you ever wondered which Insert in cache works faster this: a) var temp = (PRPayrollDetails)PayRollsDetails.Cache.Insert(); or this: b)          va...

How To Read From Stored Procedure In Acumatica

Hello readers, today I want to share hwo it is possible to read from stored procedure in Acumatica. Keep in mind, that reading from sp is against best practices of Acumatica, because if you read from sp, then you'll reading will not be cached and other side effects, but sometime you don't have a...

Get Extension Of Basic Dac Class In Acumatica

Helllo, today I want to share how to get extension of basic DAC class iin Acumatica. Lets say you have class ARTran, and extenstion for it ARTranExt and you want to get it in the code of ARTran_RowUpdated event Then you can get extenstion in the following way:        prot...

How To Get Companyid In Acumatica

Hello everybody, today I want to share how to find current company id in Acumatica: Here it is: int? companyid = PX.Common.PXContext.GetSlot<Int32?>("singleCompanyID")   for me it was long way to find it   Ready to take your Acumatica experience to the next level? If you’ve been s...

Enumerate Cached Objects

Hello everybody, today I want to share how to enumerate cahed objects according to some type.  Imagine you have following declaration: public PXSelectJoin<PRTran> PaySlipDetails; And that you need to enumerate them as list of PRTran's in some special way. In my case I used following in...

Rename Column At Screen In Acumatica

Hello everybody, today I want to share answer at simple question how to change the caption at some screen.  For example you want to change caption at screen AR202000 for Inventory ID to caption INVENTORY ID. For this purpose we need to understand which DAC is responsible for Grid. For this p...

FieldUpdated Behaviour

Hello everybody, today  I want to share one interesting feature of Acumatica.  I revelaed that after inserting of new row executes FieldUpdated even if feld wasn't updated. After reading documentation I found that it is gotcha and inteded to be so. Discover the power of customizati...