Skip to content
logo
platformaerp.com

Kalkulacja cen

  • [item].[pricing_calculate] - nieużywane juz raczej , do sprawdzenia

[document].[documentLine_updateLastPrice]

uaktualnienie ostatniej ceny jelsi dokument w konfiguracji altersLastPrice

  • dostawcy [wms].[itemSupplier]
  • ostatnie ceny [item].[pricing]
  • ostatnie lokacje wms.stockbalance

Kolejnosóc podpowiadania cen

  • item.supplier cena od dostawcy dlatego że ostatnia cena dostawcy będzi najbardziej adekwatna
  • item.pricing ostatnia cena
  • wms.item itemlastprice
SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
begin tran

declare @itemID uniqueidentifier = '9D797DBA-7CC6-E511-80C3-9C8E994DC647'

    select itemID, isnull(nullif(nullif(d.currency, ''), 'NULL'), 'PLN') currency, correctedItemPrice
    , isnull(cd.documentDate, d.documentDate) documentDate, isnull(cd.accDate, d.accDate) accDate, isnull(cd.modDate, d.modDate) modDate
    , ROW_NUMBER() OVER(PARTITION BY itemID, isnull(nullif(nullif(d.currency, ''), 'NULL'), 'PLN') ORDER BY isnull(cd.documentDate, d.documentDate) DESC, isnull(cd.accDate, d.accDate) DESC, dl.documentOrdinalNumber DESC, d.documentFullNR DESC) rowno
    from document.documentLine dl
    inner join document.document d on d.documentID = dl.documentID
    inner join document.documentType dt on dt.documentType = d.documentType and dt.masterDocumentCategory = 'warehouse' and dt.altersLastPrice = 1
    left join document.document cd on d.initialCorrectedDocumentId = cd.documentID
    where dl.[status] = 1
    and itemID = @itemID

declare @documentID uniqueidentifier = '0acc443e-cbc8-e511-80c3-9c8e994dc647'
declare @documentOrdinalNumber int = 2
declare @username varchar(50) = 'ULA.POLAK'

declare @sysCorrectedItemPrice decimal(18,2)
declare @correctedItemPrice decimal(18,2)

select @sysCorrectedItemPrice = sysCorrectedItemPrice, @correctedItemPrice = correctedItemPrice
from document.documentLine
where documentID = @documentID and itemID = @itemID and documentOrdinalNumber = @documentOrdinalNumber and [status] = 1

select @sysCorrectedItemPrice '@sysCorrectedItemPrice', @correctedItemPrice '@correctedItemPrice'

exec [document].[documentLine_updateLastPrice]
    -- Add the parameters for the stored procedure here
    @username = @username,
    @documentID = @documentID,
    @itemID = @itemID,
    @sysItemPrice = @sysCorrectedItemPrice,
    @itemPrice  = @correctedItemPrice,
    @sysAdditionalPrice = null

select itemCode, itemLastPrice, * from wms.item where itemID = @itemID
select * from [item].[pricing] where itemID = @itemID

rollback tran