Monday, September 17, 2018

LS NAV Demo Mods


  • GL
    • General Ledger Setup: Set Show Amounts to All Amounts
    • P16 Add button for P490 Account Schedules Overview
    • Add GL Budgets Shortcut to Bookkeeper Navigation Menu
    • Add 2018 budget entries
    • Install Excel
    • Account Schedules: Create Column Layouts
      • Prior Year (-1Y comparison date)
      • History (-1M to -6M comparison date)
      • By Department dimensions (Department filter on each column for each value)
    • P9004 add buttons for P118 General Ledger Setup, P1875 Business Setup, P119 User Setup
  • Inventory
    • T32 Item Ledger - add description flowfield
    • P38 Item Ledger entries - show Description flowfield

Saturday, September 15, 2018

Dynamics NAV - Replenishment system - Transfer


  • To setup transfers to come up in the requisition worksheet automatically, 
    • Setup Transfer Routes from one location to another
    • Setup Stockkeeping units
      • Define the specific warehouse that can be used to transfer a specific item to a specific location
      • From: Transfer From Code , TO: Location Code
    • Click Carry out Actions from the Requisition worksheet
      • This will generate a Transfer Order

Friday, September 14, 2018

Dynamics GP - Remove or Clear tem Allocations - Manufacturing Picklist


  • These items are on open picklists that haven’t been fully picked.
    • Delete the Picklist to remove the allocation.
    •  From the Item Allocation Inquiry Screen, Select the document holding the allocation, click “Document Number”
    •  Navigate to the Picklist
    •  Enter the MO number
    • Click Delete to delete the picklist. This will release the allocation.


Wednesday, September 5, 2018

Dynamics NAV - Page or Subpage does not insert data into table immediately. Refresh or next clears the record and does not commit data.

https://community.dynamics.com/nav/f/34/t/203873



  • If the subpage is a LIST type, it will not save the record until the "Ok" button is pressed on the parent form
  • If the subpage is LISTPART type, it will save the record immediately

LS NAV - Update Jobs not updating by action

Retail Setup>General>Preaction Creation By: Set to Database Triggers

Affects everyone after 11.0

LS NAV - Non-Inventory Items - Miscellaneous Charges, Services - Create an item that does not track stock

Retail Items>Invoicing>Tick No Stock Posting

Core NAV does not have any options to prevent stock posting.
Items>Inventory Value Zero only affects cost posting, but will still track stock
You need to transact directly against a GL account instead of using an item, or use a Service Item
Or periodically adjust stock to 0.


Dynamics GP - Manufacturing - Finished Goods Costs are higher than expected

Scenario:
Receive Raw Material with FIFO costs, Complete an MO using backflush, no labor, no overhead, Finished Goods cost does not match raw material cost

Explanation: