Create a template for LedgerJournalTrans table to Import Vendor Invoices, we have been doing this for years now and never had problem
1. Create a Journal Batch. AP >> Journals >> Invoices >> Invoice Journal. Note down the Journal Number.
2. Click on the Lines button and note down the voucher number assigned. Check in the journal how the Voucher number is assigned (In connection with balance, or One Voucher number, GL >> Setup >> Journal >> Journal Names)
3. Now in your spreadsheet you have to have the Journal Number which you created in Step 1, and each line should have Voucher number from Step 2.
Upload the data, then view the upload information. You should be able to see the A/P invoices
Hemant K
somnath jana <[EMAIL PROTECTED]> wrote:
Hi Shanmug !!
The tips may help you, follow the steps
1. Create a temptable according to the value of customer/vendor which fields u r going
to import.
2. Create a defination group for importing the data, type should be Custom and take
the 'Name of table" as u create just now.
3. Import the data into that temporary table.
4. Create a command button into the journal form and write codes on its and click button
5. See the data comes to your journal.
Note in this case it does not require the CSV format just .xls file.
Thanks
Somnath Jana
shanmug P <[EMAIL PROTECTED]> wrote:
Hi ,
I have to import the Opening Balance for the Vendors and customers, for vendors i tried in Vendor Invoice Jn, by template and CSV file. In the earlier case the template is not creating for LedgerjournalTrans in the later case its getting imported but datas are not visible in the form.
It will be really useful if some one give some tips.
Regards
Shanmugavel.
---------------------------------
Yahoo! India Answers: Share what you know. Learn something new. Click here
Send instant messages to your online friends - NOW
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
| Business finance course | Business to business finance | Small business finance |
| Business finance consultant | Business finance magazine | Business finance schools |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
