MYOB 导入“支付金额”
我似乎发现了 MYOB 的异常（我实际上发现了很多异常，这只是另一个正在困扰我的异常......）
我正在生成一个包含来自网络系统的所有发票的文件 - 没有问题。
如果发票有 3 行，并且帐户是通过 COD 支付的，那么我会遇到问题
，例如
"INV", "DATE" ... "AMOUNT", "INC TAX AMOUNT" ... "AMOUNT PAID"
8421, 12/06/2010 ... 60, 66 ... 66
8421, 12/06/2010 ... 120, 132 ... 132
8421, 12/06/2010 ... 96, 105.6 ... 105.6
8421, 12/06/2010 ... 84, 92.4 ... 92.4
当我导入此文件时，发票余额仍然未结，问题是它只导入“已支付金额”的第一行，所以换句话说，基于上述内容：
Invoice 8421 导入 4 行
发票总金额为 $396
支付的金额（导入）为 $66< /p>
未结余额 = 330 美元
当然，第一行预计不会是：
Inc tax Amount = $66
Amount Paid = $396
这对我来说似乎完全不合逻辑。是我做错了什么还是 MYOB 真的很糟糕？
I seem to have found an anomaly with MYOB (I've actually found many anomalies, this is just another one that is doing my head in...)
I am generating a file with all invoices from the web system - no problems.
If an invoice has 3 lines and the account is paid COD, I am having a problem
e.g.
"INV", "DATE" ... "AMOUNT", "INC TAX AMOUNT" ... "AMOUNT PAID"
8421, 12/06/2010 ... 60, 66 ... 66
8421, 12/06/2010 ... 120, 132 ... 132
8421, 12/06/2010 ... 96, 105.6 ... 105.6
8421, 12/06/2010 ... 84, 92.4 ... 92.4
When I import this file, the balance of the invoice is still outstanding and what it appears is the issue is that it is only importing the first line of "amount paid", so in other words, based on the above:
Invoice 8421 is imported with 4 lines
The total invoice amount is $396
The Amount paid (that is imported) is $66
The outstanding balance = $330
Surely the first line isn't expected to be:
Inc tax Amount = $66
Amount Paid = $396
It seems completely illogical to me. Am I doing something wrong or is MYOB just really bad?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不久前做了一次 MYOB 导出，我确实感受到了你的痛苦:)
我遇到了类似的问题，但我记不清到底是什么问题了。但我认为行结尾存在一些问题（检查它是否是 \n、\r、\n\r）。我们还发现了一个问题，当我们进行导出时，客户端会将其作为文本文件打开（使用记事本）并重新保存，不知何故弄乱了导入。
导出时的文本编码也可能发挥一些作用。还要确保所有文本都被正确“引用”。
没有太多帮助，抱歉，已经有一段时间了
I did an MYOB export a while back for a while and I do feel your pain :)
I ran into similar issues but I can't remember exactly the problem. There was some issues with line endings though I think (check whether it's \n, \r, \n\r). We also found an issue where we would do the export, the client would open it as a text file (using notepad) and re-save it and somehow that messed up the import.
Text encoding on the export might play some role too. Also make sure that any text is "Quoted" properly.
Not much help sorry, it's been a while