Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need to add Master Calendar to your application and then you will have those extra dates available in your application
Master Calendar Generation Script
This blog post may help you: How to populate a sparsely populated field