Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
IS this Possible in Navision
ranjityadav
Member Posts: 92
I want to create a Item in Navision but i dont want it to effect mine Item Ledger.
Like It will not post ILE while am doing Purchse Receipt.
If it is possible then please let me know.
Like It will not post ILE while am doing Purchse Receipt.
If it is possible then please let me know.
0
Answers
NAV Freelance Consultant
The whole point of purchasing an Item is so that you can sell it. And in order to know what inventory you have available to sell it needs to be in the item ledger. What is it exactly that you are trying to accomplish?
My Blog - nav.education
As i can't book G/L Directly and these items are stationary items like rubber,pen,pencil, paper roll etc.
As purchase dept. wants to know the last purchase price before raising the new Purchase Order thats the reason of creating the Items and these are non-inventorized items.
Thats why i asked is it possible or not.
But i also agree with you if a item is created in ERP, while doing any transaction for that purticular item will hav the ILE.
http://ssdynamics.co.in
Thanks for your reply.
If we do the inventory value zero thats means it will post the value entry with 0 cost but Ile is posted in this transaction too.
here mine concern is not to effect ILE.
How does Zero effect your ILE?
Is this office suppies?
Don't raise PO's when purchasing office supples then.
Or raise the PO - print it out & submit it to whomever you get these goods from & delete the PO.
Or create it as a quote that is just their for reordering purposes but never goes to the next step.
I don't see where another dozen ILE lines a year with value zero cause any possible harm.
It's probably 1 percent of 1 percent of 1 percent of your yearly ILE's you're worring about here.
http://www.BiloBeauty.com
http://www.autismspeaks.org
i cant delete the PO too as purchase dept. need the last purchase price for that Item.
Its not sationary oly some other consumables also which not required to hit the ILE.
http://ssdynamics.co.in
In your case you should not ask if something is possible in NAV. Rather describe the scenario and requirements and you'll get a much better answer.
Right now we can only guess...
Abhishek
I tired.
this is not possible in Navision and that logical too..
I still stick to my statement of what's the harm if the entries are zero?
Who's counting how many ILE they have?
Is the real concern here slowing down the system or something?
THose entries will not slow doen the system
http://www.BiloBeauty.com
http://www.autismspeaks.org
My little suggestion:
In the Purchase Line table add a function working on Item type lines only.
This function should be able to retrieve the costing account on which the line should be charged, according to General Ledger Posting Setup and change Type and No. values into G/L Account and Account No. leaving all the other data as they are.
In the Item table add a boolean field "Switch to G/L Account"
Have the users enter purchase order lines as type Item for all your Items
Add some code to codeunit 415 so that, when a PO is released, for each Item line the "Switch to G/L Account" is checked and, if true, the above said function is issued.
If you add on the Purchase Line table a field where the original Item No. is stored before switching to g/l account, you may even reverse the process if the order is reopened.
Hope this helps
Dynamics NAV MVP (2005-2010)
this is not possible to create an item which will not effect the ILE.
I agree with you all.
Have a look at the Swiss version, they have a property "No Stockkeeping" on the item card that does exactly what you want.
You can have a look at the code behind it, I do not know which other countries have this field too.
This is what the help says about it:
No Stockkeeping Field
The Item Table
This option on an item card causes no item ledger entry to be generated when that item is posted.
If you really need something that does not post item ledger entries, only values and where there is no stock (it will always appear as 0), this is what you need, just look at how it is done in Switzerland.
can u please share this code with me?
I just clicked on an old bookmark yesterday, it was Mibuso, and saw this question.
I still remembered this was possible in Switzerland. So just download the Swiss version from partnersource and have a look or ask your partner to have a look at it for you. If I remember well it really are only 1 new field and a few lines of code.
Good old NAV times, I actually miss them