Hi Jay,
Maybe you can do it like this:
While select ItemId, GroupId, Qty, amount From InventTransJournal
where GroupId == 'CH254'
{
if (amount < 0)
temp.amount = abs(amount);
else
temp.amount = -1 * amount;
temp.insert();
}
with kind regards,
Pascal
Jay Sathasivam
<[EMAIL PROTECTED]
o.com> To
[EMAIL PROTECTED]
21-04-2004 00:35 cc
Subject
Please respond to Re: [development-axapta] Re: How to
development-axapt Insert record
[EMAIL PROTECTED]
Hi Pascal and Claudia
Thanks for that but my problem is
I have a temp table and 1000 records of InventTransJournal table
in the InventTransJournal I have + Amount and - Amount so
If I do this way it is not working
Insert_recordset Temp(ItemId, GroupID, Qty, Amount)
Select ItemId, GroupId, Qty, -1 * Amount From InventTransJournal
where GroupId == 'CH254';
Note :-
I am not inserting 1 record. also If it is (+) then I have to Update (-)
amount and If (-) then I have to update (+) Amount.
Regards
Jay
Pascal Dutour Geerling <[EMAIL PROTECTED]> wrote:
Hi Jay,
You can also use the function abs(-amount) this will return a positive
amount.
(see system documentation --> functions)
with kind regards,
Pascal
Claudia G�ries
<[EMAIL PROTECTED]
.de> To
[EMAIL PROTECTED]
20-04-2004 14:26 cc
Subject
Please respond to [development-axapta] Re: How to
development-axapt Insert record
[EMAIL PROTECTED]
Hi Jay,
tempTable.amount = InventJournalTrans.Amount * -1;
tempTable.insert();
cu
Claudia
--- In [EMAIL PROTECTED], Jay Sathasivam
<[EMAIL PROTECTED]> wrote:
>
> Hi Guys
>
>
>
> I want to Insert into temp table some records from
InventJournalTrans there I have
>
> (-) amount so how can I Insert the amount as (+) .
>
>
>
> Regards
>
> Jay
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Photos: High-quality 4x6 digital prints for 25�
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25�
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
