Good day

On Sage Evolution, where do I get the data to create the Supplier age on SIC, and to sort it according different parameters?

Henning

Views: 105

Reply to This

Replies to This Discussion

Hi Henning.

Please have a look at the link below which should assist you in identifying the base tables used in the Evolution DB.

https://www.sageintelligence.com/report-utility/sage-evolution/

I think you'll have better success contacting the Evolution support team to identify were the specific information you're looking for can be found in the DB.

Hope this helps!

Kind regards,
Keeveshin

Thank you, will check and try

I have done a similar report on Debtors, works like a bomb, see script below and amend

ALTER proc [dbo].[zspThymeDebtorsReport] (@RunDate dateTIME)
as

BEGIN

truncate table _etblAllocsDCLinkRangeTemp
insert into _etblAllocsDCLinkRangeTemp (DCLink)
select DCLink from _bvARAccountsFull where (IsNull(MainAccLink,0)=0) and
((select round(IsNull(SUM(Debit),0)-IsNull(SUM(Credit),0),2) from PostAR where AccountLink=DCLink and TxDate<=@RunDate)<>0)

--exec [Cicoti HeadOffice]..sp_procedure_params_rowset N'_espSetPostARAPAge',1,NULL,NULL

exec _espSetPostARAPAge;1 'AR',@RunDate,NULL,4

select c.credit_limit,C.Account,C.Name,c.Tax_Number,C.Credit_Limit,B.cBranchDescription,B.cBranchCode,A.Age1 as Age_1,
A.Age2 as Age_2,A.Age3 as Age_3,A.Age4 as Age_4,A.Age5 as Age_5,A.Age6 as Age_6,A.Age7 as Age_7,
A.FCAge1 as FCAge_1,A.FCAge2 as FCAge_2,A.FCAge3 as FCAge_3,A.FCAge4 as FCAge_4,A.FCAge5 as FCAge_5,A.FCAge6 as FCAge_6,A.FCAge7 as FCAge_7,
case when c.AccountTerms = 0 then 'Current'
when c.AccountTerms = 1 then '30_Days'
when c.AccountTerms = 2 then '60_Days'
when c.AccountTerms = 3 then '90_Days'
when c.AccountTerms = 4 then '120_Days'
when c.AccountTerms = 5 then '150_Days' end as AccTerms,

A.AccountBalance,A.AccountBalanceForeign

from [dbo]._efnAgedPostARBalancesSumExtra(@RunDate, null) A
INNER JOIN Client C
ON C.DCLink = A.AccountLink
LEFT JOIN _etblBranch B
ON B.idBranch = C.Client_iBranchID

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service