This special webinar is a Q&A session held with existing Denali customers on 15 September, 2016. It lasts about 1 hour.
Questions & Answers from the Webinar
- How could I re-reconcile a bank account in Bank Rec for a month already reconciled?
Once you post the reconciliation, you can’t redo it. It is recommended that you print and/or save the reconciliation report right before posting.
- Please go over recurring GL entries, we have followed the Denali GL User Guide and cannot get it to work.
Reoccurring GL Journal entries must be set up in a separate batch marked as reoccurring. Once these are saved, then you can open a regular batch (not a reoccurring batch) and process the reoccurring Journal entries. You can’t process reoccurring Journal entries in a reoccurring batch as these batches are only for setting up the reoccurring entries and saving them for future processing. When you process reoccurring Journal entries in a regular batch, the original entries are still saved in the reoccurring batch in order to reprocess them as often as you need. You can edit or delete the reoccurring entries from the reoccurring batch, but you must be in a regular (not reoccurring) batch in order to process and post these entries.
- In Payroll how would you set up a benefit code for 401k match that is not a straight percentage, for example a contribution of .25% up to 4% employee contribution?
You can only set up a benefit code that is a percentage of gross, fixed amount, variable amount, or based on the number of units (hours) on the paycheck. For other options not listed, you can use Variable amount and then manually enter the amount on each paycheck as needed.
- How did you have the comments automated to the items you rang up (in Order Entry or Point of Sale)?
You can add additional comments to the items in Inventory that you can set to automatically be inserted on the invoice/sale in OE and POS. These additional comments can be added by going to the item in Inventory (Stock Item Maintenance) and selecting the “Ext. Description” tab.
- We have a cloud installation. How do we get the Excel and Word options to work? Do we need to have an Office key for the cloud server?
You will need to install a copy of Microsoft Excel and Word on the cloud workstation in order to open Excel and Word files from the cloud workstation. You should have received a license key for these applications from the retailer where you purchased them. If you need to purchase Microsoft Excel or Word (or Microsoft Office which includes both Word and Excel), contact a Microsoft retailer or go to www.microsoft.com for more information.
- When inventory is added to AP it is NOT being reflected in Inventory. How do we fix this?
When entering bills in AP, if you select “Direct” as the line type in the Detail grid, nothing will post to Inventory. If you need to add items to inventory from a vendor bill in AP (including updating the cost of items), be sure to select “Inventory” as the line type instead of “Direct” (make sure AP to Inventory integration is turned on in the AP Module Preferences).
- Can you demonstrate how your new email module would work with emailing out pay stubs to employees?
For more information on Denali eDelivery (the new email delivery system to email pay stubs to employees, invoices and statements to customers, and purchase orders to vendors), contact your Cougaar Mountain Account Executive at 1-800-388-3038.
- When Cougar was set up to integrate, all my sales taxes are going into the withholding accounts instead of the sales tax account. How do I fix it?
When you integrate Sales with General Ledger, you setup the Tax Codes in Sales to include the Liability account in GL where you want the sales tax liability to post to. If you put in the withholding tax liability account on the Sales Tax code in sales, it will post to this account. To fix this, you will need to go to the Sales Tax code in the Sales module and enter the correct Sales Tax Liability account on the Sales Tax code. This will correct all postings from Sales to General Ledger going forward, but it does not change anything that has already posted up to this point. To correct past postings, you will need to do a Journal Entry in GL.
- In Accts Receivable some of the customer cards have old item from past years. Last year when we closed out for the year, I did a purge, but there is still old invoices in there with no old credits to offset them. What is the best way to clean these up?
Purging open items or history will not purge any items that still have a balance remaining on the item. To clear these up, you will need to enter a credit and apply it to the old items to clear them up. If the items are credits, you will need to enter a charge and then apply the old credits to the charge. (Keep in mind that if you zero out a credit balance on a customer’s account, you may need to issue a refund to the customer. It is recommended that you check with your accountant to determine if this is necessary.)
- Can you reprint posting after you post your invoices?
It is possible to reprint the GL Posting in General Ledger under the “Reports” menu (select “Reprint Posting”). However, the other module posting reports are only available immediately after posting. If you need to be able to reprint these reports, it is recommended to save these reports as a pdf or MS Word document.
- Unit of measure in OE (can, six pack, case of coke)
You can set the Unit of Measure to whatever you want it to be in the Inventory Item Maintenance, under the Sales Info tab. Then you can include this for the items in Order Entry by setting up the Order Entry Screen Layout to include this field in the Detail section.
- Capabilities of user defined fields in PR (why isn’t this available in IN, AR & AP)
The Denali Payroll module is one of our newer modules in Denali. When we designed the Payroll module for Denali, we enhanced the User Defined options for Payroll, but the other modules were already completed prior to these newer options being available.
- I believe at this time our only question is if benefits can be costed to follow the employee wages or do percentages need to be manually put in? For example, if an employee works 10 hours for program/job #1 and 30 hours for program/job #2, would 25% of that employees benefits follow where the 10 hours went for job #1 or would we have to manually enter the percentages each time as the number of hours change to each job?
You can set up the benefits to automatically calculate based on percentage of total gross wages for each employee. If you allocate the benefit to all departments (programs for Fund accounting), then you can delegate specific benefit expense accounts under the department code (program code). Then when you process payroll, the benefit expense is automatically allocated to the specific department code (program code) based on the amount of gross wages that are allocated to each department (program). In this example, if the employee’s hourly rate is the same amount for both programs, then yes, it will automatically allocate 25% of the benefit expense to program/job #1 and 75% to program/job #2.
- Denali can “print” reports to Excel, but they appear in Excel in the image of a printed report, not suitable for calculation. Is there a way to output reports to Excel as data so I can combine, sort, modify, graph, and analyze the data?
There are a couple of reports in General Ledger that can be saved as a “csv” file for Microsoft Excel (Audit Trail and Trial Balance). No other reports have this option at this time. There is one other option for Spreadsheet Export to export period totals for each account to Excel under the Reports menu in General Ledger.
- After posting sales, the time of the sale seems to be changed to 0 (midnight). Is there a way to preserve the actual time to allow me to track sales trends through the day?
The time of sale should not reset at posting. Please contact customer support at 1-800-390-7053 for assistance.
- Is there a way to add buttons to the POS window to add commonly sold stock items?
Yes, the latest version of Denali does have this option. Under the Options menu in the Sales module, there is an option to “Setup Item Buttons”. Then to add the buttons to the Sales Entry screen, go to the Sales Entry Layout and select the option you want for “Display Inventory Item Buttons”. (Note: this option is only available if you have the Point of Sale module installed and only for Sales Entry Layout codes where the Entry Window is set to “POS Register”.)
- Is there a way to have two receipts for credit card sales and just one receipt for cash sales?
Yes. For Point of Sale, this is setup in the Register Code. Just enter the number of copies you would like to print for each tender type. In Order Entry, this can be setup in the Sales Entry Screen Layout (for codes where the Entry Window is set to “Order Entry”) under the “OE Invoice” tab.
- Is there a way to not open the cash drawer for credit card sales and for tender amounts equaling zero?
Not at this time.
- Is there a way to perform a database backup (using command line parameters for database and system date) by just clicking a desktop icon rather than entering the Denali controller?
The best option for backing up the Denali database for your organization is in the Denali Controller module. However, if you have access to the SQL Server where the Denali data is stored, you may have options for running a SQL backup of your data. Check with your database or IT administrator for more information on SQL backups.
- Is there a way to bypass the UAC box when opening Denali on Windows 10?
Yes, you can set your User Account Control settings to “Never Notify” in Windows 10 settings. You may need Administrator privileges for your Windows 10 operating system to do this.
- What is the difference between EFT and ACH payments:
Denali does not differentiate between EFT and ACH. It is simply called an Electronic Payment in Accounts Payable. There is no other option for ACH.
- How does each of them work in Denali:
EFT Payments in Accounts Payable can be made under the Pay Bills or Enter Bills (Immediate Checks only) entry. If the Vendor is setup for Electronic Payments, just make sure the “Electronic” box is checked in Enter Bills or the “Electronic Payments” is checks in Pay Bills (these options are checked by default for vendors setup for Electronic Payments in Vendor Maintenance under “Remit To” tab).
- When you make payments using one of the two methods, how does it flow in Denali?
When paying vendors electronically, Denali generates a data file that you would upload to your bank (similar to the Direct Deposit file in Payroll). Check printing is suppressed for all Electronic Payments when printing checks. All other functions are the same as regular payments.
- How does it integrate with our bank?
There is no direct integration. Denali simply creates a data file. You need to be set up with your bank to process Electronic Payments to vendors. Then you simply log into your online banking and upload the file. This process is entirely based on how your bank handles electronic payments. Most banks have a Cash Management or Bill Pay system after you log in to upload the file. Some smaller banks simply have an email address to send the file to. Check with your bank to determine the process.
- How do our vendors get the information on which invoices were paid in each transaction? Can we create a report that would replace the check stub?
Since the payment is made electronically, the information is submitted in the data file. You can print a “Payment to Invoice” report in lieu of the check stub for electronic payments. This report shows the payment and each invoice that the payment paid.
- What is the best way to except donations? Would we want to create a tax exempt inv. code and have it at zero cost and retail and then price override any time someone wants to make a donation?
I recommend setting up a Non-Inventory code (which can be set as tax exempt) with a default price of zero. Then just override the price when you use it. Non-Inventory codes can be setup in the Sales module under the Options menu.
- Will Denali notify upon entering invoices that the invoice number is a duplicate rather than waiting until the posting process?
No. Transaction validation is done at posting. However, you can select “Print Account Impact Summary” when you run the edit report to validate the batch. If there are duplicate invoice numbers, you will get the same posting error that you would get at posting. If there are no errors, you will see the General Ledger impact if you were to post the batch without any further changes, but nothing actually gets posted yet at this point (as noted at the end of the GL Impact Summary report).