Beginning/End of Period Balances Sheet

[Phan_Anh_Son]

Beginning/End of Period Balances

Hi All,

How to fill periods in Open columns?. Pease let me know if you have any suggestions. 

Thanks,

[marksouzacosta]

Can you please give more examples of the output that you are expecting?

[Phan_Anh_Son]

Sorry my english is not good,

How to get the Balance number from the previous day and put it in the open column of the next day.

Thanks,

[zhaofeng]

Hi

I‘ve tried to make an example for you.Hope this reply can solve your problem.

[Phan_Anh_Son]

Thanks for your help, zhaofeng

But I want the number in Open column is previous day's number in Balance column

and Balance = Open + Purchase - Sales

Thanks,

[zhaofeng · Accepted solution]

I‘ve made some changes to this example,please check it.

[Phan_Anh_Son]

Thank you for your help.

[Phan_Anh_Son]

Thank you for your help But why "data error" when loading from excel data table?

[zhaofeng · Accepted solution]

Accroding to the screenshot on the right,you need to add a table name in line 12.

Data:
Load
 Date,
 ID,
 Purchase,
 Sales
From [your file path];

[Phan_Anh_Son]

Thank you for your help.