date:20070731

Hello,

email me about that. We have some solution and that is working for couple
customers.

[EMAIL PROTECTED]


On 7/13/07, Neil Coleman [EMAIL PROTECTED] wrote:

   Scalable Data Systems has both RF and batch barcode solutions for AX.
 For more information, please contact [EMAIL 
 PROTECTED]neil%40scalable.com.auor
 [EMAIL PROTECTED] john%40scalable.com.au

 Regards

 Neil Coleman

 -Original Message-
 From: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of tj_jayson
 Sent: Saturday, 14 July 2007 7:47 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Re: Barcode solutions

 Hi All,

 One of our customer also looking for this kind of solution. Any help
 will be appreciated

 Thanks

 TJJ

 --- In Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED] Village%40yahoogroups.com, James Flavell
 [EMAIL PROTECTED] wrote:
 
  Hi is anyone aware of any 'off the shelf' barcode solutions for
 basic
  warehouse functions for AX?
 
 
 
  I know barcoding and how to do it but am looking for a package that
 is ready
  to go and can be applied to a std AX to cover incoming and outgoing
  functions. Preferred is online rather than offline/batch updates.
 
 
 
  Thanks
 
  James
 
 
 
  [Non-text portions of this message have been removed]
 


 [Non-text portions of this message have been removed]

  



[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] shipping or export documents in AX

Hello James,

For the Foreign Trade, there are some Templates such as Certificate of
Origin, Shippers Export Declaration and so on. So we found them in Word
Format on the internet. By using Document Handling on SalesTable, we are
printing the Required fields on the documents my field Mapping . Also that
is good, we are keeping the documents for each Sales Order by Document
Handling. Of course, that is not really Foreign Trade functionality, but we
need to create the documents and save them for the customer. So, we are OK.

If you need, email me directly and I could give more information.

Gokhan Kestek
[EMAIL PROTECTED]
[EMAIL PROTECTED]

On 7/27/07, James Flavell [EMAIL PROTECTED] wrote:

Okay glad to hear you found a solution,

Just wondering what document templates you are referring to? Std AX
templates or ones you created yourself as I would be interested to see.

Thanks
James

-Original Message-
From:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of AX CONS
Sent: 26 July 2007 23:10
To:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] shipping or export documents in AX

Hello James,

Thank you for your consideration. I have found another way now. I hope
that
could work.

Now, I am using the document Management function annd Word Template. I
have
found export document word templates and I gave some field maping by use
Document Management and that is working fine now. For more Sales Order
lines, also I am using the Temp table to handlle more lines.

Thank you

On 7/25/07, James Flavell [EMAIL PROTECTED] djf%40columbusindo.com
wrote:

There are a few documents such as Bill of Lading etc but by the sounds
of
what you want std Ax wont cover your requirements.

What we did for one customer with similair requirements was to add a few
fields to CustInvJour and make a new report for Cert of Origin (looks
pretty
much like invoice but with values removed and coutnry of origin added).

For packing we used the PickingList journal lines and made a report out
of
these.

The nice part about this solution was it was made as part of an 'Export
shipments' module whereby several sales orders could be combined into a
simple shipment and a single packing document generated. Also it is all
really just built using std Axapta so there its footprint is pretty
small.

I am afraid the modication belongs to my company but if you have similar
requirements (esp if it invovles combining several sale sorders into a
shipment) and are interested then let me know and I can probably send
some
print screens of what it does.

Thanks
James

-Original Message-
From:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
Axapta-Knowledge-Village%40yahoogro
ups.com

[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
Axapta-Knowledge-Village%40
yahoogroups.com]
On Behalf Of AX CONS
Sent: 25 July 2007 03:37
To:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
Axapta-Knowledge-Village%40yahoogro
ups.com
;
[EMAIL
PROTECTED]development-axapta%40yahoogroups.comdevelopment-axapta%40yahoogr
oups.com
Subject: [Axapta-Knowledge-Village] shipping or export documents in AX

Hello,

Does *Axapta* contain a series of export or shipping documents? We
currently use a package independent of the ERP to create
Certificates of Origin, Proforma Invoices, Shippers Export
Declarations, and Packing Lists (which contains a conversion and
weight utility). If/When we implement *Axapta*, it would be helpful
to use *Axapta* to create export documents and not an additional PC
based Solution .

Any assistance would be greatly appreciated.

Gokhan Kestek
[EMAIL PROTECTED]
gokhankestek%40whatisaxapta.comgokhankestek%40whatisaxapta.com
[EMAIL PROTECTED] gokhan%40fine.com gokhan%40fine.com

[Non-text portions of this message have been removed]

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

Come and choose your preferred name for Microsoft Dynamics AX on the
Axapta
Knowledge Village, Visit www.axapta-knowledge-village.tk

Yahoo! Groups Links

[Non-text portions of this message have been removed]

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

Come and choose your preferred name for Microsoft Dynamics AX on the
Axapta
Knowledge Village, Visit www.axapta-knowledge-village.tk

Yahoo! Groups Links

[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] Start-Up Tool for Dynamics AX

2007-07-31 Thread patrick.kraenzlin

Dear developers

I've created a Start-Up tool for Dynamics AX to manage multiple 
configurations over the Versions 2.5 up to 4.0.

It's easy to use and designed for developers, technical supporters 
and application supporters as well. Just for everyone who works with 
more than one Dynamics AX configuration concurrent and does not like 
the jungle of links to the ax32.exe -regconfig= client or shortcuts 
to the AXC files.

Key features:
- Management of XPOs, AXCs and registry configurations from different 
Dynamics AX Versions
- Integrated Remotemanagement of NT-services
- Exportmanager to duplicate/provide configurations from/to different 
sources
- Direct modifications on configuration properties and test mode 
function
- Run As function (useful since Version 4.0)
- Shortcuts to system tools such COM+, SQL-Studio, Visual Studio, 
ODBC, a.s.o.


Currently the tool's interface is in german language. Before I will 
translate it into english language I need some feed back (if the 
responses are positive, I will translate it ...). Cause most 
functions are indicated with an icon instead a button text, people 
without german language knowledge should be able to use the main 
functions too.

