• Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • FAQ

Microsoft Dynamics Tricks and Tips!

Olof Simren - Microsoft Dynamics NAV Blog

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • FAQ

Subcontracting Part 3: Transport Charges

Aug 22, 2014 | Posted by Olof Simren | Finance, Manufacturing, Purchase | 4 comments |

This is the third post in a series of subcontracting blog posts, and it starting to get a bit tricky. The topic is how to handle transport charges for subcontracting operations. In other words if you have a vendor that handles parts of the production process and you receive an invoice from a shipping agent/transportation company for the transportation of products either to and/or from the subcontractor.

If you haven’t read part 1 and part 2 it might be a good idea to read those first, this post assumes you know the basics of subcontracting and uses the same items as an example.

There are three ways that I have successfully done this in the past, all of them with some pros and cons;

1. Item Charge on a Purchase Invoice against the Transfer Receipt.

2. Adding a separate Subcontracting Operation to the Routing.

3. Adding a Transportation Cost Accrual Operation to the Routing.

Each method is described in details below.

Item Charge on a Purchase Invoice against the Against Transfer Receipt

In this method you create a purchase invoice based on the invoice received from the transportation company and you assign the cost against a previously posted transfer receipt. It handles the actual costs only and will not affect any standard cost roll-up, so it is a method that is more applicable to the FIFO or average costing methods.

To do this you need the transportation company as a vendor in Dynamics NAV (obviously), and you also need an item charge setup to handle transportation costs. A prerequisite is also that you used a transfer order to send the components to the subcontractor (like described in my post subcontracting part 2) or a transfer order to move the finished product back from the subcontractor. Without a posted transfer receipt this method will not work.

Here is how you do it;

Create a purchase invoice representing the transportation costs and add the item charge(s) as lines according to the invoice received.

Transport-Cost-Purchase-Invoice-Dynamics-NAV

Next you assign the item charges to the transfer receipt(s) by selecting Line -> Item Charge Assignment and then using the Get Transfer Receipt Lines to select the transfer receipts to assign the cost to.

Item-Charge-Assignment-Dynamics-NAV

If you get a transportation cost invoice covering multiple shipments (maybe throughout the month) then you need a way to distribute the costs across the different transfer receipts (instead of entering the Qty. to Assign manually). Standard Dynamics NAV can help you with this by suggestion a distribution according to the amounts of the products or equal across the lines.

Item-Charge-Assignment-Suggestion-Dynamics-NAV

This suggestion can also be easily customized to include other criteria such as weight. You also need to be aware of how the dimensions in item charges are handled, read my previous post related to this.

Then you post the purchase invoice and after running the cost adjustment you see that Dynamics NAV forwards the costs applied like this to any inventory value or COGS for the finished product produced through the subcontractor on the production order.

Nice!

Adding a separate Subcontracting Operation to the Routing

The second option is to add a separate subcontracting operation to the routing. By doing this you will be able to define an expected cost that could also be part of a standard cost roll-up and you will get a second purchase order to be used for invoicing the transportation cost. This method can also be used even if you are not transferring products using transfer orders.

To do this you need a vendor for the transportation company (obviously), but also a work center so that it can be added to a routing as an operation. The vendor, work center and routing can be setup as any other subcontracting operation. See subcontracting part 1 for details.

The routing for such could for example look like below, where the expected transport cost is defined as $3. Note that the operation is without any times, it’s purely to create a purchase order in order to incorporate the transport charges into the cost of the finished product.

Routing-With-Freight-Charges-Dynamics-NAV

When you then create your purchase order for the subcontracting trough the subcontracting worksheet you also get a second purchase order in the suggestion.

Subcontracting-Worksheet-Freight-Charge-Dynamics-NAV

The second purchase order is for the transportation costs and will stay open to be match with the transportation cost invoice when received. It is linked to the operation on the production order the same was a regular subcontracting purchase order.

Freight-Charge-Purchase-Order-Related-to-Production-Dynamics-NAV

This is a quite straight forward way of doing it, it works well in a standard cost environment (as well as FIFO and average) and there is no prerequisite of having to use a transfer order to ship of receive products from the subcontractor.

The downside of this method is if you receive invoices from the transportation company that covers multiple shipments, such as a monthly invoice, then this will be a bit hard and cumbersome.

