Saturday, June 13, 2015

Inventory Cycle Count

Stock count requirements:
Before you set up and use stock counts, you should be aware of the requirements and restrictions. Item types Only Sales Inventory or Discontinued items can be assigned to a stock count. “Freeze” inventory when starting a stock count It’s a good business practice to restrict access to the inventoried items that are being counted during a stock count.

Steps:
     Create Stock Count Schedule

Goto --> Dynamics GP-->Inventory-->Stock Count Schedule

Stock Count Schedule 

























When you’re ready to begin work on a stock count at a specific site, create a stock count schedule-  specify which item-site combinations are to be included in this stock count. (If you’re using multiple bins, you specify which item-site-bin combinations are included.) You can save the stock count schedule or you can choose to start it. You also can reuse stock counts.


To create a reusable stock schedule, mark the Reuse option.


If you need to add many items in your stock count click on “Mass Add” button.  
Stock Count Mass Add




























You have many option to add Mass Items base on Range you have selected. Like Item Number or Class or by Site ID.

Once Item Range is selected then click on Add Button

In my example I have selected one Item: SUGAR.

Stock Count Schedule with Item





























When you’ve finished, choose Save and close the window. Need to call back Stock Count ID again to start Stock Count.

Starting a stock count schedule
Use the Stock Count Schedule window to start a stock count. If the stock count can be started—if there are no exceptions—the status of the count will be changed to Started, stock count forms will be printed and information about the on-hand quantity of each item-site combination will be captured.


Choose Start Count.
When you start a stock count schedule, the quantity on hand for each line in the stock count schedule is captured. Later, the actual count number quantities will be compared to the captured values to create default variance transactions. 

The report destination window for the Stock Count Exceptions report appears. Choose the destination for the Stock Count Exceptions report.

Stock Count Schedule





























Please select Print on Hand Quantities and Print Item Lot or Serial Number if you need to count by Tracking Option then Click on OK.

Below report will print if there is no exceptions.

Stock Count Form

















Use this report to do your physical stock count.
  
Open Stock Count Entry
Got--> Dynamics GP-->Transaction>>Inventory-->Stock Count Entry

Stock Count Entry

























Select Your Stock Count ID
It will display all items. If Item is Lot/Serial --> Click on Serial/Lot button and can enter count quantity.

Stock Lot Count Entry Screen


























Click Okay to go main screen- Stock Count Entry.

On Stock Count Entry screen:
1)      Distribution- It will show each Items GL Distributions.
2)      Serial/Lot- Enter Inventory count by Lot or Serial as explained above.
3)      Unposted Transaction Button- To display if there is unposted transaction are   
         considered in stock count or not for specific item.
4)      Trx History- It display total historical transactions for specific item

Once you have enter Count system will enter Variance for you.  
e.g. Stock Count Lot Number Entry screen.

Stock Count Lot Entry Screen




























Click Okay to goto Main screen.

























If you’re using autoposting options for stock count variances,variance transactions will be posted and reports will be printed when you process a stock count. If you’re not using autoposting, variance transactions are saved in a batch; you’ll need to post the batch.

Once you are satisfied with result click “Process” button.
System will prompt for following Reports:

1)  Exception Report
























Effects of processing a stock count
When you process a stock count, several things happen:
  • Variance transactions are created. If the Autopost Stock Count Variances option is marked, the transactions also will be posted.
Cost information for variance transactions will be based on the cost of the items at the time of the stock count. Cost information is based on the item’s cost trends, so variance transactions might not match the true cost of the items. 

  • New Next Stock Count Dates are calculated for the items in the stock count schedule. 
  • History information about the results of the stock count is stored. History is kept to be the basis of the Accuracy Comparison report, which helps you monitor the accuracy of your stock counts over time.
  • If the stock count wasn’t marked to be reused, it’s deleted. If it was marked to be reused, the stock count results are cleared and the status of the count is set to Available.
  • The exceptions report for processing a stock count is printed. The report lists the problems, if any, that prevent the stock count information from being processed. Even if a stock count is successfully processed, the exceptions report is printed. If the stock count had no variance transactions that is noted in the exception report; otherwise, the report lists the batch number and variance transaction numbers used.

Goto --> Inquiry-->Inventory-->Inventory Transaction.

Inventory Adjustment


Until Next Post.. !!!!