Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    6

    Unanswered: Decrement Formula

    Hi,

    Let say item A got on hand qty as on today so now i want to decrement the qty starting from last month to each month until on hand qty reach to zero. Once balance value reach to Jan 2014 must forward to Dec 2013 and if reaches to Jan 2013 forward to 2012 Dec...

    How to accomplish this task.
    please help.

    Item-Year-12-11-10-9-8-7-6-5-4-3-2-1
    A 2014
    2013
    2012

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I'm sorry, but I don't understand your question.

    Can you try and explain with example numbers, please?
    If you have a picture to illustrate, that would help too!
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2015
    Location
    UK
    Posts
    1
    I think you need to create a SQL Query for that..
    If you elaborate your point, so that we can provide you the exact solution.

  4. #4
    Join Date
    Aug 2011
    Posts
    6

    Decrement Formula

    Click image for larger version. 

Name:	Stock Aging.jpg 
Views:	4 
Size:	35.3 KB 
ID:	16115

    Please refer to the attachment for your kind perusal.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •