When i add consumed entry from item journal get standard journal it show to me error " you must specify source no in item journal line journal template name 'item', journal batch name 'default' ,line no 1000" i try to add source no field in form from table item journal line but when i added it .it not accept to drill down in the form or the table why this error show thanks
Salam Ahmed,
I believe your Item Journal Template "ITEM" does not have a Source Code assigned to it. Typically, the "ITEM" Item Journal Template has a Source Code value of "ITEMJNL" by default. So, my suggestion is to add the desired Source Code to the Item Journal Template table, then run the Get Standard Journal function from the Item Journal worskheet, and hopefully that'll resolve your problem.
Let me know if it works out!
Regards,
Mohamad El-Sadek
MCP, MBSS, MCTS
it is already exist in my table . i open table item journal template i found this value already exist as following
ITEM Item journal 702 40 703 No Item ITEMJNL No 7303 Inventory Posting - Test Item Journal Item Register - Quantity Warehouse Register - Quantity
the problem still found
can any one help me
mr mohammed i test what you say but it not solved the proplem until now can you explain more
Dear Ahmed,
Is there a way for you to run the debugger? If you are a Super user, you can turn it on from Tools->Debugger->Active in the Classic Client. Also, which version of NAV are you using? What I'm trying to see here if we can find the location in code that's causing your problems.
On another note, would you be able to create some temporary/dummy standard journals and fill them in with some information, then try to get them from the Item Journal? Maybe the Standard Journal you were using earlier didn't the have the Source Codes set on the lines section.
Let me know .
Regards.
Nav 2009 r2 my version and when i run debugger this print screen show to me
www.mediafire.com/view
please help me if possible
thanks
OK, it seems that the field in question is NOT the "Source Code" field, but the "Source No." field, which is an internally used field and is neither editable nor visible in the Item Journal.
I've ran the same procedure as you have mentioned in your first, and I noticed the Source No. field was left blank by the system. However, I was able to post it just fine, and the system didn't give me any error messages neither in the "Get Standard Journals" function, or when posting. Are you sure that this feature isn't customized in your system?
Also, regarding the debugger, please ensure that "Breakpoint on Triggers" does NOT have a checkmark against it. Then, run the process again. This time you should get an error message and a yellow arrow in the code that shows were execution stopped. That's the point of code I want to look at.
Please advise.