please see above there are a few examples and also what the stock is its basically just booking in part in and out with no costs, suppliers etc..just for our records what comes in and when sent out but muliple parts against 1 ref no in and same as going out
I've managed that bit before it's the actual sending out
So I create a box of mixed screws to send some where
Box of screws has a shipment no
And screws in the box can be
So rma on this part doesn't exist really
Every single screw will have an su number but the box they come in will have an rma number. If I got 2 boxes of screws then there would be 2 rma numbers but every screw needs a su number
Rma 1 box of screws no 1 with 3 screws
Rma 2 box of screws no 2 with 4 screws
Ah right yea I will re do this.
The su number is like a licence plate for the part and we have a roll of stickers for these that we attach to all the parts out of the box and is very important as it seperates the parts so to speak as all the parts in the box could be same part number and not...
It's getting there but when i scan SU out it doesnt populate the part fields etc. ive attached if you could have a look please lol
I have attached database now and also a pdf that maybe explains it better hopefully lol
here is were i am at, the goods in works fine and it is now just when we are sending the parts out as getting duplicate error ?
we need the same as goods in for goods out but when we scan the su number this then pulls data in from the goods inward for part number and serial...ive tried...
I have attached a sample copy of database as trying to get back in to access again and a bit rusty !
Can someone help with this, i am sure its simple but i am missing something and if you could explain lol
So if you look at goods inward this is fine !
The problem is i am trying to...
sorry i maybe should have mentioned but wanted to keep as simple as possible
actually there are no invoices or charges involved and stock simply gets delivered and collected
all stock is owned by another company and we simply store and ship for them.
all these are is for our records only
I will keep this as simple as i can so not to confuse anyone i hope lol
I am trying to create a database to log all stock items coming in and going out to and from carriers or couriers as currently this is all done manually.
When goods come in this can be 1 item or 20 items and they...
I have a query and report that shows invoices with invoice date obviously ?
My accountant wants data from the last 3 months records ?
March,April and May invoices and next time June, July and August
i want the criteria so code will simply show the last from months only and...
We have a list of unique numbers on our database and then someone comes to do audit with what should be the same as ours so looking for a way that when we import their list it looks at ours and shows any queries for missing or extra items ?
The code is the unique number...
I am creating a simple database to keep records of stock movements.
We have parts that come in and out of our warehouse all which will be scanned at time of movement.
I am thing I will need a few tables and relationships for this and this is the main advise that I will be...
I have a form with a field called PartNumber these are entered from a barcode scanner by scanning barcodes on a box.
My problem is this:
When we scan a part number the barcodes actual part numbers are shown like this: PN321-ab55 but the actual part number we use is 321-ab55...