Re: [Axapta-Knowledge-Village] delete_from vs loop delete

[Marko Salonen]

try-catch deadlock and retry?

On 1 September 2010 10:33, thomas 'znal' ramdhan wrote:

>
>
> Hi Burtt,
>
> Thanks for brief explanation :)
> I have declare all suitable index for my table, but sometimes still returns
> me lock error. If I use batch helpers, for sure I get more lock issue in
> activity monitor. If this is the case, is loop delete the righteous solution
> ?
>
> Thanks and Regards,
> Afin
>
>
>

Re: [Axapta-Knowledge-Village] I got a problem with employee form

[Marko Salonen]

You have added a relation between the tables, right?

On 5 August 2010 06:20, SUNEEL BABU  wrote:

>
>
> Hi,
> I got a problem with employee form.  i.e.,
> I want to add some fields to empltable. For this "I create a new table with
> the required fields along with emplid". And i attach the table as a
> datasource in the employee form. I put the fields in a new tab page.
> Now i create a new record in empltable but i am unable to insert values in
> to my new table. The fileds are disabled in the tab page. How can i activate
> the fields. I tried with create method. But it does't work.
>
> Please any one send me the solution ASAP
>

Re: [Axapta-Knowledge-Village]

[Marko Salonen]

Hi,

DISTINCT is, uh, tricky.
Start by checking this
out
.

--m

2008/8/21 joelwu <[EMAIL PROTECTED]>

>
>  Dear All:
>
> Anyone know how to do a select distinct in Dynamics AX, for exmple I have a
> table like this
>
> F1   F2   F3   F4   F5   F6   F7
> A   P-01   Ser   TTA   0   0   0
> A   P-01   Ser   TTA   0   65   65
> A   P-01   Ser   TTA   35   0   -35
> A   P-01   Spa   EOI   0   0   0
> A   P-01   Spa   EOI   26.01   0   -26.01
> A   P-02   Spa   Cab   0   0   0
> A   P-02   Spa   Cab   596.25   0   -596.25
> A   P   Sub   MLL   0   105   105
> A   P   Sub   MLL   0   5000   5000
>
> I want to get the unique field of F2, F3,F4 like the result bellow
>
> P-01   Ser   TTA
> P-01   Spa   EOI
> P-02   Spa   Cab
>  P   Sub   MLL
>
> How can I do this in AX??
>
> Joel
>
>
>

Re: [Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for?

[Marko Salonen]

Yeah, we all wish that MS would do things differently :)

Get a developer to do a new report? Shouldn't take too long.

--M

On 15/01/2008, James Flavell <[EMAIL PROTECTED]> wrote:
>
> Thanks
>
> I dont think its a bug (now I know what the report is doing)
>
> I beleive MS decided to hedge their bets that users will run the report
> for
> several items and dimensions rather than one.  So they decided to do ALL
> items in teh SQL statement regardless of what you select as this is better
> performance in SQL rather than issuing new SQL statement for each item.
>
> So if you run this report for ALL items it takes 10 mins in Ax4.0 but if
> you
> ran it in Ax3.0 it would take longer
> Whereas if you ran one item in AX4.0 it still takes 10 mins but in Ax3.0it
> takes less
> So its good and bad depending on how you are running the report
>
> Of course it would have been nice if MS made 2 versions (I mean the old
> version was already there so its not like they would have had that much
> extra work) so you could make a mnual decision which one to use
>
> I just wished MS had clearly stated the change somewhere then I would not
> wonder why the report takes so long and have to go read the code to find
> out
> (which a lot of users wont be able to do and so will live with the idea AX
> is crap because it takes 10 mins for 1 item to be printed)
>
> Hope I made sense
> Thanks
> James


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for?

[Marko Salonen]

Unfortunately I have no experience with said tables, but... are you running
the latest service pack and/or have you browsed Microsoft's hot fix list?
Sounds a bit like a bug to me.

--Marko

On 10/01/2008, James Flavell <[EMAIL PROTECTED]> wrote:
>
> Sorry for the many posts
>
> Okay it seems the 145,000 records are for ALL items and ALL warehouses (or
> all inventory dimensions you might have ticked to print) even though I
> only
> set teh filter as one item and one warehouse!
>
> I am not sure if it is a bug and it should have only created
> InventSumDateTrans for the one item but to me if you give me the option to
> filter that implies I can spee up my report by only printing the items I
> need...
>
> I guess 10 mins or so for ALL items is not so bad but I wish MS would have
> made it clear...I am sure every user under the sun would be complaing
> about
> having to wait 10 mintues to get only 1 item!
>
> Thanks
> James


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for?

[Marko Salonen]

Hi,

Check this out:
http://dynamicsmatters.blogspot.com/2007/05/dynamics-ax-base-data-model-part-ii.html

Another source says simply:

InventSumDateTable (On-hand inventory periodic header)
InventSumDateTrans (On-hand inventory periodic transactions)

--M

