Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

自定义规则中,数据源一旦使用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
355 views