Announcement

Collapse
No announcement yet.

calculation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • calculation



    Dear Sir, I need a formula or VB to update counted quantity to be updated from split value of count
    example, duplicate material 69992383 number has two lines with Total Stocks 199 and 200 I need to update on 199 to be 100 on counted quantity and 200 to 83 on counted quantity, the line must not more than total stock.

    below table result is on counted quantity.
    Material Plant Batch Counted quantity Total Stock Quant QOH Count
    69992383 mb 100 199 1770606 202 183
    69992383 mb 83 200 1912215 202 183
    92383755 mb 9 10 1867224 296 138
    92383755 mb 129 289 1857498 296 138
    85529234 mb 0000036356 28 40 1879841 72 60
    85529234 mb 0000036005 6 8 1902546 72 60
    85529234 mb 0000005430 6 8 1793281 72 60
    85529234 mb 0000007588 20 24 1793282 72 60
Working...
X