The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Justin_Zurn's avatar
Justin_Zurn
New Contributor
2 months ago

Orders calculation formula using Backlog and Sales Accounts

Hello,

I'm attempting to create an orders (500055) account, calculated using existing Backlog (500054) and Sales (100020) Accounts.   (Current Month Backlog - Prior Month Backlog + Current Month Sales)

When I run this calculation in the forecast scenario, February - December work as expected, but there is an issue with January that I can't pinpoint.  Any ideas where I've gone wrong?

Thank you in advance,

Justin Trad

 
 
 
If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity)) And api.Time.GetPeriodNumFromId(api.Pov.Time.MemberID) = 1 Then
   
api.data.calculate("A#500055:T#PovYearM1:O#import:U1#none:U2#none:U5#none:U6#none = (A#500054:T#PovYearM1:O#top:U1#top:U2#top:U5#top:U6#top - A#500054:T#PovPriorYearM12:O#top:U1#top:U2#top:U5#top:U6#top) + A#100020:T#PovYearM1:O#top:U1#top:U2#top:U5#top:U6#top")
 
Else If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity)) Then
                                       
api.data.calculate("A#500055:T#Pov:O#import:U1#none:U2#none:U5#none:U6#none = (A#500054:T#Pov:O#top:U1#top:U2#top:U5#top:U6#top - A#500054:T#PovPrior1:O#top:U1#top:U2#top:U5#top:U6#top) + A#100020:T#Pov:O#top:U1#top:U2#top:U5#top:U6#top")
 
End If
Admin
Finance
System

2 Replies

  • rhankey's avatar
    rhankey
    Contributor III
    2 months ago

    You don't specify what is occurring with the M1 logic.

    I would start by replacing the T#PovYearM1 on the destination side with T#POV, as though this Calculate() is being run for M1, OS isn't usually happy if it thinks you could be attemptingto write to a different DataUnit than you are currently in.

    Beyond that, you're going to need to provide a little more clues as to what is occurring with the M1 logic.

    • Justin_Zurn's avatar
      Justin_Zurn
      New Contributor
      2 months ago

      Thanks for reviewing rhankey,

      For M1, it appears as if the Prior Year Backlog portion of the formula is being left out.

      " - A#500054:T#PovPriorYearM12:O#top:U1#top:U2#top:U5#top:U6#top)"

      Unsure of the cause at this point.  Will continue to troubleshoot.

       

      Thank you,

      Justin Trad