Forum Discussion

Justin_Zurn's avatar
Justin_Zurn
New Contributor
1 day 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 Sa...
Admin
Finance
System
rhankey's avatar
rhankey
Contributor III
20 hours 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
    17 hours 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