Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / GURU Help Needed
Microsoft Dynamics RMS (Archived)

GURU Help Needed

(0) ShareShare
ReportReport
Posted on by Community Member

 Help

I need to make a new item every so often and would like to have it done programmitocally.  I did this using an (INSTEAD OF INSERT) trigger but since we DON'T always need a new item created I disabled it.
The new item is a basically a copy of an existing item with a few changes as outlined below.

Could a button execute this sql code prompting for a parm (Existing ILC).  
The sql does bascially the following:

  1- Need error checking on parm
            . ILC (parm1) exists and has a departmentid of 7 and a quantity > 0

  2. Create NewILC using alot of data from the original ItemLookupCode

             . Description  =  orgILC description plus Fat Quarter
             . ItemLookupCode = parm of orgILC (ILC plus FQ)
             . CategoryID = 22    
             . Item Type = 3
             . Price = orgILC price / 4
             . PriceA = orgILC priceA / 4
             . PriceB = orgILC priceB / 4
             . PriceC = orgILC priceC / 4
             . TaxID = orgILC taxid
             . Cost =  orgILC cost /4
             . Quantity = 0
             . LastUpdated = today's date
             . LastSold = empty
             . LastCounted = blank,  
             . Date Created = today's date

    Other fields in new items are the same as the orginal item
      DepartmentID, CommissionMode, FoodStampable, ItemNotDiscountable, TaxID, BarcodeFormat, ExtendedDescription, SubDescription1, SubDescription2, SubDescription3, QuantityEntryNotAllowed, PriceMustBeEntered, Taxable, WebItem, Consignment, Inactive, DoNotOrder, etc...

Any help would be appreciated.

Danny

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: Re: GURU Help Needed

    Ed

    Excellant idea... 

    Thanks for the great suggestion.

    Danny

  • Community Member Profile Picture
    Community Member on at
    Re: GURU Help Needed

    You could do this a custom html file using the qsbridge functions.  you can use the drilldown.htm in the store operations\html directory as a good starting point. Look for "qsBridge.RequestQSRules();" and 
    " qsRules.OpenRecordSet(sql, true); " parts.    You can then use a form input textbox to enter the itemlookupcode for the item to copy.

    You could then attach this html file to a custom button and set security on the button.  Also the html script for qsbridge can only be executed if invoked from the POS.

     This will would take time to develope and test.

    Hope this helps
    Ed Boyer

  • Community Member Profile Picture
    Community Member on at
    Re: Re: GURU Help Needed

     Any suggestion would be appreciated - since we do alot of these FQ items but no all items have FQ created from them (why trigger was disable),

    The ideal would be able to call a modified stored procedure  from a custom button. Anybody able to help me. I am also open to other ideas.

     Thanks

  • Community Member Profile Picture
    Community Member on at
    Re: GURU Help Needed

    Hi Danny

    What is the business issue you are looking to resolve?

    If you are disabling your trigger, its probably not worth going this route in the first place.  Chances are there's an easier way to handle than with a trigger.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans