You can use Profit/Loss Journal which is pretty easy. But take care when you are posting the Journal. If are trying to use the upload to bring in Starting Inventory, I would suggest you need to check your posting properly. We normally use this journal for Initial Data load, change the posting to wash account.
Hemant
shanmug P <[EMAIL PROTECTED]> wrote:
hi,
Thanks yah it works, but in the case of inventory i'm trying to uplode through movement journal,in which the dimension number is created automatically when im selecting an item in the jn'l but if i try to insert the record with blank dimension no. how to di this,
Any idea...
Shanmugavel
hema krish <[EMAIL PROTECTED]> wrote:
hi shanmug...
i agree with hemant...it should work..
Hav been using the same method too..
Didnt encounter a problem either..
anybody having other suggestions..
Regds
Hema Krish
Hemant Kumthekar <[EMAIL PROTECTED]> wrote:
Hi,
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.
---------------------------------
---------------------------------
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.
[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.
---------------------------------
---------------------------------
Do you have a question on a topic you cant find an Answer to. Try Yahoo! Answers India
Get the all new Yahoo! Messenger Beta 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.
---------------------------------
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call 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.