Questions about how to use the tool can be answerd by reading the 
help file (can be opened inside the application).

The software is running on Win 98/00/XP (and should also run on 
Vista). Under Windows 98/00 missing GDI+ will make the GUI more text 
based, but the functionality is still the same.

The software doesn't need an installation routine; Just copy the EXE-
File anywhere and start it. Only VB6 Runtime libraries are needed to 
run the application and most of Microsoft OS has them already 
installed. After start you will find a new Systray-Icon; click it to 
launch the GUI.

You can download the file from here:
http://www.luegisdorf.ch/SmartStart3000.exe

I like to hear from you and hope you find some pleasure on this tool!
Please provide your feed back to this e-mail: patrick[at]luegisdorf
[dot]ch (the yahoo-address will not read very often ...)

Thank you for your intrest!
Best regards
Patrick

[Axapta-Knowledge-Village] how to install AX 4.0

2007-07-31 Thread mohangiri

Hi 
 i m new in Axapta field Please tell me How to install Ax 4.0 server  
client in one machine

Thanks in advance

Mohan 
09818839935

Re: [Axapta-Knowledge-Village] Blank InventDim problem

Hello James,

Which Version of Axapta are you using?

Gokhan Kestek
[EMAIL PROTECTED]
[EMAIL PROTECTED]


