多个订单发票？

本文介绍了多个订单发票？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我需要一种方法来每月从多个订单创建发票？

在tbl_order表中，我有一个订单列表来自客户。

tbl_order表 OrderID（PK） ShopID（FK） CustomerID（FK） Statu 总计 OrderDate

让我们说，我想创建一个发票，期限为：从$ code> tbl_order.ShopID = 2

发票应该有发票号和发票日期，在发票中会有多个OrderID。

我需要创建发票表，如果是这样的表设计应该是什么？

解决方案

您将需要2张表。

发票表。

InvoiceID（PK） InvoiceDate InvoicePrice InvoiceBtw ect。

订单和发票之间的链接表。 所以你可以跟踪在哪个发票处理哪个订单。

InvoiceID（FK to tbl_invoices.InvoiceID） OrderID（FK to tbl_orders.OrderID）

I need a way to create an invoice from multiple orders every month?

In the tbl_order table, I have a list of orders from the customer.

tbl_order table OrderID (PK) ShopID (FK) CustomerID (FK) Statu Total OrderDate

Let say I want to create an invoice for period: 1 to 31 May from tbl_order.ShopID = 2

(From there, I can an invoice report to a Shop/Company of Commission they owe me, etc. When I do recieved commission from them - I need a way to update invoice status)

The invoice should have Invoice Number and Invoice Date, in the invoice there will be multiple OrderID.

Do I need to create an invoice table, if so what the table design should be?

解决方案

You would need 2 tables.

The invoice table.

InvoiceID (PK) InvoiceDate InvoicePrice InvoiceBtw ect. etc.

An link table between orders and invoices. So you can keep track which order is processed in which invoice.

InvoiceID (FK to tbl_invoices.InvoiceID) OrderID (FK to tbl_orders.OrderID)