You are Here
Scrapping items to different G/L accounts in Dynamics NAV and Business Central
Application Business Central Dynamics NAV Featured Finance Inventory

Scrapping items to different G/L accounts in Dynamics NAV and Business Central

One of the questions I get very often is: how do I control which G/L accounts are being used, when the inventory is adjusted in an Item Journal?

Figuring out which accounts are used when adjusting the inventory in Dynamics NAV and Business Central has always been a bit of a puzzle.

The inventory batch will determine the account, based on the type of adjustment made. This means that the account will be different depending on which Entry Type is used on the item journal line.

Purchase: will use the Direct Cost Applied Account from the Gen. Posting Setup

Sales: will use the Cost of goods sold (COGS) account from the Gen. Posting Setup

Positive Adjustment: will use the Adjustment account from the Gen. Posting Setup

Negative Adjustment: will use the Adjustment account from the Gen. Posting Setup

So, if the General Posting Setup look like this:

Then, based on the General Product Posting Group from the item, combined with the blank General Business Posting Group the accounts shown below are used.


Let’s make an example (Item 80001 and 80002 have General General Product Posting Group: RETAIL).

An Item journal like this:


Will give this result:


A line with the Entry Type of sales:


Will give this result:


Notice that the Adjust Cost – Item Entries will of course identify the cost amount of the sales transaction and therefore only withdraw the cost amount from the inventory to add to the Cost of Goods Sold account.

Lastly, a line with the Entry Type of Positive Adjustment or Negative Adjustment like these:


Will give this result:


This all confirms the rules above. But this also means that depending on the purpose of the inventory adjustment, I can target these three accounts in different situations:

Sales: I want scrap items and post the cost to the Cost of Goods Sold account.

Purchase: I want to adjust the inventory positively and post the negative cost to the Direct Cost Applied account.

Positive or Negative adjustments: I want to adjust the inventory positively or negatively and post the cost to the Adjustment account.

But what if I want to target other accounts?

The easy way to do that, out-of-the-box, is to use custom General Product Posting Groups.

So, I create two new General Product Posting Groups called SCRAP and EXPIRED. I have also made special G/L accounts for the new posting groups:


The only field used is the Inventory Adjustment Account and it is therefore only possible to use these General Product Posting Groups with Entry Types: Negative or Positive Adjustment.

Next, I need to add the General Product Posting Group to the Item Journal:


Posting will give this result:


Exactly as I wanted, the costs are posted to the new accounts.

Post Views: 1,002
Share
Facebook Twitter Pinterest Linkedin

Related Posts

