Skip to main content

Regarding Formulas in the Vertical Header

 

Because all data entered from the vertical header is copied to the hidden BKPF header fields, formulas arenotpermitted in the vertical header data entry fields. For example, if you have a “Document Header Text” field in vertical header and attempt to enter a “=glsu_description()” formula, GLSU will let you know that this cannot be done. If you chose to continue, GLSU will unhide the BKPF header and place the cell selection in the proper field. This is where you enter all header formulas. As the formulas create a change in the BKPF header cell, this data will be copied to the vertical header for you. Please also keep in mind that entering a formula anywhere on the GLSU template that references a cell in the vertical header area will not work as expected. As you make changes to the fields in the vertical header using the “Choose fields” screen, the vertical header is effectively removed and recreated. Therefore, any formulas in the GLSU template that are tied to a cell in the vertical header will also be removed by Excel.

 

Was this article helpful?

We're sorry to hear that.