Untitled Document
Microsoft Dynamics RMS Experts
  Register   Login
 Search
RMS Experts
 
  You are Here: Dynamics RMS Community ... Dynamics RMS and POS Forums
 
RMS and POS Forums
Subject: Auto Populate CustomDate field

You are not authorized to post a reply.   
Author Messages
olie04
Posts:33

05/06/2010 12:28 PM Alert 
We use the CustomDate1 field for our rewards customers for expiration of their rewards card. Is there anyway possible to auto-populate that field so that the clerks don't have to worry about typing in the date for a new customer? I tried setting the fields' DEFAULT value to getdate(), but the date still shows 12/30/1899, and it doesn't add the current date. What I would love to do is do a dateadd('yyyy', '1', getdate()) but I am just trying to get the getdate() function working for the default value. Any insight on this would be greatly appreciated! TIA!
morzo23@yahoo.com
Posts:1

05/25/2010 6:17 AM Alert 
Hi Olie04, there are two ways you can do this (if I have understand exactly what you want to achive): first, by SQL, creating a stored procedure, that will update the field, when something exactly happends with the Customer, playing with the Customer.[ID] field as a variable or, create a small add-on, a dll or a .exe file that will update that field, again based on Customer.[ID] field...

Hope this helps and gives you more ideas...

Regards, A.
olie04
Posts:33

05/25/2010 8:17 AM Alert 
Posted By morzo23@yahoo.com on 05/25/2010 6:17 AM
Hi Olie04, there are two ways you can do this (if I have understand exactly what you want to achive): first, by SQL, creating a stored procedure, that will update the field, when something exactly happends with the Customer, playing with the Customer.[ID] field as a variable or, create a small add-on, a dll or a .exe file that will update that field, again based on Customer.[ID] field...

Hope this helps and gives you more ideas...

Regards, A.


Thanks for the reply! I will most definitely look at the stored procedure option, maybe using a trigger?

I am on the road to learning C# right now, so making .dll & .exe files will soon be available to me, however, I do not know the first thing to when it comes to programming for RMS. I am not a developer, but would definitely love to know how to get the resources on it, etc.

I do mostly PHP/MYSQL programming, and I am very fluent at that, but trying to join the Microsoft brigade, I am just lost. C++, C#, Netframe works, etc.

I downloaded Visual Studio 2010 for C#, and I know how to make buttons, and text objects, but I havent the slightest clue on how to incorporate that into RMS.

olie04
Posts:33

05/25/2010 9:48 AM Alert 
Posted By morzo23@yahoo.com on 05/25/2010 6:17 AM
Hi Olie04, there are two ways you can do this (if I have understand exactly what you want to achive): first, by SQL, creating a stored procedure, that will update the field, when something exactly happends with the Customer, playing with the Customer.[ID] field as a variable or, create a small add-on, a dll or a .exe file that will update that field, again based on Customer.[ID] field...

Hope this helps and gives you more ideas...

Regards, A.


Just a small update. I figured out how to use a trigger, and like magic whenever a new customer is inserted, it automatically adds 1 year and sets the price level.

Thank you for pointing this out! It works great!
You are not authorized to post a reply.
Forums > Microsoft RMS and POS > General RMS and POS Discussion > Auto Populate CustomDate field



ActiveForums 3.6
Sponsor
Get RMS Training today!
(c) 2006-2012 Retail Hero ®