[Axapta-Knowledge-Village] Index usage
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 through GlobalGiving. http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] Index usage
Hi Harry I look for all record and all fields of the records. I just wonder should i create index for situation (for ex fileds1,2,4 3 is missing) or can i use a index that has some fileds that i know the values. This is a generic question but to give an example, inventTrans table has some indexes on it. But when i create a select sentence for most records in table, i can't find an index that has fields itemid and dateFinancial. So i can't decide to use itemidX or OpenItemidx. They both have itemid., Hope i could explain problem. Thanks a lot. Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Harry (Harshawardhan Deshpande Gönderilmiş: Sal 06.09.2005 18:12 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] Index usage hi Cenk the missing field value... where does it stand 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; 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. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS *Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. *To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through GlobalGiving. http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] SQL Ram Usage
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. Thanks. Yahoo! Groups Sponsor ~-- Help Sudanese refugees rebuild their lives through GlobalGiving. http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Hot fix : HF25_004 is for which version is it?
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). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
YNT: [Axapta-Knowledge-Village] writing an info into a certain cell in exisiting excel file
Hi Ali
it's something like that.
static void aaa(Args _args)
{
SysExcelApplication sysExcelApplication;
SysExcelWorkbooks sysExcelWorkbooks;
SysExcelWorkbooksysExcelWorkbook;
SysExcelWorksheets sysExcelWorksheets;
SysExcelWorksheet sheet_org;
SysExcelWorksheet sheet_new;
SysExcelCells cells;
SysExcelCell_XP cell;
;
try
{
sysExcelApplication = SysExcelApplication::construct();
//sysExcelApplication.visible(true);
sysExcelWorkbooks = sysExcelApplication.workbooks();
sysExcelWorkbooks.open(C:\\Documents and
Settings\\spark\\Desktop\\aaa.xls);
sysExcelWorkbook = sysExcelWorkbooks.item(1);
sysExcelWorksheets = sysExcelWorkbook.worksheets();
sheet_new = sysExcelWorksheets.itemFromNum(1);
cells = sheet_new.cells();
cell = cells.item(9,1);
info(cell.value().bStr());
sysExcelWorkbooks.close();
}
catch(Exception::Error)
{
sysExcelWorkbooks.close();
}
}
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Ali KESKIN
Gönderilmiş: Per 25.08.2005 15:49
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: [Axapta-Knowledge-Village] writing an info into a certain cell in
exisiting excel file
Hi All,
I want to write a text into a certain cell in an existing Excel file. Is it
possible? How can I do?
Thanks in advance for your helps.
Ali KESKIN
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
*Visit your group Axapta-Knowledge-Village
http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web.
*To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
*Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
http://docs.yahoo.com/info/terms/ .
Yahoo! Groups Sponsor ~--
font face=arial size=-1a
href=http://us.ard.yahoo.com/SIG=12hptg1bt/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1125012393/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org
Put more honey in your pocket. (money matters made easy) Welcome to the Sweet
Life - brought to you by One Economy/a./font
~-
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 Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
winmail.dat
[Axapta-Knowledge-Village] Security Seetings for User Groups
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 href=http://us.ard.yahoo.com/SIG=12hc9scc6/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123683619/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] Re: [Urgent] Cannot Post Ledger Journal
I found error, I just can't understand why it happens. Error exists on method : Classes/LedgerVoucher/Post Line 78 : LedgerTrans.write(); Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: hwimmer Gönderilmiş: Per 28.07.2005 12:39 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] Re: [Urgent] Cannot Post Ledger Journal Hi Cenk! Cannot help you with your exact problem, but if you want to find out where this error message is thrown, take a look at: http://axaptafreak.blogspot.com and read: 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, and we get error : Cannot create a record in Ledger transactions (LedgerTrans). Voucher: MF002551, 31/05/2005. The record already exists.. When i look in LedgerTrans table, there is no data like this. How can i solve this problem. That topic is really very Urgent for me!!! Thanks a lot. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS *Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. *To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] [Urgnet] SysDataBaseLog drop from Sql
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. 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] 2000 vs 2003 does performans differs?
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 to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] [Urgent] Rename Primary Key doesn't work for purchase order
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 can it happen? 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
YNT: [Axapta-Knowledge-Village] SalesParmTable, SalesParmSubTable, SalesParmLine SalesParmUpdate tables
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. Cenk Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Hennie Potgieter Gönderilmiş: Per 14.07.2005 13:48 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] SalesParmTable, SalesParmSubTable, SalesParmLine SalesParmUpdate tables Hi, Can anyone please tell me what the purpose of this tables are? The way I understood it is that it is tables that temporarily keep data for the purpose of posting sales orders. Once posted to the GL, they wont ever be referenced again. Is this assumption correct? Can I safely purge old data from this tables once posted to the GL? (We do have Delete Order after Invoicing selected in Sales Ledger parameters causing Axapta to purge SalesTable and SalesLine once posted) Thanx in anticipation Hennie -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS *Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. *To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] Select statement
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 Guys,anyone can help me? select sum(Qty) from InventTrans where InventTrans.DatePhysical _startDate ; where can i get the value from the line above ? Refer to the Help Documentation, the value is in the field Qty in InventTrans tabel.But i cant get it. Is there any clue i can use to get the value from the line above? -- Best regards, setiaji mailto:[EMAIL PROTECTED] Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS *Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. *To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] SpecTrans for shows RedHand for VendTransOpen
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 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] [Urgent] MUIC table lock
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: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] [Urgent] inventSerialid activatation after using item.
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: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] YNT: BomPartOF i can't add range with code
This method is init of Bom datasource. My code is in red, I don't create query.
Thanks.
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Özgür Genç
Gönderilmiş: Per 07.07.2005 14:21
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: [Axapta-Knowledge-Village] YNT: BomPartOF i can't add range with code
This is because you create new query.. It will not work. do not create new
query.. First take the query from the system and then add a range.. And try to
do that not in the init method of the form, in the init method of the
datasource.
Best regards.
Mehmet Özgür Genç
Team Leader, Lead Developer
Tel : +90 212 283 91 23 / 2042
Mobile: +90 533 225 93 05
http://www.veripark.com
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: 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 on
bomversion i only see boms that has active bomversion.
But when i add code below i can't have the same result why?
Thanks.
void init()
{
Query q;
QueryBuildDataSourceqB;
QueryBuildDataSource qds;
QueryBuildRange qbr;
super();
q = new Query();
qB = q.addDataSource(tablenum(BOM));
criteriaBOMItemId = qB.addRange(fieldnum(BOM,itemId));
criteriaBOMFromDate = qB.addRange(fieldnum(BOM,fromDate));
criteriaBOMToDate1 = qB.addRange(fieldnum(BOM,toDate));
criteriaBOMToDate2 = qB.addRange(fieldnum(BOM,toDate));
qds = qb.addDataSource(tablenum(BomVersion));
qds.addRange(fieldnum(BomVersion,active)).value(enum2str(Noyes::Yes));
qds.joinMode(JoinMode::ExistsJoin);
qds.relations(true);
BOM_ds.query(q);
}
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
*Visit your group Axapta-Knowledge-Village
http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web.
*To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
*Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
http://docs.yahoo.com/info/terms/ .
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 Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
winmail.dat
[Axapta-Knowledge-Village] TempTable usage
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 someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] RE: TempTable usage
Thanks... Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kiinin yerine: [EMAIL PROTECTED] Gnderilmi: ar 01.06.2005 10:48 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE: TempTable usage We are also using same way to get 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; 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. Sharing the knowledge on Axapta. 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] [very urgent] inventSumTTSLog
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 bu kiinin yerine: DouglasT Gnderilmi: ar 25.05.2005 12:47 Kime: development-axapta@yahoogroups.com Konu: Re: [development-axapta] splash screen Maybe check bitmap resource 7511 within executable ax32.exe ?? It's technically possible to change this using an resource editor, but I don't know if it's legally allowed. One really interesting case which requires you to change this resource (replace this with an empty bitmap) is the following: If you want to speed up launching the Axapta client runnung under an rdp or ica session on an Terminalserver/Citrixserver you can write a small PreAxapta Launcher application which detects if the current session is runniung on rdp/ica. In that case the modified Ax32.Exe is launched with all the parms passed to PreLauch application. regards Douglas Hi! Does anybody know if it's possible to change the image that appears when you launch axapta? I've looked in the AOT's resources and in the application files without success. Any suggestions? Thank you very very much Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] [development-axapta] Auto posting for purch packing slip doesn't work when it is in changecompany{}
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 method, there is a while, it ntr company it gets
into while, but in spk(with red lines) it doesn't get into while.
while (Query.next())
static void defterenakil(Args _args)
{
PurchTable p;
PurchFormLetter_Invoice purchFormLetter =
PurchFormLetter::construct(DocumentStatus::PackingSlip);
;
changecompany(ntr)
{
select p where p.PurchId == 0342_056;
purchFormLetter.update(p,A-114663,systemDateGet(),PurchUpdate::All,AccountOrder::None,NoYes::No,NoYes::Yes);
}
}
Thanks..
Cenk ÝNCE
Yahoo! Groups Sponsor ~--
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-
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 Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
YNT: [Axapta-Knowledge-Village] Transaction text
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 we want to change %4, %5 and %6 - reserved for user adjustments - in the transaction text. Where can we make this change in the system? We have search also under classes without success. Can anybody give us a tip? Thanks in advance. Best regards Stefan Heidkamp 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] inventtableModule doesn't refresh on inventtable when i rename itemid
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 in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] Closing SalesLine
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. Thanks Cenk nce Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] Re: Closing SalesLine
Thanks. That solved my problem. :) Kimden: jaykay_nl [mailto:[EMAIL PROTECTED] Gnderilmi: ar 13.04.2005 16:19 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] Re: Closing SalesLine This depends where you are in the process. Are the goods picked yes or no. If picked, then the picking should first be reversed: SalesOrderLine/Inventory/Pick, mark picked line and post transaction (Status will change to not picked. Continue with next step). If not picked, then: Functions/Deliver remainder/Cancel quantity. Regards. --- 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 for this or how can i code it. I want this salesline not to be used in master planning. Thanks Cenk Ynce 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: YNT: [Axapta-Knowledge-Village] SalesId Adjustment
Hi Harry I know it. I just don't want to lose any inheritance that comes from num. So i copy num as num2 and change adjustment only. Thanks Harry Kimden: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED] Gnderilmi: ar 06.04.2005 13:05 Kime: Axapta-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. Kimden: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED] Gnderilmi?: ar 06.04.2005 00:18 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] SalesId Adjustment hi Cenk Why 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 wonder if it will create a problem? or is it just view? Thanks. Sharing the knowledge on Axapta. Do you Yahoo!? Take Yahoo! Mail with you! http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/maildemo Get it on your mobile phone. 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] SalesId Adjustment
Because adjustment on SalesIdBase is disabled. Kimden: Harry (Harshawardhan Deshpande [mailto:[EMAIL PROTECTED] Gnderilmi: ar 06.04.2005 00:18 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: Re: [Axapta-Knowledge-Village] SalesId Adjustment hi Cenk Why 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 wonder if it will create a problem? or is it just view? Thanks. Sharing the knowledge on Axapta. Do you Yahoo!? Take Yahoo! Mail with you! http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/maildemo Get it on your mobile phone. 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] SalesId Adjustment
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 low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] Auto Posting Purch order doesn't work (Urgent)
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;
PurchFormLetter_PackingSlip purchFormLetter =
purchFormLetter::construct(DocumentStatus::PackingSlip);
;
Select p where p.PurchId like 0058_056;
if(p)
{
purchFormLetter.update(p,,systemDateGet(),PurchUpdate::All,AccountOrder::None,NoYes::No,NoYes::No);
}
}
Yahoo! Groups Sponsor ~--
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-
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 Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
winmail.dat
[Axapta-Knowledge-Village] new field to inventTrans how to fill?
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! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] invoicing more than one sales order once
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 = salesTable::find(1000); salesFormLetter.update(_salesTable,systemDateGet(),SalesUpdate::All,AccountOrder::None,NoYes::No,NoYes::Yes); Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] Record level Security for inventDim
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 in all table list(because it has no conf. key). Should i define a sec. and conf. key for this table and make it possible to define record level security. Thanks.__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Serial or batch number
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 Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] Axapta runs slowly when windows xp performance and appearance setup change!!!
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 mycomputer\properties\advanced\settings and desktop\rigth click\properties\appearance\effects\. 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 Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] Negative recid
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! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] used query instead of Previously used query
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 support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] RE : used query instead of Previously used query
Hi Steeve That doesn't work. But i found solution. If you override function saveUserSetup on query of report, it stops writing syslastvalue. Thank you for answer. Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi: Cum 11.02.2005 16:00 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE : used query instead of Previously used query You probably already thought about this one but... You could use this : element.query().dataSourceTable(tableNum(TheTable)).clearRange(fieldNum(TheTable, TheField)); 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 report run with clean query? I mean last previous selections will not be showed every time. Thanks. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129pmb8ni/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108216815/A=2532114/R=2/SIG=12kb9kead/*http://clk.atdmt.com/NFX/go/yhxxxnfx002014nfx/direct/01/time=1108130415041145 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t
Thank you Steeve Last question about it : Haw can i find inventDimParm? I can't find it in salesline for example? Best Regards Steeve... Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi: Cum 11.02.2005 15:43 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Actually InventSumDateDim (and other InventSumDate*) DOES NOT give sum of transactions on a date, it really give the qty of an item at a given date. What it does is that it takes the current qty (in InventSum) and roll back to the date (parameter) using the transactions to know what was the inventory qty at that date. Go ahead and try it. ;-) IIRC, InventSumDate will give the qty at the end the day so if you want to know the qty at the beginning of the day you'll probably have 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 Thansk Steeve Probably i asked my question not a clear way. InventSumDateDim gives the sum of transactions on a date, but i want to calculate qty, at the beginning of date, means sum of transactions before given date. Thanks. Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi: Per 10.02.2005 18:56 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Use method InventSumDateDim::newParameters(). BUT! (Take a deep breath) If you have SP3 and happen to cancel production lines from time to time, make sure those fixs are installed otherwise you may get erroneous results: (I got from MBS) CH_421871 CH_421566_1947 The following is not MBS official but that's what I end up adding to make everything work ok. I ask my VAR to ask MBS about those changes and validate that they are needed, but it's taking forever. I've tested it and they are now in production and its fine. Anyway it's only for report. + After that you will have to change line 15 of InventSumDateValueReport::selectInventTransPostingPhysical() to : group by statusIssue,statusReceipt,packingslipreturned,dateInvent and line 17 InventSumDateDim:: selectInventTransPostingPhysical () to : group by statusIssue,statusReceipt,packingslipReturned For more info about all this mess see discussion 11147 on technet. Steeve... -Message d'origine- 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 the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129nkp1bc/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108141014/A=2532114/R=2/SIG=12kmnkgnn/*http:/clk.atdmt.com/NFX/go/yhxxxnfx002014nfx/direct/01/time=1108054614302338 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=1294s20ck/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108215910/A=2532114/R=2/SIG=12khb3qm9/*http://clk.atdmt.com/NFX/go/yhxxxnfx002014nfx/direct/01/time=1108129510018306 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- 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
YNT: RE : RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t
Thanks for the fifth time for today() :) Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi: Cum 11.02.2005 16:42 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: RE : RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t You dont' find inventDimParm, you build it. It tell InventSumDateDim what parameter to take from inventDim record. inventDimParm inventDimParm; inventDimParm.ItemIdFlag= true; inventDimParm.InventLocationIdFlag = true; InventSumDateDim::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 fvrier 2005 09:25 : Axapta-Knowledge-Village@yahoogroups.com Objet : YNT: RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Thank you Steeve Last question about it : Haw can i find inventDimParm? I can't find it in salesline for example? Best Regards Steeve... Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi?: Cum 11.02.2005 15:43 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: RE : [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Actually InventSumDateDim (and other InventSumDate*) DOES NOT give sum of transactions on a date, it really give the qty of an item at a given date. What it does is that it takes the current qty (in InventSum) and roll back to the date (parameter) using the transactions to know what was the inventory qty at that date. Go ahead and try it. ;-) IIRC, InventSumDate will give the qty at the end the day so if you want to know the qty at the beginning of the day you'll probably have 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 Thansk Steeve Probably i asked my question not a clear way. InventSumDateDim gives the sum of transactions on a date, but i want to calculate qty, at the beginning of date, means sum of transactions before given date. Thanks. Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi?: Per 10.02.2005 18:56 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Use method InventSumDateDim::newParameters(). BUT! (Take a deep breath) If you have SP3 and happen to cancel production lines from time to time, make sure those fixs are installed otherwise you may get erroneous results: (I got from MBS) CH_421871 CH_421566_1947 The following is not MBS official but that's what I end up adding to make everything work ok. I ask my VAR to ask MBS about those changes and validate that they are needed, but it's taking forever. I've tested it and they are now in production and its fine. Anyway it's only for report. + After that you will have to change line 15 of InventSumDateValueReport::selectInventTransPostingPhysical() to : group by statusIssue,statusReceipt,packingslipreturned,dateInvent and line 17 InventSumDateDim:: selectInventTransPostingPhysical () to : group by statusIssue,statusReceipt,packingslipReturned For more info about all this mess see discussion 11147 on technet. Steeve... -Message d'origine- 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 the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129nkp1bc/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108141014/A=2532114/R=2/SIG=12kmnkgnn/*http:/clk.atdmt.com/NFX/go/yhxxxnfx002014nfx/direct/01/time=1108054614302338 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=1294s20ck/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108215910/A=2532114/R=2/SIG
[Axapta-Knowledge-Village] 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. Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t
Thansk Steeve Probably i asked my question not a clear way. InventSumDateDim gives the sum of transactions on a date, but i want to calculate qty, at the beginning of date, means sum of transactions before given date. Thanks. Kimden: Steeve Gilbert [mailto:[EMAIL PROTECTED] Gnderilmi: Per 10.02.2005 18:56 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE : How can i find the real invent quantity on time t Use method InventSumDateDim::newParameters(). BUT! (Take a deep breath) If you have SP3 and happen to cancel production lines from time to time, make sure those fixs are installed otherwise you may get erroneous results: (I got from MBS) CH_421871 CH_421566_1947 The following is not MBS official but that's what I end up adding to make everything work ok. I ask my VAR to ask MBS about those changes and validate that they are needed, but it's taking forever. I've tested it and they are now in production and its fine. Anyway it's only for report. + After that you will have to change line 15 of InventSumDateValueReport::selectInventTransPostingPhysical() to : group by statusIssue,statusReceipt,packingslipreturned,dateInvent and line 17 InventSumDateDim:: selectInventTransPostingPhysical () to : group by statusIssue,statusReceipt,packingslipReturned For more info about all this mess see discussion 11147 on technet. Steeve... -Message d'origine- 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 the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129nkp1bc/M=298184.6018725.7038619.3001176/D=groups/S=1705001380:HM/EXP=1108141014/A=2532114/R=2/SIG=12kmnkgnn/*http://clk.atdmt.com/NFX/go/yhxxxnfx002014nfx/direct/01/time=1108054614302338 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
RE: [Axapta-Knowledge-Village] Strange Layer problem
Thanks. It solved. Cenk NCE ERP Teknik Danman (Microsoft Axapta) ERP Technical Consultant (Microsoft Axapta) Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S www.datasistem.com.tr Tel : 0232 463 16 63 (Dah: 128) -Original Message- From: Stefan Osterburg [mailto:[EMAIL PROTECTED] Sent: 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 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 and it becomes in layer cus it works well. Why does it happen? Thanks. Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Strange Layer problem
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 and it becomes in layer cus it works well. Why does it happen? Thanks. Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] markuptrans with amount zero
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 Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: [Axapta-Knowledge-Village] RE: markuptrans with amount zero
Hi harry It will be easy to use it because i want my records to be linked to invoice and to be removed form salesorder after billing. So it will be easy to use markuptrans. One more reason they are real misc. charges which is not shown in my Accounting System but which is shown to customer. Thanks. Kimden: Harry Deshpande [mailto:[EMAIL PROTECTED] Gnderilmi: Sal 18.01.2005 22:04 Kime: Axapta-Knowledge-Village@yahoogroups.com Konu: [Axapta-Knowledge-Village] RE: markuptrans with amount zero Hi It should not create any problems for axapta (other than filling up the database). Why do u need to create these transactions? (just curious) Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions http://www.cgnz.com/middlemarketsolutions Ph +64 29 277 5133 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst Young, and Ernst Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world's leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.cgnz.com/middlemarketsolutions CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. 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:[EMAIL PROTECTED] Sent: Wednesday, 19 January 2005 7:12 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: markuptrans with amount zero 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. 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] Make 2 Production Order, 1 Production Order.
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 ProdIdChild)
{
ProdTable ProdMain,ProdChild;
ProdBOMCalc ProdBOMCalc;
;
ttsBegin;
SELECT FORUPDATE ProdMain WHERE ProdMain.ProdId == ProdIdMain;
SELECT FORUPDATE ProdChild WHERE ProdChild.ProdId == ProdIdChild;
WHILE SELECT FORUPDATE ProdBOMMain
WHERE ProdBOMMain.ProdId == ProdMain.ProdId
{
SELECT FORUPDATE ProdBOMChild
WHERE ProdBOMChild.ProdId == ProdChild.ProdId
ProdBOMChild.ItemId == ProdBOMMain.ItemId
ProdBOMChild.LineNum== ProdBOMMain.LineNum;
ProdBOMMain.QtyBOMCalc = ProdBOMMain.QtyBOMCalc +
ProdBOMChild.QtyBOMCalc;
InventMovement::setMinMaxQty(prodBOMMain);
InventMovement::bufferSetTransQtyUnit(prodBOMMain);
ProdBOMMain.update(true);
WHILE SELECT FORUPDATE InventTransChild
WHERE InventTransChild.InventTransId == ProdBOMChild.InventTransId
{
InventTransChild.InventTransId = ProdBOMMain.InventTransId;
InventTransChild.update();
}
ProdBOMChild.delete();
}
ProdMain.QtySched += ProdChild.QtySched;
ProdChild.delete(false);
ProdMain.update();
ttsCommit;
}
Yahoo! Groups Sponsor ~--
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-
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 Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
winmail.dat
[Axapta-Knowledge-Village] i need intercompany setup document
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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] YNT: Markuptrans voucher error, because of rounding
The error looks like salesprice rounding error, because i update salesprice after inserting markuptrans. sl.SalesPrice -= round((trans.salesLine().DS_SatisFiyati * sg.Value ) / toplam, 0.01); sl.lineAmount = sl.calcLineAmountForced(); 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 with code, same as i create from markuptrans form on salesline. Both records identical, however i get error when i try to get invoice for that salesorder. What is absent in my code? Thanks and good years... //* ttsbegin; select forupdate sl where sl.RecId == trans.salesLine().RecId; select forupdate mt where mt.TransTableId == tablenum(salesline) mt.TransRecId == trans.salesLine().RecId mt.MarkupCode == sg.MarkupCode; mt.initFromSalesLine(trans.salesLine()); mt.lineNum = MarkupTrans::lastLineNum( mt.transTableId, mt.transRecId) + 1; mt.initFromSalesLine(trans.salesLine()); mt.initFromMarkupTable(MArkupTable::find(ModuleInventCustVend::Cust,sg.MarkupCode)); mt.MarkupCode = sg.MarkupCode; sairGider = (trans.Qty * trans.salesLine().DS_SatisFiyati * sg.Value ) / toplam; mt.Value = round(sairGider,0.01); mt.ModuleCategory = HeadingLine::Linie; mt.insert(); eskibf = sl.SalesPrice; sl.SalesPrice -= round((trans.salesLine().DS_SatisFiyati * sg.Value ) / toplam, 0.01); sl.lineAmount = sl.calcLineAmountForced(); sl.update(); ... //*** 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
YNT: I Miss Something - [Axapta-Knowledge-Village] [Urgent] I can't insert MarkupTrans with code
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 Something I miss If you try my previous hint, the field currencyCode assignment from sales line will be overwritten by the standard currency code. If you want to keep your markupTrans record to have currency code from salesLine, perhaps you don't have to call initValue(), but just do this: mt.initFromSalesLine(trans.salesLine()); mt.lineNum = MarkupTrans::lastLineNum( mt.transTableId, mt.transRecId) + 1; Or anyway suitable for you (since sometimes initValue() cannot be just ignored), just to assure that lineNum's value is assigned after transTableId and transRecId have been specified. -Aji Sarosa- --- Aji Sarosa [EMAIL PROTECTED] wrote: Hi Ince, Every record inserted to MarkupTrans must be unique based on these three fields as a key: - TransTableId - TransRecId - LineNum You can check index TransRecIdIdx for MarkupTrans to verify this. The value of field LineNum is assigned in method initValue() based on TransTableId and TransRecId. this.lineNum = MarkupTrans::lastLineNum( this.transTableId, this.transRecId) + 1; But the field transTableId (=??) and transRecId (=??) are not yet filled in at the time initValue() is called, which means lineNum's value built will NOT represent (the last lineNum + 1) for the expected transTableId and transRecId. So, instead of call table's method in this sequence: // assign lineNum mt.initValue(); // assign transTableId and transRecId mt.initFromSalesLine(trans.salesLine()); try to change the sequence like this: // assign transTableId and transRecId mt.initFromSalesLine(trans.salesLine()); // assign lineNum mt.initValue(); so the field transTableId and transRecId are guaranteed to be filled in before lineNum's assignment. Hope this helps. -Aji Sarosa- __ Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. http://celebrity.mail.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=1293c6n9c/M=298184.5639630.6699735.3001176/D=groups/S=1705001380:HM/EXP=1104375909/A=2495208/R=0/SIG=11egg01lg/*http://www.netflix.com/Default?mqso=60188914 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[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, .
The record already exists..
Does anybody knows why does this happen?
My code is like
.
ttsbegin;
select forupdate mt where mt.TransTableId ==
tablenum(salesline)
mt.TransRecId == trans.salesLine().RecId
mt.MarkupCode == sg.MarkupCode;
if(!mt)
{
mt.initValue();
mt.initFromSalesLine(trans.salesLine());
mt.initFromMarkupTable(MArkupTable::find(ModuleInventCustVend::Cust,sg.MarkupCode));
mt.MarkupCode = sg.MarkupCode;
sairGider = (trans.Qty *
trans.salesLine().DS_SatisFiyati * sg.Value ) / toplam;
mt.Value = decround(sairGider,2);
info(num2str(mt.Value,1,1,1,1));
mt.insert();
}
else
{
mt.Value += decround(sairGider,2);
info(num2str(mt.Value,1,1,1,1));
mt.update();
}
...
Thanks
Yahoo! Groups Sponsor ~--
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
~-
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 Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
winmail.dat
[Axapta-Knowledge-Village] barcode
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 ERPTeknik Danman (Microsoft Axapta) ERPTechnical Consultant(Microsoft Axapta) Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S www.datasistem.com.tr Tel : 0232 463 16 63 (Dah: 128) Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.804 / Virus Database: 546 - Release Date: 11/30/2004
RE: [Axapta-Knowledge-Village] Executing Report from a self made form
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 www.datasistem.com.tr Tel : 0232 463 16 63 (Dah: 128) Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
YNT: [Axapta-Knowledge-Village] packing slip error
Thanks i solved it. Kimden: Sun Fen [mailto:[EMAIL PROTECTED] Gnderilmi: Pzt 06.12.2004 06:56 Kime: [EMAIL PROTECTED] Konu: Re: [Axapta-Knowledge-Village] packing slip error Hi, For under delivery message : Have you checked the Accept Under delivery setup in AP Parameter and in the Purchase line? For physical updating quantity: This could be caused by the unit conversion cause i have face similar problem. Check the conversion calculation for the quantity that you are going to receive and the inventory quantity that will be stored. Regards, AFEN - 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 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 that i miss something. Because for example i can't see Inventory Registration on my purchline. Please help. Cenk NCE ERP Teknik Danman (Microsoft Axapta) ERP Technical Consultant (Microsoft Axapta) Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S www.datasistem.com.tr http://www.datasistem.com.tr/ Tel : 0232 463 16 63 (Dah: 128) Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129cii75l/M=298184.5639630.6699735.3001176/D=groups/S=1705001380:HM/EXP=1102396078/A=2434971/R=0/SIG=11eeoolb0/*http://www.netflix.com/Default?mqso=60185400 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- 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 Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
[Axapta-Knowledge-Village] packing slip 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 that i miss something. Because for example i can't see Inventory Registration on my purchline. Please help. Cenk NCE ERPTeknik Danman (Microsoft Axapta) ERPTechnical Consultant(Microsoft Axapta) Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S www.datasistem.com.tr Tel : 0232 463 16 63 (Dah: 128) Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] inventDim(Urgent)
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 ERPTeknik Danman (Microsoft Axapta) ERPTechnical Consultant(Microsoft Axapta) Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S www.datasistem.com.tr Tel : 0232 463 16 63 (Dah: 128) Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 Yahoo! Groups is subject to the Yahoo! Terms of Service.
