Thread: Report for Tax filing

We are all working hard to file tax return. Is there something in our ADNSF that makes the reporting easy. Is everyone downloading the orders to Quickbooks to do it?

Sure. You can create a custom report via the admin panel by following these directions in our KB. You'll then need to create a custom query which retrieves the information you need.

e.g.

Code:

INSERT INTO CustomReport (Name, Description, SQLCommand) VALUES ('Test Report', 'Test Description of our report', 'Select o.OrderNumber, c.FirstName, c.LastName, o.OrderTotal, o.OrderTax from Orders O join Customer C on C.customerid=o.customerid')

That should gave you results like:

Code:

OrderNumber FirstName     LastName                OrderTotal            OrderTax
----------- ------------------------------------------------------------------------------------
100137      Admin          AspDotNetStoreFront    53.45                 8.91
100139      Admin          AspDotNetStoreFront    668.23               74.25
100140      Admin          AspDotNetStoreFront    110.79               7.36