Invoice application question

[mastermind315]

I'm creating an invoice for an Auto Dealer. I want to automatically enter in the sale items section the description of the car to be sold. I know I can create a calculated field with this item description. My question is how to make the first item sale description to be filled with this calculated field.

[Ray in Capetown]

Re: Invoice application question

There are many options available, describe where the correct vehicle is selected from. I dont use field rule for a one item per invoice, that remains linked (but you can) .
I could imagine a dropdown variable field (object) named "vehiclecode" on the form using a record list-edit combo-box to select from table "vehicles" (return the vehicle code)
and then on the "on change" of that object something like this

tbl =table.open("vehicles",FILE_RO_SHARED)
tbl.index_primary_put("code")
fnd=tbl.fetch_find(vehiclecode.value)
varVehDesc=tbl.description
tbl.cose()

Collect whatever info you need from that vehicles table into variable like the example varVehDesc to save it to the form field required.
In this case you have to have created an index named code on the vehicle code field, which for a car dealership would probably be a given.

[Tom Cone Jr]

Re: Invoice application question

Is each invoice limited to a single car? If so, the description belongs in the invoice header. If the invoice can include multiple cars, why wouldn't the descrip be a necessary part of each item record? Color me confused.

[Ray in Capetown]

Re: Invoice application question

Tom, good question
A clue here "the description of the car to be sold." So I guess a motor dealer usually sells one car at a time. In my experience they will either describe the vehicle fully in a header with terms etc and/or in summary on one of the lines in item details. Then other lines will contain additional charge items, extras, plates, guarantee etc. In the latter case standard stock table lookups apply.

[mastermind315]

Re: Invoice application question

Each invoice is limited to one car and the AutoID is part of the invoice header. The rest of the items are accessories that come from another table. This particular invoice required always a car to be sold so I want a particular display format in the first item part, something like this ACURA TSX 2006 VIN: JA123456789012345.

[GGandhi]

Re: Invoice application question

hello

you could have one table with the following
autoid numeric, auto increment
make character
model character
year character
vin character
and fill that that table with, for example
autoid 9 (automatically inserted by alpha)
make acura
model tsx
year 2006
vin JA123456789012345.
and then in the invoice header on the autoid field you could define a lookup that will pull the record from this table and fill in the other fields.
all you have to do is go to the lookup tab and fill in the info, that should do it.(assuming invoice header contains autoid, make,model,year and vin fields)

to make it even easier you can define the make, model as simple lists.

[mastermind315]

Re: Invoice application question

I do have a table of the Car information and that info is displayed correctly in one section of the invoice, what I want is to add in the description part of the items a brief description of this car (is kind of redundant info) but displayed in another section of the invoice. Check the screenshot in the items charged the info I want. This was done (marked with an arrow) manually, I want it to appear automatically as soon the information of the car to be sold is filled.
Screenshot.jpg

[GGandhi]

Re: Invoice application question

hello

you should be able to do this with setting the browse.object.text value of the browse on change event of the autoid as suggested earlier by ray.
collect all the info needed and create the description combining all the info using alltrim as needed

[Tom Cone Jr]

Re: Invoice application question

I think the easiest solution here might be to change the data entry sequence a bit. When the order begins create a new line (Item) record automatically. Every order has a header, with a description, and at least one item with the same description.

[mastermind315]

Re: Invoice application question

Done it... I accomplished it using the browse.object.text event on AutoID primary key change. Thank you all for the suggestions!