Posting freight lines automatically from the WMS Shipment in Dynamics NAV

Posting freight lines automatically from the WMS Shipment in Dynamics NAV

Some of my customers using the Dynamics NAV Warehouse Management (WMS) module face the same issues with this WMS setup:

  1. The Sales Orders are created by the sales people and a freight line is applied, either as a G/L line or as a resource line.
  2. When the sales order is released for delivery, shipment lines are made based on the sales order, either by the sales person, by the warehouse manager or by the warehouse employee himself.
  3. Depending on the setup, a pick is created and posted to “transport” the item from the picking zone to the shipment zone.
  4. Lastly, the warehouse shipment is posted.
  5. At nighttime, all sales orders with posted shipments are automatically invoiced and invoices are printed/sent by email.

Using the WMS module, it means that the warehouse employees do not necessarily see the sales order because they have all necessary information on the Warehouse Shipment. However, only item lines are transferred to the warehouse shipment so all other types have to be handled manually on the sales order. Making an automation like this, will leave all G/L lines and resource lines behind on the sales order to be posted separately later. This also means that the customers will receive separate invoices: one for the items and one for the freight.

There is a fairly simple solution to the problem. It does demand a license to change codeunits though.

In the Warehouse setup table (5769), two fields are created:

  • Post G/L lines with Shipments
  • Post Resource lines with shipments.

Two lines if both G/L Lines and Resource lines should be posted otherwise one field is enough.

And the equivalent Warehouse Mgt. Setup page (5775):

In the Whse.-Post Shipment Codeunit (5763):

Find the function HandleSalesLine, make a local variable…

…and insert the Following lines just before the end of the function:

~~~~

Now if the fields are activated in the setup table, freight lines made as G/L lines or resource lines on the sales order will always be included in the posting of the shipment, and thereby be included on the invoice.

To keep the solution as close to standard as possible, the fields could be created in a customer specific setup table and page. This way the only change will be in the codeunit.

1,895 thoughts on “Posting freight lines automatically from the WMS Shipment in Dynamics NAV

  1. Yo guys, been checking out betvndvip and gotta say it’s pretty slick. Easy to use and the odds seem decent. Worth a look if you’re after a new spot to place your bets. Just remember to gamble responsibly!

  2. Hey would you mind letting me know which hosting company you’re working with? I’ve loaded your blog in 3 completely different web browsers and I must say this blog loads a lot quicker then most. Can you recommend a good web hosting provider at a fair price? Kudos, I appreciate it!

  3. Hello everyone!
    I came across a 153 useful resource that I think you should explore.
    This site 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://theedp.com/the-22bet-login-process/

    Additionally don’t overlook, guys, — a person constantly are able to within the publication locate solutions for your most complicated inquiries. Our team made an effort to present the complete content via the extremely understandable manner.

  4. Hello lads!
    I came across a 153 very cool page that I think you should take a look at.
    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://betterthisworld.com/money/how-to-earn-money-freelancing/

    And remember not to overlook, everyone, that a person at all times may in the publication locate solutions for the most most confusing questions. We made an effort to present all data in the very accessible way.

  5. I was just looking for this information for a while. After 6 hours of continuous Googleing, finally I got it in your website. I wonder what’s the lack of Google strategy that don’t rank this kind of informative web sites in top of the list. Usually the top web sites are full of garbage.

  6. We’re a group of volunteers and opening a new scheme in our community. Your site offered us with valuable info to work on. You’ve done a formidable job and our whole community will be grateful to you.

  7. I like what you guys are up also. Such clever work and reporting! Keep up the excellent works guys I¦ve incorporated you guys to my blogroll. I think it’ll improve the value of my web site 🙂

  8. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your site? My blog is in the exact same area of interest as yours and my users would genuinely benefit from a lot of the information you present here. Please let me know if this ok with you. Thank you!

  9. Hey there I am so thrilled I found your blog page, I really found you by error, while I was browsing on Google for something else, Anyways I am here now and would just like to say many thanks for a marvelous post and a all round entertaining blog (I also love the theme/design), I don’t have time to read it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the excellent job.

  10. I needed to compose you this very small remark just to give many thanks as before with your awesome pointers you’ve provided on this website. It is certainly remarkably open-handed of you to convey openly precisely what many people would’ve distributed for an e-book to make some cash for themselves, especially since you might have done it if you considered necessary. The things likewise worked like a fantastic way to recognize that most people have the identical fervor like my personal own to grasp way more with regards to this condition. I am certain there are a lot more fun instances ahead for many who looked over your blog.

  11. I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly a lot often inside case you shield this increase.

  12. Thông tin vô cùng giá trị, cảm ơn ad nhé.
    Tiện thể đây, cho mình giới thiệu một bến đỗ an toàn, xanh chín cho bet thủ đó chính là nhà
    cái 789win. Mọi người hãy vào thẳng tên miền 789win.buzz cho an toàn nhé, tránh link giả mạo.
    Giao diện của 789win.buzz cực kỳ mượt mà, không giật lag.
    Bác nào xa bờ thì thử vận may tại 789win.buzz nha các
    chiến hữu.

Leave a Reply

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