创建定期发票 [英] Create Recurring Invoice

问题描述

我正在寻找使用以下标准创建月度经常性发票的指南。


我们管理租车的车辆公司，因此我们要求每个月发票相同的金额。 （月费基于28天的月份）


发票报告必须显示车辆登记，车辆获得（或解除）的日期和每辆车的管理费，


目前我们有一定数量的车辆要管理但是将来可能会在月中购买新车或者可能在月中卸货，因此付款将按天数计算管理（noofdays *（月费/ 28））


表ACCVehicles - 持有ownerID，Reg，DateAcquired，DateDischarged和管理车辆的数据


我从哪里开始？


一如既往，感谢您的帮助，并提前感谢您。

Hi,

I am looking for guidelines to create a monthly recurring invoice using the following criteria.

We manage vehicles for Rental companies and therefore we require to invoice same amount each month. (monthly fee is based on 28-day month)

Invoice report must show vehicle reg, date vehicle acquired (or discharged) and management fee for each vehicle,

at the moment we have a set number of vehicles to manage but in future, a new vehicle may be acquired mid-month or it may be discharged mid-month and therefore payment will be calculated on the number of days managed (noofdays*(monthly fee/28))

table ACCVehicles - holds ownerID, Reg, DateAcquired, DateDischarged and data of managed vehicles

where do I go from Here?

As always, your help is appreciated and thanking you in advance.

推荐答案

您拥有创建发票表所需的一切。但我认为您可能还需要一张适合您的客户和您管理的汽车的桌子。创建3个表后，您只需链接表。你在数据库中使用MS访问或SQL吗？

You have everything you need to create an invoice table. but I think you might also need a table for your customers and the cars you manage. After creating the 3 tables all you have to do is link the tables. are you using MS access or SQL for ur Database?

这些车辆的费率是多少？每辆车有不同，还是全球性？

您是否存放已经收费的地方，另外还有已支付的费用？


It在进行任何进一步设计之前，首先要对数据结构进行整理，这一点非常重要。设计错误的结构是一种非常缓慢的进展方式，而且非常令人沮丧，因为你必须继续扔掉并重新开始。

What is the rate for these vehicles? Does it vary per vehicle, or is it global?
Do you store anywhere what has already been charged and, separately, what has been paid?

It really is most important that the data structure is sorted out first before any further design is done. Designing to the wrong structure is a very slow way to progress, and quite disheartening, as you have to keep throwing away and starting again.

车辆的费率是全球的。

它基于28天的月份

如果我们持有10天的车辆我们收费（费率/ 28） * 10

如果我们每月保留超过28天，那么exra天是免费的。


一种方法是创建一个发票每个客户的所有车辆的详细信息，并在随后的每个月复制此发票。

如果增加或减少车辆，这可以单独处理。

担心所有车辆可能不会被包括在内，特别是当一个客户拥有100多辆车时。 />

方法是

1.打开发票表格

2.选择客户 - 并显示该客户的所有车辆

3.创建发票 - 所有车辆将被添加到InvoiceDetail并自动计算费率。

Hi,

the rate for vehciles is global.
it is based on 28-day month
if we hold a vehicle for 10-days we charge (Rate/28)*10
if we hold for more then 28 days per month, the exra days are for free.

one method in mind is to create one Invoice with details of all vehicles per client and to copy this invoice every subsequent month.
If a vehicle is added or discharged, this can be dealt individually.
Fear is that all vehicles may not get included especially when one client hold 100+ vehicles.

The method in mind was to
1. Open Invoice Form
2. Select Client - and display all vehicles for this client
3. Create Invoice - All vehciles would be added to InvoiceDetail and charge rate calculated automatically.

这篇关于创建定期发票的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！