When I produce an invoice the line items each have it's own price .I have customers that at times would buy more than one item and we would just add the item to the next line of his invoice and post a message "sold with previous item" and charge him 0.00. I would like to activate this with a button that allows you to automatically add the message above if this item is added on to the invoice. Is this possible?

It depends. If you just want a button to type in some text, it's easy to do. If you need to detect that some specific conditions exist for the button to work, it must be possible for a calculation to make this determination.

-bd

Hi Dobbers,

[color:"blue"] > When I produce an invoice the line items each have it's own price.

Okay, this part sounds right.

[color:"blue"] > I have customers that at times would buy more than one item

However, not quite sure I'm getting the picture here, do you mean several items all different or multiples of the same item?

[color:"blue"] > and we would just add the item to the next line of his invoice and post a

> message "sold with previous item" and charge him 0.00. I would like to

> activate this with a button that allows you to automatically add the message

> above if this item is added on to the invoice. Is this possible?

I don't think you need a button, I think you need to change the invoice design to allow quantities of the same item.

Lee

I think a script using the Set Field step will do this for you.

Within Set Field you can use a Case expression to make sure that the text is correct for the items that are entered into other fields already.

Then you can attach your script to a button on the layout.

Lee, what I mean when I buy more than one item is we inventory bicycles as individual items, but when we sell them we may include more than one bicycle with the purchase

ie..

Bicycle item no.123;

Bicycle item no. 124,

Bicycle item no. 125.

If the customer bought item no. 123, we may include item. 124 and 125 with the same invoice but submit a message stating that item no. 124 is sold with item no. 123 and on the next line of the invoice state that item no. 125 is sold with item no. 123. I need to have a button available to show the message "sold with item ()" if items 124 and 125 are to be sold with item 123. Is this possible?

Hi Dobbers,

If I'm reading this right, and I'm not positive that I am, do to the others trying to help you with your button idea (I won't go into that, I'll let them do it all). But, instead I'm going to continue with the Invoice modification idea that I have, in order to accomplish what I think you are trying to do.

If this is not what you want, and in fact the other's ideas are, then please just say so instead of answering the questions below.

Questions:

Are the second two bicycles free to you, or did you have to pay for them?

If they have a cost, are you just including their sales price in the price of 123, or are you discounting them part of all of their cost do to a group purchase?

I understand the need to adjust your inventory, but I really think you would be better served by having there sale price reflected in the invoice instead of a message and than show there price as a discount, in a discount field. This is a cleaner way to do it, doesn't require a button, and it also shows the buyer that they have received some value (the other two bikes that cost XXX.xx) because of a group, or whatever.

Good Luck

Lee