Adding a Transportation Cost Accrual Operation to the Routing

The last method is to setup a separate operation in the routing that will add some costs that represent the expected transportation costs. By configuring this correct way you can get Dynamics NAV to automatically post the transportation costs against an accrual account when the production order is finished. The accrual is then later reversed when the invoice is received from the transportation company.

What you need for this method is a work center to handle the accrual posting. The work center should be setup with a separate posting group to control the general ledger account, and the flushing method should preferable be setup a backward flushing (so it does not add any additional steps to the operation to complete the production order).

This is how to do it; setup the work center with the Unit Cost Calculation equal to Units and the Specific Unit Code checked (just like a regular subcontracting work center). Set the Flushing Method to Backward to have Dynamics NAV to automatically finish the operation and apply the cost. Use a General Product Posting Groups that is specifically created for this purpose.

Transport-Cost-Work-Center-Dynamics-NAV

The posting setup is then done to post the cost into an accrual account for transportation costs.

General-Posting-Setup-Dynamics-NAV

We then add an operation using this work center to the routing where we specify the estimated transportation cost in the Unit Cost field.

Routing-With-Transport-Charge-Dynamics-NAV

Dynamics NAV will then automatically credit the freight accrual account according to the amount specified in the routing when the production order is changed to finished. See Production Order Posting to General Ledger for more details about how Dynamics NAV posts into the GL from production.

When the transportation cost invoice later arrives in the end of the month, you simply post this against the accrual account, which will create a debit transaction and reverse the accrued transport costs.

Transport-Cost-Purchase-Invoice-2-Dynamics-NAV

What remains in the accrual account in the end of the month (in case of differences between expected accrued costs and actual invoiced costs) need to be cleared manually through journal entries (probably move to some kind of variance account in the P&L).

This method is useful if you are receiving transportation costs invoices that span multiple production orders. It is also an easy method to maintain since it does not add much of work, all that needs to be done is to add the extra operation to the routing and the rest is handled by Dynamics NAV automatically.

That’s it for transportation costs related to subcontracting. If anyone has other methods to do this (maybe better ones) feel free to post a comment.

Upcoming blog posts about subcontracting will describe how to use warehouse receipts for subcontracting, how things can be simplified with some small code changes and how to setup Dynamics NAV when you are performing subcontracting on behalf of a customer.

Make sure to subscribe to not miss anything. 🙂

Note that I also have a Twitter account now where you can follow me: @microsoftNAV

Tags: FinanceProductionProduction OrdersPurchase OrdersRoutingSubcontractingTransport Costs
4 Comments
3
Share

You also might be interested in

Discrepancy Between Purchase and Direct Cost Applied

May 8, 2014

In school we where told that when you invoice (voucher)[...]

Consignment Inventory

Apr 26, 2015

Being able to handle consignment inventory in Microsoft Dynamics NAV[...]

Work Centers vs. Machine Centers

Feb 2, 2015

A topic that is discussed on all manufacturing implementations is[...]

4 Comments

