DESCRIPTION

Munsoft version 7.0.13 focuses on several important enhancements to finish off the VAT increase implementation over and above the usual array of general enhancements. All development focus is currently expended on the year-end enhancements which you will see in the Munsoft 7.0.14 and 7.0.15 release.

As per usual there are enhancements included within this release which users can reference via their logged issues against the SYSAID number indicated with each item. Please note that if you do not recognise the SYSAID reference number, then please ignore it as it serves as reference for the users who logged the relevant issue.

RELEASE ITEMS

The following issues are addressed within the Munsoft 7.0.13 release.

CONSUMER DEBTORS STATEMENTS

• A client-specific enhancement has been applied to the Consumer Debtor Statement to additionally indicate the relevant interest transactions.

  SYSAID: 52 307

• A client-specific enhancement has been applied to the Consumer Debtor Statement to additionally display the Agreement details.

  SYSAID: 53 249

• The Consumer Statement extract has been amended to provide an additional option for municipalities that require all their Consumer statements to be generated and made available on the Consumer portal. This extract will contain all the Consumer account statements including the accounts which do not have any balances or movements, over and above the current active Consumer statements.

  SYSAID 53 494

CONSUMER DEBTORS – DEBTOR DETAILED AGEING REPORT - EXCEL

The Consumer Debtor Details Ageing Excel export functionality has been amended to exclude instances where all values are zero so as ensure that these records are removed from the extract.

SYSAID: 53 444

CONSUMER DEBTORS – CONSUMER NOTES

The Consumer notes capture screens have been amended to ensure that only active operators are visible for selection.

SYSAID: 50 492

CONSUMER DEBTORS – DEBTORS RECON REPORT EXCEL

The duplicated billing values which were created within the Debtors Rates Recon Excel extract as from the implementation of the mSCOA 6.2 chart has been removed.

SYSAID: 49 438

CONSUMER DEBTORS – DEBIT AND CREDIT NOTES

The Debtor Debit/Credit note transaction screen has been amended to allow the user to select from a dropdown to apply a 14% VAT rate, from which the system will calculate the VAT automatically and flag the transaction as a 14% VAT transaction. The output VAT report will report on these 14% VAT transactions in a separate column.

SYSAID: 53 072

CONSUMER DEBTORS – DEBIT AND CREDIT NOTES - BULK

Users can now select a 14% VAT rate when importing bulk debit/credit notes. These transactions will be flagged at the selected 14% VAT rate irrespective of the transaction date occurring after March. During payment settlement these transactions will flag the settled VAT as at 14% VAT on the Output VAT report.

SYSAID: 53 277

CONSUMER DEBTORS – TIME OF USE METER READINGS IMPORT

Enhancements have been applied to the time-of-use meter readings import to calculate the consumption based on the variance of the imported current reading and the previous month's reading.

SYSAID: 51 656

CONSUMER DEBTORS – VAT ON METER READINGS ADUSTMENTS

The VAT on each transaction (for each period adjusted) is calculated and levied separately. The system will use the VAT rate applicable to the levy period for each VAT transaction.

SYSAID: 53 143

MONTH END BILLING

The Consumer month-end billing procedures have been enhanced to prevent the scenario where a billing run could fail halfway and have a negative impact on the data integrity. Billing runs will now either complete or fail in totality to ensure the integrity of the underlying Consumer billing dataset, in the event where a billing run is accidentally terminated before completion.

CONSUMER DEBTORS – METER BILLING VAT CORRECTION.

The new Meter Split Consumption Calculation extract calculated the portion of VAT that should have levied at 14% and will automatically create a spreadsheet with the relevant bulk credit notes which can be used to import the credit notes in the correct format.

The narration of these credit notes will default to “VAT INCREASE ADJ” on import if the user selects the "display desc on stat" checkbox. The text file sent to the printers will leave these credit notes to display in detail on the statements and not bulk them together into the VAT amount.

CONSUMER DEBTORS TRANSACTIONS

A new "narration" field has been added to the Payment Reversal and Payment Transfer transaction screens. Users are advised to utilise the new checkbox to indicate whether the narration should reflect on both account statements.

SYSAID: 50 210

