RE: [development-axapta] Posting Movement Journals

Sun, 14 Mar 2004 18:23:25 -0800

I believe it does create InventTrans because once you create a line you can see it in the inventtrans screen (the inventory button on the lines has the transactions option and so I am pretty sure this only appears when InventTrans is existing) and also in onhand screens...
 
The Copy of lines to another jounral working, indicates that indeed you are missing something during your import and whatever it is is getting fired during the copy.  I suggest you take whatever code is in the copy and base your import around this (or just do import and then copy..I guess this will depend upon how many lines you have).
 
I think from what I remember only counting juornal does not create inventtrans, you might wnat to import into this (which is a TmpInentjournal or seomthing) instead but then you do not have so much control over offset account and also the TransType.
 
James
 
-----Original Message-----
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 11:03 AM
To: [EMAIL PROTECTED]
Subject: SV: [development-axapta] Posting Movement Journals

Hello Harry,
 
Thanks for your reply. I will investigate further...
 
However, I was under the impression that Axapta does not create records in InventTrans, until the actual posting takes place. Am I missing something here ?
 
Thanks in advance.
 
/Jens
-----Oprindelig meddelelse-----
Fra: Deshpande, Harry [mailto:[EMAIL PROTECTED]
Sendt: 15. marts 2004 02:26
Til: '[EMAIL PROTECTED]'
Emne: RE: [development-axapta] Posting Movement Journals

hi Jens!
 
Compare the lines in table InventTrans. Field TransChildRefId is creating the problem.
 
regards
 
harry
 
-----Original Message-----
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 7: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

Reply via email to