Hello
James,
Thanks
for your answer. I am actually not loading in data directly in SQL. Everything
happens through Axapta import based on *.def and *.dat file.
One
interesting thing, though: I noticed that if I use the Copy function to put
all imported lines into another journal, I am able to post the - new - journal
without any problems. Does that ring a bell ?
Thanks
in advance.
/Jens
-----Oprindelig meddelelse-----I think you need other tables...I believe InventTrans is created for journal
Fra: James Flavell [mailto:[EMAIL PROTECTED]
Sendt: 15. marts 2004 00:55
Til: [EMAIL PROTECTED]
Emne: RE: [development-axapta] Posting Movement Journals
lines and if you dont have that then you will get the error you describe.
Direct data import to SQL is not recommended, should always go via Axapta
import script and fire off all the code that usually gets done with a manual
entry.
-----Original Message-----
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 8:02 AM
To: [EMAIL PROTECTED] Com (E-mail)
Subject: [development-axapta] Posting Movement Journals
Hello there,
I was wondering if anyone could give me a hint regarding Movement Journals.
Let's say that I import 1 line into the Movement Journal with all necessary
information. When I validate, no errors are found. However, when I post, I
get this error:
Error Posting - Journal\Journal: 1\Voucher: 10015_062\Line No: 1,00 Cannot
receive quantity 9,00, as stock transactions with status 'Ordered',
'Arrived' or 'Registered' are insufficient.
Error Posting - Journal\Journal: 1 The journal is not posted and the update
is cancelled.
If I enter the same line manually, i.e. with the same pieces of information,
I can post without problems.
I have checked the above information in InventJournalTrans with the SQL
Server Enterprise Manager, and both lines (imported line and manually
entered line) are 100% alike.
Do I have to populate other table(s) in order to import and post ?
Thanks in advance.
Axapta 3.0 SP1
Best regards,
Jens Strandberg
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
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.
