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 standard data Like Customer Id,
Currency, ItemId, Qty , price etc (may be from .csv file) and then you
should write the functions, as the data is imported, to create the Sales
order (table and lines).
you should write a class and in this
1. import the data
2. check if the data is correct or not. If the data is correct then
3. write the function to create the sales order
4. write the function to create the sales line (check on the salesTable form
/datasource:salesLine ,how the salesline is created).
cheers,
Girish
-----Original Message-----
From: Nitesh [mailto:[EMAIL PROTECTED]
Sent: 11 October 2004 08:36
To: [EMAIL PROTECTED]
Subject: Re: [development-axapta] Import from excel for invoicing
Hi Akash ,.
Thanks 4 reply,while importing a record of
SalesTable from excel to sales table in Axapta the salesid (num seq ) is
giving problem. When i m giving the next SalesId manually in the Excel
sheet, then the import shows it in the sales table but making another record
result in conflict of Number Sequences between the record imported and the
new record i try to create. Now when i import a record in Sales Table from
an Excel sheet after leaving SalesId blank in Excel, the blank feild is as
it is coming in the Sales Table(Axapta)... i.e no number sequence(Sales ID).
This is not solving my purpose. I want everything to happen normally as
Axapta Standard. Any solutions??? Pls Reply.
Best Regards
Nitesh Seth
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
