Release Notes - Build 3.10

Enhancements 

Account Reconciliation

• The Account Reconciliation is a new feature available on the Accounting Tab to help users reconcile a specific GL Account.  

• The option is available if the Account Reconciliation Security is set on the Accounting Tab in the Security Window.  

• This new screen will allow the user to enter a g/l account and reconciliation date to reconcile the account.  If it is the first time that the g/l account has been reconciled we will allow for the entry of a beginning balance.

• If the g/l account has been reconciled previously the reconciliation date will be displayed below the reconciliation date.  

• There can only be one open reconciliation for a specific g/l account.  

• The user can select to display debits, credits as well as entries after the reconciliation date.  

• The Display Records button will display all records.  

• If the user needs to do a journal entry to account for a missing item such as bank fees they can take the Journal Entry button and that will allow them to do the journal entry and then come back and display it in the datagird.

• Once the beginning balance plus/minus the debits and credits equals the ending balance the Finalize button will be enabled and that will allow the user to complete the reconciliation process.

AP Invoice Entry Window

• Accounts Payable Adding Documents to Header

• The user can now add documents to the A/P Invoice directly from the A/P Invoice entry screen.

AP Payments

• New functionality has been added to allow Date Selection in Auto Checks. This feature will allow a date to be picked and have that be the check date and posting date for the check run. A new Check Date field has been added to the Auto Checks tab in AP Payments. The Check Date field will be visible after the user has performed the Build function. The new date picker has been added to the right of the check number field. It will default to today's date.

Currency Code Window and Currency Updates

• Real Time Currency

• We now have a button, Bank of Canada Inquiry, that will get the current exchange rate by making an API call to the bank.  The user will select a Currency Type and then the button becomes enabled.  It will then populate the rate with the current rate and the user can save the record.

• Work Order Uses the Current Rate

• If the user is prompted for an Invoice Date and selects a previous date the system will get the correct currency rate for the date selected.

• Accounts Payable Uses the Correct Currency Rate

• If the user enters an a/p invoice and selects an invoice date that is prior to the current date the system will pull the correct currency exchange rate.

Deposits 

• Deposits is a new feature that has been added that allows the user to take deposits from customers to use towards payment on services invoiced on a Work Order

• Branch Window Updates for Deposits

• We have two new line items in the Branch record for deposit accounting.  There is a debit and a credit line item.

• Invoicing Window Updates for Deposits

• Within the Sales Document there is now a Deposits option.  

• The user can add a single deposit to the order and void that single deposit. 

•  The visibility of the button is dependent on the Show Deposit Button security being turned on in the Invoice Tab of the Security Window

• When the user takes the Deposit button they will see the Add/Revere Deposit Window .  They can enter a deposit amount, a payment type and comments.  If there is already a deposit the Add Deposit button will say Reverse Deposit.

• When the Add Deposit or Reverse Deposit button is selected the system will post the deposit to the general ledger.

Invoice Design Options

• A new checkbox option on the Comments tab, Print Comments on Bottom, was added to allow the user to decide if the Work Order Comments print before or after the details on the Work Order.  

Invoicing/Sales Document Window

• In a Sales Document/Work Order a new option named ‘Preview As Invoice’ has been added under the Print drop down. When this option is selected we will Print Invoice in place of Order for both the title and the Document # field. This will be enabled for Open Sales Documents/Work Orders only. 

• Foreign currency price can now be entered on a Sales Document/Work Order. A new plus button has been added to the right of each Sell Rate field. This button will open a new ‘Calculate Currency Exchange’ window where the foreign price can be entered. The foreign price entered will be multiplied by the conversion rate that is saved on the Rates/Taxes tab of the Sales Document/Work Order. If foreign currency is used on the Sales Document/Work Order then the Invoice will be printed with the foreign currency.

• If the Sub-Name line is not populated on the Customer record a blank line will no longer be printed on Invoices or Quotes.

• Ability to Mark a Sales Document as Emergency or Stock

• On the header of a Sales Document there is a new drop down that allows the user to define if it is Stock or Emergency.

• Invoices that have a Currency Type identified on them in the Rates/Taxes tab will now only display the Invoice Total on the documents in the Currency identified.  

Purchase Order Window

• The Purchase Order Window was updated to allow users to add Documents to a Purchase Order

• The Parts Tab on the Purchase Order was updated to display the SKU of a Part Number when adding it to a Purchase Order

• The PO Parts Receive Window called from the Purchase Order was updated to display the SKU of a Part Number when receiving the Part Number.  The user can also click into the data grid and edit the SKU when receiving the part.  

Issues Resolved

AP

• An AP Invoice Number can be entered multiple times under the same Journal and be paid correctly. 

• AP Payments now works when there are multiple AP Invoices created from a Voucher or Journal Type.  

• AP Invoices now require a Vendor Number when setting up the AP Invoice for a Credit Card Payment.  

Invoicing/Sales Document Window

• When changing the Bill To or Ship To Customer on an Invoiced Work Order the check for Auto Charges is no longer called.  

• Converting a Quote to an Open Work Order with Parts and Miscellaneous Charges that had an apostrophe in the Description or Additional Description now are added to the Open Work Order.  

• When Invoicing a Work Order with a Currency Type on it, the Invoice will show the Total Amount correctly in the Currency identified.  

• The warning message for editing a Secondary Meter on an Equipment record now displays correctly.  

• Invoicing a Work Order when the Customer had an apostrophe in the OB10 field now works correctly.  

• Sections can now be created on a Work Order that have an apostrophe in the name.