acc.entr.MnfInvCtDbCr.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of beige-acc Show documentation

It consists of double entry accounting and trading (web-store) business logic. It's based on previous beigesoft-accounting and beigesoft-webstore projects.

The newest version!

select 14 as SRTY, MNFCT.DAT, 'INVENTORY' as ACDB, ITMCT.NME as SADNM, ITMCT.IID as SADID, 1004 as SADTY, SUM(MNFCT.TOT) as DEBT,
'INVENTORY' as ACCR, ITMCTU.NME as SACNM, ITMCTU.IID as SACID, 1004 as SACTY, SUM(MNFCT.TOT) as CRED
from MNFCT
join ITM on ITM.IID=MNFCT.ITM
join ITMCT on ITMCT.IID=ITM.CAT
join MNFPRC on MNFPRC.IID=MNFCT.MNP
join ITM as ITMU on ITMU.IID=MNFPRC.ITM
join ITMCT as ITMCTU on ITMCTU.IID=ITMU.CAT
where MNFCT.RVID is null and MNFPRC.MDENR=1 :WHEAD
group by SRTY, MNFCT.DAT, ACDB, SADNM, SADID, SADTY, ACCR, SACNM, SACID, SACTY