ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Sales
DrillDown Icon Inventory Management
DrillDown Icon Packing List Management
DrillDown Icon RMA Receiver
DrillDown Icon PO Receiving & DMR
DrillDown Icon Kitting, Allocating & Shortage Management
DrillDown Icon Inventory Control Management
DrillDown Icon Inventory Control Mgmt (ICM)
DrillDown Icon Inventory Handling
DrillDown Icon IPS Upload
DrillDown Icon Inventory Cycle Count
DrillDown Icon Physical Inventory
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon Physical Inventory - FAQ
DrillDown Icon When Processing Physical Inventory is there one large GL Transaction or many individual ones?
DrillDown Icon Standard Cost Adjustment
DrillDown Icon Part Manufacturer Setup
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Administration
DrillDown Icon Accounting
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
When Processing Physical Inventory is there one large GL Transaction or many individual ones?

Q5:  Physical inventory:  What GL #’s will be used and will it hit as one huge Transaction or individual Transactions?

A5:  Below you can see the Inventory Default Account Setup Screen.  And I have highlighted the GL account for Inventory Adjustments.


Then I had the following parts in the system as follows:

                                    Before the Physical Inventory       Adjusted To via Physical Inventory         

101-0001688            100 On Hand @ 0.67                      120

101-0001689            200 @1.321                                      150

101-0001690            0 @ 0.47                                            100

101-0001691            0 @ 0.874                                          100

101-0001692            0 @ 2.11                                            100

Since the 1st, 3rd, 4th and 5th records were actually increasing the qty on hand they all were included into the Transaction # 2124 shown below.  So yes they are grouped into one larger transaction #, but they are displayed in sub categories within the Individual Transaction Inquiry reports as shown below for easier reference.

Since the 2nd records was reducing qty out of stock it generated an inventory issue transaction # 2125 shown below.


Article ID: 5910