-
Type: Story
-
Status: Closed (View Workflow)
-
Resolution: Completed
-
Affects Version/s: None
-
Fix Version/s: CFA 2019R3
-
Component/s: Exports
-
Labels:
-
Sprint:CFAMX 2019R3 Sprint 4
-
SCRUM Team:Globogym Purple Cobras
-
SOW (Time Tracking) Project:44918
-
Work Type Classification:Sustaining
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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
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>
- implements
-
CFAMX-3005 Add Additional fields to SO export
- Closed
- relates to
-
CFAMX-5421 SO Export - suppress DistributorInvoiceNumber element when no data is present
- Done
-
CFAMX-5422 CLONE 2019R3 - SO Export - suppress DistributorInvoiceNumber element when no data is present
- Done