Get Started with Redwood: Oracle Cloud SCM and Purchasing
SQL Query to fetch Invoice to GRN Matching Report which includes PO ,Invoice and Receipt details
in Purchasing
Summary:
Need proper joins
Content (please ensure you mask any confidential information):
PO_NUMBER | GRN_NUMBER | INVOICE_NUMBER | QUANTITY | QUANTITY_RECEIVED | QUANTITY_OUTSTANDING | PO_APPROVED_DATE | PO_AMOUNT | PO_VALUE_RECEIVED | PO_VALUE_OUTSTANDING | NATURE_STYLE | LINE_NUM | Match_Status |
|---|
Version (include the version you are using, if applicable):
25C
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0