[Axapta-Knowledge-Village] Re:Production module (Route) link - type

2007-07-03 Thread Hans-Walter Bous
Hi, when defining primary and secondary operations you don't have to define link types. Primary and secondary operations have to be planned at the same time. The only thing that you should consider: Are the resources in the secondary operations "Exclusive" or not. Link type is used to link o

Re: [Axapta-Knowledge-Village] Changing Decimal places

2007-01-11 Thread Hans-Walter Bous
Hi, in GL decimals are setup on currencies. If you change them you should consider that teir might occur problems (in year closing the quantity of decimals is checked). in Stock the decimals are setup on units. Inf you change them their you will get stock quantities that cannot be posted (e.

RE: [Axapta-Knowledge-Village] Record Level Security problem

2006-05-22 Thread Hans-Walter Bous
Hi James,   to get RLS work properly you have to make sure that the users you want to set it up for get their table rights just from one group (the one where you set up RLS).   Rights are cumulative !!! The only exception is function rights and table rights. You may have full control on e.g. cus

RE: [Axapta-Knowledge-Village] Axapta Security Precedent

2006-05-12 Thread Hans-Walter Bous
Hi,   user goup rights are cumulative. In your example: access to table is perimtted.   But consider that you have   a) function rights (is a user enabled to use menu item e.g. CustTable and in what way)   b) table rights   So if you set up table right full access and menu item right read only

Re: [Axapta-Knowledge-Village] Hide company

2006-05-12 Thread Hans-Walter Bous
hi,   setting up domains and define access rights does solve this problem: users can only choose comanies they have access rights in.   John sreenath reddy <[EMAIL PROTECTED]> schrieb:   Try using xDataArea class.   check the method hasaccess()   check the functionality of that class..probably

RE: [Axapta-Knowledge-Village]

2006-03-16 Thread Hans-Walter Bous
Hi, dictrelation.lines() will give you the number of relations. In the loop over this you have to check dictRelation.lineType(i) The possible relations are defined by ENUM TableRelation::FIELD, ::THISFIXED or ::EXTERNFIXED. For FIELD and EXTERNFIXED dictRelation.lineExternTableValue(i) will

RE: [Axapta-Knowledge-Village] Axapta Security Keys Question

2006-03-15 Thread Hans-Walter Bous
Hi, When setting permissions you will only see security keys that have at least one child. So you have to create a father child relation. John jimbow3012 <[EMAIL PROTECTED]> schrieb: Here is the problem - new security keys don't appear when trying to set group permissions. What did I miss

RE: [Axapta-Knowledge-Village] sales order posting -- Secondary Currency error

2006-03-08 Thread Hans-Walter Bous
Hi, do you have any exchange rates for your secondary currency ? John hello world <[EMAIL PROTECTED]> schrieb: Hi All, When i am posting a sales order following error occured, Voucher 'TEST36', date '08/03/2006', account '9001', amount currency '100.00', amount MST '

RE: [Axapta-Knowledge-Village] Is multiple table recordset can be returned?

2006-02-07 Thread Hans-Walter Bous
Hi, you can return a container. Anant Upreti <[EMAIL PROTECTED]> schrieb: Hi All, Is it possible to return from axapta method the combined recordset/resultset of multiple table having some foreign key relationships. If it is then how? For one table it's possible

RE: [Axapta-Knowledge-Village] Is multiple table recordset can be returned?

2006-02-07 Thread Hans-Walter Bous
Hi, you can return a container. Anant Upreti <[EMAIL PROTECTED]> schrieb: Hi All, Is it possible to return from axapta method the combined recordset/resultset of multiple table having some foreign key relationships. If it is then how? For one table it's possible

RE: [Axapta-Knowledge-Village] System Accounts Posting

2006-01-19 Thread Hans-Walter Bous
Hi, you can setup invoice rounding for sales and purchase on the exchange codes, e.g. in Switzerland every invoice is rounded to 0.05. Then you of course must setup these system accounts. :) John jesse <[EMAIL PROTECTED]> schrieb: Hi, Does anyone knows what or where the posting type belo

RE: [Axapta-Knowledge-Village] Rename department dimension

2006-01-17 Thread Hans-Walter Bous
Go to the Base Enum SysDimension. Here you can change Department. Johnsherin francis <[EMAIL PROTECTED]> schrieb:I have a requirment where the first dimension named Department should to renamed to something else.   When i go to extended datatypes Dimensions i can see only Cost Centre and

