View Issue Details

IDProjectCategoryView StatusLast Update
0005468OXID eShop (all versions)2.6. Administer orderspublic2017-06-28 10:52
Reporterwiedeking Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Product Version4.7.6 / 5.0.6 
Summary0005468: Generation of DTAUS File is faulty when Order w/ Total 0€
DescriptionWhen there is an order with a total sum of 0€ and you generate the DTAUS File for all the orders, the DTAUS File will be corrupted.
It is not allowed to have orders within the DTAUS File with Total Sum =0.

and it also makes no sense to add these orders to your file, since you do not want to transfer it to the bank anyway.

To have orders with 0€ is possible e.g. if you have vouchers etc.

Solution:
in the file: \oxid\application\controllers\admin\order_overview.php
in Line: 164
add "and oxtotalordersum > 0 " to the select statement.

=>
        $sSelect = "select * from oxorder where oxpaymenttype = 'oxiddebitnote' and oxtotalordersum > 0 ";
Steps To Reproduce1. Create an order and give it a 100% discount
2. in the admin console go to: Bestellungen verwalten => Bestellungen => übersicht => DTAUS Export erzeugen
3. Test the DTAUS File e.g. with http://www.xpecto.de/content/dtauschecker

TagsNo tags attached.
ThemeNot defined
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Activities

QA

2017-06-28 10:52

administrator   ~0012161

DTAUS export removed
In former OXID eShop versions in admin panel => order administration there used to be a button for downloading a DTAUS file for marked orders. This function was removed as the DTA/DTAUS format will no longer be accepted by the banks (was formerly used for domestic money transfer inside Germany, outdated by SEPA). For SEPA compliant exports we suggest to use a module instead. The following parts of the code were removed:

folder /core/phpdtaus/
aplication/models/oxdtausbuilder.php
related code from application/controllers/admin/order_overview.php

Source: https://oxidforge.org/en/oxid-eshop-version-4-9-0-ce-pe-5-2-0-ee.html