] On Behalf Of Irshad
Sent: Saturday, April 17, 2010 7:58 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] IMPORTING THE DEMO DATA
Hi All
I have installed and configured my AX without any account etc. now I got sample
demo data which contosbase. how can I import
Sent: Sat, 17 April, 2010 10:27:34 PM
Subject: [Axapta-Knowledge-Village] IMPORTING THE DEMO DATA
Hi All
I have installed and configured my AX without any account etc. now I got sample
demo data which contosbase. how can I import it into AX 2009. can somebody help
me for its import?
than
Hi All
I have installed and configured my AX without any account etc. now I got sample
demo data which contosbase. how can I import it into AX 2009. can somebody help
me for its import?
thanks
Irshad
Hi,
I am importing Sales order via excel.
The tables included are SalesTable,SalesLine,InventTrans and InventDim.
Importing is succesful.
But when I post the imported SO, I am getting error "Physical remainign qty
in the inventory unit must be other than zero".
There are no set up problems with U
hai anitha thanks,
Can tell me how the csv type file is to import as a custom type and how to
map the fields . exactly..
thanks
kishore
--- On Thu, 31/12/09, Anitha S wrote:
From: Anitha S
Subject: Re: [Axapta-Knowledge-Village] Importing the customtype file using
defination group
Hi Kishore,
Try to include the logic of creating number sequence in "Import Criteria "
tab of definition group.
Hope it helps !!!
Regards,
Anitha
On Mon, Dec 28, 2009 at 5:44 PM, kishore wrote:
>
>
> Hai all,
>
> I have a issue like while importing the custom type file into axapta by
> creati
Hai all,
I have a issue like while importing the custom type file into axapta by
creating a defination Group.
How to write a code in the conversion tab (In order to generate numberseq
(voucher) while importing) in the defination group of custom type file using
table ledgerjournaltrans.
I hav
ble, if u check on address table, update/insert method, it
updates/insert the records in DirpartyAddressRelationship &
DirPartyAddressRelationshipMapping tables.
Hope this helps...
Regards
Manish
--- On Tue, 24/11/09, Anitha S wrote:
From: Anitha S
Subject: [Axapta-Knowledge-Village] Imp
Hi,
I am trying to import Vendor and their respective addresses..
I have included
DirpartyTable,Address,DirpartyAddressRelationship,DirPartyAddressRelationshipMapping
and VendTable in Excel Template.
But how could we fill in the details for DirpartyAddressRelationship &
DirPartyAddressRelationshi
components and click OK the data will be imported in AX.
Hope this will help u. A sample Template is attached.
-Tushar
--- On Mon, 5/10/09, Belal Marzouk wrote:
From: Belal Marzouk
Subject: [Axapta-Knowledge-Village] Importing & Exporting BOM
To: Axapta-Knowledge-Village@yahoogroups.com
D
Hello,
How can I export and import BOM including its components? How can I import them
too?
Regards,
Belal
.
Dear All,
I want to use group by tech in AX2009 Reports.
data save this way in table
Descripotion Qty
CostPrice SalesPrice
Television 1
5000 6000
Television
Hi ,
I assume you are doing *Excel import*.
To import the data in Empl Table *(without address information)* ,it is
enough if you use *EmplTable *and *DirpartyTable*.Kindly check the
attachment.
To import with Address, include DirpartyAddressRelationship and address
Tables.
Hope this would have
Dears,
kindly anyone can help me about importing employee table?
Till now i m sure that its a must (or a prerequisit) to import the "global
address book" but also there are some virtual tables that wants to be imported
or created automaticaly.
The employee table, is like the Item Master table
what is necessary, then do what is possible,
and suddenly you are doing the impossible.
www.robinhood.in
To: Axapta-Knowledge-Village@yahoogroups.com
From: maryann.h...@gmail.com
Date: Fri, 20 Mar 2009 05:49:14 -0600
Subject: Re: [Axapta-Knowledge-Village] Importing Question
You
You can never import directly into an AX database because you cannot
succeed in setting the record ids.
You can try to use the AX Admin import - but there is one new
complexity with AX 2009 - the global address book must be loaded with
customer data as well and I personally have not been very succ
Hi Everyone, I'm fairly new to Ax2009. My question is on importing data into
the CustTable.
I have about 50K rows of customer info to import into Ax. Can I import directly
into the database or should I do this through AX Admin/Data export-import form?
Thanks
Check your number sequence.
Regards
From: Anitha E
Sent: Monday, January 12, 2009 1:51 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Importing a posted journal in Ax 2009
Hi all,
I am working on Ax2009 - AIf.
When I am trying to import a posted
Hi all,
I am working on Ax2009 - AIf.
When I am trying to import a posted journal in GL,I am getting the following
error:
“Journal has already been posted and, consequently, is not open.”
Do you have any idea about the classes to be refeered in UpdateNow() and
PrepareForSave methods in Axd clas
Hi All,
I am in the process of implementing AX 2009. I have already imported all the
basic data in the system like vendors, customers, items and bank information.
The problem which i am facing is how do i import the existin open balances from
the legacy system to AX 2009?
What all are the detai
Dear All,
I am uploading an excel sheet to AX 4.0 with more that company ID record in the
sheet however the system gives an error to accept this companies but when i use
only 1 company in the sheet the system works,
so anybody knows how we can upload records to multiple companies in 1 she
after you import journal you can copy it and post the journal which you copy it
-
Thanks
Wael Elfarahati
Mob: +966502768276
From: Rajesh Talpade
Sent: Tuesday, October 07, 2008 10:51 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Importing of Stock
Gurus,
I want to import stock into Ax 4.0 SP2. For this I have imported a movement
journal and lines. At the time of posting, it fails as it is looking for a line
of the status ordered in inventtrans. So next I imported a line for each of the
lines in a movement journal. Now it allowed me to po
Hi all,
I am trying to import the opening balances of the Items. I exported Invent
journal trans,Invent dim tables and entered the data in the templates.The
Journal number(Profit and loss) is also entered in the template.I tried to
import the data to the Profit and loss journal, I could see the
Dear Trinadh,
For importing item master, you have to import following tables
1.inventTable.
2. InventTableModule.
3. InventItemLocation
4. InventDim.
When importing inventItem location ,you have to concentrate on the
dimension
Dear Ali,
We populated the tables (InventTableModule and InventItemLocation) and
tried to import the data in Ax4.0 Sp2. But still the data could be seen only in
the table level. Could you please suggest the process of importing the data.
Reply to this mail asap is highly appreciated.
Hi,
To import data from excel use this code
static void importformexcel(Args _args)
{
SysExcelApplication excel;
SysExcelWorkbooks books;
SysExcelWorkbook book;
SysExcelWorkSheets sheets;
SysExcelWorkSheet sheet;
str _filepath = "C:\\Test.xls";
loginProperty log
Hi,
I want to export data from a table to excel file and after doing
modifications in the excel i want to import the file back to axapta.
I want this using X++ code as I have already worked with the
"import excel" using excel template.
rounded correctly Axapta will complain.
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Dynamics
Freak
Sent: 01 August 2007 15:46
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Importing Opening
Hi Guys,
For migrating the trial Balance from a legacy system to AX, I imported ledger
journal transactions into the ledgerjournaltrans table.
On validating the journal, the system shows up an error saying that
"Amount is specified too detailed in relation to the rounding of the currency.
Err
Hi Barath,
Check out this entry from Dax Guy's blogit should help you
http://daxguy.blogspot.com/2007/04/excel-import-custom.html
Regards
Kamalakannan
http://casperkamal.spaces.live.com
On 6/28/07, barath <[EMAIL PROTECTED]> wrote:
>
>
>
> Hi All,
>
> I need to import(Excel format) transac
Hi All,
I need to import(Excel format) transactions in to Ax for
posting a journal entry.
Is there anyway to import data from two tables?
It will be great if anybody can help me in this issue.
Regards,
Barath
[Non-text portions o
posting is provided "AS IS" with no warranties, and confers no rights.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anisha Fakir
Sent: 12. april 2007 11:33
To: [EMAIL PROTECTED]
Subject: Re: [Axapta-Knowledge-Village] Importing of Item Coverag
anks
Regards,
Anisha
- Original Message
From: Anders Sorensen <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2007 11:17:29 AM
Subject: RE: [Axapta-Knowledge-Village] Importing of Item Coverage data for
Master Planning
Hi,
C
k if it helps!!
gards,
Ashwani Jain
- Original Message
From: Anders Sorensen <[EMAIL PROTECTED]>
To: "Axapta-Knowledge-Village@yahoogroups.com"
Sent: Wednesday, 11 April, 2007 5:17:29 PM
Subject: RE: [Axapta-Knowledge-Village] Importing of Item Coverage data for
Master Planning
ge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of anishafakir1
Sent: 10. april 2007 16:27
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Importing of Item Coverage data for Master
Planning
Hi, I am trying to import data into the Item Coverage tabl
Hi, I am trying to import data into the Item Coverage tables but the
information is not displaying on the front end (form).
If the ReqItemTable is browsed the data I imported is popultated in
the table. I tried synchronising and ran a Consistency check but does
not fix the problem of data not d
le on the Address table or Cust Table.
Hemant K
- Original Message
From: g_coope <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Monday, February 26, 2007 11:28:40 AM
Subject: [Axapta-Knowledge-Village] Importing Address Data
Hello.
Can anyone help with
Hello.
Can anyone help with data import of addresses? Specifically, we are
trying to import employee records.
I have two issues:
1)What is the correct set of keystrokes to define the hard return in
the 'Streetname' field?
2)I have already imported the postcodes (zipcode records) into table
z
Hi everyone,
I am facing issue in free text invoice import. Its not importing Address
field against customer accounts. In "CustInvoiceTable", in Customer Account
field I entered customer account and didn't add anything in address field
because it should bring the address detail from customer m
hai
what will happen to the usr layer when we import 'var' layer objects.
will it overwrite the 'usr' layer or 'usr' will remain same?
and at the time of running application what will happen?
will it run on old 'usr' layer ?
Hi group,
Getting problem when Importing data (smmQuotationLines table) from
excel sheet
I want to insert records in smmQuotationTable and smmQuotationLine
tables from excel sheet. I am able to insert record for
smmQuotationTable.
But getting problem while inserting records for smmQuotati
Hi,
To be certain that the data can be imported you could do this:
Start the definition group wizard and create a new excel template. Make
sure that you select the zipcode table. Now finish the wizard.
From this point you can fill the newly created excel file, import it
with the import butto
Hi all,
I am trying to import a XLS file that containing ZIP codes into the
CustTable. But it was failed as the ZIP codes always imported with
blank values while other information are correct.
What should the column layout/format of the XLS file be to make the
function work?
Sharing
Hi,
you can do it with the COM, COMVariant and COMDispFunction Classes.
Betty
__
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193
Sharing the knowledge on Axapta.
Vi
Hi,
I have an application where i have linked an excel sheet to a form.
A user can open the excel sheet by clicking a button on the form.
Once opened, the user would be entering\deleting\updating some data in
the excel sheet.
The excel macros would do some processing of the data entered/modifi
6 10:51
> À : Axapta-Knowledge-Village@yahoogroups.com
> Objet : Re: [Axapta-Knowledge-Village] importing class
>
>
> hey !, that question, is from axapta programming exam...
> mmm correct answer is "synchronizing"...
>
>
>
> On 3/13/06, gopala krishna <
llage@yahoogroups.com
Objet : Re: [Axapta-Knowledge-Village] importing class
hey !, that question, is from axapta programming exam...
mmm correct answer is "synchronizing"...
On 3/13/06, gopala krishna <[EMAIL PROTECTED]> wrote:
>
> after imporing the class do we need to d
hey !, that question, is from axapta programming exam...
mmm correct answer is "synchronizing"...
On 3/13/06, gopala krishna <[EMAIL PROTECTED]> wrote:
>
> after imporing the class do we need to do any additional steps like
> recompiling OR synchronizing
>
>
>
>
> Thanks,
> Gopal
>
>
> -
hi gopala,
the axapta compiles the class it self while importing, if you are getting
some error than you need to check it.
bye
Kumar
gopala krishna <[EMAIL PROTECTED]> wrote:
after imporing the class do we need to do any additional steps like
recompiling OR synchronizing
after imporing the class do we need to do any additional steps like
recompiling OR synchronizing
Thanks,
Gopal
-
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all
.
Regards,
Steeve...
-Message d'origine-
De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la
part de shanmug P
Envoyé : 20 février 2006 08:24
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Importing The Master Table
Hi,
Hi,
I'm trying to import the Item Master (Excel Import), Can any one say what
are the Relational Tables i have to consider. I have user only the Invent
Table, the datas are imported in to the Table but its not visible in the Item
Card.
Give some Suggestion.
Regards
Shanmugavel
Wish u a happy and prosperous new year, Yah thanks man, its working fine. Cheersss Shanmugsreek maska <[EMAIL PROTECTED]> wrote:Hi there, If you exported ledger table and then if you are able to import it then it would show in COA... try that again.. Make sure you a
Hi there, If you exported ledger table and then if you are able to import it then it would show in COA... try that again.. Make sure you are exporting Ledger table. regards sreeSend instant messages to your online friends http://in.messenger.yahoo.com
Sharing the knowledge o
Hi Sree, Thanks for your reply. Actually i want to impot the Master datas in to the system, Like vendor master, customer master and Accounts of COA also. 1. In the case of COA i have created a template ( Using wizard), and in the template we have entred the datas. Then i tried to i
Hi shanmug, I hope you have exported Ledger table for the COA... If you did that there are 2 ways to enter data in to Excel. 1 . Either convert the data to a text format (ie is copy it to a notepad and save) and then copy that data to XL tempate. 2 . In the Excel sheet change
Hi All, My requirement is to import the chart of account names in the XL Template to the syetem.I have created XL Template from the System using the wizard, for Object i have selected chart of accounts ( While creating the template) , while importing the datas its importing in the "CACLedger tab
ed by which "owners".
/Jens
-Oprindelig meddelelse-
Fra: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af Andrew
Staples
Sendt: 12. december 2005 20:57
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: [Axapta-Knowledge-Village] Importing BOM's into
Has anyone created a process flow for importing BOM's into Axapta? As an
example, what Axapta tables need records in order to link all the uploaded
items, and what are the links between the Axapta tables? Any available
templates?
We've got all the BOM's from the old system, just need to know whi
list - SIS
> Sendt: to 19-05-2005 06:55
> Til: Axapta-Knowledge-Village@yahoogroups.com
> Emne: RE: [Axapta-Knowledge-Village] Importing Items
> - Help!
>
>
>
> hi
>
> when u r importing to inventitemlocation,
> inventdimid field should be filled with som
Sent: Wednesday, May 18, 2005 7:24 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Importing Items - Help!
Hello Everyone!
Well I need some help again! We are trying to import our Items Into
Axapta t
24
PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject:
[Axapta-Knowledge-Village] Importing Items - Help!
Hello Everyone!
Well I need some help again! We are trying to import our Items
Into Axapta through the Import Utility - via CSV files (.DAT
Files).
Anyway I have crea
, 2005 8:54 AM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject:
[Axapta-Knowledge-Village] Importing Items - Help!
Hello Everyone!
Well I need some
help again! We are trying to import our Items Into Axapta through the Import
Utility - via CSV files (.DAT Files
correctly due to one to many commas.
Maybe this little bit of info will help someone out in
the future!
thanks,
Brandon
From: Brandon George
[mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 9:54
AMTo: 'Axapta-Knowledge-Village@yahoogroups.com'Subject:
[Axapta-Knowledg
Title: Message
Hello
Everyone!
Well I need some help again! We are trying to import our Items Into
Axapta through the Import Utility - via CSV files (.DAT
Files).
Anyway
I have created a test item, and then looked in the database to see what Tables
Are updated, and what I have found
Hi..
I need some help.
I am importing some tables, which i exported from other System.
And It is importing the table but it is not accessable.
Instead it is showing the table, but it is not accepting the format, this is in demo version.
If I do same thing with standard app. it works.
Tell m
Yeah. I agree with Girish. We also developed seperate classes/ validations for importing data espcially for invoices / Banking.
Girish B <[EMAIL PROTECTED]> wrote:
Hi Raj, the trainings are conducted by Microsoft itself orit might be outsourced to some other organisation. youcould find th
Hi Raj,
the trainings are conducted by Microsoft itself or
it might be outsourced to some other organisation. you
could find the training scedule from the partner site.
good luck.
cheers,
Girish
--- veeraraj govindasamy <[EMAIL PROTECTED]> wrote:
-
Hi Girish
Hi Girish
Can u let me know about the Training courses
conducted for the Axapta or where i can the
information.
Thanks
RAJ
--- Girish B <[EMAIL PROTECTED]> wrote:
> Hi Nitesh,
>
> Import function like the one you are doing should be
> done when we need to import data in the tables whic
Hi Nitesh,
Import function like the one you are doing should be
done when we need to import data in the tables which
usually dont need any other functions to run (Like BOM
tables).
When you want to create the Sales order from the
excel data then it is better if you just import some
of the stan
Hi Nitesh
Easy way to do it.
1. Convert it to csv file.
2. Open Administrator>Periodic>Data Export/Import>Definition Group
3. Create a new custom type Defn. Group
4. Select Table name, specify Path name
5. Select Field Setup, specify the field no
6. Run import
Hope it will help you.
Rgds
Krish
Hi all,
How can i import data from excel for transaction of sales order form.i e want to
enter the data through excel and want to put it in sales order form for
invoicing.Is it possible??? :-(
Regards
Nitesh
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
Hi,
You have to creat new company and just choose DMO comany data file from setup disk or
directory in data import periodic function. And everythign should be fine.
Darius
>Hi
> I have Axapta installed on my machine. I tried to
>import sample company data (DAT). But i cant see any
>sales ord
Hi
I have Axapta installed on my machine. I tried to
import sample company data (DAT). But i cant see any
sales orders, Items etc. I think something went wrong.
How can i create/import data for another company?
It would be rgeat if someone explain the steps to get
sample data to work.
Thanks,
M
75 matches
Mail list logo
