Hi Karen,
kdellaripa: I've gone to the Tables/Fields section for the InvoiceLineItem and clicked on Edit fields, but it won't let me edit that field.
Once a field is created there is no way to edit it, you're only allowed to delete it.
kdellaripa: What can I do to change that field to show as a whole number?
You'll need to:
- Make a copy of the QuickBooks_Invoice screen and edit the grid for InvoiceLineItems.
- On step 2 you'll see a list of all the columns for this grid, click the actions link on the Quantity column.
- Under the event dropdown you'll want to select Lose Focus.
- You'll want to add 2 actions here:
- Basic Math Calculation and the value you'll want is Value From Screen: InvoiceLineItems:Quantity. Add 0 to this and make sure you pick the rounding options that suit your needs.
- Enter Value Into Field On Screen and you'll want to update the field: InvoiceLineItems:Quantity with the action result from the step above this.
- Click Save & Close. Click Finish.
These actions will round the quantity field on the InvoiceLineItems grid everytime the field loses focus. There is no way to limit the data entry into this field since it's a decimal in the database so we're just changing the value after the user enters it. You may want to put a note somewhere on this page telling customers the quantity field will only accept whole numbers and will round up any decimal places.
Please let me know if you have any questions on this.
~C