[Axapta-Knowledge-Village] Eliminating InventTrans for performance

2009-11-10 Thread Pankaj Kant
Hi We have a requirement for eliminating the Invent trans posting. The usage of Axapta will be to control financial information derived from the departments within company that sells services to each other. Stock transactions are not needed for this purpose. We have a serious performance

[Axapta-Knowledge-Village] put enum value into qbds dynamically

2009-11-10 Thread giridharraj
Hi, I would like to get the enum value which is actually in a string into query build value dynamically.i.e.,for ex: str value; value = 'Delivered' fieldName = 'Salesstatus' These are the values that i get during the process.I came to know that to put enum values in querybuild value we need to

Re: [Axapta-Knowledge-Village] put enum value into qbds dynamically

2009-11-10 Thread Anitha S
Hi, Chk if this suits ur requirement. QueryBuildDataSource qbds; QueryBuildRange qbr; str fieldEnum ; qbds = this.query().datasourcetable(TABLENAME); qbr = qbds.addrange(fieldnum(TABLENAME,FIELDNAME) ;// Assume this field is ENUM fieldEnum =

[Axapta-Knowledge-Village] Re: put enum value into qbds dynamically

2009-11-10 Thread giridharraj
Thanks alot anitha, it has suited my requirement. --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eani...@... wrote: Hi, Chk if this suits ur requirement. QueryBuildDataSource qbds; QueryBuildRange qbr; str fieldEnum ; qbds =

[Axapta-Knowledge-Village] Difference between salesbasket, salesquotationbasket and salesorder

2009-11-10 Thread giridharraj
Hi, can anyone tell me the concept and difference between Salesbasket,salesquotationbasket,salesorder,salesbasketline,salesquotationbasketline,salesline,salesquotationline tables in Axapta? If I place some qty for an item, the inventory availability must reduce, in which table will this happen