invoice item description

[Christopher Glaeser]

Accounting packages like Quickbooks allow the item descriptions to be edited
once place in an invoice. For example, assume the following Invoice:

Invoice 63

ItemID ItemDescription Price
403 Clean Gutters $140.00

Then when this item is placed in the invoice, you can edit the description
to:

403 Clean Gutters and Roof

I'm guessing to support this edit feature, the ItemDescription is *copied*
to a new field and not linked, is that correct?

Best,
Christopher

 

[J. Goddard]

Hi -

I don't know what you mean by "linked" - do you perhaps mean "bound"?

You can initialize the description from a lookup table, using the After
Update event of the ItemID. However, if you are going to be keeping the
invoice data in a table, then ItemDescription will have to be in the
table, because it can be changed. A word of caution, though: If you
keep the ItemID too, then you will have the same itemID referring to
more than one description (a database no-no) - in your example below,
does item 403 mean "Clean Gutters", or "Clean Gutters and Roof"?

But if Item 403 refers to a general class of things, like "Cleaning
Services", then this is OK.

Hope this helps

John