0012861: Physical Inventory Document Posting Not Accurate Enough

Description

At the present moment when a Physical Inventory document, there's only ONE accounting entry created for both POSITIVE inventory result (Inventory Differences) , and NEGATIVE inventory count. This allows for compensation between INCOME and EXPENSES resulted from the inventory count.

Proposed Solution

There should be TWO accounting entries made:
1. For the products that have a POSITIVE (higher than expected) inventory count.
2. For the products that have a NEGATIVE (lower that expected) inventory count.

POSITIVE Inventory Count is considered as Revenue.
NEGATIVE Inventory Count is considered as Expense.

In the *Defaults* tab for the *Accounting Schema* (Financial Management->Accounting->Setup->Accounting Schema->Defaults), instead of the single Inventory Differences account, should be TWO accounts:
  1. Inventory Count Revenue.
  2. Inventory Count Expense.

Also, in the *Physical Inventory* (Warehouse Management->Physical Inventory) document should be TWO ADDITIONAL tabs:
  1. For the POSITIVE inventory count items.
  2. For the NEGATIVE inventory count items.

And there should be possible to print EACH tab as a separate document (*This would be the physicals copies of the *Physical Inventory Count Income* and *Physical Inventory Count Expense* documents.

So, the final result should be a new *Physical Inventory* document layout:
1. Header (as is now).
  |---> 1. Lines (as is now)
  |---> 2. Excess Inventory (new tab)
  |---> 3. Less Inventory (new tab)

Issue History
Date Modified	Username	Field	Change
2010-04-04 11:08	icematrix3k	New Issue
2010-04-04 11:08	icematrix3k	Assigned To	=> adrianromero
2011-06-03 10:59	dalsasua	Assigned To	adrianromero => dalsasua
2011-07-20 18:12	dalsasua	Assigned To	dalsasua => jonalegriaesarte

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.