3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items

akrem
edited March 2023 in Academy Discussions

Time scale issue can't get to IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN 0 ELSE 1

DAT01 There is no time scale

INV01 dimentsion by week, How do I get to part of formula to reference week ? There is nothing in SYS01 that allows me to select “First Week of Timescale”

IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN 0 ELSE 1

Answers

  • Hi @akrem

    You need to create “First week of Timescale” line item logic in your sys module. You can follow below steps to create this:

    The model calendar I have followed is “Weeks: 4-4-5”. You need to check your model calendar and adjust the logics accordingly if you have a different model calendar

    Hope, this resolves your issue

  • Hi I am in the Supply chain module using SYS01 Time Settings by Week. I added a field called “Weeks” to test this.

    1. How did you get Format as (Week) its not an option only text, boolean or list ?
    2. There is no such list for ITEM(Time) to make this work ?

  • Hi @akrem

    “Weeks” appear under Time Period dropdown

    Thanks

  • akrem
    edited March 2023

    Thank you

  • Hello,

    Is there any reason my first week of timescale is not being checked off ? compare our screenshot below.

    Mine:

    Yours:

    Formulas:

    Time Settings:

  • Hi @akrem

    For the “First week of staging” line item, set the timescale to “Month”. See my screenshot attached above

  • Excellent thanks again.