Fill in extra dates

sjhussain · ‎2016-05-04

‌Hello

Hope everyone is fine.

We have a GL table and would like to fill in the dates with 0 amount. The table has the following example information.

There will be a lot of missing data for the date which we want to fill.

CompanyName, BusinessLine, ACCTID,Date,Amount

abc,bl1,revenue,jan-2016,45000

abc,bl1,revenue,mar-2016,90000

abc,bl1,revenue,may-2016,10000

what we want to do is to insert

abc,bl1,revenue,feb-2016,0 And

abc,bl1,revenue,apr-2016,0

hope someone can assist us.

thanks

sunny_talwar · ‎2016-05-04

You need to add Master Calendar to your application and then you will have those extra dates available in your application

Nicole-Smith · ‎2016-05-04