Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005731Openbravo ERP07. Sales managementpublic2008-10-29 15:272011-02-04 09:11
ReporterRenateNieuwkoop 
Assigned Tormorley 
PrioritynormalSeveritymajorReproducibilityN/A
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version2.40beta 
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
Summary0005731: RFE: ATP report
DescriptionRight now to determine whether a Sales Order can be shipped, there is only the stock report. When you do have stock there is no indication whether there is already sales order for which the stock is required.

What is missing is a Available to Promise report (ATP).
It has the following information (example):

Product: Boots
on hand: 49

Date Qty ATP
29/10/2008 Sales Order 10 39
1/11/2008 Purchase Order 3 42
3/11/2008 Sales Order 2 40
5/11/2008 Sales Forecast 5 35
10/11/2008 Purchase Order 10 45

So for example if you have a new Sales Order today for quantity 45, you can
see that you ship all on 10/11/2008 (or 39 today). Even though you have 49 in stock, you can not ship these today because 10 of those are for Sales Orders.

What I'm used to is to see the above screen (inquiry ATP) and then have another screen (inquiry plan) where you would see the actual Sales Order and Purchase Order number. Above example has Sales Order 10x on 29/10/2008, but then in the
plan screen you would be able to see what the Sales Orders are and what the quantities per Sales Order would be.
You could include that info in the above overview, but it would mean that the
above screen is less easy to read.
Steps To Reproduce
Proposed Solution
Additional Information
TagsReleaseCandidate, Usability
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-29 15:27RenateNieuwkoopNew Issue
2008-10-29 15:27RenateNieuwkoopAssigned To => cromero
2008-10-29 15:27RenateNieuwkoopsf_bug_id0 => 2207447
2008-10-29 15:30RenateNieuwkoopNote Added: 0009828
2008-11-10 13:09cromeroAssigned Tocromero => pjuvara
2008-11-17 08:17pjuvaraTag Attached: ReleaseCandidate
2008-11-17 08:18pjuvaraStatusnew => acknowledged
2008-12-16 11:12rgorisTag Attached: Usability
2009-10-07 11:08johnfandlNote Added: 0020822
2009-10-07 11:25johnfandlNote Added: 0020826
2011-02-04 09:11jpabloaeAssigned Topjuvara => rmorley

Notes
(0009828)
RenateNieuwkoop   
2008-10-29 15:30   
Next step would be to add the ATP in the Sales Order screen for each product that is being entered in Lines
(0020822)
johnfandl   
2009-10-07 11:08   
An ATP screen is expected by anyone with ERP experience. FYI, I just attended the Basic Development Training last week, and a new partner asked me "why doesn't Openbravo have an ATP Screen?" It is a good question.

Also, for the first-time ERP buyer, it clearly shows the benefit of a fully integrated system - by bringing everything related to a product together all on one screen, so you can see what the inventory level is projected to be if everything is executed as planned.

Paolo, I think this one should go on the list to address soon. A really nice ATP screen will help with QuickStart (and of course the other editions as well). It is a functional gap that is relatively easy to fill, since all of the data is in place.
(0020826)
johnfandl   
2009-10-07 11:25   
Another thought re: ATP is that it could really be a showcase for the new smartclient JS functionality, for example this demo: http://www.smartclient.com/#customGrouping. [^] For ATP, users want to see the big picture over time for an item, and then be able to "unfold" the details for a given day. The smartclient grid lets us do that very nicely.

Also, instead of the traditional "ATP Exception Report" (which shows which items are projected to "go negative" in a given time frame), that could be implemented as a really killer screen implemented with smartclient ajax technology.