Skip to end of metadata
Go to start of metadata

Problem

In 7.02.01 databases where there are no Debtor System Templates loading the Debtor System Template to create a new template errors.

image-2020-07-28-10-45-28-699.png

Solution

SQL Management skills required

A working knowledge of SQL Management Studio is required to complete this task.


The issue will be addressed in the next full release of Jiwa Financials after 7.02.01.  In the interim, run the following script over the 7.02.01 database to allow the form to load and new templates to be created

DELETE FROM DB_DebtorSystemTemplateDefaultReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplate%'
DELETE FROM DB_DebtorSystemTemplateDefaultReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplateUI%'

GO

DELETE FROM DB_DebtorSystemTemplateReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplate%'
DELETE FROM DB_DebtorSystemTemplateReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplateUI%'

GO