Monday, January 27, 2014

Dynamics GP - How to do a Stock Count


  1. Understanding Inventory Setup options
    1. Inventory>Setup>Inventory Control
    2. Sales>Setup>Sales Order Processing
  2. Understanding how other transactions affect the Inventory Quantities
    1. What affects Allocated Quantities?

      1. Sales Order Quantities Allocated by Line Item or Batch
      2. Unposted Purchase Return Quantities
      3. Unposted Sales Invoice Quantities Allocated by Line Item or Batch
      4. Unposted Inventory Transfer Quantities
      5. Unposted In-Transit Transfer Quantities
      6. Unposted Inventory Transaction Quantities
      7. Unposted Inventory Assemblies
      8. Unposted Manufacturing Issues
      9. Processed Stock Counts WITHOUT Autopost ticked (Will generate unposted Inventory Transactions)
    1. What Affects On Hand Quantities?
      1. Posted Purchase Receipts
      2. Posted Purchase Returns
      3. Posted Sales Invoice Quantities Allocated by Line Item or Batch
      4. Posted Sales Returns
      5. Posted Inventory Transfer Quantities
      6. Posted/Shipped In-Transit Transfer Quantities
      7. Posted Inventory Transaction Quantities
      8. Posted Inventory Assemblies
      9. Posted Manufacturing Issues
      10. Processed Stock Counts WITH Autopost ticked (Will generate and post Inventory Transactions)
    2. What does not Affect Inventory Allocated, or On Hand Quantities?
      1. Sales Quotes
      2. Non-allocated Sales Orders
      3. Non-allocated Sales Invoices
      4. Unposted Purchase Receipts
      5. Unposted Sales Returns
      6. Stock Count Schedules
      7. Unprocessed Stock Count Entries
  1. Useful Inventory Inquiry Screens
    1. Item - Shows quantities in locations
    2. Item Transaction - Shows all item transaction history
    3. Serial/Lot Trace - Shows movement of a serial/Lot through all transactions
    4. Inventory All-in-One View - Shows all inventory transactions and their movement
    5. Bin Quantities - Shows item quantities in bins
    6. Item Allocation - Shows all item allocations
    7. Item Stock - Shows all item transactions and a running stock total
    8. Price Trace - Test extended pricing
  2. Pre-Requisites
    1. All transactions affecting inventory on hand should be entered into the system
    2. Post as many Receivings Batches as possible
    3. Post as many Inventory Batches as possible (Adjustments and Transfers)
    4. Post as many Sales Batches as possible (Invoices and Returns)
    5. Post as many Assembly Batches as possible
    6. Post as many Manufacturing Issues as possible
    7. Post as many Manufacturing Receipts as possible
    8. Run a full check links
    9. Run a reconcile against sales and inventory
  3. Actual Stock Count
    1. Create a Stock Count Schedule for a Site and collection of Items
      1. Inventory>Transaction>Stock Count Schedule
      2. Tick Reuse Stock Count if you want to always use this list as a template
      3. Click Start Count when you're ready to snapshot your stock and begin counting
      4. Print your stock count list 
    2. Ideally, you should refrain from doing any transactions that will affect inventory until the stock count is completed. Why?
      1. Stock that should not be allocated may become allocated, and may prevent the stock count adjustments from going through. Eg. Stock incorrectly shows 100, physical is 0. When they count, -100 adjustment must go through, but users may have allocated the incorrect 100, resulting in orders for stock that does not exist, and pushing available stock into negative when the stock count is posted. This is further compounded if serials and lots are in use.
    3. Count your Stock
    4. Enter your stock count
      1. Select stock Count ID
      2. For each line, you can review the stock data that was captured by pressing the expansion button on the right of the column labels
        1. Captured Qty = On Hand Qty when "Start count" was clicked
        2. On Hand Qty = Current On Hand Qty (Informational Only)
        3. Allocated Qty = Current Allocated Qty (Informational Only)
      3. Enter your count for each item
        1. Variance is calculated as Captured Qty - Counted Qty
        2. When your variance is posted, it will affect the Current On Hand Qty
      4. Tick Verify
      5. Enter Lot or Serial Numbers
      6. If you tick "Autopost stock count variances", it will automatically post the adjustment when you click "process"
      7. Process your stock count
  4.  If you are finished with all transactions for the previous periods, you should close the fiscal periods accordingly.
    1.  Tools>Setup>Company>Fiscal Periods
    2. Select the year
    3. Tick any periods you want to prevent posting to.

No comments:

Post a Comment