Forum Discussion

ERICCFG's avatar
ERICCFG
Frequent Visitor
1 year ago
Solved

Sage 300 date overlap problem.

Hello, I have a date overlap problem. I have an accounting entry table (sage 300) where there is a date column, fiscal year, period etc. In some cases the accounting entry date is the same for two pe...
  • ERICCFG's avatar
    ERICCFG
    1 year ago

    thank you

     

    I found the solution,

     

    CALCULATE(
        SUM(GLACC[Valeur]),
        GLACC[Type] = "2-Dépense",
        TREATAS(VALUES(Calendrier[Période]), GLACC[Période]),
        TREATAS(VALUES(Calendrier[Année Fiscale]), GLACC[Année Fiscale]),
        ALL(Calendrier) -- Supprime le filtre sur la date
     
    Thnank you for the people, they write me
some_bih's avatar
some_bih
Community Champion
1 year ago

Hi ERICCFG on link you can find standard calendar creation and fiscal year too. It also showing a lot of examples with measures, like sales fiscal year (search fiscal)

ERICCFG's avatar
ERICCFG
Frequent Visitor
1 year ago

thank you

 

I found the solution,

 

CALCULATE(
    SUM(GLACC[Valeur]),
    GLACC[Type] = "2-Dépense",
    TREATAS(VALUES(Calendrier[Période]), GLACC[Période]),
    TREATAS(VALUES(Calendrier[Année Fiscale]), GLACC[Année Fiscale]),
    ALL(Calendrier) -- Supprime le filtre sur la date
 
Thnank you for the people, they write me
  • some_bih's avatar
    some_bih
    Community Champion
    1 year ago

    Hi ERICCFG great. If some of posts here helped you mark ita as solution, so other could see it.