基本的Mysql和PHP会计应用程序
我不是程序员，但我的任务是为一家小型企业制作一个基本的会计应用程序。
我正在查看 pbook，但我不确定这是否足以满足我的需求。
我需要能够计算每天销售了多少食品、多少饮料、有多少客人，然后如果是客人购买，则将食品和饮料的订单与客人联系起来。
pbooks 的可定制性足以做到这一点吗？使用现场演示，您似乎无法仅针对日期或某些客户生成报告......，也许有更好的簿记解决方案？
否则，我认为我有足够的 mysql 知识来做到这一点，并且 php 代码应该主要是正确地获取查询。
正确的？
此外，有人可以推荐这样一个系统的现场演示吗？
我无法找到任何现场演示，可以演示如何生成给定时间段的报告，或显示客人的总销售额等。
我需要证明这一点，以表明为什么它是一个比不断扩大的 Excel 工作簿混乱得多的解决方案......
I am not a programmer, but I have been tasked with making a basic accounting app for a small business.
I was looking at pbooks, but I am not sure this is customizable enough for my needs.
I need to be able to count each day how many food items are sold, how many drink items, how many guests, and then tie orders of food and drinks to guests if it is a guest that purchases it.
Is pbooks customizable enough to do this? Using the live demo you do not seem to be able to generate reports just for dates, or for certain customers..., perhaps there is a better bookkeeping solution?
Otherwise, I think I have enough mysql knowhow to do this, and theh php code should mostly just be getting the queries right.
Right?
Additionally, can anyone recommend a live demonstration of such a system?
I have not been able to find any live demos where I can demonstrate how you can generate reports for a given time period, or show the total sales for a guest or such.
I need to demonstrate this to show why it is a much better solution that an ever expanding mess of an excel workbook....
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
认真雇用一名程序员
。成本会更低，而且会更快、更正确地完成。我同意任何东西都比 Excel 电子表格更好，但初学者对会计应用程序的演绎不是其中之一。
错误
PHP 代码将比简单的“正确获取查询”复杂得多。
如果您无法自行安装免费、开源、社区支持软件，那么您不应该承担这项工作。
再次强调，我的建议是要么聘请一位确切知道自己在做什么的程序员，要么就您感兴趣的项目寻求社区的支持。这不是一个讨论论坛。
Hire a programmer
Seriously. It will cost less and be done faster and correctly. I would agree that just about anything is better then an Excel spreadsheet but a beginners rendition of an accounting application is not one of them.
Wrong
The PHP code will be much more complex then simply "getting the queries right."
If you can't install free, open source, community backed software on your own then you should not be tasked with this job.
Again, my suggestion would be to either hire a programmer who knows exactly what they are doing or seek support from the community for which projects you are interested in. This is not a discussion forum.
如果您需要使用该套餐进行 IRS 申报，那么 phpBMS 或 Freeagent 或 Freshbooks 等在线服务是不错的选择，因为他们随时了解最新的税务规则
There's phpBMS or online service like Freeagent or Freshbooks which are good options if you need to use the package for IRS returns, because they're kept up to date with the latest tax rules
http://www.nolapro.com/
尝试一下它是免费的基于网络的会计软件。
http://www.nolapro.com/
Try it it's free web-based accounting software.
http://bambooinvoice.org/
我已经看到这种方法在较小范围的会计中取得了相当程度的成功（保持记录、通过电子邮件发送发票、生成 pdf）。它是在 CodeIgniter 下构建的，因此如果您熟悉该框架的 MVC 方法，它也是可以合理扩展的。
http://bambooinvoice.org/
I've seen this employed with reasonable degrees of success for smaller scope accounting (keeping records, emailing invoices, generating pdfs). It's built under CodeIgniter so if you're familiar with that framework's approach to MVC it is also reasonably extendable.
您需要的是 POS 系统，而不是会计系统
You need a POS system, not an accounting system
我刚刚遇到 Akaunting - 截至 2020 年不断更新。我还没有测试过它。
还遇到了 简单会计系统，但从查看 sourceforge 上的文件来看，它看起来有点简单且杂乱。还没有实际尝试过。自 2015 年初以来也没有更新。
I just came across Akaunting - being continually updated as of 2020. I haven't tested it yet.
Also ran into Simple Accounting System but looks sort of simple and disorganized from looking the files on sourceforge. Haven't actually tried it. Also hasn't had updates since early 2015.