RE: [Axapta-Knowledge-Village] Ledger Journals Clean Up

2007-07-31 Thread James Flavell
Just to be clear it deletes the posted journals but NOT the ledger transactions If you want to get the journals back you would have to modify the script to export the data out before it deleted it and then write an import if you want to get it back. I guess AX idea is you can keep the posted jour

RE: [Axapta-Knowledge-Village] uploading balances for Customers & vendors

2007-07-31 Thread Craig Fidler
Agree but I would say that MS should be looking at providing an import script for data take-on From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of faiqa Sent: Tuesday, July 31, 2007 5:22 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowl

RE: [Axapta-Knowledge-Village] Re: Fixed Asset - Acquistion

2007-07-31 Thread James Flavell
Sorry I don't get you >From what I recall I can aquire an asset on its aquistion date (e.g. 10/01/1981) and then depreciate from that date up to whatever date I specify in the depreciation proposal script Sorry I don't know why you are getting 1/1/2006 without seeing your data in Ax -Origin

Re: [Axapta-Knowledge-Village] Re: Fixed Asset - Acquistion

2007-07-31 Thread G Radhakrishnan
Hii, thanks a lot for wonderful explanation from all of you. I could convience my user on the date which is the first date of the calender and as of today they have agreed. Anyway in future if they ask about the original acquistion date, I will create a new filed in table and in the form; th

Re: [Axapta-Knowledge-Village] Ledger Journals Clean Up

2007-07-31 Thread G Radhakrishnan
Hi, Is this option available in V3.0 ?? if it is going to remove posted transactions,is there anyway to reverse it back --- AX CONS <[EMAIL PROTECTED]> wrote: > Yes, you are right. > > This job is cleaning the POSTED journal number. So > you will not see the > Journals even in Posted. >

Re: [Axapta-Knowledge-Village] uploading balances for Customers & vendors

2007-07-31 Thread G Radhakrishnan
Dear Gokhan, Just a clarification. Is CustTrans and VendorTrans required for uploading opening balances ? Only custTransopen, vendortransopen are sufficient, right?? Regards, GR. --- AX CONS <[EMAIL PROTECTED]> wrote: > Hello, > > That is up what your customer wants to see. > > First of al

RE: [Axapta-Knowledge-Village] Re: what does prompt() do?

2007-07-31 Thread Janet Blake
Yes, and the if(prompt()) will return true if they clicked OK and not Cancel. Janet From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of markus_sendelbach Sent: Tuesday, July 31, 2007 12:19 PM To: Axapta-Knowledge-Village

Re: [Axapta-Knowledge-Village] Re: Group by in X++ ??

2007-07-31 Thread Varden Morris
Thanks. That was an oversight by me. When using “group by” the field has to be apart of an aggregation before it can be selected. Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message --

Re: [Axapta-Knowledge-Village] uploading balances for Customers & vendors

2007-07-31 Thread AX CONS
Hello, That is up what your customer wants to see. First of all update the CustTrans, CustTransOpen, Vendor and VendorTransOpen. These transactions will update your Vendor and Customer balance. After that update the LedgerTrans, LedgerBalancesTrans and LedgerBalancesDimTrans. The best way you can

[Axapta-Knowledge-Village] Re: what does prompt() do?

2007-07-31 Thread markus_sendelbach
prompt() will open a dialog. --- In Axapta-Knowledge-Village@yahoogroups.com, "pabundes" <[EMAIL PROTECTED]> wrote: > > Anybody knows what does the next line in the class SalesFormLetter?: > > if(SalesFormLetter.prompt()) > > it ask for something or execute some method? or what?? > > > thanks

[Axapta-Knowledge-Village] what does prompt() do?

2007-07-31 Thread pabundes
Anybody knows what does the next line in the class SalesFormLetter?: if(SalesFormLetter.prompt()) it ask for something or execute some method? or what?? thanks in advance.

RE: [Axapta-Knowledge-Village] uploading balances for Customers & vendors

2007-07-31 Thread faiqa
Just use LedgerJournalTrans table , here you can enter transactions for vendor/customer/ledger account using account type. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tarek Saleh Sent: Tuesday, July 31, 2007 11:27 AM To: Axapta-Knowledge-Villag

Re: [Axapta-Knowledge-Village] Ledger Journals Clean Up

2007-07-31 Thread AX CONS
Yes, you are right. This job is cleaning the POSTED journal number. So you will not see the Journals even in Posted. Thank you On 7/31/07, James Flavell <[EMAIL PROTECTED]> wrote: > > I think its deleting the posted journals if I remember correctly > > -Original Message- > From: > Ax

[Axapta-Knowledge-Village] Re: Fixed Asset - Acquistion

2007-07-31 Thread novembercalendar
Hi GR, 1)We created a new field in the AssetBook table called "InitialAcquisitionDate - this is the one we use to retain what the original acq date is - system does not use it for anything. The one I referred to as "last acquisition date" is really the "acquisitiondate" field. This one is p

[Axapta-Knowledge-Village] Re:salesordre/inventtory and production

2007-07-31 Thread fvatne
Hi Thank you for your answer, but I would like to use the production module in Axapta not the project module, because we have made a web interface where the whole production process is controlled. So what I really need is a possibility to make invoices and track inventory of the different stage

[Axapta-Knowledge-Village] uploading balances for Customers & vendors

2007-07-31 Thread Tarek Saleh
Dear All, currently i need to upload the customer as well as the vendor balances, so what is the proper table i should export: "vendtrans & cust trans" or "ledger trans and then vendtrans & custtrans" or someother tables. Thanks for your support, Tarek --

RE: [Axapta-Knowledge-Village] Re: Fixed Asset - Acquistion

2007-07-31 Thread G Radhakrishnan
Hi, I have filledup the acquistion date as original date. But after import, when you go for acquistion, the system gives the date as 01/01/2006. As you told may be my first period is from 2006. So If I keep period much before it will take accordingly. . But this date is taken as "Acquistion date" a

Re: [Axapta-Knowledge-Village] Hiding Data

2007-07-31 Thread Sumit Loya
Hi, You can set the record level security for the dimension territory and restrict the user groups of those users to the territories you want them to see. Regards, Sumit On 7/31/07, Hardees Buff <[EMAIL PROTECTED]> wrote: > > Hi, > > Scenario: > > - We have a dimension "Territory" in my Axapt