I'm creating a database where I have a customers and invoices table, obviously there is a relationship between the two tables using a customerID field where I have referential integrity enabled. However not all invoices require a customer account as some are cash sales where no customer details are required.
I'm unsure of the correct procedure, all I can think of is to create a separate table for cash sales??
Am creating a Product-Sales Database, and I would like the corresponding Sales made in the Sale Table to be automatically deducted or to be reflected in the Product Table. The product table contains all my stock and has a relationship with the Sales Table. The Sale Table does not necessarily include the Stock. How can I create possibly a Sales Form that will be used as an entry point for all the products (stock) sold and automatically register the sold products in the Sales Table and at the same time make the required adjustments in the Products Table.
I am considering creating a form to use as a cash register or simple POS system. Where I could start looking into this? are there any templates or sample code I could refer to? Using access 2003 version...
I have a combo box which looks up a set of values from a table, some of these I have got to store, others I merely want to work with and calculate from. These columns are:
Now for most of these, I 'think' I have it planned where they will go or how they will be used, but the OTRate is flummoxing me a wee bit.
On the form, I have an OT(time) field - the idea being that the user will enter the hours and minutes of overtime they have done (short time format - is this correct?)
Then, I would like the form to calculate the cash value (has to be stored in a field) by multiplying the hours/mins worked by the OT Rate - - but I don't want to store the OTRate unless I really have no other option. Once the calculation has been done, if the Rate is then 'forgotten' then that is no issue, as the only time it would be needed is if the field is revisited to amend any errors (so I am thinking the calculation should be done as an After Update event on the OT(time) field?)
I am building a database in Microsoft Access and my client has the followed USB Cash Drawers and they want to open the Cash Drawer through a command button in Microsoft Access,how to open the cash drawer through VBA command. Here are the 03 Cashdrawers links they are using.
M-S Cash Drawer - CF405 USB Connect. URL...
Epson T20 Thermal Receipt Printer - Epson ReadyPrint T20 Receipt Printer USB. URL... and NuRolPOS NURCDM116 Standard Duty Cash Drawer with 5 Coin/5 Bill Till. URL...
does anyone know how to get a serial cash drawer with kick back interface to open through Access? any help or a point in the right direction will be hugely appreciated
We have an Access database that opened some cash drawers attached to the computer through USB and it is working perfectly. We have some of the cash drawers that are attached to the EPSON Receipt printer and we also want to open those Cash Drawers attached to the receipt printer. Looking for code to open the cash drawer attached to the receipt printer, Is there any command available that I could send to the receipt printer and it would open the Cash Drawer.
I have also taken the screenshot of the utility program that will show the information regarding the printer and I am very expecting to get this working soon as we have build the Microsoft Access database that would checking the cash drawer status and also open the USB cash drawers.
Thank you for your time. I want to set up an automated recurring monthly invoice for clients in my database.
I know this is possible but I am having trouble finding the solution and in fact having problems how to search for a solution.
On the 1st of every month I would like to have a query run that inserts a new row into my invoice table for all current clients invoicing them for that month.
Please please help. Invoicing one at a time using a form is taking far too long each month.
I have a table called vendors in that table is Company Name, address, city, state and zip. I also created a form called vendors same information. On the form i have a combo box called bill to party which selects the name that will print on the invoice.
Ex Company Name ABC Address What Ever City State Zip Phone
Billed to party (here is the combo box on the form)
However when i select the bill to party on the form from the combo box it is only showing the name of the billed party on the invoice and not the address city and state.
I dont want to create extra text boxes on the form so when i chose the bill to name on the form will fill in the text boxes I dont want to do this. All i want is to select the bill to party from the drop down menu and when i view the invoice it will automatically show up on the invoice.
I have a report that produces invoices and gets its data from a multi-table based query. The query has multiple lines for each customer and the report groups and totals them. How can I have the invoices numbered sequentially? Any help please?
What Im trying to do is make invoices that I have in to data base... reason for it is to keep a close watch on the price fluctuation since the stuff we get are from different country. We don't really need it but this is my own little project just for myself...I have all the tables made and form ready but I have couple of problems.
1. How do I calculate and save it in the table? I Know this violates 3rd normalization but I need to do this since the price will change almost every week. basic calculation which is total price / quantity.
2. How do I get the previous record on the form automatically? lets say that the date I put in is July,4,2005. How do I get this to show up in form for the new data input? and keep that date until it is updated using form.
3. Since I'll be getting same stuff lots of times, and since they all have item number, How do I get it to auto fill? lets say that I input a item number and rest of the form automatically fills in the rest of the values...and updates are saved to the table and next time I input the same item number updated data will automatically fill in the rest.
Thanks in advance. This is my first post so, please go easy on me...:) I also search the forum but couldn't find anything that I understood... Is this a project too advanced for newbies? As I have stated earlier, I have everything layout but I'm just trying to make it easier inputing new data. and all the codes that are here, I'm lead to believe they are Visual Basic. and good book for newbies on VB?
I'm sort of new to Access, but over the past few months I've been able to develop an inventory database for my work which turned out quite nicely and does everything I need it to, except for one thing.
I want to also create invoices for my customers, and after looking at examples I understand that most people link the "order" with the invoice, so that there is one invoice per order. However, I need the ability to combine many orders into one invoice. That's where I'm stuck.
I don't know how to arrange my relationships and forms so that I can "pick" the orders I want on my invoice, and not at the time of the Order, but at some point after. Basically my orders will be established, but their allocation to invoices won't, until I come along and put them into their rightful bill.
Does anyone have any thoughts on this? I'm pretty stumped.
I have a table with every invoice I have raised to my customers on it (160,000 records so far). Every record identifies the customer and the date of the invoice. I would like a query that returns details of the last 4 invoices raised to each customer based on the date of the invoice. So, if I have 100 customers I would expect 400 records returned. I have spent ages searching and reading the forums re this and have seen several post that I "think" are similar, but I think I'm too daft to understand the solutions put forward. I "think" this involves a module to count but as I have never written a module in my life am a bit confused. Any pointers would be greatly appreciated.
I have a pretty simple database that we use to track customers, orders, invoices, and payments. I have an order form that shows all of the order details, and has a subform with services, qty, price, etc. Sometimes we need different products that are part of the same order to appear on two different invoices (say an order is for part 100 and part 101. If part 101 ships first it needs to be invoiced, and part 100 will be on a separate invoice when it ships later), so one order can have multiple invoices.
I'd like to create a solution where when a user clicks the invoice button on the order form, they are able to select which lines from the subform should be invoiced on that particular invoice.
I have a table which has sentdate invoices and paiddat invoices. i want to be able to get a monthly count for the amount of invoices sent and paid to compare on a graph. e.g jan 2011 = 5 feb 2011 = 6 ect
I am importing data from a supplier. The table has many invoices included and varying items on each invoice. I need to find a way to separate each invoice with all the included items. For example:
We have a billing scheme in which we partial-bill ceratain customers based on certain events: 30% when they sign the contract, 30% a number of days later, 30% when we ship the goods and the last 10% upon installation. This is a common process, known in many indistries as 'progress billing.'
What I am trying to do is compare the collection performance on the invoices based upon which trigger sent them. For example, I'd like to find the average and standard deviation (plus some percentiles) of the time it takes to collect invoices that are sent... when we ship, let's say.
I have a table that shows order number, invoice number, invoice date, amount and payment date. So, I can have the order number show up to 4 times with a chronology of invoice dates.
My question is this: How do I group for analysis all the FIRST invoices, the SECOND ones, etc...?
Thanks for any help! I can do this in excel... but I was given this extract of 100000+ lines, and hope to do it all in Access. Thanks again.
I create 30 invoices a month. each client gets billed the same amount each month (for example Customer A gets billed $100 every month, Customer B gets charged $200 each month). Only two things get changed on the invoice-'Description' (for example the description would be 'services rendered for July 2014' for July invoice) and 'Invoice Date'.
Now please see the image attached, I have an append query that combines information and creates invoices for all 30 clients.
The problem is, the 'Invoice No' field in the invoice table stays empty, because I do not know how to start numbering at a specific point (for example invoice numbering should start at 14150001) and I want it to add the number (+1) automatically when this append query adds data to the invoice table.
I need to create buyer and seller invoices within my access 2003 databases, my sister in law runs an antiques auction house and I'm working on a database to capture all their information.
I've created a 2 queries (a buyer invoice and seller invoice), show all unsettled items with the relevant item information and fee's.
However, I would like it to automatically allocate an invoice number, and store the information back to a table (seller and buyer ID, total number of items on the invoice, total fee etc)
I'd like store the invoices as well, so within the customer record form, I can include a box showing a list of the buyer invoices on one side and seller invoices in another (not all customers are buyers and sellers).
Once I've issued an invoice, can I automate it to show that item as then as invoiced?
Can the invoices be editable at all?
When they come in and settle their account, I also need to feed this information back in as well.
Can i arrange an invoice for seller's particularly, to show all sold items, and the fee's associated with them
Returned items as well as any associated fee's with them?
I have been looking at the Northwind example.
I see how they have an orders details table and orders table, I could replicate this.
I could have an Buyers Invoice table and Buyers Invoice Details table, but how do I generate an invoice, pull the next Invoice number from my (currently blank) invoice table, and pull in the outstanding items for that buyer for that specific auction date (I have a query), and then populate back information from the invoice?
I like the fact that their order form is editable, do any changes go back to the query, that then populate the invoice when you click print invoice?
I need to be able to (at the end of the auction) pull all items from my item log, for that buyer, and print them an invoice, automatically saving all the invoice details back into my database.
I need be able to automatically flag the items in my items table, as invoiced and pull the invoice number in?
I can see how all the Northwind tables, queries, and forms relate to each other and subforms, but I'm not sure how to actually create an invoice, get invoice number, merge with my query, and then feedback in.
As you all know, in the Northwind sample database there are the Invoices and Invoices Filter query. The Invoices Filter query adds a criteria to select only items that belong to the current order. OrderID is integer.
However, if I change OrderID to Replication ID, it stops working.
Any idea how to make it work? Currently I work around this problem in my DB by adding a criteria to filter by Date and Customer ID, but IMO this is less than ideal.
I have a subform in columns that has a list of invoices bound together by the site number on the form there is a Expense code that runs 51 to 95.
On another tab I want to add all the invoices for a expense code together and display the total amount
Below is an example of invoices
IDSite CodeInvoice DatePOInvoiceContractorInvoice AmountExpense Code 10289S20/09/2013 346603410Dj Commercial Cleaning Ltd 25.2362A 20289S28/09/2013 346061141Platinum Landscapes 240.0055A 30289S03/09/2013 353112021Clean And Green 167.0063A 40289S02/08/2013 353112015Clean And Green 174.0063A 50289S19/08/2013 111115271Southern Electric 189.5679A 60289S19/08/2013 346061121Platinum Landscapes 240.0055A 70289S02/06/2013 353112009Clean And Green 160.0063A 80289S02/05/2013 353112003Clean And Green 181.0063A
I need to send a large number of reports (actually 1 page invoices) as faxes. A few years ago I used to use a version of WinFax Pro with command line parameters to accomplish this. I would actually print each invoice to the WinFax Printer with a command line that contained the fax number for that client and using this method I was able to send each invoice to a different fax number (customer).WinFax is no longer available.