IBM Support

SELLER_ORGANIZATION_CODE in YFS_ORDER_INVOICE does not get populated for Credit and Debit Invoices

Troubleshooting


Problem

SELLER_ORGANIZATION_CODE in YFS_ORDER_INVOICE does not get populated for Credit and Debit Invoices

Symptom

When a Credit or Debit invoice is created, SELLER_ORGANIZATION_CODE in the YFS_ORDER_INVOICE is blank. Because of this Credit or Debit invoice cannot be retrieved based on Seller Organization Code. SELLER_ORGANIZATION_CODE is populated only for SHIPMENT invoice.

Resolving The Problem

YFS_ORDER_INVOICE table has ORDER_HEADER_KEY column populated for all the invoice types. Use OrderHeaderKey to fetch SellerOrganizationCode of the order and populate this value in YFS_ORDER_INVOICE table.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX8026

Document Information

Modified date:
16 June 2018

UID

swg21558697