Dayalan Punniyamoorthy Blog

Memaparkan catatan dengan label Add a New Row. Papar semua catatan
Memaparkan catatan dengan label Add a New Row. Papar semua catatan

Isnin, 18 Disember 2023

Add a New row to enter data for a New Product or a Customer - Using Groovy Part 2

 In the Part -1  we saw how to add a new row for a New Product or a Customer using the Calculation Manager rule. In this post, we will see how to do the same using the Groovy rule. 

This is the data from where add a row option is enabled,


Column A is hidden and the rest of the column will be visible.


The actual form is shown below, 

Isnin, 13 November 2023

Add a New row to enter data for a New Product or a Customer - Part 1

 In this blog, let's discuss how to address the requirements of entering data into a New Product or a Customer in a Data From exists in the PBCS or EPBCS application where the Suppress missing data for Rows or Suppress Missing data for Columns are enabled. Or the data does not exist for that combination but the users want a provision to enter the data for that specific combination. 

During the Budget or the Forecast, the users might want to enter data for a combination that never had any historical data. 

It is a general best practice the Data Forms will be enabled with the following,

  • Suppress missing data - Rows
  • Suppress missing data - Columns