{"id":87048,"date":"2020-04-09T15:06:04","date_gmt":"2020-04-09T06:06:04","guid":{"rendered":"https:\/\/support.questetra.com\/?p=87048"},"modified":"2022-06-01T15:37:00","modified_gmt":"2022-06-01T06:37:00","slug":"moneyforward-journal-create","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/","title":{"rendered":"MoneyForward Journal, Create"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create-2021\/_\">https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">MoneyForward Journal, Create<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2020-04-08 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/\">https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li> A: Select STRING DATA for Slip Description<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Select NUMERIC DATA for Sales Amount (Single Record)<\/li>\n<li> C: Select DATE DATA for Sales Record (Single Record)<\/li>\n<li> D: Select NUMERIC DATA for Sales Amount (Multiple Records)<\/li>\n<li> E: Select DATE DATA for First Sales Record (Next Month 1st Day)<\/li>\n<li> F: Select NUMERIC DATA for Division Number<\/li>\n<li> G: Select DATE DATA for Scheduled Due Date<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> M: Set Record Tpl for Receivable Single (e.g. &#8220;,,AR,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> N: Set Record Tpl for Received Single (e.g. &#8220;,,Rvd,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> P: Set Record Tpl for Receivable Sales (e.g. &#8220;,,AR,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> Q: Set Record Tpl for Received Sales (e.g. &#8220;,,Rvd,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> R: Set Record Tpl for Payment of Receivable (e.g. &#8220;Bank,,na&#8221;)<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> S: Set Record Tpl for Payment of Received (e.g. &#8220;Bank,,na&#8221;)<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> X: Select STRING DATA for TSV (update)<\/li>\n<li> Y: Select FILES DATA for Excel-CSV (update)<\/li>\n<li> Z: Set End Month of Fiscal Period (eg March: &#8220;3&#8221; )<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Nashorn Script (engine type: 1)\n\/\/ \n\/\/ Notes:\n\/\/ \"Transaction No.\"\n\/\/ - The slip generated on April 1 = 8 digits of \"401yyyzz\" (closing month \"12\").\n\/\/ - The slip generated on April 1 = 8 digits of \"101yyyzz\" (closing month \"3\").\n\/\/ - The slip generated on March 31 = 9 digits \"1231yyyzz\" (closing month \"3\").\n\/\/ - The yyy part is the last three digits of {process ID}.\n\/\/ - The zz part is the split ID (01,02, ...).\n\/\/ - It may be renumbered when imported to MF.\n\/\/ - \"Transaction No.\" such as \"manual entry\" will be the increment value.\n\/\/ No header row is added to the generated \"journal TSV\". (for Sheet Append)\n\/\/ The following 21 items are posted in the header line of \"Journal Excel-CSV\"\n\/\/ - &#091;0] Transaction No, &#091;1] Transaction Date,\n\/\/ - &#091;2] Debit account, &#091;3] Debit sub-item, &#091;4] Debit tax classification,\n\/\/ - &#091;5] Debit department, &#091;6] Debit amount (yen), &#091;7] Debit tax amount,\n\/\/ - &#091;8] Credit account, &#091;9] Credit sub-item, &#091;10] Credit tax classification,\n\/\/ - &#091;11] Credit department, &#091;12] Credit amount (yen), &#091;13] Credit tax amount,\n\/\/ - &#091;14] description, &#091;15] journal memo, &#091;16] tag, &#091;17] MF journal type,\n\/\/ - &#091;18] Closing journal, &#091;19] Creation date, &#091;20] Last update date\n\/\/ #Money Forward journal_sample.csv\n\/\/ https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html\n\/\/ The description of the split sales records in the format \"2020-04 @ {Description}\".\n\/\/\n\/\/ Notes (ja):\n\/\/ \"\u53d6\u5f15No\" \u306f\u3001\n\/\/ - 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c\"12\"\u306e\u5834\u5408 \"401yyyzz\" \u306e8\u6841\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/ - 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c \"3\"\u306e\u5834\u5408 \"101yyyzz\" \u306e8\u6841\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/ - 3\u670831\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c\"3\"\u306e\u5834\u5408\"1231yyyzz\" \u306e9\u6841\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/ - yyy \u90e8\u306f {\u30d7\u30ed\u30bb\u30b9ID} \u306e\u4e0b\u4e09\u6841\u306b\u306a\u308a\u307e\u3059\u3002\n\/\/ - zz \u90e8\u306f\u5206\u5272ID\u306b\u306a\u308a\u307e\u3059\uff0801,02,\u2026\uff09\u3002\n\/\/ - \u203bMF\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u969b\u306b\u30ea\u30ca\u30f3\u30d0\u30fc\u3055\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n\/\/ - \u203b\u305d\u306e\u5f8c\u306e\u300c\u624b\u52d5\u3067\u4ed5\u8a33\u300d\u7b49\u306e \"\u53d6\u5f15No\" \u306f\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5024\u306b\u306a\u308a\u307e\u3059\u3002\n\/\/ \u751f\u6210\u3055\u308c\u308b\u300c\u4ed5\u8a33TSV\u300d\u306b\u30d8\u30c3\u30c0\u884c\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002\uff08Sheet\u8ffd\u8a18\u304c\u60f3\u5b9a\u3055\u308c\u308b\u305f\u3081\uff09\n\/\/ \u751f\u6210\u3055\u308c\u308b\u300c\u4ed5\u8a33Excel-CSV\u300d\u306e\u30d8\u30c3\u30c0\u884c\u306b\u306f\u4ee5\u4e0b\u306e21\u9805\u76ee\u304cCSV\u5f62\u5f0f\u3067\u63b2\u793a\u3055\u308c\u307e\u3059\n\/\/ - &#091;0]\u53d6\u5f15No,&#091;1]\u53d6\u5f15\u65e5,\n\/\/ - &#091;2]\u501f\u65b9\u52d8\u5b9a\u79d1\u76ee,&#091;3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee,&#091;4]\u501f\u65b9\u7a0e\u533a\u5206,\n\/\/ - &#091;5]\u501f\u65b9\u90e8\u9580,&#091;6]\u501f\u65b9\u91d1\u984d(\u5186),&#091;7]\u501f\u65b9\u7a0e\u984d,\n\/\/ - &#091;8]\u8cb8\u65b9\u52d8\u5b9a\u79d1\u76ee,&#091;9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee,&#091;10]\u8cb8\u65b9\u7a0e\u533a\u5206,\n\/\/ - &#091;11]\u8cb8\u65b9\u90e8\u9580,&#091;12]\u8cb8\u65b9\u91d1\u984d(\u5186),&#091;13]\u8cb8\u65b9\u7a0e\u984d,\n\/\/ - &#091;14]\u6458\u8981,&#091;15]\u4ed5\u8a33\u30e1\u30e2,&#091;16]\u30bf\u30b0,&#091;17]MF\u4ed5\u8a33\u30bf\u30a4\u30d7,\n\/\/ - &#091;18]\u6c7a\u7b97\u6574\u7406\u4ed5\u8a33,&#091;19]\u4f5c\u6210\u65e5\u6642,&#091;20]\u6700\u7d42\u66f4\u65b0\u65e5\u6642\n\/\/ \uff03Money Forward journal_sample.csv\n\/\/ https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html\n\/\/ \u5206\u5272\u3055\u308c\u305f\u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u306e\u6458\u8981\u306f \"2020-04 @ {\u6458\u8981}\" \u3068\u3044\u3063\u305f\u66f8\u5f0f\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/\n\/\/ \uff1c\uff14\u4f1d\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u8a2d\u5b9a\u4f8b\uff1e\n\/\/ \u30ab\u30f3\u30de\uff0820\u500b\uff09\u3067\u533a\u5207\u3089\u308c\u305f\u6587\u5b57\u5217\u3067\u632f\u66ff\u4f1d\u7968\u884c\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n\/\/ \u5909\u6570\uff08EL\u5f0f\uff09\u3092\u633f\u5165\u3059\u308b\u3068\u3001\u5909\u6570\u90e8\u304c\u6848\u4ef6\u306b\u5fdc\u3058\u3066\u5909\u5316\u3057\u307e\u3059\u3002\n\/\/ \u203b\u306a\u304a \"&#091;0],&#091;1],&#091;6],&#091;12],&#091;14]\" \u306e\u5404\u9805\u306f\u81ea\u52d5\u7684\u306b\u4e0a\u66f8\u304d\u3055\u308c\u307e\u3059\n\/\/ \n\/\/ - \u58f2\u639b\u91d1\u58f2\u4e0a\u4f1d\u7968\u3092\u300e&#091;17]MF\u4ed5\u8a33\u30bf\u30a4\u30d7\u300f\u3092 \"\u672a\u5b9f\u73fe\" \u306b\u3057\u305f\u3044\u5834\u5408\n\/\/ -- \",,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,\u672a\u5b9f\u73fe,,,\"\n\/\/ - \u524d\u53d7\u91d1\u58f2\u4e0a\u4f1d\u7968\u306e\u300e&#091;3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 \"\u53d6\u5f15\u5148\" \u306b\u300e&#091;9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 \"\u5546\u54c1\u7a2e\" \u306b\n\/\/ -- \",,\u524d\u53d7\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,#{#q_Product},\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,\"\n\/\/ - \u58f2\u639b\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e&#091;9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 \"\u53d6\u5f15\u5148\" \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 \"\u672a\u5b9f\u73fe\" \u306b\n\/\/ -- \",,\u666e\u901a\u8caf\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,,,,\u672a\u5b9f\u73fe,,,\"\n\/\/ - \u524d\u53d7\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e&#091;9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 \"\u53d6\u5f15\u5148\" \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 \"\u672a\u5b9f\u73fe\" \u306b\n\/\/ -- \",,\u666e\u901a\u8caf\u91d1,\u307f\u305a\u307b\u9280\u884c,\u5bfe\u8c61\u5916,,,0,\u524d\u53d7\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,,,,\u672a\u5b9f\u73fe,,,\"\n\n\n\/\/\/\/\/\/\/\/ START \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == for \"MoneyForward\u30af\u30e9\u30a6\u30c9\u4f1a\u8a08\" ==\nconst myNumOfCols = 21; \/\/ \u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u306e\u30d8\u30c3\u30c0\u884c\u306f\u4ee5\u4e0b\u306e21\u9805\u76ee\nconst headerRow =\n  \"\u53d6\u5f15No,\u53d6\u5f15\u65e5,\u501f\u65b9\u52d8\u5b9a\u79d1\u76ee,\u501f\u65b9\u88dc\u52a9\u79d1\u76ee,\u501f\u65b9\u7a0e\u533a\u5206,\u501f\u65b9\u90e8\u9580,\u501f\u65b9\u91d1\u984d(\u5186),\u501f\u65b9\u7a0e\u984d,\" +\n  \"\u8cb8\u65b9\u52d8\u5b9a\u79d1\u76ee,\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee,\u8cb8\u65b9\u7a0e\u533a\u5206,\u8cb8\u65b9\u90e8\u9580,\u8cb8\u65b9\u91d1\u984d(\u5186),\u8cb8\u65b9\u7a0e\u984d,\u6458\u8981,\" +\n  \"\u4ed5\u8a33\u30e1\u30e2,\u30bf\u30b0,MF\u4ed5\u8a33\u30bf\u30a4\u30d7,\u6c7a\u7b97\u6574\u7406\u4ed5\u8a33,\u4f5c\u6210\u65e5\u6642,\u6700\u7d42\u66f4\u65b0\u65e5\u6642\";\nconst colSlipId = 0;  \/\/ \"\u53d6\u5f15No\" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 0\uff09\nconst colDate   = 1;  \/\/ \"\u53d6\u5f15\u65e5\" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 1\uff09\nconst ymdFormat = \"YYYY\/MM\/DD\"; \/\/ \u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff08MoneyForward\u306e\u5834\u5408\u306f \"YYYY\/MM\/DD\"\uff09\nconst colDrAmt  = 6;  \/\/ \"\u501f\u65b9\u91d1\u984d\" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 6\uff09\nconst colCrAmt  = 12; \/\/ \"\u8cb8\u65b9\u91d1\u984d\" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 12\uff09\nconst decimalPlaces = 0; \/\/ \u901a\u8ca8\u306e\u5c0f\u6570\u70b9\u4ee5\u4e0b\u6709\u52b9\u6570\u5b57\uff08\u65e5\u672c\u5186\u306e\u5834\u5408\u306f 0\uff09\nconst colSlipDescr = 14; \/\/ \"\u6458\u8981\" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 14\uff09\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA = configs.get( \"conf_DataIdA\" ) + \"\"; \/\/ required\nconst dataIdB = configs.get( \"conf_DataIdB\" ) + \"\";\nconst dataIdC = configs.get( \"conf_DataIdC\" ) + \"\";\nconst dataIdD = configs.get( \"conf_DataIdD\" ) + \"\";\nconst dataIdE = configs.get( \"conf_DataIdE\" ) + \"\";\nconst dataIdF = configs.get( \"conf_DataIdF\" ) + \"\";\nconst dataIdG = configs.get( \"conf_DataIdG\" ) + \"\"; \/\/ required\n\nlet   tplReceivableSingle = configs.get( \"conf_TplReceivableSingle\" ) + \"\";\n  if( tplReceivableSingle === \"\"){\n      tplReceivableSingle = \",,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,\";}\n  const arrTplReceivableSingle = tplReceivableSingle.split(\",\");\nlet   tplReceivedSingle   = configs.get( \"conf_TplReceivedSingle\" ) + \"\";\n  if( tplReceivedSingle   === \"\"){\n      tplReceivedSingle   = \",,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,\";}\n  const arrTplReceivedSingle   = tplReceivedSingle.split(\",\");\nlet   tplReceivableSales   = configs.get( \"conf_TplReceivableSales\" ) + \"\";\n  if( tplReceivableSales   === \"\"){\n      tplReceivableSales = \",,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,\";}\n  const arrTplReceivableSales = tplReceivableSales.split(\",\");\nlet   tplReceivedSales     = configs.get( \"conf_TplReceivedSales\" ) + \"\";\n  if( tplReceivedSales     === \"\"){\n      tplReceivedSales   = \",,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,\";}\n  const arrTplReceivedSales   = tplReceivedSales.split(\",\");\nlet   tplPaymentReceivable = configs.get( \"conf_TplPaymentReceivable\" ) + \"\";\n  if( tplPaymentReceivable === \"\"){\n      tplPaymentReceivable = \",,\u666e\u901a\u9810\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,,,,,,,\";}\n  const arrTplPaymentReceivable = tplPaymentReceivable.split(\",\");\nlet   tplPaymentReceived   = configs.get( \"conf_TplPaymentReceived\" ) + \"\";\n  if( tplPaymentReceived   === \"\"){\n      tplPaymentReceived     = \",,\u666e\u901a\u9810\u91d1,,\u5bfe\u8c61\u5916,,,0,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,,,,,,,\";}\n  const arrTplPaymentReceived   = tplPaymentReceived.split(\",\");\nif( myNumOfCols !== tplReceivableSingle.split(\",\").length ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {M} does not match 20-commas Header \\n\" );\n}\nif( myNumOfCols !== tplReceivedSingle.split(\",\").length ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {N} does not match 20-commas Header \\n\" );\n}\nif( myNumOfCols !== tplReceivableSales.split(\",\").length ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {P} does not match 20-commas Header \\n\" );\n}\nif( myNumOfCols !== tplReceivedSales.split(\",\").length ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {Q} does not match 20-commas Header \\n\" );\n}\nif( myNumOfCols !== tplPaymentReceivable.split(\",\").length ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {R} does not match 20-commas Header \\n\" );\n}\nif( myNumOfCols !== tplPaymentReceived.split(\",\").length ){\n  throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                   \" Config {S} does not match 20-commas Header \\n\" );\n}\n\nconst dataIdX = configs.get( \"conf_DataIdX\" ) + \"\";\nconst dataIdY = configs.get( \"conf_DataIdY\" ) + \"\";\n\nlet numEndMonth = 12;\nconst monthInt = \/^(&#091;1-9]|1&#091;0-2])$\/; \/\/ RegExp: 1,2,,,11,12\nconst strEndMonth = configs.get( \"conf_EndMonth\" ) + \"\";\nif( strEndMonth === \"\" ){\n  engine.log( \" AutomatedTask ConfigWarning:\" +\n              \" {Z:EndMonth} is 12 (default)\" );\n}else{\n  if( monthInt.test( strEndMonth ) ){\n    numEndMonth = parseInt(strEndMonth, 10);\n  }else{\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" Config {Z:EndMonth} must be 1 to 12 \\n\" );\n  }\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet slipDescr = \"\"; \/\/ config required\nif( engine.findDataByNumber( dataIdA ) === null ){\n  engine.log( \" AutomatedTask StringWarning:\" +\n              \" {A} is empty\" );\n}else{\n  slipDescr = engine.findDataByNumber( dataIdA ) + \"\";\n}\n\nlet salesAmtSingle       = engine.findDataByNumber( dataIdB ) - 0;  \/\/ null-0 -&gt; 0\nlet salesAmtMultiple     = engine.findDataByNumber( dataIdD ) - 0;\nlet salesAmtMultipleNum  = engine.findDataByNumber( dataIdF ) - 0;\nif( salesAmtSingle === 0 &amp;&amp; salesAmtMultiple === 0){ \/\/Case 0: Error exit\n  throw new Error( \"\\n AutomatedTask UnexpectedError:\" +\n                   \" Both {B:salesAmtSingle} and {D:salesAmtMultiple} are zero \\n\" );\n}\n\nlet salesAmtSingleDate   = engine.findDataByNumber( dataIdC ) + \"\";\nlet salesAmtMultipleDate = engine.findDataByNumber( dataIdE ) + \"\";\n\nlet dueDate = \"\"; \/\/ config required\nif( engine.findDataByNumber( dataIdG ) === null ){\n  throw new Error( \"\\n AutomatedTask UnexpectedDateError:\" +\n                   \" Date {G} is null \\n\" );\n}else{\n  dueDate = engine.findDataByNumber( dataIdG ) + \"\";\n}\nconst dateDueDate = toJsDate( dueDate );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/  &#091;M] numMonthSerial (Serial Number, 1 means the first month of the fiscal year.)\n\/\/               01 02 03 04 05 06 07 08 09 10 11 12\n\/\/  EndMonth= 1: 12  1  2  3  4  5  6  7  8  9 10 11\n\/\/  EndMonth= 3: 10 11 12  1  2  3  4  5  6  7  8  9\n\/\/  EndMonth=12:  1  2  3  4  5  6  7  8  9 10 11 12\nconst dateToday = new Date();\nconst numMonthSerial = (dateToday.getMonth() + 12 - numEndMonth ) % 12 + 1;\n\/\/  &#091;MDD] todaySerial\nconst todaySerial = numMonthSerial * 100 + dateToday.getDate();\n\/\/\/ \"\u53d6\u5f15No\" (tmpSlipId): 8or9\u6841 MDDyyyzz,\nlet tmpSlipId = todaySerial * 100000 +\n                (processInstance.getProcessInstanceId() % 1000) * 100;\n\nlet myTsv    = \"\";\n\n\/\/Case 1: Only Single Sales \/ \u4e00\u62ec\u58f2\u4e0a\u3060\u3051\u306e\u5834\u5408\nif(salesAmtSingle !== 0 &amp;&amp; salesAmtMultiple === 0){\n  let dateSalesAmtSingleDate = toJsDate( salesAmtSingleDate );\n  engine.log( \" AutomatedTask message:\" +\n              \" Single only\" );\n\n  if( dateSalesAmtSingleDate.getTime() &lt;= dateDueDate.getTime() ){\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivableSingle.concat();\n    tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n    tmpArrSales&#091;colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n    tmpArrSales&#091;colDrAmt]  = salesAmtSingle;\n    tmpArrSales&#091;colCrAmt]  = salesAmtSingle;\n    tmpArrSales&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrSales.join(\"\\t\");\n    myTsv += \"\\n\";\n\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceivable.concat();\n    tmpArrPay&#091;colSlipId]   = tmpSlipId + \"\";\n    tmpArrPay&#091;colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay&#091;colDrAmt]    = salesAmtSingle;\n    tmpArrPay&#091;colCrAmt]    = salesAmtSingle;\n    tmpArrPay&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(\"\\t\");\n  }else{\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivedSingle.concat();\n    tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n    tmpArrSales&#091;colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n    tmpArrSales&#091;colDrAmt]  = salesAmtSingle;\n    tmpArrSales&#091;colCrAmt]  = salesAmtSingle;\n    tmpArrSales&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrSales.join(\"\\t\");\n    myTsv += \"\\n\";\n\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceived.concat();\n    tmpArrPay&#091;colSlipId]   = tmpSlipId + \"\";\n    tmpArrPay&#091;colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay&#091;colDrAmt]    = salesAmtSingle;\n    tmpArrPay&#091;colCrAmt]    = salesAmtSingle;\n    tmpArrPay&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(\"\\t\");\n  }\n\n}\n\n\/\/Case 2:  Including Multiple Sales \/ \u5206\u5272\u58f2\u4e0a\u3092\u542b\u3080\u5834\u5408\nif(salesAmtMultiple !== 0){\n  if(salesAmtMultipleNum === 0){\n    throw new Error( \"\\n AutomatedTask UnexpectedConfigError:\" +\n                     \" '0' can not be used as division number. \\n\" );\n  }\n  engine.log( \" AutomatedTask message:\" +\n              \" Multiple \" + salesAmtMultipleNum );\n\n  \/\/ Subtotal of ReceivableSales and ReceivedSales\n  let myReceivableSales = 0;\n  let myReceivedSales = 0;\n\n  \/\/\/\/ Single\n  if(salesAmtSingle !== 0){\n    engine.log( \" AutomatedTask message:\" +\n                \" Multiple with Single\" );\n    let dateSalesAmtSingleDate = toJsDate( salesAmtSingleDate );\n\n    if( dateSalesAmtSingleDate.getTime() &lt;= dateDueDate.getTime() ){\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivableSingle.concat();\n      tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n      tmpArrSales&#091;colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n      tmpArrSales&#091;colDrAmt]  = salesAmtSingle;\n      tmpArrSales&#091;colCrAmt]  = salesAmtSingle;\n      tmpArrSales&#091;colSlipDescr] = slipDescr;\n      myTsv += tmpArrSales.join(\"\\t\");\n      myTsv += \"\\n\";\n      myReceivableSales += salesAmtSingle;\n    }else{\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivedSingle.concat();\n      tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n      tmpArrSales&#091;colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n      tmpArrSales&#091;colDrAmt]  = salesAmtSingle;\n      tmpArrSales&#091;colCrAmt]  = salesAmtSingle;\n      tmpArrSales&#091;colSlipDescr] = slipDescr;\n      myTsv += tmpArrSales.join(\"\\t\");\n      myTsv += \"\\n\";\n      myReceivedSales += salesAmtSingle;\n    }\n  }\n\n  \/\/\/\/ Multiple\n  \/\/ Sales for each month\n  \/\/ The remainder is added to the first month. \/ \u5546\u306e\u5270\u4f59\u306f\u521d\u6708\u306b\u52a0\u7b97\n  \/\/ \"101\/10\" is divided into \"10.10\" * 10, in the case of two decimal places.\n  \/\/ \"101\/10\" is divided into \"11\" * 1 and \"10\" * 9, in the case of 0 decimal place.\n  const monthlySalesFollow =\n        Math.floor( salesAmtMultiple \/ salesAmtMultipleNum * Math.pow(10, decimalPlaces) ) \/\n        Math.pow(10, decimalPlaces);\n  const monthlySalesFirst  =\n        salesAmtMultiple - monthlySalesFollow * ( salesAmtMultipleNum - 1 );\n  let arrSalesAmtMultipleDate  = new Array( salesAmtMultipleNum );\n\n  \/\/ First Month\n  arrSalesAmtMultipleDate&#091;0]   = toJsDate( salesAmtMultipleDate );\n  if( arrSalesAmtMultipleDate&#091;0].getTime() &lt;= dateDueDate.getTime() ){\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivableSales.concat();\n    tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n    tmpArrSales&#091;colDate]   = funcDateStr( arrSalesAmtMultipleDate&#091;0], ymdFormat );\n    tmpArrSales&#091;colDrAmt]  = monthlySalesFirst;\n    tmpArrSales&#091;colCrAmt]  = monthlySalesFirst;\n    tmpArrSales&#091;colSlipDescr] =\n      funcMonthStr( arrSalesAmtMultipleDate&#091;0] ) + \" @ \" + slipDescr;\n    myTsv += tmpArrSales.join(\"\\t\");\n    myTsv += \"\\n\";\n    myReceivableSales += monthlySalesFirst;\n  }else{\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivedSales.concat();\n    tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n    tmpArrSales&#091;colDate]   = funcDateStr( arrSalesAmtMultipleDate&#091;0], ymdFormat );\n    tmpArrSales&#091;colDrAmt]  = monthlySalesFirst;\n    tmpArrSales&#091;colCrAmt]  = monthlySalesFirst;\n    tmpArrSales&#091;colSlipDescr] =\n      funcMonthStr( arrSalesAmtMultipleDate&#091;0] ) + \" @ \" + slipDescr;\n    myTsv += tmpArrSales.join(\"\\t\");\n    myTsv += \"\\n\";\n    myReceivedSales += monthlySalesFirst;\n  }\n\n  \/\/ Following Months\n  \/\/ Record on 1st of each month \/ \u6b21\u6708\u4ee5\u964d\u306f1\u65e5\u306b\u58f2\u4e0a\u8a08\u4e0a\n  for( let i=1; i &lt; salesAmtMultipleNum; i++){\n    arrSalesAmtMultipleDate&#091;i] = new Date(\n                                     arrSalesAmtMultipleDate&#091;0].getFullYear(),\n                                     arrSalesAmtMultipleDate&#091;0].getMonth() + i,\n                                     1); \/\/ 1st of each month\n    if( arrSalesAmtMultipleDate&#091;i].getTime() &lt;= dateDueDate.getTime() ){\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivableSales.concat();\n      tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n      tmpArrSales&#091;colDate]   = funcDateStr( arrSalesAmtMultipleDate&#091;i], ymdFormat );\n      tmpArrSales&#091;colDrAmt]  = monthlySalesFollow;\n      tmpArrSales&#091;colCrAmt]  = monthlySalesFollow;\n      tmpArrSales&#091;colSlipDescr] =\n        funcMonthStr( arrSalesAmtMultipleDate&#091;i] ) + \" @ \" + slipDescr;\n      myTsv += tmpArrSales.join(\"\\t\");\n      myTsv += \"\\n\";\n      myReceivableSales += monthlySalesFollow;\n    }else{\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivedSales.concat();\n      tmpArrSales&#091;colSlipId] = tmpSlipId + \"\";\n      tmpArrSales&#091;colDate]   = funcDateStr( arrSalesAmtMultipleDate&#091;i], ymdFormat );\n      tmpArrSales&#091;colDrAmt]  = monthlySalesFollow;\n      tmpArrSales&#091;colCrAmt]  = monthlySalesFollow;\n      tmpArrSales&#091;colSlipDescr] =\n        funcMonthStr( arrSalesAmtMultipleDate&#091;i] ) + \" @ \" + slipDescr;\n      myTsv += tmpArrSales.join(\"\\t\");\n      myTsv += \"\\n\";\n      myReceivedSales += monthlySalesFollow;\n    }\n  }\n  if(myReceivableSales !== 0 &amp;&amp; myReceivedSales !== 0){\n    tmpSlipId++;\n    let tmpArrPay1         = arrTplPaymentReceivable.concat();\n    tmpArrPay1&#091;colSlipId]  = tmpSlipId + \"\";\n    tmpArrPay1&#091;colDate]    = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay1&#091;colDrAmt]   = myReceivableSales + myReceivedSales;\n    tmpArrPay1&#091;colCrAmt]   = myReceivableSales;\n    tmpArrPay1&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay1.join(\"\\t\");\n    myTsv += \"\\n\";\n    let tmpArrPay2         = arrTplPaymentReceived.concat();\n    tmpArrPay2&#091;colSlipId]  = tmpSlipId + \"\";\n    tmpArrPay2&#091;colDate]    = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay2&#091;colDrAmt]   = 0;\n    tmpArrPay2&#091;colCrAmt]   = myReceivedSales;\n    tmpArrPay2&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay2.join(\"\\t\");\n  }else if(myReceivableSales === 0){\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceived.concat();\n    tmpArrPay&#091;colSlipId]   = tmpSlipId + \"\";\n    tmpArrPay&#091;colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay&#091;colDrAmt]    = myReceivableSales + myReceivedSales;\n    tmpArrPay&#091;colCrAmt]    = myReceivedSales;\n    tmpArrPay&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(\"\\t\");\n  }else if(myReceivedSales === 0){\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceivable.concat();\n    tmpArrPay&#091;colSlipId]   = tmpSlipId + \"\";\n    tmpArrPay&#091;colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay&#091;colDrAmt]    = myReceivableSales + myReceivedSales;\n    tmpArrPay&#091;colCrAmt]    = myReceivableSales;\n    tmpArrPay&#091;colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(\"\\t\");\n  }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dataIdX !== \"\" ){\n  engine.setDataByNumber( dataIdX, myTsv );\n}\nif( dataIdY !== \"\" ){\n  let outputFiles = engine.findDataByNumber( dataIdY ); \n  \/\/ java.util.ArrayList\n  \/\/ - com.questetra.bpms.core.event.scripttask.QfileView\n  if( outputFiles === null ){\n    outputFiles = new java.util.ArrayList();\n  }\n  let strSjisCsv = headerRow + \"\\n\" +\n                   myTsv.replace( \/,\/g, \"\" ).replace( \/\\t\/g, \",\" );\n  outputFiles.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      (processInstance.getProcessInstanceId() + \".csv\"),  \/\/ fileName\n      \"text\/comma-separated-values; charset=Shift_JIS\",   \/\/ for sjis\n      strSjisCsv\n    )\n  );\n  engine.setDataByNumber( dataIdY, outputFiles );\n}\n\n\n} \/\/\/\/\/\/\/\/ END \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction funcDateStr( dateObj, formatStr ){\n  formatStr = formatStr.replace(\/YYYY\/g, dateObj.getFullYear());\n  formatStr = formatStr.replace(\/MM\/g,   ('00' + (dateObj.getMonth() + 1)).slice(-2));\n  formatStr = formatStr.replace(\/DD\/g,   ('00' +  dateObj.getDate()).slice(-2));\n  return formatStr;\n}\n\nfunction funcMonthStr( dateObj ){\n  let myStr = dateObj.getFullYear() + \"-\" + (\"00\" + (dateObj.getMonth()+1)).slice(-2);\n  return myStr;\n}\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n  \/\/ BPMS Date:     \"2020-04-01\"\n  \/\/ BPMS Datetime: \"2020-04-01 23:59\"\n\n  let year       = 0;\n  let monthIndex = 0;\n  let day        = 0;\n  let hours      = 0;\n  let minutes    = 0;\n\n  \/\/  The Date object has a large number of methods.\n  \/\/ \"Date.parse\" is danger (strongly discouraged)\n  \/\/ - new Date(\"2014-11-10\") \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n  \/\/ - new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\n  let arrDatetime = bpmsDateOrDatetimeStr.split(\" \");\n  if( arrDatetime.length === 1 ){\n    let arrDateParts = arrDatetime&#091;0].split(\"-\");\n    year       = parseInt(arrDateParts&#091;0], 10);\n    monthIndex = parseInt(arrDateParts&#091;1], 10) - 1;\n    day        = parseInt(arrDateParts&#091;2], 10);\n  }\n  if( arrDatetime.length === 2 ){\n    let arrDateParts = arrDatetime&#091;0].split(\"-\");\n    let arrTimeParts = arrDatetime&#091;1].split(\":\");\n    year       = parseInt(arrDateParts&#091;0], 10);\n    monthIndex = parseInt(arrDateParts&#091;1], 10) - 1;\n    day        = parseInt(arrDateParts&#091;2], 10);\n    hours      = parseInt(arrTimeParts&#091;0], 10);\n    minutes    = parseInt(arrTimeParts&#091;1], 10);\n  }\n\n  return new Date( year, monthIndex, day, hours, minutes );\n}<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAEVElEQVRYR8WXe0yVdRjHPy+3AyeF\nUmLeEAZeQk6kWOaWYbrSLrISDk5QqaAVh9VC12b6B65WMoqVJQpBWZumKw5aUSNl6qKagQgGRkuR\nBDUuXhBU7vBr73vO6RzOnaLx++9939\/zPN\/neb6\/7\/N7JcZ5SW7Hjy1R49MXh8QyYAGIUJDuMtiL\nDpAuADUIjtOvOkhJbLc7vl0DSPhyCsJzM4g0wNcdp0AvSPlIQ9kUrWl1ZuMcQLw+DUnkgHSHm4Gt\ntonbCOk1irX5juwdA0go3o0Qun8X2MpKkvIoik+358s+AK1+P5A4JsHNTg6g1yZZ+7QFMJaZ20Sz\nrcRIAErPyRuLzDfEzGRJRCAHKy5z+HSb2aVAZ8kJMwCF7VKDI8ItnjOJTatm82hUEHeqfZCMlr0D\nQ9Q1dbGztIG95c1KoPSV4WSv1zDB14u2zj6e31VFaY3pMIjbSGKW6XSYAWiL3weRYS\/7txIjefnx\ncALU3g6LMzgkKKtt48WPqklZFsrWuHtQeXvQ2T1AemEN+3+6aGEr7UAfv1F+YQAgi4yq75q9c16Y\nFk3y0hB8vDxcdkYIqG3qJOOzX3k7MZLIYH\/K66+y7sNKbvYMWtr30qeaLIuVAUC8fj0Se60j6FaE\nkbVOYzdzOVhP\/5DSCj8fT4MeCjha105czgnrgLbgBRso1u4zANDqPwFSLHdN9PPi2LYY7g83qq2V\ni98udrHmvQr81V4UvBTNvTMDONdyi2feOUH9pS6X1QL2oNemmgBUG\/TdvJ57JIQPUu7D38+278NC\nUFD2J7rCGsXgiQVTyErSkF\/WSP6RRuZMnUDI3WrKatudAalBr402Aii6bh4sBpvc1PnoVobhYaR7\nXXOnEnD1ouloF0\/nlT2nKalqsRtA7v\/DEYHEZP7gBIDoQJ8wyVQBYb3zY91CUpeHKq\/7B4fJ\/uoP\nMr+oV56ffmAaX5\/8y67ztQ8Fs+uF+bTe6CVyY5nzVui1xvS0eqcAmq50s3ZHBb+cvT7CoawN2xM1\nvPvNWeWcz5vhz4GMRUSFBCg8GAUA2xbkJEfx6pOz8PKU+K66lVVZP9tks2X1XDITIrja1U\/ekUYe\niwoiZl6g0rbqxhss3HzU7RY4JKGnh8Tr+86Q+\/15hWxxD07jjaLfuXSth\/I3lyq9tl7ycfz0+AVS\n8065S0L7x7B06xJCg9Qk7zzJsTNXFGKmrQijofWWogGa4AClQtarvbOPtIJqDlXa54lxv8UxdCBE\nKctDFUX79lSLomjbkzTMmOznlFhDw4LPf2zm2dwq5wQcIUROpFgGsCl2Nr7eBrVztkahhFZSLHt1\nMozkKbglbi6BE1UO48vD6FDlZaXvVrpvx8Z6GMlbXIxjufTbEiJ4KnoqQQEqZHLKGd\/sHaDyXAe7\nD5931XMjEEfjWP48hhcSh6VyeCExWYzrlcwEYlwvpf9HJUZ9LTeBGNcfk38qMZ6\/ZpZUHrefU1fy\n9x+\/\/w06a8wwleGinwAAAABJRU5ErkJggg==\" alt=\"\"\/><\/figure><\/div>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/1qxEEAseKquplvveEXISdi5FFJQV7lHe9\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">MoneyForward-Journal-Create.xml<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/moneyforward-journal1.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/moneyforward-journal2.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"87051\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/attachment\/moneyforward-journal-create-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"MoneyForward-Journal-Create-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.\" class=\"wp-image-87051\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"87054\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/attachment\/moneyforward-journal-create2-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"MoneyForward-Journal-Create2-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i2.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?fit=1024%2C576&amp;ssl=1\" alt=\"Journal Slips, Generate Automatically\" class=\"wp-image-87054\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>&#8220;Transaction No.&#8221;<ol><li>The slip generated on April 1 = 8 digits of &#8220;401yyyzz&#8221; (closing month &#8220;12&#8221;).<\/li><li>The slip generated on April 1 = 8 digits of &#8220;101yyyzz&#8221; (closing month &#8220;3&#8221;).<\/li><li>The slip generated on March 31 = 9 digits &#8220;1231yyyzz&#8221; (closing month &#8220;3&#8221;).<\/li><li>The yyy part is the last three digits of {process ID}.<\/li><li>The zz part is the split ID (01,02, \u2026).<\/li><li>It may be renumbered when imported to MF.<\/li><li>&#8220;Transaction No.&#8221; such as &#8220;manual entry&#8221; will be the increment value.<\/li><\/ol><\/li><li>No header row is added to the generated &#8220;journal TSV&#8221;. (for Sheet Append)<\/li><li>The following 21 items are posted in the header line of &#8220;Journal Excel-CSV&#8221;<ol><li>[0] Transaction No, [1] Transaction Date,<\/li><li>[2] Debit account, [3] Debit sub-item, [4] Debit tax classification,<\/li><li>[5] Debit department, [6] Debit amount (yen), [7] Debit tax amount,<\/li><li>[8] Credit account, [9] Credit sub-item, [10] Credit tax classification,<\/li><li>[11] Credit department, [12] Credit amount (yen), [13] Credit tax amount,<\/li><li>[14] description, [15] journal memo, [16] tag, [17] MF journal type,<\/li><li>[18] Closing journal, [19] Creation date, [20] Last update date<\/li><\/ol><\/li><li>#Money Forward journal_sample.csv<ol><li><a href=\"https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html\" rel=\"nofollow\">https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html<\/a><\/li><\/ol><\/li><li>The description of the split sales records in the format &#8220;2020-04 @ {Description}&#8221;.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"gYZCcZobXp\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/\">Fiscal Month-Day String, Create<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cFiscal Month-Day String, Create\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/embed\/#?secret=kAr3kVUutu#?secret=gYZCcZobXp\" data-secret=\"gYZCcZobXp\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"QXheQYrols\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/googlesheets-appendtsv\/\">New Record to Google Sheets (TSV)<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cNew Record to Google Sheets (TSV)\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/googlesheets-appendtsv\/embed\/#?secret=6OYFUsLolt#?secret=QXheQYrols\" data-secret=\"QXheQYrols\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.<\/p>\n","protected":false},"author":2,"featured_media":87049,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[169],"tags":[],"faq_section":[],"class_list":["post-87048","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":3,"uagb_excerpt":"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-mE0","jetpack-related-posts":[{"id":110776,"url":"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create-2021\/","url_meta":{"origin":87048,"position":0},"title":"MoneyForward Journal, Create","author":"Hirotaka NISHI","date":"2021-08-04","format":false,"excerpt":"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"MoneyForward Journal, Create","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70808,"url":"https:\/\/support.questetra.com\/en\/addons\/journaltsv-generator\/","url_meta":{"origin":87048,"position":1},"title":"Journal Slip TSV from Invoice Data","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Generate transfer slip TSV (tab-separated-values) with sales amount, sales date, due date. It supports cases where add a sales collectively or divided into several months or mixture of those. In order to generate a file for the accounting system, you need to place a converter such as \"TSV to Excel-CSV\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":73398,"url":"https:\/\/support.questetra.com\/en\/addons\/journal-tsv-create\/","url_meta":{"origin":87048,"position":2},"title":"Journal-TSV Create","author":"IMAMURA, Genichi","date":"2018-12-12","format":false,"excerpt":"Creates the Journal-Slip TSV. The transfer slip TSV of the sales is generated based on the Invoice data. To generate a file that can be imported into the accounting system, place a converter such as \"TSV to Excel-CSV FILE\" in the downstream process.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69591,"url":"https:\/\/support.questetra.com\/en\/addons\/generate-transferslips\/","url_meta":{"origin":87048,"position":3},"title":"Generate Transfer Slips","author":"Hirotaka NISHI","date":"2016-09-08","format":false,"excerpt":"Regarding to the down payment for long-term service, stores sales transfer slip data for the number of months of contract into a data item","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75362,"url":"https:\/\/support.questetra.com\/en\/templates\/paypal-billing-process-20211227\/","url_meta":{"origin":87048,"position":4},"title":"PayPal Billing Process","author":"Hirotaka NISHI","date":"2021-12-28","format":false,"excerpt":"An independent subprocess to be invoked by various business flows. Through \"PayPal Invoicing API\", 1) let PayPal generate \"PayPal Invoice\", 2) let PayPal send \"PayPal Invoice\", 3) confirm payment status of \"PayPal Invoice\" to PayPal. Also generates \"Transfer slip CSV\" for accounting system automatically.","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-paypal-billing-process-20210428-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-paypal-billing-process-20210428-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-paypal-billing-process-20210428-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-paypal-billing-process-20210428-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-paypal-billing-process-20210428-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87503,"url":"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create\/","url_meta":{"origin":87048,"position":5},"title":"Fiscal Month-Day String, Create","author":"IMAMURA, Genichi","date":"2020-04-22","format":false,"excerpt":"Creates a date ID for fiscal year sorting. The first day of the first month of the fiscal year will be \"101\". The 25th day of the last month is \"1225\". If the fiscal year starts in Jan, the string will be the same as the calendar format \"Mdd\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Fiscal Month-Day String, Create","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/Fiscal-Month-Day-String-Create-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/87048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=87048"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/87048\/revisions"}],"predecessor-version":[{"id":110804,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/87048\/revisions\/110804"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/87049"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=87048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=87048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=87048"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=87048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}