Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

CIS Deduction showing on remittances report.

Report design issues and solutions.
Post Reply
iStevie
User
User
Posts: 19
Joined: 17 Jun 2011, 07:51
Sage Version: v2013 19 UK/Europe/Africa

CIS Deduction showing on remittances report.

Post by iStevie » 03 May 2016, 12:49

Hi,

I have made a remittance report however when I make a payment of an invoice which has been subject to a CIS deduction, the remittance report shows me what we have paid on what invoice, but doesn't show any details about any CIS deductions.

I am looking to either add a note/message line to show under each transaction where a CIS deduction has been made to quote the verification ref and deduction amount; or add a column for CIS Deduction taken.

Is this possible? If so which Joins would I need to create/add to be able to add a field which shows this information to my remittance report?

Appreciate any help,
Kind regards,
Steve.

p.s. Sage v22 with report designer v1.4.2015.05.
- Sage 50 Accounts Professional 2016 Subscription
- Sage 50 Payroll
- Sage 50 HR 2010
- Sage 50 Forecasting 2007
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4629
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: CIS Deduction showing on remittances report.

Post by brucedenney » 03 May 2016, 13:30

Are you using the CIS module?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
iStevie
User
User
Posts: 19
Joined: 17 Jun 2011, 07:51
Sage Version: v2013 19 UK/Europe/Africa

Re: CIS Deduction showing on remittances report.

Post by iStevie » 10 May 2016, 08:07

Hi, apologies for the delay - Yes I am using the CIS module.

Regards,
Steve.
- Sage 50 Accounts Professional 2016 Subscription
- Sage 50 Payroll
- Sage 50 HR 2010
- Sage 50 Forecasting 2007
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4629
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: CIS Deduction showing on remittances report.

Post by brucedenney » 10 May 2016, 08:35

I am pretty sure the remittance does not carry that information, you would need to do "a statement" to have that information.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Post Reply

Return to “Sage 50 Report Designer”

Who is online

Users browsing this forum: No registered users and 10 guests