Help in Setting and amending a report

SOLVED

Hi
please could anybody help me set up this report?

Covid has played havoc with my brain and I need simple instructions. Step by step kind.

I am using Sage 50 Cloud Accounts uk.

I’m wanting to set up a new report with the following information shown on the print out.

Go to Suppliers 

Reports

Supplier Invoice Summary.

the data I wish to be shown once I print it is

Tran No -Item -Type -Date -A/c Ref -Inv Ref -Details -Extra ref- Net Amount -Tax amount- Gross amount.

Thank you in advance.

K81

Parents
  • +1
    verified answer

    Hi,

    Go to Suppliers > Reports > Daybooks > Daybooks Supplier Invoices (Detailed)

    That will show you that info but you'll need to add on ex ref > AUDIT_SPLIT.EXTRA_REF
    Ian

  • 0 in reply to Ian C

    Thanks for replying, I have tried this but still cannot add the ex ref. I think my sage toolbar isn’t showing all and I cannot get the drop down by clicking on the report? 

  • 0 in reply to K81

    Hi,

    Are you saying that you can't find Edit to get you in Report Designer? or a problem with Report Designer?

    Ian

  • 0 in reply to Ian C

    Hi, I have found Edit but it then the option disappears. 
    it’s not allowing me to amend the report.

    I have tried creating a new one but again no luck or save as. 

    I have seen I the criteria that options to create this report are not clear.

    trans no, item, type, date, ac ref, invoice ref, extra ref, details net amount, tax amount, gross amount.

    My report header Day books Supplier Invices

    with the usual date from date to supplier etc. 
    wondering if it’s the numeric message that appears? 

    or I’m selecting the wrong criteria options?

    or could it be my remote working at home.

    thanks for your help.

    K81

Reply
  • 0 in reply to Ian C

    Hi, I have found Edit but it then the option disappears. 
    it’s not allowing me to amend the report.

    I have tried creating a new one but again no luck or save as. 

    I have seen I the criteria that options to create this report are not clear.

    trans no, item, type, date, ac ref, invoice ref, extra ref, details net amount, tax amount, gross amount.

    My report header Day books Supplier Invices

    with the usual date from date to supplier etc. 
    wondering if it’s the numeric message that appears? 

    or I’m selecting the wrong criteria options?

    or could it be my remote working at home.

    thanks for your help.

    K81

Children