Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-3942

SO Export - Add Distributor Invoice Number

    Details

    • Sprint:
      CFAMX 2019R3 Sprint 4
    • SCRUM Team:
      Globogym Purple Cobras
    • SOW (Time Tracking) Project:
      44918
    • Work Type Classification:
      Sustaining

      Description

      As a third party system I want the Suggested Order Export to include the Distributor Invoice Number so that I can perform analysis on the data

      Notes

      • The Distributor Invoice Number will only be available if an ASN has been linked to the Order
      • The field is Optional and will not always be present
      • The values comes from the ASN file:
        • <cbc:ID>Will05012019b</cbc:ID>
      • The field will be represented in the file header, when available
        • <DistributorInvoiceNumber>Will05012019b</DistributorInvoiceNumber>
        • This comes from tbTransactionSupplyOrder > sYourReference
        • When the Invoice Number is provided in the ASN, this column is populated
        • The value is displayed in the Invoice Number field when receiving the order. The user can choose to delete/update/or leave this number at this time
        • Note: for some vendors we remove the Invoice number as a part of the XSLT Transform, the current transform on JAT is set to take use the invoice number provided
        • Because of this, we should only include this field when there is data in it

      Acceptance Criteria

      1. Confirm that the Suggested Order Export does NOT include the new element (DistributorInvoiceNumber) when the order is Created
        • There is no ASN associated to the order at this time
      2. Confirm that the Suggested Order Export includes a new element that represents the Distributor Invoice Number when the order is Received, if an ASN has been associated to the order prior to the order being received
      3. Confirm that the Suggested Order Export includes a new element that represents the Distributor Invoice Number when the order is changed thru the Correct Receive process, if an ASN has been associated to the order prior to the order being received
      4. Confirm that the Suggested Order Export includes a new element that represents the Distributor Invoice Number when the order is changed thru the Change Apply Date process, if an ASN has been associated to the order prior to the order being received
      5. Confirm that the Suggested Order Export includes a new element that represents the Distributor Invoice Number when the order is Canceled, if an ASN has been associated to the order prior to the order being received
      6. Confirm that the Suggested Order Export does NOT include the new element (DistributorInvoiceNumber) when the order is Received and an ASN has NOT been associated to the order
      7. Confirm that the Suggested Order Export does NOT include the new element (DistributorInvoiceNumber) the order is changed thru the Correct Receive process and an ASN has NOT been associated to the order
      8. Confirm that the Suggested Order Export does NOT include the new element (DistributorInvoiceNumber)when the order is changed thru the Change Apply Date process and an ASN has NOT been associated to the order
      9. Confirm that the Suggested Order Export does NOT include the new element (DistributorInvoiceNumber) when the order is Cancelled and an ASN has NOT been associated to the order
      XSLT

      To use Invoice # in ASN
      <xsl:attribute name ="InvoiceNumber">
      <xsl:value-of select ="cbc:ID"/>
      </xsl:attribute>

      To blank out the invoice number that is supplied in the ASN
      <xsl:attribute name ="InvoiceNumber">
      <xsl:value-of select ="''"/>
      </xsl:attribute>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 13h 40m
                  13h 40m
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 11.75h Time Not Required
                  11.75h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.