Hello everybody.
I want to share if you need to execute stored procedure in Acumatica how to achieve it.
It's simple.
1. Create Stored procedure in db.
2. Use in your code PXDatabase.Execute.
For example let's say you created stored procedure which has name DeletePrTranByPrPayroll...
Just small search result.
Row persiting event declares as following:
protected virtual void YourDACClasss_RowPersisting(PXCache cache, PXRowPersistingEventArgs e)
{
}
Ready to take your Acumatica development to the next level? If you’re looking to custo...
Hello,
today I want to note how to create new instance of Graph. Lets say you need to create instance of graph PRPaySlipManager.
In that case you can get instance of that graph in the following way:
PRPaySlipManager manager = PXGraph.CreateInstance<PRPaySlipManager>();
Ready to take your Ac...
Hello everybody,
I want to share how to fight with error:
Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
Today I wanted to move Acumatica to SQL Azure and faced that error message. After research I found that I have to remove the two "ON [PRIMARY]" pa...
Hello everybody,
I want to share what is purpose of field TStamp in database for tables in Acumatica. In reality you can make projects without it, but. If you add it, you'll help Acumatica with concurency management
Ready to take your Acumatica experience to the next level? Just as the TSt...
The Structure of a Strategy Program in LUA
Thursday, July 24, 2014 1:07:00 PM
Hi all,
I continue investiaging another area of knowledge of humankind, which is FXCM trading Station.
So, if you need to write strategy, you'll need following methods to be defined in your strategy:
Init()
Pre...
Hello everybody,
now I want to share with you difference between RowInserting and RowInserted events.
The RowInserting event happens before the new data record is actually inserted into the cache but after all field events happen for this data record. The RowInserted event happens after the actua...
Hello everybody,
Imagine that you crated in your page Grid, and when opened it at page can't notice buttons Refresh Add Row, Delete Row, Fit To Screen in Grid. I believe it can be puzzling how to add those buttons to screen as it was for me at once. Add to your grid following line:
&nb...
Hello everybody,
today just quick fact. In master-detail DAC and Graph there are used attributes PXDBDefault and PXParent. For me it was interesting to know, that PXDBDefault is intended for initializing values and PXParent is intended for cascade deleting of rows.
Ready to take your Acuma...
Hello everybody.
In case if you want to add some table to Acumatica with compnayid field, and suddenly you can't save it, check weather you configured default Value or Binding in db. It should be ((0)) like on the screenshot:
I noticed it only recently while coping with error message about...