Custom report - Orders include cost of goods.

Kapil Kapur · ‎August 18, 2021

Hello,

I am a UK based freelance data analyst who has been tasked with making some bespoke reports. I am using the desktop version of Premier Accountant Edition 2021.

The first report that I have to make needs the following headings:-

1. Order Date (*)

2. Customer (*)

3. Orders Booked (Value) (*)

4. Inv Amount

5. Customer Req Date ( I have due date)

6. Promised Date

7. Ship Date (*)

8. Cost

9. Margin

10. % Margin

11. S.O (not sure what this refers to)

12. Customer Purchase Order number. (*).

In the above list the (*) means that I have managed to include the above field in my report. My question is how do I get the remaining fields ? Thank you.

kind regards

Kaps

I have created a custom report that I have memorised that includes

EmmaM · ‎August 18, 2021

Hello Kapi, Thanks for reaching out to the Community! Looking at this in terms of one report with all 12 headings that wouldn't be possible within desktop, most reports are geared towards specific data. You could run a transaction list by customer report and use the customise report and you will get a lot of the ones you mentioned but not the margins.

You could also look at the stock, purchases, and customer reports., it would be the case of combining multiple reports(loading them in different tabs) into excel using vlookups to combine them.

View solution in original post

EmmaM · ‎August 18, 2021

Hello Kapi, Thanks for reaching out to the Community! Looking at this in terms of one report with all 12 headings that wouldn't be possible within desktop, most reports are geared towards specific data. You could run a transaction list by customer report and use the customise report and you will get a lot of the ones you mentioned but not the margins.

You could also look at the stock, purchases, and customer reports., it would be the case of combining multiple reports(loading them in different tabs) into excel using vlookups to combine them.

Topics

Training

Community

Resources

Custom report - Orders include cost of goods.

Custom report - Orders include cost of goods.

Custom report - Orders include cost of goods.

Need to get in touch?