[Carolyn Pitalo]

I would like to produce a Report which includes the following informations, per Sales Invoice:

Invoice Date, Customer Name, Sales Invoice #, Total Merchandise Sale, Shipping Income, Total Income; Corresponding Vendor Invoice #(s), Merchandise COGS, Shipping Expense, Total COGS.

Is it possible to create this report? If yes, can you please tell me how?

Thank you!
This is a cached copy. Click here to see the original post.

[Aminian]

You should be able to get most of what you are looking for by customizing the Customer Profitability report.

[Carolyn Pitalo]

RE: Sales Report with G/L Account Amounts in Columns

Thank you, Mo. I do not know how to set up separate columns for the 2 elements of each transations: 1 for part sale, 1 for shipping revenue.

Can you tell me how to do so?

[Aminian]

You can add the Item to the report and have it grouped by this column. Let me know if this works.

[Carolyn Pitalo]

RE: Sales Report with G/L Account Amounts in Columns

We have way too many items for this approach. Any other ideas?

thank you!

[Aminian]

Unfortunately, I do not have any other ideas without more research.

[Author]

Posts