 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Need conceptual help with form for entering Sales Tickets
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 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.  Signaturehth, SusanV > Hi > [quoted text clipped - 13 lines] > Mark Thornblad > Centre, Alabama > 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 [quoted text clipped - 25 lines] > > Mark Thornblad > > Centre, Alabama 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 If all the transaction details are in the details subform, then you would want it to go on the details subform. >> Why not simply add a field for the amount paid? If the issue is that >> users [quoted text clipped - 36 lines] > > Mark Thornblad |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.