Point-of Sales - Report Stock Code is Static
SME Accounting package, General Ledger, Debtors, Creditors, Stock
Brought to you by:
philipdc
Menu
▾
▴
#443 Point-of Sales - Report Stock Code is Static
POS TRN_2200\TRN_1990\TRN_1792 the Stock Code does not change only the Stock Description.
Tried this and other alternatives – but could not get it fixed
The Existing (old) Sql:
SELECT Cast(DH.DDate as date) DDate ,
S.SStockCode,
ms.SDescription,
ms.SExtraDescription,
Sum(DL.FQtyShipped ) FQtyShipped ,
sum(DL.FinclusiveAmt) FinclusiveAmt
FROM Account A, DocLine DL, Stock S, DocHead DH , Messages ms
WHERE DH.WTypeID = 10
and WSOURCETYPEID > 1
AND DH.DDate >= :FROMDATE
AND DH.DDATE <= :TODATE
AND A.WAccountID = DH.WAccountID
AND DH.WDocID = DL.WDocID
AND DL.WStockID = S.WStockID
and dl.WDESCRIPTIONID = ms.WMessageID
group by Cast(DH.DDate as date),
S.SStockCode,
ms.SDescription,
ms.SExtraDescription
ORDER BY 1 desc
It's not using ansi joins mayby its wrong - its grouped on description, but it can be that stock has an alternate description.
Must use the stockdescription not the one used in docline
delete messages and put in stock.Sdescription
The Stock Descriptions is correct but the stock code is duplicated as the first stock code - SALESPERCUST.SSTOCKCODE (TrpExpression2)
No further development in TurboCASH4
Fixed in http://sourceforge.net/projects/turbocash/files/TurboCASH5/Development-Beta/TurboCASH-500412-setup.exe/download