Uploaded image for project: 'OSCAR'
  1. OSCAR
  2. OS-11819

Supply Status - Add additional Column to the ANZ Shortage Report Broadcast (QA Inventory, Distributor DOS, Distributor Qty)

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • Medium
    • 7.2
    • None
    • BSL

    Description

      Problem Statement

      Supply Status - Add additional Column to the ANZ Shortage Report Broadcast (QA Inventory, Distributor DOS, Distributor Qty)

      Correct some of the columns for which data is missing (old material number, open order qty)

      Acceptance Criteria

      Columns addition

      • QA Inventory is added next to the other inventory columns
      • Distributor DOS, Distirbutor Qty is added towards the end of the report 

      Columns corrections

      • Ensuring "Old Material Number" is currently dropping the leading 0´s
      • "Old Material Number" is sometimes missing for some materials (while present in SAP), join condition would need to be reviewed to change country_key with plant
      • Open Order Qty is currently showing 0 everywhere and needs to reflect correct values

      Attachments

        Issue Links

          Activity

            People

              bonaks bonaks
              ESPAGJ Espagnet, Julien
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d