87 thoughts on “Scrapping items to different G/L accounts in Dynamics NAV and Business Central”

  2. hello there and thank you for your information – I have definitely picked up something new from proper here. I did however expertise several technical points using this web site, since I experienced to reload the website lots of occasions previous to I may get it to load correctly. I had been puzzling over if your web host is OK? Now not that I am complaining, but slow loading circumstances occasions will very frequently impact your placement in google and could damage your high-quality ranking if advertising and ***********|advertising|advertising|advertising and *********** with Adwords. Well I am including this RSS to my e-mail and can glance out for a lot extra of your respective fascinating content. Make sure you update this again soon..

  3. Hello just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Safari. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I figured I’d post to let you know. The design look great though! Hope you get the problem fixed soon. Cheers

  4. I’m impressed, I must say. Really rarely do I encounter a blog that’s both educative and entertaining, and let me inform you, you could have hit the nail on the head. Your concept is excellent; the issue is something that not enough people are talking intelligently about. I’m very blissful that I stumbled throughout this in my seek for something relating to this.

  8. Admiring the persistence you put into your site and in depth information you provide. It’s nice to come across a blog every once in a while that isn’t the same outdated rehashed information. Great read! I’ve saved your site and I’m adding your RSS feeds to my Google account.

  11. A large percentage of of what you claim is astonishingly accurate and that makes me ponder why I hadn’t looked at this with this light before. This article really did turn the light on for me as far as this specific issue goes. Nevertheless there is one point I am not too comfy with and while I make an effort to reconcile that with the central idea of the issue, permit me observe exactly what all the rest of the subscribers have to point out.Nicely done.

  12. I have to get across my affection for your kind-heartedness for folks who absolutely need help with this important matter. Your special dedication to passing the solution up and down appears to be especially interesting and have regularly encouraged guys just like me to realize their pursuits. Your new helpful recommendations means so much to me and even more to my fellow workers. Warm regards; from each one of us.

  13. What’s Happening i am new to this, I stumbled upon this I have found It absolutely useful and it has helped me out loads. I hope to contribute & help other users like its aided me. Good job.

  15. Great post. I was checking continuously this blog and I am inspired! Extremely useful info specifically the remaining phase 🙂 I maintain such information much. I was seeking this particular information for a very long time. Thanks and best of luck.

  16. Gamebet2 is pretty basic, but sometimes that’s what you want. Simple, easy to navigate. Got a few go-to games there now. Give it a try if you are after something straightforward! Link here: gamebet2

  17. I don’t even know how I ended up here, but I thought this post was great. I don’t know who you are but certainly you are going to a famous blogger if you are not already 😉 Cheers!

  18. Hi there! This is my 1st comment here so I just wanted to give a quick shout out and tell you I truly enjoy reading through your articles. Can you recommend any other blogs/websites/forums that go over the same subjects? Thank you so much!

  19. Greetings from Los angeles! I’m bored at work so I decided to check out your blog on my iphone during lunch break. I love the info you provide here and can’t wait to take a look when I get home. I’m shocked at how quick your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyways, very good blog!

  20. Attractive section of content. I just stumbled upon your weblog and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently fast.

  23. Hello team!
    I came across a 152 valuable site that I think you should take a look at.
    This site is packed with a lot of useful information that you might find helpful.
    It has everything you could possibly need, so be sure to give it a visit!
    https://oneframework.net/the-montessori-nursery-experience-a-unique-approach-to-early-education/

    Furthermore don’t neglect, everyone, — one constantly may in this publication locate responses to your most tangled queries. Our team made an effort to lay out all of the information in an most easy-to-grasp manner.

  24. Looking for a casino? 8mbets Slots, table games, and live casino all in one place. Quick login, convenient registration, modern providers, stable payouts, and comfortable player conditions.

  25. Playing at the casino? 8mbets Play online for real money. We offer a wide selection of slots, live dealers, fast payments, easy login, and exciting offers for new and returning players.

  26. Do you love gambling? jwin7 Online is safe and convenient. We offer a wide selection of games, modern slots, a live casino, fast deposits and withdrawals, clear terms, and a stable website.

  27. Продажа IQOS ILUMA https://ekb-terea.org и стиков TEREA в СПб. Только оригинальные устройства и стики, широкий ассортимент, оперативная доставка, самовывоз и поддержка клиентов на всех этапах покупки.

  28. Купить IQOS ILUMA https://spb-terea.store и стики TEREA в Санкт-Петербурге с гарантией оригинальности. В наличии все модели ILUMA, широкий выбор вкусов TEREA, быстрая доставка по СПб, удобная оплата и консультации специалистов.

  29. IQOS ILUMA https://terea-iluma24.org и стики TEREA — покупка в Москве без риска. Гарантия подлинности, большой выбор, выгодные условия, доставка по городу и помощь в подборе устройства и стиков.

  33. My spouse and I stumbled over here by a different web address and thought I may as well check things out. I like what I see so now i am following you. Look forward to looking at your web page repeatedly.

  34. Hello team!
    I came across a 152 very cool site that I think you should browse.
    This platform is packed with a lot of useful information that you might find valuable.
    It has everything you could possibly need, so be sure to give it a visit!
    https://www.vallesdelsol.cl/cosas-que-deberias-priorizar-comprar-cuando-te-mudes-solo/

    Furthermore don’t neglect, guys, — you always are able to inside this article find answers to your the very complicated inquiries. Our team made an effort to present all of the data using an extremely easy-to-grasp way.

  37. the best adult generator virtual partner 18+ create erotic videos, images, and virtual characters. flexible settings, high quality, instant results, and easy operation right in your browser. the best features for porn generation.

  38. I’d should test with you here. Which is not one thing I usually do! I enjoy studying a post that will make individuals think. Additionally, thanks for permitting me to remark!

  41. I’ve been surfing online more than 3 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my view, if all web owners and bloggers made good content as you did, the internet will be a lot more useful than ever before.

  42. I have been exploring for a bit for any high quality articles or weblog posts in this sort of area . Exploring in Yahoo I at last stumbled upon this site. Reading this info So i’m happy to exhibit that I have an incredibly just right uncanny feeling I discovered just what I needed. I most without a doubt will make certain to do not overlook this site and give it a glance regularly.

  43. Hello everyone!
    I came across a 153 great site that I think you should dive into.
    This resource is packed with a lot of useful information that you might find valuable.
    It has everything you could possibly need, so be sure to give it a visit!
    https://bitcios.com/five-simple-tips-on-how-to-overcome-anxiety/

    And don’t neglect, folks, that a person constantly may within this publication discover answers to address your the absolute complicated inquiries. We attempted to explain all data via the very understandable manner.

  44. This is the precise weblog for anybody who desires to seek out out about this topic. You understand so much its nearly exhausting to argue with you (not that I truly would want…HaHa). You definitely put a brand new spin on a topic thats been written about for years. Nice stuff, simply nice!

  46. Жіночий портал https://soloha.in.ua про красу, здоров’я, стосунки та саморозвиток. Корисні поради, що надихають історії, мода, стиль життя, психологія та кар’єра – все для гармонії, впевненості та комфорту щодня.

  47. Сучасний жіночий портал https://zhinka.in.ua мода та догляд, здоров’я та фітнес, сім’я та стосунки, кар’єра та хобі. Актуальні статті, практичні поради та ідеї для натхнення та балансу у житті.

  48. Портал для жінок https://u-kumy.com про стиль, здоров’я та саморозвиток. Експертні поради, чесні огляди, лайфхаки для дому та роботи, ідеї для відпочинку та гармонійного життя.

  54. Сайт города Одесса https://faine-misto.od.ua свежие новости, городские события, происшествия, культура, экономика и общественная жизнь. Актуальные обзоры, важная информация для жителей и гостей Одессы в удобном формате.

  55. Сайт города Винница https://faine-misto.vinnica.ua свежие новости, городские события, происшествия, экономика, культура и общественная жизнь. Актуальные обзоры, важная информация для жителей и гостей города.

  56. Новости Житомира https://faine-misto.zt.ua сегодня: события города, инфраструктура, транспорт, культура и социальная сфера. Обзоры, аналитика и оперативные обновления о жизни Житомира онлайн.

  57. Портал города Хмельницкий https://faine-misto.km.ua с новостями, событиями и обзорами. Всё о жизни города: решения местных властей, происшествия, экономика, культура и развитие региона.

  58. Новости Львова https://faine-misto.lviv.ua сегодня: городские события, инфраструктура, транспорт, культура и социальная повестка. Обзоры, аналитика и оперативные обновления о жизни города онлайн.

  59. Днепр онлайн https://faine-misto.dp.ua городской портал с актуальными новостями и событиями. Главные темы дня, общественная жизнь, городские изменения и полезная информация для горожан.

  60. Автомобильный портал https://avtogid.in.ua с актуальной информацией об автомобилях. Новинки рынка, обзоры, тест-драйвы, характеристики, цены и практические рекомендации для ежедневного использования авто.

  61. Новости Киева https://infosite.kyiv.ua события города, происшествия, экономика и общество. Актуальные обзоры, аналитика и оперативные материалы о том, что происходит в столице Украины сегодня.

  63. Портал для пенсионеров https://pensioneram.in.ua Украины с полезными советами и актуальной информацией. Социальные выплаты, пенсии, льготы, здоровье, экономика и разъяснения сложных вопросов простым языком.

  64. Объясняем сложные https://notatky.net.ua темы просто и понятно. Коротко, наглядно и по делу. Материалы для тех, кто хочет быстро разобраться в вопросах без профессионального жаргона и сложных определений.

  65. Блог для мужчин https://u-kuma.com с полезными статьями и советами. Финансы, работа, здоровье, отношения и личная эффективность. Контент для тех, кто хочет разбираться в важных вещах и принимать взвешенные решения.

  66. Полтава онлайн https://u-misti.poltava.ua городской портал с актуальными новостями и событиями. Главные темы дня, общественная жизнь, городские изменения и полезная информация для горожан.

  67. Портал города https://u-misti.odesa.ua Одесса с новостями, событиями и обзорами. Всё о жизни города: решения властей, происшествия, экономика, спорт, культура и развитие региона.

  68. Новости Житомира https://u-misti.zhitomir.ua сегодня: городские события, инфраструктура, транспорт, культура и социальная сфера. Оперативные обновления, обзоры и важная информация о жизни Житомира онлайн.

  69. Новости Хмельницкого https://u-misti.khmelnytskyi.ua сегодня на одном портале. Главные события города, решения властей, происшествия, социальная повестка и городская хроника. Быстро, понятно и по делу.

  70. Львов онлайн https://u-misti.lviv.ua последние новости и городская хроника. Важные события, заявления официальных лиц, общественные темы и изменения в жизни одного из крупнейших городов Украины.

  71. Новости Киева https://u-misti.kyiv.ua сегодня — актуальные события столицы, происшествия, политика, экономика и общественная жизнь. Оперативные обновления, важные решения властей и ключевые темы дня для жителей и гостей города.

  72. Актуальные новости https://u-misti.chernivtsi.ua Черновцов на сегодня. Экономика, происшествия, культура, инфраструктура и социальные вопросы. Надёжные источники, регулярные обновления и важная информация для жителей города.

  73. Винница онлайн https://u-misti.vinnica.ua последние новости и городская хроника. Главные события, заявления официальных лиц, общественные темы и изменения в жизни города в удобном формате.

  74. Новости Днепра https://u-misti.dp.ua сегодня — актуальные события города, происшествия, экономика, политика и общественная жизнь. Оперативные обновления, важные решения властей и главные темы дня для жителей и гостей города.

  75. Городской портал https://u-misti.cherkasy.ua Черкасс — свежие новости, события, происшествия, экономика и общественная жизнь. Актуальные обзоры, городская хроника и полезная информация для жителей и гостей города.

  78. Поставляем грунт https://organicgrunt.ru торф и чернозем с доставкой по Москве и Московской области. Подходит для посадок, благоустройства и озеленения. Качественные смеси, оперативная логистика и удобные условия для частных и коммерческих клиентов.

  80. Op zoek naar een casino? WinnItt biedt online gokkasten en live games. Het biedt snel inloggen, eenvoudige navigatie, moderne speloplossingen en stabiele prestaties op zowel computers als mobiele apparaten.

  83. Hello everyone!
    I came across a 153 very cool resource that I think you should take a look at.
    This resource is packed with a lot of useful information that you might find insightful.
    It has everything you could possibly need, so be sure to give it a visit!
    https://lyricsans.com/tips-for-women-on-how-to-find-your-own-individual-style-of-dress/

    Furthermore do not neglect, everyone, — a person always are able to within this article locate solutions to address the most the absolute confusing inquiries. Our team made an effort to lay out the complete data using the very understandable manner.

  86. Нужен проектор? https://projector24.ru большой выбор моделей для дома, офиса и бизнеса. Проекторы для кино, презентаций и обучения, официальная гарантия, консультации специалистов, гарантия качества и удобные условия покупки.

  87. Нужен проектор? projector24.ru/ большой выбор моделей для дома, офиса и бизнеса. Проекторы для кино, презентаций и обучения, официальная гарантия, консультации специалистов, гарантия качества и удобные условия покупки.

Leave a Reply

Your email address will not be published. Required fields are marked *