Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012861Openbravo ERP04. Warehouse managementpublic2010-04-04 11:082011-07-20 18:12
Reportericematrix3k 
Assigned Tojonalegriaesarte 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP14 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012861: Physical Inventory Document Posting Not Accurate Enough
DescriptionAt 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.
Steps To Reproduce
Proposed SolutionThere 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)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-04 11:08icematrix3kNew Issue
2010-04-04 11:08icematrix3kAssigned To => adrianromero
2011-06-03 10:59dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:12dalsasuaAssigned Todalsasua => jonalegriaesarte

There are no notes attached to this issue.