New Report: Sales Order Lines to Deliver

[dottenbr]

After Nabin adds Requested Date and Confirmed Date to the Sales Order Line we would like to create a report to show all Sales Order Lines to Deliver. So we are actually accessing a child table, not a DocType.

This serves a couple of purposes:

• Easy communication with customers about all their orders in the ERP system in Excel or CSV format so they can import it into their system
• Immediate display of how much the confirmed date and the requested date differ so that measures can be taken to improve the delivery date or so the customer can change their requested date to ensure both ERP systems and the customers and suppliers delivery date expectation line up. This is actually quite crucial when you get into performance evaluations.
• Display for shipping managers or business managers to see how many days they actually have until something has to be delivered, or they see that they should have delivered something yesterday or last week (etc.)
• Displaying to sales managers or financial comptrollers what financial stake there is if something may not be delivered and prioritizing (production shifting) accordingly
• Simple analytics to show how much revenue is expected in a certain time period

The feature should be multi company ready and while calculating the days delayed and days to delivery should take the companies Holiday List for that calculation to make sure non-working days and holidays are not counted to the companies disadvantage.

Sample Excel Sheet attached. sample table.xlsx

[creamdory]

Hi @nabinhait ! Any additional comments for this one before dev? Thanks!