RE: [Axapta-Knowledge-Village] MST Round-off error in Invoice Approval Journal

2005-12-02 Thread Hans-Walter Bous
Go to Ledger / Setup / Parameters. Here you should setup maximum penny difference and maximum penny difference in secondary currency. :) JohnIrving <[EMAIL PROTECTED]> schrieb: I have posted an invoice in the Invoice Register Journal:Then I go to the Invoice Approval Journal and fetch the post

Ant: [Axapta-Knowledge-Village] Dynamic insertion , updation in Axapta

2005-11-14 Thread Hans-Walter Bous
Hi Mohit, do I understand you right that you want to import data not coming from Axapta ? Why don' t you use standard functionality ? Under Administration / Periodic / Data Import / Export you can set it up with an import definition type ´"user defined". Then you can also setup the fields to com

Ant: RE: [Axapta-Knowledge-Village] Security rights not effective!

2005-10-21 Thread Hans-Walter Bous
Hi James, concerning user group rights you should consider this: you give user group rights on menu items. And these menu items can be integrated at different points in the main (e.g. posting sales orders you can achieve directly from the form salestable (accessed by menu item salestable) and di

Ant: [Axapta-Knowledge-Village] What to do if we sell inventory but don't deliver it?

2005-10-13 Thread Hans-Walter Bous
Hi Stephen, I think you have to make some adoptions. What do you think of this proposal: When the item is sold to the customer and you use it later on as a by-product then in my opinion this should be considered as a "new" item (the old one but the owner is your customer). So when you nvoice th

Ant: [Axapta-Knowledge-Village] Add same information in 2 different company accounts

2005-10-04 Thread Hans-Walter Bous
Hi Jens, you can setup virtual companies to share tables between companies. But then you should share more than inventtable and inventtablemodule (there are some other tables that fields o inventtable refer to (itemgroup, itemlocation,) If you're interested how to setup virtual companies: a)

Ant: [Axapta-Knowledge-Village] Number days of a month

2005-10-03 Thread Hans-Walter Bous
Hi, try it with dayOfMth(endMth(date)). JohnAlfonso Collados Arroyo <[EMAIL PROTECTED]> schrieb: Hi all: Is there any function that calculates the number of days in a month? Thanks you --This e-mail and any attachments are confi

Ant: [Axapta-Knowledge-Village] Adding Fields In Grid From Two or more tables

2005-09-28 Thread Hans-Walter Bous
Hi Mukesh, you can make a display method on inventtable and put this into the grid. JohnMukesh mutreja <[EMAIL PROTECTED]> schrieb: Hi All,    I m new in Axapta. i m facing a problem regarding adding datain grid from two tables. Is it Possible? I want to add a fieldLicenceNo. in the InventTa

[Axapta-Knowledge-Village] Re: Production Order vs. BOM

2005-04-28 Thread Hans-Walter Bous
Hi Yifat, on the item (TAB PAGE References) you can set item coverage "Stop Explosion" to YES. As long as this is set you'll get a planned purchase order. JohnAxapta-Knowledge-Village@yahoogroups.com wrote: Yahoo! Groups Sponsor ~--> Has someone you k

[Axapta-Knowledge-Village] Re: Posting Profile Purchase Order

2005-03-30 Thread Hans-Walter Bous
Hi, do you know the difference between cost of sales method and total expenditure method? You can set up your inventory model groups for that: post financial inventory = YES is cost of sales post financial inventory = NO is total exenditure. With cost of sales on purchasing only stock is post

[Axapta-Knowledge-Village] Re: Virtual Companies

2005-02-02 Thread Hans-Walter Bous
Hi, there is no limitation for setting up virtual companies. But there is another limitation: you can allocate one table only once. E.G. If yoe have a virtual company (VC1)  and table collection (TC1) for sharing ZipCodes you cannot setup a second virtual company (VC2) with the same table coll

[Axapta-Knowledge-Village] Re: Table Collections

2005-02-02 Thread Hans-Walter Bous
Hi Don, you only need table collections for setting up virtual companies. So, what do your companies intend to share. For sharing e.g. taxes setup take a look at the forms for setting up taxes --> which tables are used. Best wishes John   Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlose