=Issue=

The day, month, year, or GL export was not closed by accident. This WIKI describes the process of inserting a retroactive closeout in the database.

=Explanation of Error=

Cyrious SMS uses closeouts to track when the daily, monthly, or annual reports were created, or when the GL export file was created. This is simply a date and time entry in the Closeout table. To retroactively closeout, a new record must be manually inserted into this table.

Note:

  • If customer is running 8.91 you can walk them through closing and unclosing specific dates in Cyrious
  • _Existing users do NOT need to close while this work is done._
  • FASTSIGNS does NOT need a Royalty Closeout. Also Allegra Customers that are on the current release *8.91) does NOT need a Royalty Closeout either.

=Only for 8.91 Customer to insert their own closeouts=

  1. Navigate in Cyrious to Mgmt>Accounting>Retroactively Closeout
  2. Select the Close Out Type from the DropDownList (Daily, Monthly, Yearly, Royalty) that you need
  3. At the bottom of the page choose the date and time you need (please note you can not choose a future datetime closing)
  4. Click the Insert Close Out button
  • Note: to see the newly inserted close, you will have to choose a report that allows datetime selection or shutdown and reopen Retroactively Closeout

=Tier 1 Actions=

  1. Obtain the exact date and time for the closeout to be inserted.
  2. Opened the Database Browser at ..\Cyrious$\SMS\Utilities\DBBrowser.exe.
  3. On the View Tables tab, Click on the Closeout Database table in the left section.
  4. Scroll to the bottom of the grid by clicking on the ยป button beneath the data.
  5. Look for the missing closeout.
  6. Insert a new record in the table by clicking the + button beneath the data.
  7. Enter the Date and Time in the Date Column
  8. Enter the same StoreID used in the other rows in the StoreID column.
  9. Enter the apropriate closeout type in the CloseOutType column
    • D for Daily Closeouts
    • M for Monthly Closeouts
    • Y for Yearly Closeouts
    • X for GL Export Closeouts
    • R for Royalty CloseoutsCheck with management before manually inserting any Royalty closeouts.
  10. Leave the remaining sales columns blank.
  11. Click the check mark button beneath the data to save that row.
  12. Verify that your close out is seen in SMS
    • Click on Reports | Activity Report
    • Expand the Show Detail button under dates
    • Click the drop down for dates
    • Select Prior Close Outs
    • Select the appropriate close out type you inserted
    • Examine the list for your entry.

Notes:

  • If you are inserting a Yearly closeout, it should have a monthly and daily closeout immediately before it. Insert these one and two seconds earlier if needed.
  • If you are inserting a Monthly closeout, it should have a daily closeout immediately before it. Insert this one second earlier if needed.

=Task Information=

  • Last Updated: 2/16/2015
  • Created By: Michael Nolan
  • Verified By:
  • Applies to All Versions
You could leave a comment if you were logged in.