August 6, 2014
Creative thinking and NAV flexibility beats customization
The other day, a client presented me with a scenario that took some thinking on to how to set it up in Dynamics NAV without requiring a customization. The client, who is running Microsoft Dynamics NAV 2009 R2 with the Role Tailored Client, sells wooden stakes. A vendor supplies green (not dry) stakes, which the client then sorts, dries, shapes, treats, and bundles for shipment. The challenge he presented is in the purchasing and receiving process. The green stakes are stocked in NAV as ‘each,’ but the purchase unit of measure is 1,000 ‘Board Feet.’ There are approximately 3,000 stakes per 1,000 board feet. When the delivery of the green stakes is made, the vendor expects an 80 percent cash on delivery payment. The stakes are then sorted to determine which are of good quality and which are of 2nd quality. The client makes the final payment to the vendor for the good quality stakes only. The client is able to keep the 2nd quality stakes and use them for other purposes; these are put into inventory with a zero value. Here is the solution I came up with to manage this process within Dynamics NAV without requiring a customization:
- We created the following 3 items in NAV with associated costing methods:
- Green Stake - FIFO Cost
- Good Quality Stake -FIFO Cost
- 2nd Quality Stake - Standard Cost = 0.00
- We create a purchase order for 1,000 board feet of Green Stakes.
- We receive the purchase order for 1,000 board feet that will put 3,000 Green Stakes into inventory.
- We make a prepayment for 800 board feet.
- We create a NAV Released Production Order for 3,000 to output Good Quality Stakes.
- The workers do the sorting and report the quantity of Good and 2nd Quality Stakes.
- Using the NAV Consumption Journal, we consume all 3,000 Green Stakes to the production order.
- Using the NAV Output Journal, we output as many Good Quality Stakes that were counted. This will bring all of the cost to the Good Quality Stakes.
- We calculate the total price to pay and ‘invoice’ the receipt for the entire 1,000 board feet.
- We create an item journal entry to put the 2nd Quality Stakes into inventory at zero value.
- We apply the prepayment to the invoice.
- At a later date, we pay the balance of the cost to the Green Stake vendor.
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard
- Difference Between IaaS, PaaS, and SaaS And When You Need to Use Them
- How to Set Custom Color Themes in Microsoft Power BI