Pb has the following four data window:
Anticipating t_wpb
Lb (category), Bh (number), Mc (name), Yssl quantity (original) and ysje amount (original)

Storage table t_rkb
Djh (documents), Bh (number), Rkrq (inbound date), Mc (name), Rksl (inbound number), Dj (unit price), Rkje (storage amount)

Outbound table t_ckb
Ckrq (outbound date), bh (number), Mc (name), Cksl (delivery), Dj (unit price), Ckje amount (outbound)

The inventory table t_kcb
Lb (category), Bh (number), Mc (name), Yssl quantity (original) and Rkzs (library) in the total number of Ckzs (outbound) in the total number of Xkc inventory (now), Kcje (inventory amount)

The inventory table: warehousing=a certain commodity warehousing and value, the total number of outbound=outbound and the value of a commodity, now inventory=total number of original + warehousing, outbound
Inventory amount for the same reason

How to implement inventory DW display correct data?
Pb novice don't understand, say the detailed point bai

CodePudding user response:

This belongs to the problem of data... The proposal also write corresponding associated SQL

CodePudding user response:

To realize the two decimal Numbers in PB

CodePudding user response:

CodePudding user response:

The above problem add to you: you should have a balance sheet, otherwise you will not come out,
(of course, the above four tables are also from strong, just can't balance)

You can use the three options:
A, zhongjian view in the database (i.e., use the database to realize)

Two, each table to create a DW, and displayed in the window at the same time, with a program to do addition and subtraction, recycled into the final result,

Three, each item corresponding numerical (such as warehousing, outbound) in sum, reoccupy item number connection, make it a big dw, again, according to also go,

CodePudding user response:

Agree with the fourth floor,
Also can be dealt with on the basis of the fourth floor: 1, building view: will each item corresponding numerical (such as warehousing, outbound) in sum, reoccupy item number connection,
2, on the basis of the view to build dw