{"id":29161,"date":"2026-09-17T14:12:02","date_gmt":"2026-09-17T07:12:02","guid":{"rendered":"\/en\/?post_type=ht_kb&p=29161"},"modified":"2026-09-17T14:12:02","modified_gmt":"2026-09-17T07:12:02","slug":"how-to-use-closebook-tool","status":"publish","type":"ht_kb","link":"\/en\/kb\/how-to-use-closebook-tool\/","title":{"rendered":"How to use Closebook Tool"},"content":{"rendered":"

I. Purpose<\/strong><\/h2>\n

This document is intended for support \/ technical staff using the tool to resolve closebook
\n(period-end closing) issues for customers using CUKCUK software. No programming
\nknowledge required \u2014 just follow the steps illustrated with screenshots below.<\/p>\n

II. Instruction steps<\/strong><\/h2>\n

1. What is this tool for?<\/h3>\n

ClosebookTool is an internal tool used to handle 2 situations related to the closebook (period-end closing) on a customer’s CUKCUK system:<\/p>\n\n\n\n\n\n
Function<\/strong><\/td>\nWhen to use<\/strong><\/td>\n<\/tr>\n
Unlock Closebook<\/td>\nCustomer reports the closing period is “stuck” \/ locked incorrectly and cannot proceed<\/td>\n<\/tr>\n
Maintenance Closebook<\/td>\nNeed to recalculate \/ update closebook data for a specific POS register, within a specific date range<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

IMPORTANT:<\/strong>
\nThis tool operates directly on the customer’s original data. Only use it when truly necessary and after confirming the correct procedure. If unsure, ask your supervisor before clicking Process<\/strong>.<\/p>\n

2. Preparation before use<\/strong><\/h3>\n
    \n
  • The computer used to perform this task must be able to connect to the customer’s data server (SQL Server) \u2014 either on the same internal network, or via VPN if supporting\u00a0 remotely.<\/li>\n
  • Have a tool login account \u2014 request one from the technical\/admin department (this is a separate account for the tool itself, not the CUKCUK software login account).<\/li>\n
  • Clearly identify: which customer needs processing, which time period, and which POS
    \nregister (if performing data maintenance).<\/li>\n<\/ul>\n

    3. Connect to customer data<\/h3>\n
      \n
    1. Open the ClosebookTool<\/strong> application.<\/li>\n
    2. In the DB<\/strong> name field, the tool automatically scans and lists the data servers found on the network. Select the correct server for the customer you need to work on.<\/li>\n
    3. In the Database<\/strong> field, select the correct database (usually named after the customer’s code\/name).<\/li>\n
    4. Click the Connect<\/strong> button.<\/li>\n<\/ol>\n

      \"\"<\/p>\n

      Note<\/strong><\/p>\n

        \n
      • If DB name<\/strong> is not selected, the tool shows: “Please select a database instance.<\/em>“<\/li>\n
      • If Database<\/strong> is not selected, the tool shows: “Please select a database.<\/em>”
        \n\u2192 Select both fields fully, then click Connect again.<\/li>\n<\/ul>\n

        4. Log in to the tool<\/h3>\n

        After clicking Connect<\/strong>, the login screen appears:<\/p>\n

          \n
        1. Enter the User<\/strong> and Password<\/strong> you were given.<\/li>\n
        2. Click Login<\/strong>.<\/li>\n<\/ol>\n
            \n
          • If the information is incorrect \u2192 the tool shows “Invalid username or password.” \u2014 check and re-enter (note: case sensitive).<\/li>\n
          • If you click Cancel<\/strong> \u2192 you return to the database selection screen from Step 1.<\/li>\n<\/ul>\n

            CAUTION: <\/strong>Do not share the tool’s login account with unauthorized persons. This account has permission to directly modify the customer’s closebook data.<\/p>\n

            \"\"<\/p>\n

            5. Open the function you need<\/h3>\n

            After a successful login \u2192 the Tools<\/strong> menu at the top becomes active, containing 2 functions: Unlock Closebook<\/strong> and Maintenance Closebook<\/strong>.<\/p>\n

            \"\"<\/p>\n

            6. Function: Unlock Closebook (Unlock a stuck closing period)<\/h3>\n

            Use when: the customer reports being unable to close or process the closing period because it is locked incorrectly or was left in an incomplete state.<\/p>\n

            \"\"<\/p>\n

            Steps<\/strong><\/p>\n

              \n
            • Go to Tools<\/strong> \u2192 Unlock Closebook<\/strong>.<\/li>\n
            • By default, the Check version<\/strong> box is already checked \u2014 keep it as is unless
              \ninstructed otherwise.<\/li>\n
            • Click Process<\/strong>.<\/li>\n
            • A confirmation dialog appears \u2014 click Yes<\/strong> to continue (No<\/strong> to cancel the action).<\/li>\n
            • Watch the progress in the Information<\/strong> panel on the right, and wait until you
              \nsee the closing line of dashes.<\/li>\n<\/ul>\n

              Reading the results<\/strong><\/p>\n\n\n\n\n\n\n\n\n
              Displayed content <\/strong><\/td>\nMeaning<\/strong><\/td>\n<\/tr>\n
              Unlock th\u00e0nh c\u00f4ng: X (Unlock successful:
              \nX)
              \n<\/strong><\/td>\n              		Total number of closing periods processed<\/td>\n<\/tr>\n
              TH1: … \/ TH2: …<\/td>\nCount by 2 different error-case groups<\/td>\n<\/tr>\n
              \u0110\u1ed3ng b\u1ed9 BE th\u00e0nh c\u00f4ng (BE sync
              \nsuccessful)<\/td>\n              		If TH2 occurred, the data has been
              \nautomatically synced to the central system<\/td>\n<\/tr>\n
              \u0110\u1ed3ng b\u1ed9 BE th\u1ea5t b\u1ea1i (BE sync failed)<\/td>\nSyncing to the central system was not
              \nsuccessful<\/td>\n<\/tr>\n
              Kh\u00f4ng c\u00f3 kh\u00f3a s\u1ed5 n\u00e0o \u0111\u01b0\u1ee3c x\u1eed l\u00fd (No
              \nclosing periods processed)<\/td>\n              		No closing periods with errors requiring unlock
              \nwere found<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

              IMPORTANT NOTE<\/strong>
              \nAfter a successful Unlock, ask the customer to log out and log back in on the POS (point-of-sale) machine so the software correctly picks up the new state. Skipping this step means the customer will still see the same error.<\/p>\n

              7. Function: Maintenance Closebook (Maintain closebook data)<\/h3>\n

              Use when:<\/strong> you need to recalculate or update closebook data for a specific POS register,
              \nwithin a specific date range.<\/p>\n

              \"\"<\/p>\n

              Steps<\/strong><\/p>\n

                \n
              1. Go to Tools<\/strong> \u2192 Maintenance Closebook<\/strong>.<\/li>\n
              2. Select the From Date<\/strong> and To Date<\/strong> to process.<\/li>\n
              3. Select the Register Number<\/strong> \u2014 the POS register to process.<\/li>\n
              4. Keep Check version<\/strong> checked (checked by default) unless instructed otherwise.<\/li>\n
              5. Click Process<\/strong> and monitor the result in the Information panel.<\/li>\n<\/ol>\n

                Note<\/strong>
                \nThe tool automatically checks and will show an error if:<\/p>\n

                  \n
                • From Date<\/strong> or To Date<\/strong> is a future date (later than the current date)<\/li>\n
                • From Date<\/strong> is later than To Date<\/strong><\/li>\n<\/ul>\n

                  In that case, select valid dates again and click Process<\/strong> again.<\/p>\n

                  Reading the results<\/strong><\/p>\n\n\n\n\n\n\n
                  Displayed content<\/strong><\/td>\nMeaning<\/strong><\/td>\n<\/tr>\n
                  C\u1eadp nh\u1eadt th\u00e0nh c\u00f4ng X kh\u00f3a s\u1ed5 (Update
                  \nsuccessful: X closing periods)
                  \n
                  \n<\/strong><\/td>\n                  		Number of closing periods updated, then
                  \nautomatically synced to the central
                  \nsystem
                  \n<\/strong><\/td>\n<\/tr>\n
                  \u0110\u1ed3ng b\u1ed9 BE th\u00e0nh c\u00f4ng \/ th\u1ea5t b\u1ea1i (BE sync
                  \nsuccessful \/ failed)<\/td>\n                  		Result of syncing to the central system<\/td>\n<\/tr>\n
                  Kh\u00f4ng c\u00f3 kh\u00f3a s\u1ed5 n\u00e0o c\u1ea7n c\u1eadp nh\u1eadt (No
                  \nclosing periods need updating)<\/td>\n                  		No data needs processing in the selected
                  \ntime range<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                  Exit \/ switch to another customer<\/strong>
                  \nGo to the Exit<\/strong> menu to return to the initial database selection screen \u2014 use this when you
                  \nneed to switch to processing a different customer\/database.<\/p>\n

                  9. Common troubleshooting<\/h3>\n\n\n\n\n\n\n\n\n
                  Situation<\/strong><\/td>\nPossible cause<\/strong><\/td>\nResolution<\/strong><\/td>\n<\/tr>\n
                  DB<\/strong> name<\/strong> field has no data<\/td>\nThe customer’s data server
                  \ncannot be found on the
                  \nnetwork, or the current
                  \nmachine is not connected<\/td>\n                  		Check the network\/VPN
                  \nconnection, confirm the server name with technical staff<\/td>\n<\/tr>\n
                  Shows “Cannot connect to
                  \ninstance…”
                  \n<\/strong><\/td>\n                  		Wrong server name, server is down, or access has not been granted<\/td>\nContact the infrastructure\/technical
                  \ndepartment to check the
                  \nserver<\/td>\n<\/tr>\n
                  Shows “Invalid\u00a0username or
                  \npassword.”<\/td>\n                  		Incorrect tool
                  \naccount\/password entered<\/td>\n                  		Check the credentials provided and re-enter them accurately<\/td>\n<\/tr>\n
                  Shows “Error loading
                  \ndevice list…”
                  \n <\/td>\n                  		Unable to retrieve the POS
                  \nregister list from customer
                  \ndata, or incorrect database
                  \naccess rights<\/td>\n                  		Check that you connected to the correct database with the correct access rights; if the error persists, report it to technical staff<\/td>\n<\/tr>\n
                  BE sync failed<\/td>\nInternet connection lost, or the central system is experiencing an interruption<\/td>\nRetry after a few minutes; if it still fails, report it to technical staff to check the central system<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                  Important notes<\/h3>\n

                  REMEMBER<\/strong><\/p>\n

                    \n
                  • Always confirm you have the correct customer \/ correct database before clicking Connect<\/strong> \u2014 to avoid accidentally operating on another customer’s data.<\/li>\n
                  • Keep the Check version<\/strong> box checked unless instructed otherwise by the technical department.<\/li>\n
                  • For Unlock Closebook<\/strong>: always remind the customer to log in again on the POS machine after processing is complete.<\/li>\n
                  • If the result looks abnormal or you are unsure about an action, stop and contact
                    \nthe technical department instead of continuing on your own.<\/li>\n<\/ul>\n

                    Need further support?<\/strong>
                    \nContact the technical\/system administration department responsible for this tool to request an account or get help with situations outside the scope of this document.<\/p>\n","protected":false},"excerpt":{"rendered":"

                    I. Purpose This document is intended for support \/ technical staff using the tool to resolve closebook (period-end closing) issues for customers using CUKCUK software. No programming knowledge required \u2014 just follow the steps illustrated with screenshots below. II. Instruction steps 1. What is this tool for? ClosebookTool is an…<\/p>\n","protected":false},"author":114,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3604],"ht-kb-tag":[],"class_list":["post-29161","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-philippines"],"_links":{"self":[{"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/29161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/comments?post=29161"}],"version-history":[{"count":3,"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/29161\/revisions"}],"predecessor-version":[{"id":29187,"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/29161\/revisions\/29187"}],"wp:attachment":[{"href":"\/en\/wp-json\/wp\/v2\/media?parent=29161"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/ht-kb-category?post=29161"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=29161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}