Custom Report: Cost and Selling

Hello, i need help please creating a report that has the item name, qty sold, total cost of the item and total selling price of the item, but the problem is:

  1. My items are in “noninventory items” and i filled both the:
    Autofill — Sales — Unit price
    Autofill — Purchases — Unit price
    Assuming these are the actual cost and selling of these items.

However when i try to create a custom report, i can find an option to have the columns of the costs and a column for the selling price, pleaae check screenshot below.

Don’t use custom reports.

Use Advanced Queries on Sales Invoices - Lines screen to get such a report.

See: https://www.manager.io/guides?sales-invoice-lines

2 Likes

hello, but this way im not able to get them as a pdf format (report style)

Y

You do, just click on the print button at the bottom, see screenshot:
Screenshot 2024-04-22 at 11.08.16

omg thank you SO MUCH! that was reallyyyy helpful! didnt know i can have all these options!!!

A as new user it’s recommended to start by reading the Guides (current and new ones in progress) and searching the forum. You can also create a test business and apply the steps you read in the guides to make yourself even more familiar with the program. And don’t forget to read the Forum’s FAQ/Rules.