![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/02\/ExecuteAnonymous.jpg\")
<\/p>\n<\/p>\n
If you heavily customise posting rules, I’m sure you will have come across this problem. The posting rules look fine, but when you add a new Journal the UX does not ask for the right fields, or the journal just fails to post. Here is a video showing the problem<\/a>:<\/p>\n My guess is it is some kind of caching of the posting rules and my normal way around this was to clone the Journal Type and the clone would work fine. However, if you already have transactions using the Journal Type that is not a viable option, and I’ve been having problems with Journal cloning…<\/p>\n What you need to do is give the Journal Type a real good kicking, and here is some APEX code which will do just that if you run it in ‘Execute Anonymous’ :<\/p>\n <\/p>\n The TargetJournalTypeID is the Id of the Journal Type you are trying to fix, the DummyJournalTypeID\u00a0 is some other Journal Type. The code moves all the posting rules to the DummyJournalType and then moves them all back again. This seems to fire something in Financials which clears out the problem.<\/p>\n If you don’t know how to get the Journal Type Id’s or you don’t know what\u00a0‘Execute Anonymous’\u00a0 is DO NOT try this.<\/p>\n In best Blue Peter tradition:<\/p>\n <\/p>\n <\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" WARNING – EXPERTS ONLY Journal Posting problems If you heavily customise posting rules, I’m sure you will have come across this problem. The posting rules look fine, but when you add a new Journal the UX does not ask for the right fields, or the journal just fails to post. Here is a video showing Read more about Fixing Journal Posting Rule<\/span>[…]<\/a><\/p>\n","protected":false},"author":1,"featured_media":249,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[7],"_links":{"self":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/569"}],"collection":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":0,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/569\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media\/249"}],"wp:attachment":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media?parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/categories?post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/tags?post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} \/\/ This will remove all the posting rules from a Journal Type and then re connect them.\r\nid lvTargetJournalTypeID = 'a0r1v00000gXPiBAAW'; \/\/The Journal you are trying to fix\r\nid lvDummyJournalTypeId = 'a0r1v00000hIPZ5AAO'; \/\/Some other Journal\r\n\r\nList<s2cor__Sage_ACC_Posting_Rule__c> lvPostingRuleList = [Select s2cor__Journal_Type__c, Name, Id \r\n From s2cor__Sage_ACC_Posting_Rule__c\r\n where s2cor__Journal_Type__c = : lvTargetJournalTypeID];\r\nsystem.debug('Update ' + lvPostingRuleList.size() + ' posting rules');\r\n\r\nfor(s2cor__Sage_ACC_Posting_Rule__c lvPostingRule : lvPostingRuleList){\r\n lvPostingRule.s2cor__Journal_Type__c = lvDummyJournalTypeId;\r\n}\r\n\r\nupdate lvPostingRuleList;\r\n\r\nfor(s2cor__Sage_ACC_Posting_Rule__c lvPostingRule : lvPostingRuleList){\r\n lvPostingRule.s2cor__Journal_Type__c = lvTargetJournalTypeID;\r\n}\r\n\r\nupdate lvPostingRuleList;<\/pre>\nWARNING – EXPERTS ONLY<\/h1>\n
DO NOT TRY THIS AT HOME<\/h1>\n