Skip to main content

Hello everyone,

 

Looking for some insight on the title. 

Customer requires BR to generate in CSV format: 

Report is as follows: 

They required all approved expense sheet details grouping by Payroll ID and Rate. 

We had the ability to create an IAL for this data including the grouping as well. The Start and End dates are taken from the same field, Expense Date in IFS where Start Date shows the date for the oldest expense sheet and end date shows the newest expense sheet. 

However, where we hit a wall was the search parameters were based on the ‘Approve date’ which can carry many different dates so the grouping in the SQL did not work. 

We decided to create an IAL bearing all the data in the table plus the approve date and decided to perform all the other functions using Excel and it was a success. 

The report however now contained multiple worksheets and hidden cells of course due to the functions.

The current solution we provided was to move all visible cells into a new workbook and save it as CSV. which works. 

 

Is there any other way we can go around this? Any way we can get it done from IFS? The customer is a bit hesitant to follow through with manual work due to the report being related to payroll. 

 

Thank you very much,

Hello everyone,

 

Looking for some insight on the title. 

Customer requires BR to generate in CSV format: 

Report is as follows: 

They required all approved expense sheet details grouping by Payroll ID and Rate. 

We had the ability to create an IAL for this data including the grouping as well. The Start and End dates are taken from the same field, Expense Date in IFS where Start Date shows the date for the oldest expense sheet and end date shows the newest expense sheet. 

However, where we hit a wall was the search parameters were based on the ‘Approve date’ which can carry many different dates so the grouping in the SQL did not work. 

We decided to create an IAL bearing all the data in the table plus the approve date and decided to perform all the other functions using Excel and it was a success. 

The report however now contained multiple worksheets and hidden cells of course due to the functions.

The current solution we provided was to move all visible cells into a new workbook and save it as CSV. which works. 

 

Is there any other way we can go around this? Any way we can get it done from IFS? The customer is a bit hesitant to follow through with manual work due to the report being related to payroll. 

 

Thank you very much,

@Manusha as far as I know, report generated through the BR client has other hidden sheets to hold data, in Excel we have a limitation itself where by default even if save it as csv manually it will only save the first sheet. I have seen some VBA codes that can use to automatically convert the workbook into csv, but not sure whether it will work hand in hand with BR client reports. More likely to my knowledge this automation is not possible at this point 

Kind Regards!

Niyomal

Reply


Terms & ConditionsCookie settings