<http://schunk.dk/DocWeb4/Tables/InventSumDateTable.html>
On 10/01/2008, James Flavell <[EMAIL PROTECTED]> wrote:
>
> Yes very sure.
>
> I found they are used at least in the report Inventory Physical by
> dimension
> report so I would expect they are in any AX 4.0 system
>
> They have configuariotn key: LogisticsAdvanced
> and Securitykey: InventReports
>
> Not sure if they are 'tmep' tables used for the report or like InventSum
>
> The physical invenotry by dimension is VERY slow for me in Ax4.0...only 1
> item and 1 warehouse in the fitler in a report back dated 1 month with not
> transactions posted in that 1 month and it says 1 hour or more to do!
>
> Anyone aware of issues with these new tables or this inventory physical by
> dimension report in Ax 4.0? Its on SQL2000
>
> Thanks
> James
>
>
> James Flavell
>
> CITP Singapore Pte Ltd
>
>
>
> Mobile: +65 97582281
>
> Email: [EMAIL PROTECTED]
>
>
>   _
>
> From: Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of Jim Hummer
> Sent: Tuesday, January 08, 2008 12:11 PM
> To: axapta-knowledge-village@yahoogroups.com
> Subject: RE: [Axapta-Knowledge-Village] What are InventSumDateTable and
> InventSumDateTrans used for?
>
>
>
>
> Are you sure that these are DAX 4.0 tables? I couldn't find them in any
> DAX
> 4.0 db that I have.
>
>
>
> To: Axapta-Knowledge-
> <mailto:Axapta-Knowledge-Village%40yahoogroups.comFrom>
> [EMAIL PROTECTED]: [EMAIL PROTECTED]  djf1994%40gmail.comDate>
> comDate: Mon, 7 Jan 2008 18:52:03 +0400Subject: [Axapta-Knowledge-Village]
> What are InventSumDateTable and InventSumDateTrans used for?
>
> Sorry i am not sure whether I asked this before (but i guess even if I
> didthen there was no answer so its worth asking again)Can someone please
> tell me or give me any idea what the InventSumDateTableand
> InventSumDateTrans tables are used for in AX4.0?I looked at them and
> thought
> they were for the function of 'Posting periodicphysical' but even though I
> dont use that function they are gettingpopulated and i would like to be
> sure
> as anything around InventSum issomething that should be very clear about
> :)ThanksJames[Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
>
> Come and choose your preferred name for Microsoft Dynamics AX on the
> Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk
>
>
> Yahoo! Groups Links
>
>
>
>


-- 
Marko Salonen
[EMAIL PROTECTED]


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] Modifying lookups forms

[Marko Salonen]

On 06/02/07, Anil Ozay <[EMAIL PROTECTED]> wrote:
> Hi Marko,
>
> You can extend the SysTableLookup class. This class uses container to
store
> fieldId and returmItem values, to create a lookup grid.

Hello people. I've tested Anil's solution and it works great - I've yet to
go over the cross references for the class tho (update is s slow :) -
but one thing bother me with this,

Take a look at this SysTableLookup.buildGrid. Why is there a boolean named
"method" here, that is never given a value (except the default False), but
is still used in with the conpeek and  is even compared against running the
code.

Any takes on this?

> protected FormBuildGridControl buildGrid(FormBuildGridControl
> _formBuildGridControl,
>  FormBuildDataSource
> _formBuildDataSource)
> {
> FormBuildControlformBuildControl;
> Object  obj;
> boolean returnItem;
> boolean method;
> int fieldId;
> int i;
> int width;
> ;
>
>
> for (i = 1; i <= conlen(lookupItems); i++)
> {
> [fieldId, returnItem,width, method] = conpeek(lookupItems, i);
>
> if (!method)
> {
> formBuildControl =
> _formBuildGridControl.addDataField(_formBuildDataSource.id(), fieldId);
> if(width != 0)
> {
> obj = formBuildControl;
> obj.width(width);
> }
>
> if (i == 1 || returnItem)
>     {
> controlIdx = formBuildControl.id();
> lookupField = fieldId;
> }

 Regards,

 -- Marko Salonen


[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] Modifying lookups forms

[Marko Salonen]

Thank you Anil, this is just what I was after :)

I'm off to test this right away.

--Marko

On 06/02/07, Anil Ozay <[EMAIL PROTECTED]> wrote:
> Hi Marko,
>
> You can extend the SysTableLookup class. This class uses container to store
> fieldId and returmItem values, to create a lookup grid.

Re: [Axapta-Knowledge-Village] Modifying lookups forms

[Marko Salonen]

In 06/02/07, Amit Jain <[EMAIL PROTECTED]> wrote:
> Cant you do this, on your field ? Why do you want to change properties from
> lookup method?

On the field, where?

[Axapta-Knowledge-Village] Modifying lookups forms

[Marko Salonen]

Hello.

I've created a lookup form in 4.0 using Axeptapedia's code example
(http://www.axaptapedia.com/SysTableLookup_class). The lookup works
just fine, but is it possible to modify its properties, like column
widths or form height?

Regards,

-- Marko Salonen