Calculate Date on Number Series

alyssas

We want to be able to set up a No. Series to be used in the General Journals. The number should be calculated as the current month plus a number to increment

CM + "-130"

So, for example, if I created a trasaction today, the document number assigned would be

08-130

and tomorrow would be

08-131

Are we allowed to set up calculations in the number series area? Any ideas?

Thanks!
Alyssa

Waldo

May be I have misunderstood your problem, but I think you can solve it using standard numberseries. You just have to fill in more No. Series Lines, namely for each month.

Starting Date  Starting No.  Ending No.
01/08/03       08-001        08-999
01/09/03       09-001        09-999
...

eromein

You can do it by programming. Recalculating a number everytime you need it.

I think you should use Waldo's solution. Just enter 12 number series, and you can work for a year!

alyssas

Great - thanks! Worked perfectly!