Leave your reply.
  • Kishor Mistry
    · Reply

    August 27, 2014 at 10:11 AM

    At the end of the second method you say… “The downside of this method is if you receive invoices from the transportation company that covers multiple shipments, such as a monthly invoice, then this will be a bit hard and cumbersome.” Could you not just “Receive Only” the purchase orders to progress the production orders and then create an invoice and use “Get Receipts” functionality to post the transport invoice when you get it at the end of the month (relating to the multiple shipments)?

    A great series of blogs by the way!

    • Olof Simren
      · Reply

      Author
      August 27, 2014 at 12:24 PM

      You are right, good point.
      Assumes someone is receiving the purchase orders throughout the month.

  • Jorge
    · Reply

    June 6, 2016 at 12:12 PM

    Hi Olof,

    thank you for the blog , great Ideas! Currently i have a customer that wants to use the NAV subcontracting solution to so some copacking in their goods.

    Altough the sub-contracting solution replies to our process , it has a sever problem [ in my optics ]:

    PRocess steps:

    1. create a released production order.
    2. production order has 1 routing .
    3. Run the subcontracting worksheet and generate a purchase order
    4. Ship the goods [ transfer order ]
    7. Purchase receipt is posted
    ….. some time passes until the subcontractor makes his invoice
    8. Purchase invoice is created and posted.
    the problem is that between step 7 and step 8, the cost of the item is incorrect.

    If components are not invoiced, NAV uses an expected cost to determine the cost of the produced goods (in the value entries).
    For the subcontracting however, there is no expected cost used, meaning the cost of the subcontracting is added only when the purchase invoice is posted (sometimes 2 or 3 months later).
    So as long as the purchase invoice is not registered, the cost of the items is incorrect.

    This is something not possible for mu Customer, they have very accurate Costing processes.

    NOTE: The Routing does not have any COST assigned to it so no capacity ledger entries are created at the receipt.

    To me this seems a very big limitation of Sub-contracting solution. Do you know any possible work-around to this ?

    Thank you .

    Jorge

    • Olof Simren
      · Reply

      Author
      June 15, 2016 at 10:55 PM

      Hi Jorge,
      Yeah, this is a common question and a not so wanted ‘feature’ in NAV. It would have been nice if it posted an expected subcontracting cost.
      The work around is to keep the production order in the released status until you have received the invoice from the subcontractor. The produced product is then in inventory with an expected cost (which is based on the unit cost of the production order line, which in turn comes from the item card when the production order is created).
      If you desperately want to change the status to finished for the production orders before the invoice is received, then I guess a modification can be made so that the cost is not adjusted if there are outstanding subcontracting invoices. It is the field ‘Is Finished’ in table 5896 that controls if NAV should run the cost adjustment for a finished production order or not.
      I hope this helps. Sorry for a late reply, you comment got lost somehow.
      /Olof

Leave a Reply

I appreciate all feedback!
Cancel Reply

Subscribe to Blog via Email

My Dynamics NAV Partner

Naviona, LLC

Categories

  • Assembly (3)
  • Development (31)
  • Finance (14)
  • General (26)
  • Inventory (22)
  • Manufacturing (34)
  • Miscellaneous (25)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Top Posts & Pages

  • Kill Sessions in Dynamics NAV
  • Home
  • Subcontracting Part 1: The Basics
  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Scrap in Production
  • Processing of Shipments
  • Add Fields to the Item Tracking Lines
  • Downloads
  • Schedule MRP

Tags

.net Add-in Assembly Assembly BOM CAL Capacity Components Consumption Contact Costs Customer Development Dimensions Excel Finance Flushing General Ledger Inventory Item Items Lot Size Low-Level Code MRP NAV 2015 NAV 2016 Output PDF Planning Production Production BOM Production Orders Purchase Orders Receipts Reporting Reports Role Center Routing Sales Sales Order Sales Orders Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Shipment

Recent Posts

  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)
  • Sales Quote without Customer
  • Parallel Routings
  • Add Fields to the Item Tracking Lines
  • Field Level Security using Events in Dynamics NAV 2016
  • Schedule MRP
  • Activate WMS Functionality for Existing Location

RSS Feeds

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Microsoft Dynamics NAV - ERP of choice for 110,000 Companies

Categories

  • Assembly (3)
  • Development (31)
  • Finance (14)
  • General (26)
  • Inventory (22)
  • Manufacturing (34)
  • Miscellaneous (25)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Top Posts & Pages

  • Kill Sessions in Dynamics NAV
  • Home
  • Subcontracting Part 1: The Basics
  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Scrap in Production
  • Processing of Shipments
  • Add Fields to the Item Tracking Lines
  • Downloads
  • Schedule MRP

Recent Posts

  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)
  • Sales Quote without Customer
  • Parallel Routings
  • Add Fields to the Item Tracking Lines
  • Field Level Security using Events in Dynamics NAV 2016
  • Schedule MRP
  • Activate WMS Functionality for Existing Location

Recent Comments

  • Arão Benjamin on Discrepancy Between Purchase and Direct Cost Applied
  • Olof Simren on Subcontracting Part 1: The Basics
  • Olof Simren on Discrepancy Between Purchase and Direct Cost Applied
  • kelseyk on Reversing Production Output and Consumption
  • Shafeeque on Discrepancy Between Purchase and Direct Cost Applied
  • Shafeeque on Discrepancy Between Purchase and Direct Cost Applied
  • Gabriela on Subcontracting Part 1: The Basics
  • Andrew Trayfoot on Activate WMS Functionality for Existing Location

© 2018 · Olof Simren

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • FAQ
Prev Next