Hi All;
Assume that i have 4 fields on index index1 and i will run a select that i know
3 of the fields in index1. Shall i use index hint index1 in select or not?
Thanks.
Yahoo! Groups Sponsor ~--
Help Sudanese refugees rebuild their lives
in the field order of the index?
i.e. if an index has fields 1,2,3,4
which value are you looking for?
Further, i think index hint has gone out of fashion with SP2 or SP3, I am not
sure but give me some time to find out.
regards
harry
Cenk Ince [EMAIL PROTECTED] wrote:
Hi All
Hi all;
I have a problem with SQL 2000. When i run Axapta i can't use more ram than
1,826,000 MB. I thougth that it was because it is Standard Edition. Then i
created a test env. and Setup an Enterprise SQL 2000. But i can't still use
more than 1,826,000 MB ram.
Is there a solution for this.
Hi all;
I have some performance problems about MUIC and there is a hotfix (HF25_004)
for that. I wonder if this hotfix is for SP3 or SP4.
Thanks.
Yahoo! Groups Sponsor ~--
Put more honey in your pocket. (money matters made easy).
Hi Ali
it's something like that.
static void aaa(Args _args)
{
SysExcelApplication sysExcelApplication;
SysExcelWorkbooks sysExcelWorkbooks;
SysExcelWorkbooksysExcelWorkbook;
SysExcelWorksheets sysExcelWorksheets;
SysExcelWorksheet sheet_org;
Hi all;
Are security settings for user groups keeped in dat company, or in a file in
application?
Thanks.
Yahoo! Groups Sponsor ~--
font face=arial size=-1a
: Tip: How to find out where that error message comes from
This should help you to figure out what your error is.
Best regards,
Helmut
http://axaptafreak.blogspot.com
--- In Axapta-Knowledge-Village@yahoogroups.com, Cenk Ince
[EMAIL PROTECTED] wrote:
Hi all;
We try to post a ledger journal
Hi all
SysDataBaseLog table increased so much that it reached 9 GB :( So i want to
delete this log. But it doesn't clear it very quickly with standard of Axapta.
Is it good to drop table from Sql Server? Or is there a way to do it from
Axapta? Is this a suitable method to do this?
Thanks.
Hi;
Is where a big performans difference between windows 2000 and windows 2003?
Thanks.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email
Hi all;
When i rename purchid of a PO it doesn't rename it. But for other primary keys
like Salesid or itemid it works well. Second when i do this operation with
partner license it works for purchid to. I doesn't work for our customer
license.
Does anybody know how to solve this problem why
Hi Hennie;
Yes they are temp tables, but there is reference for those tables on
custinvoicejour on field PARMID.
You can use these tables to keep some data to show on invoices. So if you want
to see invoice printout and show data from this table, then there will be no
data, if you delete it.
inventTrans.Qty returns value :)
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: setiaji
kurniawan
Gönderilmiş: Çar 13.07.2005 12:30
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: [Axapta-Knowledge-Village] Select statement
Hi all;
When i try to close some transactions on vendTransOpen, it doesn't allow me
reamrk and shows a redhand icon. I see that there are some records in
SpecTrans that makes it.
How to solve this problem.
Thanks.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your
Hi all;
When we run MUIC it's sometimes locked for hours. So we restart and it
continues.
Why can this happen? How to solve this problem.
Thanks.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
Hi all;
For a group of item we didn't use inventSerialid until now. But now we need to
activate serialid.
Will it create any problem for us? If it creates problem how can we solve?
Thanks.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
: Cenk Ince
Gönderilmiş: Per 07.07.2005 13:58
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: BomPartOF i can't add range with code
Hi all;
On BomPartOf form i open form Query and and on datasource Bom i rigth clicked
and select N:1 then select bomversion table. When i add range as active
Hi all;
I need to report some data from lots of tables and cannot join them, so i
started to use temp tables, and it works fine now. But i wonder if this is the
rigth way for performans and axapta?
Thansk.
Yahoo! Groups Sponsor ~--
Has
reports from axapta. It works properly.
Fatih ztrk
Boehringer Ingelheim
[EMAIL PROTECTED]
-Original Message-
From: Cenk Ince [mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince
Sent: 01 Haziran 2005 aramba 10:38
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: TempTable usage
Hi all;
when i Update a prodOrder from CostEstimated to Started it locks the system
\classes\ReqTransUpdate\update.
There is a loop while (inventSumLogTTS.RecId) it created an endless loop.
Any Idea?
Thanks
Kimden: development-axapta@yahoogroups.com
Hi all;
We have 2 company ntr and spk. When i post a salespackingslip in spk, i want
to post purchpackingslip in ntr.
I wrote a job below, it works in ntr company without redlines, when i run it
in spk company with redlines it doesn't work.
Why can it be?
In class purchformletter\run
Classes\CustVendVoucher\setTransactionTxt
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kiinin yerine: Stefan
Heidkamp
Gnderilmi: Cum 29.04.2005 09:50
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: [Axapta-Knowledge-Village] Transaction text
Hi all
Hi all
On form inventtable i refresh itemid but it doesn't refresh inventtablemodule
datasources.
Is this a bug?
Thansk
Cenk Ince
Yahoo! Groups Sponsor ~--
What would our lives be like without music, dance, and theater?
Donate or volunteer
Hi all
I need to close salesline which RemainSalesPhysical0 and won't be send to
customer. But i can't close it when invoicing. So i need to close it later. How
can i do this? Is there a functionality for this or how can i code it. I want
this salesline not to be used in master planning.
.
--- In Axapta-Knowledge-Village@yahoogroups.com, Cenk Ince
[EMAIL PROTECTED] wrote:
Hi all
I need to close salesline which RemainSalesPhysical0 and won't be
send to customer. But i can't close it when invoicing. So i need to
close it later. How can i do this? Is there a functionality
-Knowledge-Village@yahoogroups.com
Konu: Re: YNT: [Axapta-Knowledge-Village] SalesId Adjustment
hi Cenk
Thats because it extends num. Did u blank out the
extends property?
regards
harry
--- Cenk Ince [EMAIL PROTECTED] wrote:
Because adjustment on SalesIdBase is disabled
create Num2? Why not just change salesIdbase?
regards
harry
Cenk Ince [EMAIL PROTECTED] wrote:
Hi all
I want to change the adjustment of salesid to left.
I will duplicate Num as Num2 and make Num2 adjustment left, salesIdBase
will extend num2.
I
Hi all
I want to change the adjustment of salesid to left.
I will duplicate Num as Num2 and make Num2 adjustment left, salesIdBase will
extend num2.
I wonder if it will create a problem? or is it just view?
Thanks.
Yahoo! Groups Sponsor ~--
In
Hi all;
Code below doesn't work? I think, it tries to choose line but no line choosen
in purchparmline table?
Any Help?? Thanks..
static void PurchPost(Args _args)
{
salesTable st;
SalesLine sl,int_sl;
SalesTable int_st;
PurchTable p;
PurchLine pl;
Hi all;
I added a new field on inventtrans and want to update it from packingslips and
production, and inventjournals. Shortly on all physical trans tables i added a
new field and i want to copy it to inventtans on all movements.
How can i do this thanks.
Yahoo!
Hi All;
Code below invoices one salesorder, i want to invoice more then 1 sales order
once.
How can i do this? Thanks.
SalesFormLetter_Invoice salesFormLetter =
salesFormLetter::construct(DocumentStatus::Invoice);
SalesTable _salesTable;
;
_salesTable =
Hi all
My customer wants users not to see other inventlocations(and inventonhand when they select location) that they have no relation.
For ex. User1 works for inventlocation il1, he won't see il2 and il3. I tried to make record level sec. but i couldn't make because that table doesn't viewed
Hi all
I want to learn the difference between serial and batch number. Which is used
when?
Thanks.
Yahoo! Groups Sponsor ~--
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for
Hi all,
My clients connects with Aos and run pba with a lot of variables. And as normal
PBA doesn't work very fast. But when i change some performance setup on windows
it gets to much more slow than normal. Is there anybody who had the same
problem and is there a best setup for
Hi all;
I see some negative recids in my database. Is it normal?
Thanks.
Yahoo! Groups Sponsor ~--
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
hi all
How can i make report run with clean query? I mean last previous selections
will not be showed every time.
Thanks.
Yahoo! Groups Sponsor ~--
Has someone you know been affected by illness or disease?
Network for Good is THE place to
));
The sad thing is that you have to do this for every field.
Steeve...
-Message d'origine-
De : Cenk Ince [mailto:[EMAIL PROTECTED]
Envoy : 11 fvrier 2005 08:21
: Axapta-Knowledge-Village@yahoogroups.com
Objet : used query instead of Previously used query
hi all
How can i make
to pass (date - 1) has parameter.
Regards,
Steeve...
-Message d'origine-
De : Cenk Ince [mailto:[EMAIL PROTECTED]
Envoy : 11 fvrier 2005 02:30
: Axapta-Knowledge-Village@yahoogroups.com
Objet : YNT: [Axapta-Knowledge-Village] RE : How can i find the real invent
quantity on time t
::newParameters(myDate, myItemId, inventDim, inventDimParm);
Here the method will only take care of the ItemId you pass (myItemId) and the
InventLocationId stored in inventDim record (the parameter).
Regards,
Steeve...
-Message d'origine-
De : Cenk Ince [mailto:[EMAIL PROTECTED]
Envoy : 11
Hi all
I just want to find item quantity on a given date and inventLocation.
How can i find it.
Thanks.
Yahoo! Groups Sponsor ~--
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network
-
De : Cenk Ince [mailto:[EMAIL PROTECTED]
Envoy : 10 fvrier 2005 09:07
: Axapta-Knowledge-Village@yahoogroups.com
Objet : How can i find the real invent quantity on time t
Hi all
I just want to find item quantity on a given date and inventLocation.
How can i find it.
Thanks.
Sharing
: Tuesday, February 01, 2005 9:01 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Strange Layer problem
have you compiled your application after installing the dis/dip-layers?
Cenk Ince schrieb:
Hi all
I have a problem on layers, Class LedgerVoucherObject
Hi all
I have a problem on layers, Class LedgerVoucherObject is in dip layer and when
i post packingslip on salesorder, i get error because it can't run code below.
transDateTotals returns null;
transDateTotals = new RecordSortedList(tableNum(LedgerTrans));
when , put a Enter after this code
Hi all
I want to use markuptrans with AmountCur 0 zero. It craetes voucher but the
value AmountCur is 0.
Does it make any problem for or axapta, because for some reason i will insert
hundreds of these markuptrans records every month.
Thanks.
Yahoo! Groups
. The opinions expressed are not necessarily those of
CGNZ.
CGNZ accepts no liability for any loss, damage or consequence, whether caused
by our own negligence or not, resulting directly or indirectly from the use of
this email and attachments.
From: Cenk Ince [mailto
Hi all;
I make some modificationas on prodtable. I have 2 PO and i want to make them 1
PO if they have same route, same itemid and same bom.
But when i make union them with code below i lose inventtrans references. How
can i keep references?
Thanks
void UnionPO(ProdId ProdIdMain,ProdId
Hi all;
I need intercompany setup doc.
Thanks.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of
();
sl.update();
What is wrong in my code?
Kimden: Cenk Ince [mailto:[EMAIL PROTECTED]
Gnderilmi: Paz 02.01.2005 19:14
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: Markuptrans voucher error, because of rounding
I create a markup trans for a salesline
Dear Sarosa
Thanks you.
Kimden: Aji Sarosa [mailto:[EMAIL PROTECTED]
Gnderilmi: ar 29.12.2004 05:05
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: Re: I Miss Something - [Axapta-Knowledge-Village] [Urgent] I can't insert
MarkupTrans with code
Hi all;
I try to insert markuptrans, there are 3 markupCodes, for 1 of them i can
insert markuptrans, but for 2 others i can't insert it,
All setup for 3 of markupcodes are the same.
i get error : Cannot create a record in Misc. charges transactions
(MarkupTrans). Misc. charges code: Klise,
Hi all
Im trying to entegrate a barcode
for salesline.
Beforee i begin this, i was thinking that
when i read barcode, all information (itemid-inventdim ect...) on itembarcode
description would be filled in.
But nothing happens. Do i miss anything.
Thanks..
Cenk NCE
Hi all
Is there a code example for Running a job
from .net or vb 6.0.
Which com can i use?
Thanks.
Cenk
NCE
ERPTeknik
Danman (Microsoft Axapta)
ERPTechnical
Consultant(Microsoft Axapta)
Data Sistem Genel Otomasyon Sanayi ve
Ticaret A.S
- Original Message -
From: Cenk Ince mailto:[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 10:59 PM
Subject: [Axapta-Knowledge-Village] packing slip error
Hi all
I get error
Hi all
I get error when i post
purchorder as packingslip.
Physical updating
quantity in the inventory unit '' must be other than zero
Under-delivery of
line is 100,00 percent, but the allowed under-delivery is only 0,00
percent.
I create the purchline
with code and i think
Hi all
I want to create
purchline by code but i get error, Inventory Dimension 'Size' is an item
dimension and must consequently be spesified.
How can i give the
default values for these dimension fields, and then let users to change it.
Thanks in advance.
Cenk
NCE
54 matches
Mail list logo