Skip to Content
0
Former Member
Mar 10, 2009 at 02:31 PM

Document Series Stored Procedure Check

61 Views

Hi Experts,

I have 4 document series for Purchase Order, Good Reciept PO, AP Invoice as under :

For Purchase Order

Retail 1000-9999

Wholesale 2000-2999

Manufacturing 3000-3999

Trading 4000-4999

For Good Reciept PO

Retail 1000-9999

Wholesale 2000-2999

Manufacturing 3000-3999

Trading 4000-4999

AP Invoice

Retail 1000-9999

Wholesale 2000-2999

Manufacturing 3000-3999

Trading 4000-4999

Now when any marketing document e.g Puchase Order is created in Retail and based on Purchase Order Good reciept Note is created, I want that what document series was selected in the based document it should automatically come in the target document e.g PO in retail and doing GRPO based on PO It should catch retail Document series by default. How this can be achived in SAP Business One.

Can we do it with Stored Procedure. Is so then please let me know how it can be done. or else can it be also done that whatever base document series is selected the target document should also have the same series name otherwise it would give some type of error.

Kindly help in this regard.

Regards,

Kamlesh