Need conceptual help with form for entering Sales Tickets

[mthornblad]

Hi

I am converting a system for an appliance parts store. The sales
people hand write sales tickets and I need a form for entering those
sales tickets at the end of the business day. Some customers pay cash
and some customers just sign the ticket to be billed later.

I made a master/detail (form/subform) for this. Customer info on the
master form and sales detail on the detail form. This would work fine
if all the customers paid cash. But because some customers don't
pay, I need a way to enter the amount paid from the sales ticket.

I would appreciate any advice on how to proceed.

Thanks in advance
Mark Thornblad
Centre, Alabama

 

[SusanV]

Why not simply add a field for the amount paid? If the issue is that users
don't want to enter the amount twice when paid in full, you can add a
checkbox to the form for "Paid in Full" which when checked, fills in the
amount paid with the amount of the invoice.

 

[mthornblad]

Why not simply add a field for the amount paid? If the issue is that users
don't want to enter the amount twice when paid in full, you can add a
checkbox to the form for "Paid in Full" which when checked, fills in the
amount paid with the amount of the invoice.

SusanV

Sounds easy enough but where would I place this field on the form ?
The customer info in entered in the master portion of the form. And
then all of the line items are entered in the detail section of the
form which gives a total amount for the sales ticket. Where would the
payment amount field be placed on this (form/subform) ?

Mark Thornblad

 

[SusanV]

If all the transaction details are in the details subform, then you would
want it to go on the details subform.