|'StockTransactions' BI Export Improvement
|The 'StockTransactions' BI export will now display the document statuses, as per the Document Reconciliation screen
Release date: January 24th 2023
- Enabled by Default? - Yes
- Set up by customer Admin? - No
- Enable via Support ticket? - No
- Affects configuration or data? - Yes
The d_stocktrans_custom_code2.nm_custom_code2 column in the 'StockTransactions' BI export will now contain the document reconciliation status (as seen on the Document Reconciliation screen).
Reason for the Change
Currently, if a GRN is not threaded to an Invoice then in the 'StockTransactions' export there are no values in the aforementioned column. This can cause confusion for customers, who do see a status on the Document Reconciliation screen.
All Inventory customers who use P2P&I Analytics.
The example in Fig.1 shows the empty values in the 'StockTransactions' export for dstocktranscustomcode2.nmcustom_code2 column.
After this release is completed, the Status as shown in Fig.2 will be used to populate the values in that column (in Fig.1).
Fig.1 - Null values in d_stocktrans_custom_code2.nm_custom_code2 (column V)
Fig.2 - Displays status on Inventory UI on document reconciliation screen