Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

自定义规则中,数据源一旦使用YTD就会造成合并时长很久

user-x53cvMay 25 2023

FIX("FCCS_OpeningBalanceAdjustment","FCCS_Managed Data","FCCS_No Intercompany","No Project","No CostCenter","No Material","No Other","Entity Currency","FCCS_Periodic","FCCS_Entity Input")
Account(
If(@ISMBR("Jan"))
"303002" = "304001" ->"FCCS_Intercompany Top"->"FCCS_Managed Data"->"FCCS_ClosingBalance"->"Total Project"->"Total CostCenter"->"Total Material"->"Total Other"->"FCCS_Entity Total"->"FCCS_YTD"->"Dec"->@MEMBER(@PREVSIBLING(@CURRMBR("Years")))
+ "304001" ->"FCCS_Intercompany Top"->"D365 Audit Load" ->"FCCS_ClosingBalance"->"Total Project"->"Total CostCenter"->"Total Material"->"Total Other"->"FCCS_Entity Total"->"FCCS_YTD"->"Dec"->@MEMBER(@PREVSIBLING(@CURRMBR("Years")))
+ "PRC_PL_01"->"FCCS_Intercompany Top"->"FCCS_Managed Data"->"FCCS_ClosingBalance"->"Total Project"->"Total CostCenter"->"Total Material"->"Total Other"->"FCCS_Entity Total"->"FCCS_YTD"->"Dec"->@MEMBER(@PREVSIBLING(@CURRMBR("Years")))
+ "PRC_PL_01"->"FCCS_Intercompany Top"->"D365 Audit Load" ->"FCCS_ClosingBalance"->"Total Project"->"Total CostCenter"->"Total Material"->"Total Other"->"FCCS_Entity Total"->"FCCS_YTD"->"Dec"->@MEMBER(@PREVSIBLING(@CURRMBR("Years")))
- "303002"->"FCCS_Entity Consolidation";
EndIf;
)ENDFIX

上述语句中,一旦数据源引用“FCCS_YTD”就合并很久

Comments
Post Details
Added on May 25 2023
1 comment
213 views