If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Purchasing & Booking in Deliveries Design
I am designing a purchasing database & have a problem with delivery charges
where an order is delivered part shipped. The three tables that are concered are tblPurchaseOrder, tblGoodsIn and tblGoodsInInvoice. My tblPurchaseOrder has a field for delivery cost as one purchase order has one delivery cost. I have been told that the company sometimes when raising large orders have staggered delivery and are invoiced for each delivery. My problem is, is that when it comes to matching supplier invoices, where there is more than one delivery for a single purchase order, the delivery charge shows for each delivery when it actually is an overall delivery charge. Can anyone recommend a solution? Thanks in advance |
#2
|
|||
|
|||
Purchasing & Booking in Deliveries Design
You need to handle that with the details of the Purchase Order. May I assume
that you have a PurchaseOrderLines table? If not, you need on, that is related many to one to the tblPurchaseOrder. Then, for the multiple shipments and invoices, you would need a third table that you could call PurchaseOrderLineShipments, related many to one to PurchaseOrderLines. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conrad...essjunkie.html "Will" wrote in message ... I am designing a purchasing database & have a problem with delivery charges where an order is delivered part shipped. The three tables that are concered are tblPurchaseOrder, tblGoodsIn and tblGoodsInInvoice. My tblPurchaseOrder has a field for delivery cost as one purchase order has one delivery cost. I have been told that the company sometimes when raising large orders have staggered delivery and are invoiced for each delivery. My problem is, is that when it comes to matching supplier invoices, where there is more than one delivery for a single purchase order, the delivery charge shows for each delivery when it actually is an overall delivery charge. Can anyone recommend a solution? Thanks in advance |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Document Starts in Design Mode every time I open it | Colin Higbie | General Discussion | 4 | June 14th, 2004 12:24 PM |
Applying a Custom Design Template | Clyde | Powerpoint | 1 | June 7th, 2004 09:47 PM |
Printing a Theme Design | Andrew | General Discussion | 1 | May 28th, 2004 01:00 AM |
opening a document so it is NOT in design mode | Brad Pears | New Users | 1 | May 3rd, 2004 09:13 PM |