GURU Help Needed

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: GURU Help Needed

Ed
Excellant idea...
Thanks for the great suggestion.
Danny
Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.