Forum Discussion
KenCasser
7 years agoQrew Cadet
LOL. Mine is a Pickett. It's in my drawer with a bunch of other old stuff.
Our app is for generating technical pricing quotations for windows and doors. We frequently revise our quotes as sizes change, etc, and we also copy old quotes to use as the basis for new quotes. But we want to retain the old quotes without altering them. So, we want to copy a parent and its children, and then change the date to new Date() and change the Quote # from 18042501 to 18042501A (revision) or 18051701 (copy), and then return to the revised or copied quote to make the rest of the edits. So, at the moment, I have one button that goes to a JS page and does a copyMasterDetailButtonHandler to copy the current quote and its line items, and another button (above) that takes the copy and changes its date. I'm now trying to get it to redirect to the edit screen for the copy, and then I'll figure out how to update the Quote #. After that, I want to see if I can combine the two buttons into one. I got into JS because our Quote #s rearrange new Date(), and add 01, 02, etc to the end and then reset back to 01 the next day. I got all that to work for generating new quotes from scratch, but I also need to get it to work for revisions and copies and I couldn't get it to work in straight QB.
Our app is for generating technical pricing quotations for windows and doors. We frequently revise our quotes as sizes change, etc, and we also copy old quotes to use as the basis for new quotes. But we want to retain the old quotes without altering them. So, we want to copy a parent and its children, and then change the date to new Date() and change the Quote # from 18042501 to 18042501A (revision) or 18051701 (copy), and then return to the revised or copied quote to make the rest of the edits. So, at the moment, I have one button that goes to a JS page and does a copyMasterDetailButtonHandler to copy the current quote and its line items, and another button (above) that takes the copy and changes its date. I'm now trying to get it to redirect to the edit screen for the copy, and then I'll figure out how to update the Quote #. After that, I want to see if I can combine the two buttons into one. I got into JS because our Quote #s rearrange new Date(), and add 01, 02, etc to the end and then reset back to 01 the next day. I got all that to work for generating new quotes from scratch, but I also need to get it to work for revisions and copies and I couldn't get it to work in straight QB.