Block Previous year entries

[Former Member]

Dear Experts

My client using SBO2007 Pl 08.

Previous Financial year they were using Numbering series like 1 to 1000, now this fiscal year they are using same numbering series but different period indicators.

The Problem is (Example) They created one sales order Number 344 same number had been used in previous year. If they navigate previous sales orders it shown Doc No 343 and old year doc no 343 continuously.

So How can i block previous year documents.

That is very serious issue. So please guide me.

regards

[Former Member]

thanks

[former_member187989]

hi asupathy,

When u navigate/(click orange arrow) thru browse buttons in

sales order for example,it will point to first record previous fiscal year,then first

record of current fiscal year,Educate this point to users first when u define same numbering series

for all fiscal years.

When u define period indicators in numbering series,it will show current series only,select

current series and enter document number to find sales order.

To avoid this problem define numbering series starting with year 2009 + add number 0000,0001etc.

ie., 20090000,20090001,20090002,etc., in this way easily track record

Jeyakanthan

[a_a]

Hi Raja,

All documents will show in the Sales Order window in serial order of document number.

If you want users to see only the documents pertaining to this fiscal year irrespective of the numbering, then you might want to give them a user-query like this:

Select *

FROM ORDR T0

WHERE T0.[[DocDate]] BETWEEN u2018[[%0]]u2019 AND u2018[[%1]]u2019

Hope this helps,

Ajay Audich

[Former Member]

Hi Raja,

I believe we can't block previous year document and reuse its document number. Why don't you create a series for each fiscal year?

Eg.

Fiscal year 2008: series: 08, numbering: 1 - 1000

Fiscal year 2009: series: 09, numbering: 1 - 1000

You can set this up in the Administration > Setup > Document Numbering

Hope it helps.

Warmest Regards,

Chinho

[Former Member]

Hi thanks for all

I will try and come back to you

regards

[Former Member]

Thanks yours suggestions i solved my problem temporarily with chins ho lims path way.

regards