Description |
Changes in Department totals
# Add New Field to Category for General Department Item
Field Input: Item ID
Field: Item ID
!pastedImage_d95393_0.png!
# Field: Quantity
## When Total Sales Amount - Sum (Item Movements)
> 0 Then 1,
< 0 then -1
= 0 then do not create a sales invoice line
# Total Department Sales - Total Item Sum(Movement Sales) for the same Category
Field Input: Total Sales Amount - Item Movements
Field: Price
## Should Always be positive, and chagne the quantity to negative.
# Use Item > Loc Sales Default UOM or Stock UOM
Field:UOM
|