January 24th 2023, Release Note: Inventory | Restaurants: Improvement to 'StockTransactions' BI Export

Summary

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

What’s Changing?

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. 

Customers Affected

All Inventory customers who use P2P&I Analytics.

Release Notes/Steps

Notes 

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