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

akrem
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

image.png

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

image.png
image.png
image.png

Answers

  • HimanshuRaj
    HimanshuRaj

    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

    2.PNG
    1.PNG

    Hope, this resolves your issue

  • akrem
    akrem

    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 ?

    image.png
    image.png

  • HimanshuRaj
    HimanshuRaj

    Hi @akrem

    “Weeks” appear under Time Period dropdown

    Capture.PNG

    Thanks

  • akrem
    akrem
    edited March 2023

    Thank you

  • akrem
    akrem

    Hello,

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

    Mine:

    image.png

    Yours:

    image.png

    Formulas:

    image.png

    Time Settings:

    image.png

  • HimanshuRaj
    HimanshuRaj

    Hi @akrem

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

  • akrem
    akrem

    Excellent thanks again.

Categories