Fill in extra dates

[sjhussain]

‌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]

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

Creating A Master Calendar

Master Calendar Generation Script

Understanding the Master Calendar (video)

The Master Calendar

[Nicole-Smith]

This blog post may help you: How to populate a sparsely populated field