You are not logged in.

figure from Previous Month

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Hiten

Intermediate

  • "Hiten" started this thread

Posts: 5

Date of registration: Jul 21st 2009

Location: Sydney

  • Send private message

1

Tuesday, July 21st 2009, 8:08am

figure from Previous Month

Hi

i am very new to Palo so excuse my ignorance.

I have a Dimension
with

Product
A - Z

Then for the Product

I have Measures

Opening Stock
Sales
Closing Stock

I have manually written in the Opening Stock figure for July 2009

So Opening Stock 29 - Sales = Closing Stock

i.e. 29 - 10 = 19

19 is the Closing Stock for July 2009

how do I push that 19 to be the Opening Stock for August 2009?

I am completely lost

HELP

Thanks
Hightower :D

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Tuesday, July 21st 2009, 9:12am

I have a time dimension for this:

Source code

 
1
2
3
4
5
6
7
8
9
10

C	201903
	  	YTD201903	1
  	            YTD201902	-1

C	YTD201903
	E_AB2019	1
  	E_A201903	1
  	E_V201901	1
  	E_V201902	1
  	E_V201903	1


Measure is stock(-change)

My fiscal year starts in January. The opening balance goes into E_AB2019. There is some year-changeovver to be considered.

Then you enter either the change in stock into E_V... or the stock at end of month into E_A...

On the surface you always see what went on with in the period YYYYMM or up to the end of period YTDYYYYMM regardless of the kind of input e.g. stock at end of month or costs

jgibbs

Sage

  • "jgibbs" is male

Posts: 154

Date of registration: Dec 5th 2006

Location: Toronto

Occupation: Accountant

  • Send private message

3

Tuesday, July 21st 2009, 4:28pm

My solution is similar to Axi's

I have the following elements

Opening balance
Period 01
Period 02
etc

Then I make separate consolidations

YTD P1 = Opening Balance + Period 01
YTD P2 = Opening Balance + Period 01 + Period 02
etc

Or you could just let YTD P2 = YTD P1 + Period 02. I like to drill down to the individual periods though.

This is how I manage my balance sheet accounts.

Hope that helps,
Jason

Hiten

Intermediate

  • "Hiten" started this thread

Posts: 5

Date of registration: Jul 21st 2009

Location: Sydney

  • Send private message

4

Wednesday, July 22nd 2009, 4:57am

Nearly seeing the light

Ok I think I am understanding what you are saying, let me just double check

At the mo my Paste View

Jan Feb Mar
Opening Stock 30 29 33
Sales 5 1
Goods Received 4 5
Closing Stock 29 33

Sorry being a dummy, but still lost how i get the 29 from Closing stock in Jan to be opening stock of feb

or am i thinking of this all wrong??
Hightower :D

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

5

Wednesday, July 22nd 2009, 11:05am

let Palo do the calculations!

you supply EITHER balances OR variations

the hierarchy (+/-) takes care of the other

openening blance: 0
Jan +5
=> End of Jan: 5

Feb +8
=> End of Feb: 13

Mar -2
=> End of Mar: 11

OR

openening blance: 0
End of Jan: 5
=> Jan +5

End of Feb: 13
=> Feb +8

End of Mar: 11
=> Mar -2

Hiten

Intermediate

  • "Hiten" started this thread

Posts: 5

Date of registration: Jul 21st 2009

Location: Sydney

  • Send private message

6

Thursday, July 23rd 2009, 1:52am

Light

Arrr I see...

Think I have seen the light!! Thanks MATE
Hightower :D
Rate this thread