Custom Report: Cost and Selling

[Mira]

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.

[lubos]

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

[Mira]

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

[eko]

Y

@Mira

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

You do, just click on the print button at the bottom, see screenshot:

[Mira]

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