{"id":1247,"date":"2017-12-13T15:25:00","date_gmt":"2017-12-13T15:25:00","guid":{"rendered":"http:\/\/blogs.kent.ac.uk\/finance-news\/?p=1247"},"modified":"2017-12-13T15:25:00","modified_gmt":"2017-12-13T15:25:00","slug":"agresso-update","status":"publish","type":"post","link":"https:\/\/blogs.kent.ac.uk\/finance-news\/2017\/12\/13\/agresso-update\/","title":{"rendered":"Agresso Update"},"content":{"rendered":"

\"\"<\/a><\/p>\n

Christmas Closing<\/strong><\/h3>\n

During the Christmas closure period access to Agresso will be withdrawn from \u00a012:30pm 21st<\/sup> December 2017 to 9am 3rd<\/sup> January 2018<\/strong> as the support team will not be able to respond to any queries raised.<\/p>\n

Please ensure all transactions are completed by 12:30pm on the \u00a021st<\/sup> December<\/strong>.<\/p>\n

 <\/p>\n

Information to be Aware Of<\/strong><\/h3>\n

It\u00a0recently came to light there was an issue copying data from General Ledger Transactions to Microsoft Excel.<\/p>\n

The issue was as follows:<\/p>\n

\u00a0<\/strong>Agresso:<\/strong><\/p>\n

\u00a0\"\"<\/a><\/strong><\/p>\n

Excel:<\/strong><\/p>\n

\"\"<\/a><\/p>\n

You can see that the data has not copied to Excel correctly. After further investigation, the underlying issue was found to be the Text field information within lines two and three – “23”” HP Pavillion all in one PC Product Code 1Y32EA#ABU23-<\/strong><\/p>\n

The main problem in the text field is the \u201c23\u201d\u201d<\/strong> \u2013 As the number has been wrapped by \u201c \u201c<\/strong> the result is that excel will not fully paste all of the information after the affected line.<\/p>\n

We recommend that text or numbers within Agresso are not wrapped with quotation marks to ensure data can be exported correctly.<\/p>\n","protected":false},"excerpt":{"rendered":"

Christmas Closing During the Christmas closure period access to Agresso will be withdrawn from \u00a012:30pm 21st December 2017 to 9am 3rd January 2018 as the … Read more<\/a><\/p>\n","protected":false},"author":48822,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"image","meta":[],"categories":[137333],"tags":[],"_links":{"self":[{"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/posts\/1247"}],"collection":[{"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/users\/48822"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/comments?post=1247"}],"version-history":[{"count":5,"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/posts\/1247\/revisions"}],"predecessor-version":[{"id":1273,"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/posts\/1247\/revisions\/1273"}],"wp:attachment":[{"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/media?parent=1247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/categories?post=1247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.kent.ac.uk\/finance-news\/wp-json\/wp\/v2\/tags?post=1247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}