Debtor Transaction Report Issue - Db name starting with 1

Discussions relating to plugin development, and the Jiwa API.

Debtor Transaction Report Issue - Db name starting with 1

Postby Luehman » Fri Jul 03, 2020 11:47 am

We are currently running JIWA7 as below and have found that if we have a debtor with a name beginning with either a "1" or a "0" they do not appear on the debtor transaction reports?
Considering we are running the standard JIWA report DBTRN010 we would not have expected this, after spending hours trying to reconcile why it is that our reports do not balance we have found this error and been able to test it and replicate it with any debtor if we put 1 or 0 at the beginning.
Is there an updated version of the report that corrects this?

Jiwa Financials
===============
Application Version : 7.2.1.0

Database Version : 7.2.1

SQL Login : JiwaLogin
Reports SQL Login : JiwaReports
SQL Server Name : SVR-SQL\JIWAV7
SQL Version : 10.50.2500.0
SQL Database : A1Roadlines
SQL Version String : Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
Jun 17 2011 00:54:03
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Luehman
Occasional Contributor
Occasional Contributor
 
Posts: 31
Joined: Tue Mar 17, 2020 9:48 am

Re: Debtor Transaction Report Issue - Debtor name begining w

Postby Scott.Pearce » Fri Jul 03, 2020 1:17 pm

You should log a ticket here.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 8 guests

cron