OUTPUT VAT EXTRACT

The debtor output VAT report will split the VAT settled columns between 14% and 15% to accurately report on the VAT rate at which the VAT settlement took place.

SYSAID: 53 212

CASHIER IMPORTS

• A client-specific enhancement has been applied to enable the EasyPay import to additionally import the relevant bank charges.

  SYSAID: 43 183

• An additional column has been added to the cashier Excel report to indicate “unallocated” in the reference column.

  SYSAID: 44 215

SCM REQUEST FOR QUOTATIONS

The Request for Quotations reprint screen has been enhanced to prevent the user from selecting an irrelevant creditor. Furthermore, the print button will only be enabled once a valid creditor, who was originally linked to the request, has been selected.

SYSAID: 52 846

SCM COMMODITIES

An enhancement has been applied to the Commodity List Excel report where the Commodity Type selection, filters the report output.

SYSAID: 52 923

SUNDRY DEBTOR AGEING REPORT

Both the plain text and Excel Sundry Debtor Detailed and Grouped Ageing reports have been enhanced to additionally indicate the last payment, and payment date columns.

SYSAID: 26 454

PROCUREMENT

• A client-specific enhancement has been applied to the Purchase Order Header Total to ensure the header total equals the sum of the details.

  SYSAID: 53 348

• A client-specific enhancement has been applied to the Requisition Add Header Total to ensure the header total equals the sum of Detail.

  SYSAID: 53 437

• The GRV process has been enhanced to automatically calculate VAT at 14% where Users enter the invoice date prior to 1 April and the order date is after the budget speech, i.e. 21 February 2018. Cashbook and creditors transactions have been adjusted to ensure that Users can no longer change the VAT amount to less than R1 difference from the calculated VAT amount.

  SYSAID: 53 364

BANK RECON MONTH END

A new bank recon bank code change program has been added under SUPERVISOR -> REGULAR PROCEDURES -> MONTH END -> B/RECON MONTH END -> BANK CODE TRANSFER.

This program will enable Users to move unreconciled items from the old bank code to the new bank code.

GENERAL LEDGER - VOTE ENQUIRY – HISTORY TAB

• Enhancement to Excel extract of Vote Enquiry – History Tab, where the report is displaying all long description segment, fin year, from and to fiscal information.

  SYSAID: 50 760

• A client-specific enhancement has been applied to the Vote Transaction History document to align the GUID descriptions on the document to that of the Segment Enquiry screen.

  SYSAID: 53 236

GENERAL LEDGER - JOURNALS

A client-specific enhancement has been applied to the stylesheet which prints the Segment Description instead of the GUID codes.

SYSAID: 52 783

GENERAL LEDGER - NATIONAL TREASURY TABLED BUDGET EXTRACT

An enhancement has been applied to disable National Treasury Budget Uploads where values contain cents or the total amount does not equal to zero.

GENERAL LEDGER – SC BUDGETING

An enhancement has been applied to the Project Budget Report to also additionally include controls for outer years.

STORE MODULE – STORE ISSUE

A client-specific enhancement has been applied to ensure the creation of the Stores Issue document.

SYSAID: 53 090

STORE MODULE – STOCK TAKE – CREATE BATCH

An enhancement has been applied to indicate the next available batch number on the far right of the screen next to the 'Batch Number'

SYSAID: 53 090

CASHBOOK ENQUIRY - EXCEL

An enhancement has been applied to the Cash Book Enquiry Excel output report to increase the “Description” field length.

SYSAID: 53 101

CREDITORS – PAYMENT REFERENCES

An enhancement has been applied to the export for municipalities using the 'FNB' upload. Eleven characters of the Batch Reference will be concatenated with the EFT number and displayed accordingly on the export.

SYSAID: 51 829

CREDITORS – CREDITORS AGEING REPORT

A client-specific enhancement has been applied to the Creditors Age Analysis report where the “Total” column was added for each creditor and without headings after every creditor.

SYSAID: 52 212

RELEASE DEPLOYMENT SCHEDULE

Munsoft version 7.0.13 will be released from 25 April 2018. The Munsoft release version is visible on the Munsoft Login screen.