Small hack.
If you modify table in Microsoft SQL Server Management Studio, it sometimes says something like
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be recreated o...
Hello everybody,
today I want to share how to implement master detail form step by step starting from small. So, recently I was in situation when I created form, generated DAC, created aspx page, and got some errors. When I asked support for help, they informed me that they will help me only one...
Hello everybody,
today I will share with you adventure of learning writing something for Trade Station from FXCM and some other trading companies.
I got one request from client to write for him expert advisor, and it should be for Trade Station in lua, and not in mql4.
I can't say that I was happ...
Hello everybody,
today I want to share how to cope with error message CreatedByID cannot be null and CreatedByScreenID cannot be null, and so on. In order to get rid of
those error messages use attributes [PXDBCreatedByID], [PXDBCreatedByScreenID],
[PXDBCreatedDateTime], [PXD...
Hello,
I want to share some discoveries about attributes of PXSplitContainer.
<px:PXSplitContainer runat="server" ID="sp1" SplitterPosition="300" Height="100px">
SplitterPosition="300" means that first item will have height 300 pixels
Height="100px" I didn't notice any changes at page,...
Hello everybody,
today just short notice of DAC and tables. If you create new functionality in Acumatica and look for creating tables, you should know, that all tables which you'll create should have column CompnayID, and that column shouldn't be reflected in DAC.
4 Comments
anonymous sa...
Hello everybody,
today I received the following error message in Acumatica:
Cannot insert explicit value for identity column in table when identity_insert is set to off.
After executing SQL
SET IDENTITY_INSERT table off
problem wasn't solved, so I needed to search deeper. After attaching with SQL...
Hello everybody,
today I want to share with you one of my mistakes.
Few days ago I started to develop Configuration screen, or screen which should end at xx101000. After I completed it and passed for testing I faced a challenge. The page should display only the first record. So I implemente...
Hello everybody,
today I want to share one nesessary step which is needed for graph in order to save graph which has more then one DAC ( data access class ).
In my case I have DAC PRPayRoll, which is joined with classes PRPayrollDetails, PRPaySlip, PRTran.
In that case it is needed to m...
Hello everybody.
Today I want to share how to deal with Acumatica error message
undefined: Cannot read property "length" of undefined.
If you face it, you need to know that some members of your DAC need attribute either PXInt or PXDbInt or something similar.
One more detail, DAC should have...