On 7/19/07, James Flavell [EMAIL PROTECTED] wrote:

   Hi everyone,

 Can anyone help me to understand why the following code is like it is in
 SYS
 layer

 Basically the findOrCreateBlank() method on the inventdim is returning an
 empty inventdim when it is supposed to be returning 'Axapta'

 I can understand the code and I can see I could make my call
 findOrCreateBlank(false) and it would be okay but I am just unsure of the
 reason this code even exists in the method and what the correct calling
 should be.

 My call is:

 suppItemTable.InventDimId =
 inventDim::findOrCreateBlank().inventDimId;

 this in turn calls the following method which has some test of
 configuration
 key which is causing the problem:

 static InventDim findOrCreateBlank(boolean testConfigurationKey = true)

 {

 InventDim inventDim;

 #define.blank('Axapta');

 //This is where it goes wrong since AdvancedLogistics is enabled

 //Why should the blank inventdim be different when AdvancedLogistics is
 enabled, I thought it was always 'Axapta' regardless of what modules you
 have?

 if (testConfigurationKey 
 isConfigurationKeyEnabled(configurationKeyNum(LogisticsAdvanced)))

 return inventDim;

 inventDim = InventDim::find(#blank);

 if (inventDim.recId)

 return inventDim;

 inventDim = InventDim::findDim(inventDim);

 if (inventDim.recId)

 return inventDim;

 ttsBegin;

 inventDim.inventDimId = #blank;

 inventDim.insert(true);

 ttsCommit;

 return inventDim;

 }

 Thanks

 James

 [Non-text portions of this message have been removed]

 



[Non-text portions of this message have been removed]

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

2007-07-31 Thread gomezdegomera

Hi Varden, the query you posted doesn't work

Query q = new Query();
QueryBuildDataSource dsSalesTable;
QueryBuildDataSource dsSalesLine;
QueryRun qr;
SalesTable   SalesTable;
dsSalesTable = q.addDataSource(tablenum(SalesTable));
dsSalesLine = dsSalesTable.addDataSource(tablenum(SalesLine));
dsSalesLine.addLink(FieldNum(SalesTable, SalesId), FieldNum
(SalesLine,SalesId));
dsSalesLine.JoinMode(JoinMode::InnerJoin);
dsSalesLine.addSortField(FieldNum(SalesLine, SalesId));
dsSalesLine.orderMode(ordermode::GroupBy);
dsSalesLine.addSelectionField(FieldNum(SalesLine, LineAmount),
SelectionField::Sum);
qr = new QueryRun(q);
while (qr.next())
{
SalesTable = qr.get(tablenum(SalesTable));
print SalesTable.DeliveryAddress;
}
pause;


You will see that SalesTable.DeliveryAddress is `', no fields are filled
I was going to asking you a different way to make the query to work
when I found the problem
You missed an istruction like this

dsSalesLine.addSelectionField(FieldNum(SalesTable,DeliveryAddress,SelectionField::Min);

Notice that you have to specify a type different than
SelectionField::Database

Bye



--- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris
[EMAIL PROTECTED] wrote:

 Hi Anton,
  
 I tried this in a job andI didn't get any error:
  
 Query q = new Query();
 QueryBuildDataSource dsSalesTable;
 QueryBuildDataSource dsSalesLine;
 QueryRun qr;
 SalesTable   SalesTable;
 dsSalesTable = q.addDataSource(tablenum(SalesTable));
 dsSalesLine = dsSalesTable.addDataSource(tablenum(SalesLine));
 dsSalesLine.addLink(FieldNum(SalesTable, SalesId), FieldNum
 (SalesLine,SalesId));
 dsSalesLine.JoinMode(JoinMode::InnerJoin);
 dsSalesLine.addSortField(FieldNum(SalesLine, SalesId));
 dsSalesLine.orderMode(ordermode::GroupBy);
 dsSalesLine.addSelectionField(FieldNum(SalesLine, LineAmount),
 SelectionField::Sum);
 qr = new QueryRun(q);
 while (qr.next())
 {
 SalesTable = qr.get(tablenum(SalesTable));
 print SalesTable.DeliveryAddress;
 }
 pause;
 
 anton_tjiptadi [EMAIL PROTECTED] wrote:
 
 Hi,
 How to create X++ query for Group By ??
 
 My select statement is simply like this (in Transact SQL)
 
 select a.salesid, sum(b.lineamount) from salestable a, salesline b
 where a.salesid=b.salesid
 group by a.salesid
 
 I try to build in X++ like this, but it cause error said that there's 
 no Group by 
 
 dsSalesTable = q.addDataSource(tablenum(SalesTable));
 dsSalesLine = dsSalesTable.addDataSource(tablenum(SalesLine));
 dsSalesLine.addLink(FieldNum(SalesTable, SalesId), FieldNum
 (SalesLine,SalesId));
 dsSalesLine.JoinMode(JoinMode::InnerJoin);
 dsSalesLine.addSortField(FieldNum(SalesLine, SalesId));
 dsSalesLine.orderMode(ordermode::GroupBy);
 dsSalesLine.addSelectionField(FieldNum(SalesLine, LineAmount), 
 SelectionField::Sum);
 
 Thanks in advance,
 
 
 
 
 
 
 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 the Yahoo! Terms of Service. 
 
 
   
 -
 Do you Yahoo!?
  Take Yahoo! Mail with you! Get it on your mobile phone.

[Axapta-Knowledge-Village] ax 4.0 sp1 demo data not inserted in dvd ??

2007-07-31 Thread char_l3s

hi all, 
Is there any demo data in ax4 sp1 ??? because in the dvd i receipt 
there isn't any demo data... so can any one help me?? 
is it using demo data from the previous version (ax 3.0) ? are there 
any requreiment to get the demo data??
thx for your reply.. :p

Re: [Axapta-Knowledge-Village] I have one question about cheque.

Hello KamRaju,

I have tried that, also on the payment journal lines--Payment Status, the
system start to give REUSE option also. But I have selected that, but the
system is still using the next Check Number.

I have check the first Cheque number, that is Cancelled. I think that should
be Created to use again.
On the other hand, if you look at the explanation of the Reuse Parameter on
Bank Parameters table; you are right. We should able to use that. I have
changed the Bank Check Layout to Free to Fixed, Fixed to Free. For both
case, that is same problem.

Thank you

Gokhan Kestek
[EMAIL PROTECTED]
[EMAIL PROTECTED]

On 7/27/07, KamaRaju Vudata [EMAIL PROTECTED] wrote:

Go to Bank moduleSetup Parameters and then select ALLOW CHECK RE_USE

Let me know if that helps you.

Regards,

Kamaraju

From:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of AX CONS
Sent: Thursday, July 26, 2007 7:51 AM
To:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
;
[EMAIL PROTECTED] development-axapta%40yahoogroups.com
Subject: [Axapta-Knowledge-Village] I have one question about cheque.

Hi all,

I have one question about cheque. After I reversed the transaction, the
system is converting the cheque status to Cancelled. The customer wants to
use Cancelled Cheque again. As you know, when I generate the payment, the
system is only bringing the Created status cheque. So, how can I use
Cancelled Cheque again? I have an idea about that, just change the status
of
the cheque on the ChequeTable by small modification. If I change the
status
of the Cheque, could that create any other potential problem? I know that,
that will still show old transaction. But that is OK for me.

Thank you.

[Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] Unposting a journal Entry

Hello,

If you look at Axapta 3.0, there is one class deletedatabasetrans or
something like that. That will give you idea about that. Only, be careful
about the settled Transaction.

Gokhan Kestek

[EMAIL PROTECTED]



On 7/9/07, kamaraju80 [EMAIL PROTECTED] wrote:

   Hi

 I would like to unpost a journal entry in General ledger .

 is there any way i can do it in Axapta 4.0? I dont want to void it..

 please help me.

 Regards,
 KV

 



[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] Ledger Journals Clean Up

Does anyone know what is the Ledger Journals Clean Up on the General
ledger--Periodic--Clean menu?What is that for?

Thank you

Gokhan Kestek

[EMAIL PROTECTED]
[EMAIL PROTECTED]


[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] Inventory Turnover pos

Hello,

I have a question. What is Inventory *Turnover posted field* on the Item
Transaction field?

Gokhan Kestek

[EMAIL PROTECTED]


[Non-text portions of this message have been removed]

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

I think its deleting the posted journals if I remember correctly


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of AX CONS
Sent: 28 July 2007 02:36
To: [EMAIL PROTECTED];
Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Ledger Journals Clean Up

Does anyone know what is the Ledger Journals Clean Up on the General
ledger--Periodic--Clean menu?What is that for?

Thank you

Gokhan Kestek

[EMAIL PROTECTED]
[EMAIL PROTECTED]


[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

Come and choose your preferred name for Microsoft Dynamics AX on the Axapta
Knowledge Village, Visit www.axapta-knowledge-village.tk

 
Yahoo! Groups Links

RE: [Axapta-Knowledge-Village] Blank InventDim problem

Thanks it is Ax3.0 SP5


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of AX CONS
Sent: 28 July 2007 01:57
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Blank InventDim problem

Hello James,

Which Version of Axapta are you using?

Gokhan Kestek
[EMAIL PROTECTED]
[EMAIL PROTECTED]


On 7/19/07, James Flavell [EMAIL PROTECTED] wrote:

   Hi everyone,

 Can anyone help me to understand why the following code is like it is in
 SYS
 layer

 Basically the findOrCreateBlank() method on the inventdim is returning an
 empty inventdim when it is supposed to be returning 'Axapta'

 I can understand the code and I can see I could make my call
 findOrCreateBlank(false) and it would be okay but I am just unsure of the
 reason this code even exists in the method and what the correct calling
 should be.

 My call is:

 suppItemTable.InventDimId =
 inventDim::findOrCreateBlank().inventDimId;

 this in turn calls the following method which has some test of
 configuration
 key which is causing the problem:

 static InventDim findOrCreateBlank(boolean testConfigurationKey = true)

 {

 InventDim inventDim;

 #define.blank('Axapta');

 //This is where it goes wrong since AdvancedLogistics is enabled

 //Why should the blank inventdim be different when AdvancedLogistics is
 enabled, I thought it was always 'Axapta' regardless of what modules you
 have?

 if (testConfigurationKey 
 isConfigurationKeyEnabled(configurationKeyNum(LogisticsAdvanced)))

 return inventDim;

 inventDim = InventDim::find(#blank);

 if (inventDim.recId)

 return inventDim;

 inventDim = InventDim::findDim(inventDim);

 if (inventDim.recId)

 return inventDim;

 ttsBegin;

 inventDim.inventDimId = #blank;

 inventDim.insert(true);

 ttsCommit;

 return inventDim;

 }

 Thanks

 James

 [Non-text portions of this message have been removed]

 



[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

Come and choose your preferred name for Microsoft Dynamics AX on the Axapta
Knowledge Village, Visit www.axapta-knowledge-village.tk

 
Yahoo! Groups Links

[Axapta-Knowledge-Village] Hiding Data

2007-07-31 Thread Hardees Buff

Hi,
   
  Scenario:
   
  - We have a dimension Territory in my Axapta 3.0 SP 5 installation.
  - 3 accountants from 3 different territories are accessing the same system 
and posting their transactions (in GL/AR/AP).
  - I want to hide the transactions done by accountant of one territoy from the 
others.
   In other words, I want to show only transaction done by the user in the 
system without showing other people's transactions. I want to filter 
transactions by name or assigned territory. For example, if I log in and select 
an account and go to Transactions button, I should see only transactions done 
by me, throughout the system.
   
  Can this be achived by tweaking some code? or Record Level Security?
   
  All kinds of help is welcome.
   
  Regards, 

   
-
Shape Yahoo! in your own image.  Join our Network Research Panel today!

[Non-text portions of this message have been removed]

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 Axapta 3.0 SP 5 installation.
 - 3 accountants from 3 different territories are accessing the same system
 and posting their transactions (in GL/AR/AP).
 - I want to hide the transactions done by accountant of one territoy from
 the others.
 In other words, I want to show only transaction done by the user in the
 system without showing other people's transactions. I want to filter
 transactions by name or assigned territory. For example, if I log in and
 select an account and go to Transactions button, I should see only
 transactions done by me, throughout the system.

 Can this be achived by tweaking some code? or Record Level Security?

 All kinds of help is welcome.

 Regards,

 -
 Shape Yahoo! in your own image. Join our Network Research Panel today!

 [Non-text portions of this message have been removed]

 



[Non-text portions of this message have been removed]

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

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 after posting the
journal but the Depreciation run date is same as I
kept in the excel sheet(In my case , say 10/01/1981).
I afraid this may lead cofusions for the users, right?

Regards,
GR.


--- James Flavell [EMAIL PROTECTED] wrote:

 Hi
 
 It is fine to load up assets as they oringally were
 and run aquistion and
 depreciation for these.  The only thing is you will
 need ledger periods
 going back however far you want to post back in time
 (even if you setup your
 profile to debit and credit the same GL account).
 
 Not sure why you are getting 1/1/2006 but have you
 filled in the right
 aquistion date on the asset?  Is 1/1/2006 the first
 ledger period you have
 in your system?
 
 
 -Original Message-
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of G
 Radhakrishnan
 Sent: 31 July 2007 10:15
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Re: Fixed
 Asset - Acquistion
 
 Hi,
 Thanks a lot for your explanation. Can you please
 tel
 me something on the following points;
 
 1. What do you mean by last acquistion date ? Is
 there any field available in this name ? Or u mean
 to
 say the acquistion date when you run the
 acquistion
 journal for the first time?i.e., immediately after
 import of assets.
 
 2. What did you do with the Conversion profile
 Chart
 of Accounts after the acquistion and the
 depreciation
 till 31/12/2006. Because , these are just dummy COAs
 and will remain in the COA.
 
 3. It is good that we will have the actual
 acquistion
 price; but I fear that the recent Assets; say assets
 acquired during 2001,2,3 will be having the
 acquistion
 date as 31/12/2006. So in a long run, say after 3 or
 4
 years, users should not think that the asset is
 acquired during 31/12/2006 having the service life
 say
 19 years instead of actual 25 years..am i correct ?
 
 I did a piolet run yesterday on some assets of 1981.
 System does the following.
 
 Scenario is as follows- 
 Asset dated 1981. 
 Actual service life 25 years 
 Depreciation Method - Reducing balance
 Depreciation frequency - Yearly
 
 After import,I acquired assets through GENERAL
 JOURNAL-Fixed asset journal - Acquistion proposal.
 
 System keeps the posting date as 01/01/2006. (Here ,
 I
 didnt understand,why the date is coming as
 01/01/2006
 iinstead of anyother date or it is not asking for
 acquistion date)
 
 Posted all assets. The acquistion date is updated as
 01/01/2006 where as the Depreciation run date is
 the
 date which i imported say 10/01/1981.
 
 I run depreciation after above step. System did the
 depreciation starting from 1981 till 2006 perfectly
 and it is posted on the respective posting profile.
 Now the last depreciation run date is 31/12/2006.
 
 Note that the service life remaining is automaticaly
 changed ; we need not put it manually. 
 
 
 Is the above steps are fine ?? Expecting your reply
 reply pleasee
 
 Regards,
 GR.
 
 
 
 --- novembercalendar [EMAIL PROTECTED]
 wrote:
 
  We implemented FA as of 12/31/2006.  On our
 existing
  assets, we used 
  the original acquisition date w/original acq amts,
  original service 
  life, acq dates,  depr run dates.  When we
 imported
  the assets, we 
  used 12/31/06 for the last acquisition date and
  for the Date when 
  depreciation was last run.  For service life
  remaining entered 
  life remaining after 12/31/06 depreciation.
  
  Using 12/31/2006 for the last acquisition date
  allowed us to create 
  acquisition proposals/journals dated 12/31/06. 
  Then, for the next 
  time depreciation proposals are generated, the
  system automatically 
  uses the next month's date.
  
  We set up a temporary profile called Conversion
 to
  have all the gl 
  activity go in  out of one account, since GL
  already had balances 
  representing the asset values.  
  
  We uploaded, via Atlas, accumulated depreciation
  balances thru 
  12/31/06 - posted the entry with a 12/31/06 date -
  also using the 
  conversion profile.
  
  Our IT department than ran an sql for us to change
  the assets' 
  profile from Conversion to the profile now used
 for
  ongoing 
  transactions.
  
  The benefit of loading original assets is for
  reporting accurate 
  results... If you were to only load the net book
  value, usually in 
  accounting, the original cost is recorded in one
  account, and the 
  accumulated depreciation in another, it would be
  difficult to 
  reconcile.
  
  Hope this helps!
  
  
  
  
  
  
  
  
  
  --- In Axapta-Knowledge-Village@yahoogroups.com,
  KamaRaju Vudata 
  [EMAIL PROTECTED] wrote:
  
   Hi,
   

   
   I am also having the same issue. Can anyone help
  me

[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


 

   
-
Pinpoint customers who are looking for what you sell. 

[Non-text portions of this message have been removed]

[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 stages of the item.
Frode

--- In Axapta-Knowledge-Village@yahoogroups.com, Rajesh Talpade 
[EMAIL PROTECTED] wrote:

 Hi Frode,
 From what you are saying, the first part of the
 transaction is easy. It is a straight sales order
 process. 
 However, the second is slightly tricky. Do you have
 the project module with you? You could run the second
 part as a project with visibility of all processes
 involved. In this way, firstly you are selling a
 product, (steel sheets or whatever). Next you are
 providing a service (adding value to another item, as
 the original steel sheet is now modified), and
 charging material used (if any), labour and other
 handling costs.
 This way your second invoice is only for value
 addition, and not for the base material supplied by
 your customer.
 I have run projects for a similar scenario where the
 client was conducting repairs on hydraulic equipment.
 Seemed to fit in very well. We were able to charge
 items from inventory, labour, machining costs, where
 necessary, all via projects.
 Cheers.
 Rajesh
 
 

 
_
___
 Get the Yahoo! toolbar and be alerted to new email wherever you're 
surfing.
 http://new.toolbar.yahoo.com/toolbar/features/mail/index.php

[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 populated by the system, 
each time an acquisition proposal journal is posted...So, by 
populating this field with the 12/31/06 date, in our implementation, 
it dated all acquisition journals as 12/31/06 - this is how we 
posted our original acquisition costs.  Since acquisitions were 
posted in the same period, we didn't have to go back to previous 
periods.

Since we uploaded accumulated deprecation balances, all in Dec06, we 
didn't have to go back prior periods to record each month's 
depreciation - that why we populated the last depreciation run date 
with 12/31/06 - this way, the next journals generated for 
depreciation would be dated 01/31/2007.   

2)  We didn't use dummy COA, instead we have a clearing account we 
used for other items.  We kept the Conversion profile in the system, 
since it's not being used for anything, it's just sort-of parked 
there.

3)  With the new field, initial acquisition date, there would be no 
confusion since the dates will truly reflect the date the asset was 
acquired. This date never changes unless the user changes it.  Users 
understand that the acquisition date (we renamed this to last 
acquistion date) reflects the date of when any acquisition activity 
has been posted.

On the service life, there are the two fields, on that holds what 
the original life time  then what's remaining.  So, on the older 
assets, the life time remaining would be reduced by the number of 
months the asset has already been depreciated by.

Hope this helps,




--- In Axapta-Knowledge-Village@yahoogroups.com, G Radhakrishnan 
[EMAIL PROTECTED] wrote:

 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 after posting the
 journal but the Depreciation run date is same as I
 kept in the excel sheet(In my case , say 10/01/1981).
 I afraid this may lead cofusions for the users, right?
 
 Regards,
 GR.
 
 
 --- James Flavell [EMAIL PROTECTED] wrote:
 
  Hi
  
  It is fine to load up assets as they oringally were
  and run aquistion and
  depreciation for these.  The only thing is you will
  need ledger periods
  going back however far you want to post back in time
  (even if you setup your
  profile to debit and credit the same GL account).
  
  Not sure why you are getting 1/1/2006 but have you
  filled in the right
  aquistion date on the asset?  Is 1/1/2006 the first
  ledger period you have
  in your system?
  
  
  -Original Message-
  From: Axapta-Knowledge-Village@yahoogroups.com
  [mailto:[EMAIL PROTECTED] On
  Behalf Of G
  Radhakrishnan
  Sent: 31 July 2007 10:15
  To: Axapta-Knowledge-Village@yahoogroups.com
  Subject: Re: [Axapta-Knowledge-Village] Re: Fixed
  Asset - Acquistion
  
  Hi,
  Thanks a lot for your explanation. Can you please
  tel
  me something on the following points;
  
  1. What do you mean by last acquistion date ? Is
  there any field available in this name ? Or u mean
  to
  say the acquistion date when you run the
  acquistion
  journal for the first time?i.e., immediately after
  import of assets.
  
  2. What did you do with the Conversion profile
  Chart
  of Accounts after the acquistion and the
  depreciation
  till 31/12/2006. Because , these are just dummy COAs
  and will remain in the COA.
  
  3. It is good that we will have the actual
  acquistion
  price; but I fear that the recent Assets; say assets
  acquired during 2001,2,3 will be having the
  acquistion
  date as 31/12/2006. So in a long run, say after 3 or
  4
  years, users should not think that the asset is
  acquired during 31/12/2006 having the service life
  say
  19 years instead of actual 25 years..am i correct ?
  
  I did a piolet run yesterday on some assets of 1981.
  System does the following.
  
  Scenario is as follows- 
  Asset dated 1981. 
  Actual service life 25 years 
  Depreciation Method - Reducing balance
  Depreciation frequency - Yearly
  
  After import,I acquired assets through GENERAL
  JOURNAL-Fixed asset journal - Acquistion proposal.
  
  System keeps the posting date as 01/01/2006. (Here ,
  I
  didnt understand,why the date is coming as
  01/01/2006
  iinstead of anyother date or it is not asking for
  acquistion date)
  
  Posted all assets. The acquistion date is updated as
  01/01/2006 where as the Depreciation run date is
  the
  date which i imported say 10/01/1981.
  
  I run depreciation after above step. System did the
  depreciation starting from 1981 till 2006 perfectly
  and it is posted on the respective

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

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: 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of AX CONS
 Sent: 28 July 2007 02:36
 To: [EMAIL PROTECTED]development-axapta%40yahoogroups.com
 ;
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Ledger Journals Clean Up

 Does anyone know what is the Ledger Journals Clean Up on the General
 ledger--Periodic--Clean menu?What is that for?

 Thank you

 Gokhan Kestek

 [EMAIL PROTECTED] gokhankestek%40whatisaxapta.com
 [EMAIL PROTECTED] gokhan%40fine.com

 [Non-text portions of this message have been removed]

 Sharing the knowledge on Axapta.
 Visit www.frappr.com/axapta for axapta friends.

 Come and choose your preferred name for Microsoft Dynamics AX on the
 Axapta
 Knowledge Village, Visit www.axapta-knowledge-village.tk

 Yahoo! Groups Links

 



[Non-text portions of this message have been removed]

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-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] uploading balances for Customers 
vendors

 

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

-
Pinpoint customers who are looking for what you sell. 

[Non-text portions of this message have been removed]

 



[Non-text portions of this message have been removed]

[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.

[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 in advance.

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

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 use for reference is just copy
the company without any Transactions and create sample Vendor transactions
and Customer Transactions. After thet check the tables? Which tables have
the data and how importance for you. This method is for updating Vendor and
Customer as posted. So, your Reconciliation reports will show these are not
correct and also, correction functions will not work. Maybe, the another
disadvantages

The another, you could import the transaction as Open Order. So you could
use some Journals for that, check the table names and import the data. That
could be more effective and usefull method for you.

I mean that is up to your customer needs. Let me know if you have question,
email me directly.

Thank you

Gokhan Kestek

[EMAIL PROTECTED]

On 7/31/07, faiqa [EMAIL PROTECTED] wrote:

Just use LedgerJournalTrans table , here you can enter transactions for
vendor/customer/ledger account using account type.

From:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of Tarek Saleh
Sent: Tuesday, July 31, 2007 11:27 AM
To:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
Subject: [Axapta-Knowledge-Village] uploading balances for Customers
vendors

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

-
Pinpoint customers who are looking for what you sell.

[Non-text portions of this message have been removed]

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 
From: gomezdegomera [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Monday, July 30, 2007 2:51:10 PM
Subject: [Axapta-Knowledge-Village] Re: Group by in X++ ??

Hi Varden, the query you posted doesn't work

Query q = new Query();
QueryBuildDataSourc e dsSalesTable;
QueryBuildDataSourc e dsSalesLine;
QueryRun qr;
SalesTable SalesTable;
dsSalesTable = q.addDataSource( tablenum( SalesTable) );
dsSalesLine = dsSalesTable. addDataSource( tablenum( SalesLine) );
dsSalesLine. addLink(FieldNum (SalesTable, SalesId), FieldNum
(SalesLine,SalesId) );
dsSalesLine. JoinMode( JoinMode: :InnerJoin) ;
dsSalesLine. addSortField( FieldNum( SalesLine, SalesId));
dsSalesLine. orderMode( ordermode: :GroupBy) ;
dsSalesLine. addSelectionFiel d(FieldNum( SalesLine, LineAmount),
SelectionField: :Sum);
qr = new QueryRun(q);
while (qr.next())
{
SalesTable = qr.get(tablenum( SalesTable) );
print SalesTable.Delivery Address;
}
pause;

You will see that SalesTable.Delivery Address is `', no fields are filled
I was going to asking you a different way to make the query to work
when I found the problem
You missed an istruction like this

dsSalesLine. addSelectionFiel d(FieldNum( SalesTable, DeliveryAddress, 
SelectionField: :Min);

Notice that you have to specify a type different than
SelectionField: :Database

Bye

--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Varden Morris
[EMAIL PROTECTED]  wrote:

 Hi Anton,
 
 I tried this in a job andI didn't get any error:
 
 Query q = new Query();
 QueryBuildDataSourc e dsSalesTable;
 QueryBuildDataSourc e dsSalesLine;
 QueryRun qr;
 SalesTable SalesTable;
 dsSalesTable = q.addDataSource( tablenum( SalesTable) );
 dsSalesLine = dsSalesTable. addDataSource( tablenum( SalesLine) );
 dsSalesLine. addLink(FieldNum (SalesTable, SalesId), FieldNum
 (SalesLine,SalesId) );
 dsSalesLine. JoinMode( JoinMode: :InnerJoin) ;
 dsSalesLine. addSortField( FieldNum( SalesLine, SalesId));
 dsSalesLine. orderMode( ordermode: :GroupBy) ;
 dsSalesLine. addSelectionFiel d(FieldNum( SalesLine, LineAmount),
 SelectionField: :Sum);
 qr = new QueryRun(q);
 while (qr.next())
 {
 SalesTable = qr.get(tablenum( SalesTable) );
 print SalesTable.Delivery Address;
 }
 pause;
 
 anton_tjiptadi anton_tjiptadi@ ... wrote:
 
 Hi,
 How to create X++ query for Group By ??
 
 My select statement is simply like this (in Transact SQL)
 
 select a.salesid, sum(b.lineamount) from salestable a, salesline b
 where a.salesid=b. salesid
 group by a.salesid
 
 I try to build in X++ like this, but it cause error said that there's 
 no Group by 
 
 dsSalesTable = q.addDataSource( tablenum( SalesTable) );
 dsSalesLine = dsSalesTable. addDataSource( tablenum( SalesLine) );
 dsSalesLine. addLink(FieldNum (SalesTable, SalesId), FieldNum
 (SalesLine,SalesId) );
 dsSalesLine. JoinMode( JoinMode: :InnerJoin) ;
 dsSalesLine. addSortField( FieldNum( SalesLine, SalesId));
 dsSalesLine. orderMode( ordermode: :GroupBy) ;
 dsSalesLine. addSelectionFiel d(FieldNum( SalesLine, LineAmount), 
 SelectionField: :Sum);
 
 Thanks in advance,
 
 
 
 
 
 
 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:
 Axapta-Knowledge- Village-unsubscr [EMAIL PROTECTED] com
 
 Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
 
 
 
  - - ---
 Do you Yahoo!?
 Take Yahoo! Mail with you! Get it on your mobile phone.






  

Shape Yahoo! in your own image.  Join our Network Research Panel today!   
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 



[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

Come and choose your preferred name for Microsoft Dynamics AX on the Axapta 
Knowledge Village, Visit www.axapta-knowledge-village.tk

 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* 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/

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@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: what does prompt() do?

 

prompt() will open a dialog.

--- In Axapta-Knowledge-Village@yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.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 in advance.


 



[Non-text portions of this message have been removed]

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

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 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 use for
 reference is just copy
 the company without any Transactions and create
 sample Vendor transactions
 and Customer Transactions. After thet check the
 tables? Which tables have
 the data and how importance for you. This method is
 for updating Vendor and
 Customer as posted. So, your Reconciliation reports
 will show these are not
 correct and also, correction functions will not
 work. Maybe, the another
 disadvantages
 
 The another, you could import the transaction as
 Open Order. So you could
 use some Journals for that, check the table names
 and import the data. That
 could be more effective and usefull method for you.
 
 I mean that is up to your customer needs. Let me
 know if you have question,
 email me directly.
 
 Thank you
 
 Gokhan Kestek
 
 [EMAIL PROTECTED]
 
 
 On 7/31/07, faiqa [EMAIL PROTECTED]
 wrote:
 
 
 
  Just use LedgerJournalTrans table , here you can
 enter transactions for
  vendor/customer/ledger account using account type.
 
  From:

Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 

[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
  On Behalf Of Tarek Saleh
  Sent: Tuesday, July 31, 2007 11:27 AM
  To:

Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
  Subject: [Axapta-Knowledge-Village] uploading
 balances for Customers 
  vendors
 
  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
 
  -
  Pinpoint customers who are looking for what you
 sell.
 
  [Non-text portions of this message have been
 removed]
 
  [Non-text portions of this message have been
 removed]
 
  
 
 
 
 [Non-text portions of this message have been
 removed]
 
 



   

Yahoo! oneSearch: Finally, mobile search 
that gives answers, not web links. 
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC

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

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.
 
 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:

Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 

[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
  On Behalf Of AX CONS
  Sent: 28 July 2007 02:36
  To:

[EMAIL PROTECTED]development-axapta%40yahoogroups.com
  ;
 

Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
  Subject: [Axapta-Knowledge-Village] Ledger
 Journals Clean Up
 
  Does anyone know what is the Ledger Journals
 Clean Up on the General
  ledger--Periodic--Clean menu?What is that for?
 
  Thank you
 
  Gokhan Kestek
 
  [EMAIL PROTECTED]
 gokhankestek%40whatisaxapta.com
  [EMAIL PROTECTED] gokhan%40fine.com
 
  [Non-text portions of this message have been
 removed]
 
  Sharing the knowledge on Axapta.
  Visit www.frappr.com/axapta for axapta friends.
 
  Come and choose your preferred name for Microsoft
 Dynamics AX on the
  Axapta
  Knowledge Village, Visit
 www.axapta-knowledge-village.tk
 
  Yahoo! Groups Links
 
  
 
 
 
 [Non-text portions of this message have been
 removed]
 
 



   
Ready
 for the edge of your seat? 
Check out tonight's top picks on Yahoo! TV. 
http://tv.yahoo.com/

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

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; thats it... Thanks a lot
for all of you.. I think, all of us might have faced
the problem of Original acquistion date which is
actually we are loosing those who are uploading from
old system to Axapta. I feel Microsoft can release a
permanent patch on this... 

Regards to all,
G Radhakrishnan.


--- novembercalendar [EMAIL PROTECTED]
wrote:

 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 populated
 by the system, 
 each time an acquisition proposal journal is
 posted...So, by 
 populating this field with the 12/31/06 date, in our
 implementation, 
 it dated all acquisition journals as 12/31/06 - this
 is how we 
 posted our original acquisition costs.  Since
 acquisitions were 
 posted in the same period, we didn't have to go back
 to previous 
 periods.
 
 Since we uploaded accumulated deprecation balances,
 all in Dec06, we 
 didn't have to go back prior periods to record each
 month's 
 depreciation - that why we populated the last
 depreciation run date 
 with 12/31/06 - this way, the next journals
 generated for 
 depreciation would be dated 01/31/2007.   
 
 2)  We didn't use dummy COA, instead we have a
 clearing account we 
 used for other items.  We kept the Conversion
 profile in the system, 
 since it's not being used for anything, it's just
 sort-of parked 
 there.
 
 3)  With the new field, initial acquisition date,
 there would be no 
 confusion since the dates will truly reflect the
 date the asset was 
 acquired. This date never changes unless the user
 changes it.  Users 
 understand that the acquisition date (we renamed
 this to last 
 acquistion date) reflects the date of when any
 acquisition activity 
 has been posted.
 
 On the service life, there are the two fields, on
 that holds what 
 the original life time  then what's remaining.  So,
 on the older 
 assets, the life time remaining would be reduced by
 the number of 
 months the asset has already been depreciated by.
 
 Hope this helps,
 
 
 
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, G
 Radhakrishnan 
 [EMAIL PROTECTED] wrote:
 
  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 after posting the
  journal but the Depreciation run date is same as
 I
  kept in the excel sheet(In my case , say
 10/01/1981).
  I afraid this may lead cofusions for the users,
 right?
  
  Regards,
  GR.
  
  
  --- James Flavell [EMAIL PROTECTED] wrote:
  
   Hi
   
   It is fine to load up assets as they oringally
 were
   and run aquistion and
   depreciation for these.  The only thing is you
 will
   need ledger periods
   going back however far you want to post back in
 time
   (even if you setup your
   profile to debit and credit the same GL
 account).
   
   Not sure why you are getting 1/1/2006 but have
 you
   filled in the right
   aquistion date on the asset?  Is 1/1/2006 the
 first
   ledger period you have
   in your system?
   
   
   -Original Message-
   From: Axapta-Knowledge-Village@yahoogroups.com
  
 [mailto:[EMAIL PROTECTED] On
   Behalf Of G
   Radhakrishnan
   Sent: 31 July 2007 10:15
   To: Axapta-Knowledge-Village@yahoogroups.com
   Subject: Re: [Axapta-Knowledge-Village] Re:
 Fixed
   Asset - Acquistion
   
   Hi,
   Thanks a lot for your explanation. Can you
 please
   tel
   me something on the following points;
   
   1. What do you mean by last acquistion date ?
 Is
   there any field available in this name ? Or u
 mean
   to
   say the acquistion date when you run the
   acquistion
   journal for the first time?i.e., immediately
 after
   import of assets.
   
   2. What did you do with the Conversion profile
   Chart
   of Accounts after the acquistion and the
   depreciation
   till 31/12/2006. Because , these are just dummy
 COAs
   and will remain in the COA.
   
   3. It is good that we will have the actual
   acquistion
   price; but I fear that the recent Assets; say
 assets
   acquired during 2001,2,3 will be having the
   acquistion
   date as 31/12/2006. So in a long run, say after
 3 or
   4
   years, users should not think that the asset is
   acquired during 31/12/2006 having the service
 life
   say
   19 years instead of actual 25 years..am i
 correct ?
   
   I did a piolet run

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

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


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of G
Radhakrishnan
Sent: 31 July 2007 15:31
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Fixed Asset - Acquistion

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 after posting the
journal but the Depreciation run date is same as I
kept in the excel sheet(In my case , say 10/01/1981).
I afraid this may lead cofusions for the users, right?

Regards,
GR.


--- James Flavell [EMAIL PROTECTED] wrote:

 Hi
 
 It is fine to load up assets as they oringally were
 and run aquistion and
 depreciation for these.  The only thing is you will
 need ledger periods
 going back however far you want to post back in time
 (even if you setup your
 profile to debit and credit the same GL account).
 
 Not sure why you are getting 1/1/2006 but have you
 filled in the right
 aquistion date on the asset?  Is 1/1/2006 the first
 ledger period you have
 in your system?
 
 
 -Original Message-
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On
 Behalf Of G
 Radhakrishnan
 Sent: 31 July 2007 10:15
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Re: Fixed
 Asset - Acquistion
 
 Hi,
 Thanks a lot for your explanation. Can you please
 tel
 me something on the following points;
 
 1. What do you mean by last acquistion date ? Is
 there any field available in this name ? Or u mean
 to
 say the acquistion date when you run the
 acquistion
 journal for the first time?i.e., immediately after
 import of assets.
 
 2. What did you do with the Conversion profile
 Chart
 of Accounts after the acquistion and the
 depreciation
 till 31/12/2006. Because , these are just dummy COAs
 and will remain in the COA.
 
 3. It is good that we will have the actual
 acquistion
 price; but I fear that the recent Assets; say assets
 acquired during 2001,2,3 will be having the
 acquistion
 date as 31/12/2006. So in a long run, say after 3 or
 4
 years, users should not think that the asset is
 acquired during 31/12/2006 having the service life
 say
 19 years instead of actual 25 years..am i correct ?
 
 I did a piolet run yesterday on some assets of 1981.
 System does the following.
 
 Scenario is as follows- 
 Asset dated 1981. 
 Actual service life 25 years 
 Depreciation Method - Reducing balance
 Depreciation frequency - Yearly
 
 After import,I acquired assets through GENERAL
 JOURNAL-Fixed asset journal - Acquistion proposal.
 
 System keeps the posting date as 01/01/2006. (Here ,
 I
 didnt understand,why the date is coming as
 01/01/2006
 iinstead of anyother date or it is not asking for
 acquistion date)
 
 Posted all assets. The acquistion date is updated as
 01/01/2006 where as the Depreciation run date is
 the
 date which i imported say 10/01/1981.
 
 I run depreciation after above step. System did the
 depreciation starting from 1981 till 2006 perfectly
 and it is posted on the respective posting profile.
 Now the last depreciation run date is 31/12/2006.
 
 Note that the service life remaining is automaticaly
 changed ; we need not put it manually. 
 
 
 Is the above steps are fine ?? Expecting your reply
 reply pleasee
 
 Regards,
 GR.
 
 
 
 --- novembercalendar [EMAIL PROTECTED]
 wrote:
 
  We implemented FA as of 12/31/2006.  On our
 existing
  assets, we used 
  the original acquisition date w/original acq amts,
  original service 
  life, acq dates,  depr run dates.  When we
 imported
  the assets, we 
  used 12/31/06 for the last acquisition date and
  for the Date when 
  depreciation was last run.  For service life
  remaining entered 
  life remaining after 12/31/06 depreciation.
  
  Using 12/31/2006 for the last acquisition date
  allowed us to create 
  acquisition proposals/journals dated 12/31/06. 
  Then, for the next 
  time depreciation proposals are generated, the
  system automatically 
  uses the next month's date.
  
  We set up a temporary profile called Conversion
 to
  have all the gl 
  activity go in  out of one account, since GL
  already had balances 
  representing the asset values.  
  
  We uploaded, via Atlas, accumulated depreciation
  balances thru 
  12/31/06 - posted the entry with a 12/31/06 date -
  also using the 
  conversion profile.
  
  Our IT department than ran an sql for us to change
  the assets' 
  profile from Conversion to the profile now

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-Knowledge-Village] uploading balances for Customers 
vendors

 



Just use LedgerJournalTrans table , here you can enter transactions for
vendor/customer/ledger account using account type.

From: Axapta-Knowledge-Village@yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com 
[mailto:Axapta-Knowledge-Village@yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Tarek
Saleh
Sent: Tuesday, July 31, 2007 11:27 AM
To: Axapta-Knowledge-Village@yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com 
Subject: [Axapta-Knowledge-Village] uploading balances for Customers 
vendors

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

-
Pinpoint customers who are looking for what you sell. 

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

 



[Non-text portions of this message have been removed]

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