OraFAQ Forum: Forms » Automatic Stock Level Notifications.

Home » Developer & Programmer » Forms » Automatic Stock Level Notifications.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Automatic Stock Level Notifications. [message #116445]

Wed, 20 April 2005 02:58

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Problem

Tbl_Items
Col_Item_Balance
Col_Item_ReOrderPoint
(Only Concern Columns Mentioned)

I want that when ever “Col_Item_Balance” become less then “Col_Item_ReOrderPoint” the system will show the notification by any mean to inform user.

Wishes
Jawad

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116449 is a reply to message #116445]

Wed, 20 April 2005 03:09

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In the when-validate-item trigger associated with the 'number of items purchased' fetch the information from the database, do the maths, and, if necessary, issue a message (but don't do a raise form_trigger_failure).

You will update the 'Col_Item_Balance' in another trigger.

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116650 is a reply to message #116445]

Thu, 21 April 2005 02:52

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Thanks Dj Martin

On another forum “David Aldridge” advise to make report on condition where (Col_Item_Balance < Col_Item_ReOrderPoint). This is most easy / simple and most record providing one.

But in the mean time my wishes proceeds.

I think ok I will develop above report but in addition I want that when ever (Col_Item_Balance < Col_Item_ReOrderPoint) a print come out of the printer.

Like (Item ABC reached below 55 packs).

Now will you please advise me how to take a print when even (Col_Item_Balance < Col_Item_ReOrderPoint).

Wishes
Jawad

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116656 is a reply to message #116445]

Thu, 21 April 2005 03:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Why not send an email from a database trigger? Printing reports 'sux'. Look at utl_smtp.

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116660 is a reply to message #116656]

Thu, 21 April 2005 03:44

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Yes sending email is great functionality of any system but such efficiency is not my requirement at them moment.

In my system circumstances a (Col_Item_Balance < Col_Item_ReOrderPoint) report to see at any time + a printed page for reminder is dreamed solution to maintain stock record.

So can you help me?

Wishes
Jawad

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116661 is a reply to message #116445]

Thu, 21 April 2005 03:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay ... tell me the version of forms and reports that you are using, whether it is C/S or n-tier, versions of front end system, middle level system, and backend system.

Different solutions to different configurations.

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116669 is a reply to message #116445]

Thu, 21 April 2005 05:42

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Thanks

Forms 6i Version 6.0.8.8.0
Report 6i Version 6.0.8.8.3

C/S

Oracle SQL*Plus Version 8.1.5.0.0

Moreover
All Systems :-
Windows 2000 professional (Service Pack 4)

Wishes
Jawad

Report message to a moderator

Re: Automatic Stock Level Notifications. [message #116756 is a reply to message #116445]

Thu, 21 April 2005 19:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Form Builder Reference'. Download it and search for 'run_report'.

There are numerous examples on how to launch your report.

David

Report message to a moderator

Previous Topic:	COMMIT FORM
Next Topic:	insertiing record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:56:00 CDT 2024