"Fluctuation" occurs frequently to corporate name!

Destination data in a Quotation or an Invoice differs like "Nippon Telegraph and Telephone Corporation" or "Nippon Telegraph and Telephone Corp." or "NTT Corporation" ... Yet, the SELECT method must be adopted for an input form in Quote creation flow or Billing flow (instead of TEXT form). Otherwise, data that are not worthy to be aggregated would be accumulated, on and on.

Even though we manage so-called "Customer Master" in a Spreadsheet...


In the following Workflow, it is devised that a "Customer Master for Workflow platform" to be updated automatically with data in a Google Spreadsheet. The "Customer Master" will be maintained to be always up-to-date.

* The Auto-step (Service Task) referred to [Sheet reference] which is utilized here, will become available by feature expansion with [Addon XML] beforehand. (v11.1: 2016-09-05)

[Customer Master Synchronization]
"How much money did we spend on Entertainment expense, this period?"

Serving as a Sales Manager, one should precisely know "Current total amount of external expenses that have approved". If possible, a Manager should recognize "Spending that not needed to be approved" as well. (In plain words, to keep tracking on "pocket money book" of Sales Department diligently... Formally speaking, it is "Budget management".)

In the following Workflow, "Total expenditure until then" will be indicated on the side at the time Approval request coming around. Specifically, spendings recorded in "Budget consumption logs", which is a Google Sheet (commonly called Pocket Money book), will be summed automatically. Moreover, at the moment of approving newly on a spending, the approved expenditure will be appended automatically to "Budget consumption log".


If you want the Budget consumption log to be more accurate, you will be required operational devising such as,
  • to remove the approval log that has not been consumed actually
  • to append manually for irregular small expenses
or improvement of Business Process such as
  • to create a mechanism of automatic appending from "Advertising flow" which approval is not required
  • to create a mechanism of automatic appending the items of expenditure corresponding to the budget consumption from Expense reimbursement flow

However, it is a great progress that knowing just the approximation of the total amount.

Incidentally, you will be able to build "dedicated Cloud-approval" in half a day, using this sample. You may use that system at your own home, assigning the husband as the applicant and the wife as the approver.

[Approval Request flow]
A Wave of Cloud computing is surging over Accounting systems, last few years.

In Japan, the start out of "Cloud service" by a long-established software company was a major impact. Specifically, "Yayoi online" entered into a marketplace formed by "MF Cloud" and "freee" in July, 2015. In these systems, functions that are oriented to medium or large enterprises have been enhanced, and these are tools not only for "Startup companies" or for "Sole proprietorship".

The most advantage of these systems is their capability of retrieving "detail data" of "bank statement" and "credit card" collectively. That is, All of the detail records are automatically fetched as sales slip and payment slip. Moreover, accounting titles that should have been entered manually by accounting staffs have been set beforehand by "automatic journal entry function". (Improvement on performance of automatic Journal entry is discernibly.)


However, it will not be so easy for such Cloud accounting systems to automate generating slips which according to human judgment.

* Indeed, regarding "not allocate to sales deeming as advance received" or "allocate to sales as account receivable", who made the judgment and when should be recorded precisely. (Deterrence of accounting fraud, internal control)

The following Business Process is an accounting Workflow related to advance received. It is a mechanism that automatically generates twelve "transfer slip data", for example, upon receiving "service fee of twelve months" in advance.

It is a flow of;
  1. Accounting staff determines as "advance received"
  2. Supervisor approves on it
  3. Bookkeeping staff registers "transfer slip data"

[Advance-received Registration]
"How much is the total of Quotations that have been submitted currently?"

Sales budget, which all the Sales managers care about. Even not being a Sales manager, there are many people who care about company's sales progress.
  • How many Quotations have been submitted?
  • How much is the total of those Quotations?
  • How many Orders will be reported among them?

As a matter of course, if you would like to forecast the "Sales", "Quotation tracking" is essential.

"How many of what Issues in which Step?" will be obvious if the progress of series of Quoting operations, such as "Drafting", "Approval" and "Win-loss Report", have been managed (in a Workflow). Even "Order rate" can be calculated easily by aggregating of past Issues that flowed through the Workflow. (Or rather, "Productivity of the Sales Department" should be questioned if they don't know the total price of submitted Quotations...)

The following Workflow is a "Quotation Creation flow" that begins with "1. Drafting Quotation" and ends at "4. Win-loss Report". (Want to connect to "Billing Process" in the future...)

Once a Quotation operation has started, things that must be done at the moment ("to approve on a draft of Quotation", "to submit the Quotation to the customer", etc.) will be clarified for both of Sales manager and salesperson. There will never be "Useless waiting time". And of course, never be omissions or oversights.

And the directors on board would make check for "Quotations that have been submitted and waiting for Win-loss report" (Quotations that staying at the 4th Step) in every quarterly results.

[Quotation Creation flow]

"Want to share translated document with the team..."

Indeed, "Share by Email" is not so bad. A translated sentences would be shared quickly with the team by a setting to send automatically to Team ML (Mailing List) upon completion of translating. Feedback about mistranslated or brushing up might be obtained.

However, it would not be happy that when a person who has received an email wants to reply, he or she must reply by email. Enterprise Social Networking is the mainstream for in-house information exchange, nowadays.


The Workflow definition below, it is devised to post to [OpenChat], which is an Enterprise Social Networking of Questetra, upon completion of translating. It allows co-workers to Like immediately on a High-quality translation.

[Translation Process-OpenChat Post]
  • Instruction manual sentences that described in multiple language
  • Manuscripts of Website (HTML)
  • Source codes

A Creation flow for these drafts ought to be devised to record (not only "Number of characters", also) "Hash value" automatically.

A Hash value is a "Message digest". It is also referred to as "fingerprint". In short, it generates "32 of hexadecimal characters" (in the case of MD5 method) from any data instantly, allowing to validate data falsification of even a single character. (For more details, please see Wikipedia, etc.)

In the following workflow, [Auto-steps](Service Task) of "Hash generation (MD5)" and "Hash generation (SHA256)" have been arranged. Both of them will be available when you conduct feature expansion with [Addon XML]. (Questetra BPM Suite v11.1. Releasing in early September?)

[Translation Process-Hash Value]
I definitely want an Auto-step icon that is needed in this business!

Everybody who designs Business Processes (Modeling) tends to desire to automate various processing.

In version 11.1 of Cloud-based Workflow, "Questetra BPM Suite", which we are going to release at the end of August 2016, you will be able to use additional Auto-step icons. More specifically, your original auto-step icons will be available by; obtaining packaged "Add-on XML" and importing it as Additional feature file (Process Model file).

You will get these [Add-on XML] mostly by
  • Downloading from Questetra's Website
  • Provision from third-party

Whereas, it will be also capable of creating yourself, as you can guess from the words of "Add-on XML".

The following is the same "Translation Process" workflow that I have introduced you in the last post. And in which I made a substitution to [Script Step] with self-made [Auto-Step].

[Translation Process-Add-on]