Back
5. Invoice & Billing
On closing sessions, Invoice Number displayed is always 1

Scenarios where the issue occurs:-

The Scenarios where this issue can occur are as follows:

  1. Power Failure.
  2. Unexpected Server Machine Restart or Shutdown.
How to Identify the issue:-

Steps that help us to identify the issue are as follows:

  1. When we close the session of any client from C3M Server, it shows invoice id 1.Also unable to close the session.
Solution Provided:-

Steps to resolve the issue are as follows:

  1. Open the Café Manager Console to check for the error message or issue.
  2. Close the Café Manager Console.
  3. Open the Database folder and take a backup of CCM.C3M file which is located at “C:/Program Files/Ideacts/Clinck Cyber Café Manager/Database”.
  4. Now Open the CCM.C3M file and follow the below mentioned steps:
    1. For Office 2003
  • Go to Tools > Database Utilities > Compact and Repair Database
  • This will help us remove all the invalid entries and establish the relationship between the tables.
  1. For Office 2007
  • File (MS Office Logo) > Manage > Compact and Repair Database
  • This will help us remove all the invalid entries and establish the relationship between the tables.
  1. Now open the Café Manager console and see if this resolves the issue by trying to close a session. If this does not work then go to step 6.
  2.  Open the Database and check for the following table which may have invalid Entries.
    1. “tInvoice” table
  3. If the above mentioned table has invalid entries (#######-Symbol) then remove all the rows which have those entries in the table.
  4. Close the database.
  5. Open the Café Manager console and Login to an idle client machine & now a new invoice id will be created. This should resolve the issue.