"Debits? Credits? ... What is that? Tastes good?"


Indeed, there are some programmers who show "Allergic reaction" against "Finance and accounting terminology".

However, these are words which working adults should know. Even in the "Information Technology Engineers Examination", which certifies basic IT skills, these terms appear frequently.

Incidentally, there will be nothing wrong if you call them as "Left column, right column" in practice. Both of the column are merely a "breakdown table of assets". If you consist to describe concretely, it will be sufficient to consider that "Left column: Breakdown of cash and cash-like assets", "Right column: Breakdown of assets which must be paid (debt) and which are not needed to be paid."


So... How each of "Breakdown table of assets" (Balance sheet) will be transitioning, in a case that a Cloud service providing company
  • sold service provisioning for twelve months
  • agreed on April 1st, for 120,000 JPY
  • paid on May 30th

For example...

In April, it can be regarded as "increasing of asset for one month of service worth (10.000 JPY)" since they have already provided their service (not yet paid, though.) It is so-called "Selling on credit". (Account receivable) And it will keep on changing on and after May...

[Sales Reporting]

"I can hardly get rid of mistakes in Catalogue mailing..."

You want to correspond to "Request for a Catalogue", which you have accepted via published web form, as quickly as you can. However, it won't be a joke if you made mistakes in the "Address" or "Company name" that the customer has entered. When creating "Cover sheet" with Microsoft Word by Copy & Paste, for example, made mistake that shifted ane line of the record in the list to be referred, and results in complaint,such as
  • Our company name is not like this.
  • There is no employee in the name of this.
In the worst case, it might be a "Personal information leakage incidents".


In the following Business Process, "a personnel in charge of accepting" checks entries via web form
  • if the address was not inappropriate such as erroneously submitted in the middle of the input?
  • if the address was not nonsense for mischief purpose?
  • if it does not contain abbreviations or unnecessary space?
After the check, "Cover sheets PDF" will be generated automatically, then "a personnel in charge of Mailing" will print it out and enclose the Cover sheet with the Catalogue. No manpower be involved, there.

The excellent point is that not a "list" will be created in this business operation. The risk of information leakage will be extremely reduced. And as soon as the sealing job is completed, data such as "company name" and "telephone number" will be automatically added to the Cloud-based database. (Although it is apparent, it is also assumed a flow to ask "Sales representative" in case of receiving a message such as "Want an estimate together".)

[Catalogue Request Correspondence]

I introduced a fully automated Workflow that is

> to update the Workflow platform common "Client Master" by receiving JSON response from kintone API,

in the last post.

In this post, I would like to introduce how to

> Update the "Client Master" in kintone by sending JSON data to kintone API.

More specifically, it is a mechanism that suppliers (customer code and customer name) is added to the "customer master" on the kintone, upon the moment when a start of trading in the "Credit Management Workflow" has been approved.

After all, it is configured that JSON string such as

{
  "app": "3",
  "record": {
    "customerCode": {
      "value": "9999999999999#www.example.com"
    },
    "customerName": {
      "value": "XYZ Inc"
    }
  }
}

POSTed to kintone API at the downstream of the Workflow.

* JSON: JavaScript Object Notation (Mass of data in which the pair of "key" and "value" have been enumerated)

[Credit Management]
"Customer list" is typical of "database". (Weather managed in paper or in computer.)

Data stored in "Database" is roughly classified into
  • A) Master information (Master type data)
    • Product master
    • Client master
    • Price list, etc.
  • B) Log information (Transaction type data)
    • Payment history
    • Orders record
    • Access log, etc.
And in day-to-day business, there are many occasions that you want to refer to data which is classified in A), master type data.


The following Business Process is a mechanism to synchronize "Client Master data" in the Workflow environment with client master information which is managed in "kintone", a Cloud Database, on a daily basis. (It may be considered as a Batch processing.) It is excellent for not only all the Steps having been automated, but also being capable of manually synchronization at any time.

After all, it becomes possible to refer the latest "Client Master" in a variety of business, such as "Estimate Process", "Order report Process", or "Billing Process". You might be able to eliminate so-called "name identification". (Moreover, it also has the meaning of auto-backup of data in kintone.)

[Client Master Synchronization]

"Reminder notification of Maintenance service contract renewal on the same date in 12 months later."

When I design, for example, a Contract Process, I would want an Email alert (Email reminder). That is, I want to arrange an Event to transmit an email at the most downstream of the business flow. That is referred to as [Throwing Message Event (Email)] in the terminology of "Process Modeling" (BPMN terminology).

However, the Process will take one year for all the Steps to be completed, if you have setup naturally.
(Even though any other Steps have been completed up to Conclusion of contract...)

Although this may depend on personal preference, I feel uncomfortable that the status of the Issue remains in "Running" just for not yet sending the "Reminder email". If the "Time until all the Steps to be completed" is measured as KPI in your organization, it will truly be an "annoying presence".

The following Workflow is a Business Process of Email reminder part that is independent. (It is too simple to refer to as a Business Process, though.) In short, it is a mechanism that just to accept "messages" from various Business Processes, and to transmit them at "Reminding date and time".

[Remind Notification]

"I wish I could do my input more smoothly..."

A business system is evaluated more or less by its "Operating screen". Just try to recall your day-to-day jobs, such as "Attendance report", "Decision-making request", "Contract report", "Answer to inquiry", so on... Most of the Delays and reworks that occur on these jobs are caused by "erroneous input or Inappropriate input at upstream Steps".

The following Workflow has been devised to input by clicking on the "Input sample button".

By a button being there, the concentration of inputting personnel will be sustained. Furthermore, occurrence of careless mistakes will be reduced. Even though you won't understand the advantage of "Input sample button" unless you experience, it is another input support that is different from a method of Selecting from options or Configuration of initial value. Even though it is just a button, it helps to go piled up a "sense of doing" of operators because it is their own input!?? And (something like) "CPU load" that give to the brain of the operator will drop significantly.

[Test flow for Input form]

It is no longer an uncommon that letting a Workflow system processing, such as;
  • "Auto-calculation" for consumption tax",
  • "Auto-generation" of invoice PDF,
as the sophistication of information system progresses.

You can reduce mistakes and reworkings greatly by automation of intermediate steps. And also it leads to a shortening the required time for the entire process.

However, on the other hand, excessive automation will result incomprehensible of the mechanism, and become incapable of corresponding upon occurrence of troubles.

All the more reason, when it includes auto-steps which error occurrence rate is not negligible, such as
  • "Auto data retrieving" using communication network
  • "Auto data storage" using communication network
  • "Script Step" with lots of if statement
  • "Script Step" including decimal calculation
(Actually, it might be a great agenda in "era of utilizing Cloud.)

[Invoice Issuance-Sampling check]