x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 92 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
roisin brady

Trade Creditors

SUGGESTED
Posted By

Hi there, 

Hoping someone can assist. As we close our ledgers each period we always aim to save down the aged creditors report at the same time to have a report that clearly shows the breakdown of the trade creditors amount that is included in our balance sheet. Sometimes however due to human error this report may not be saved down. As our AP team continues to post invoices with a Feb date the balance on aged creditors at end of Feb keeps moving, but the trade creditors nominal in the GL stays the same - as all further transactions are processed in period 3. This can be problematic and takes time to recreate the creditors ledger at the point of close at end of Feb. Is there a way to pull down the aged creditors report which just includes any transactions posted up to the end of that period - so ignores invoices with a date of Feb which have fallen into period 3 in the GL?

Thanks

Parents
  • 0
    SUGGESTED

    Afternoon Roisin,

    Thank you for raising a query to us via the Sage 200 Community hub.

    As the Aged Creditors Report is ran based on Transaction date, then aged based on the settings within your supplier defaults, there is no way to produce a period based aged creditors, therefore there is no way to ignores invoices with a date of Feb which have fallen into period 3 in your case, I would suggest raising an idea to the 'Sage 200 UKI Ideas Portal' to see if it’s a change we can implement into future versions of the program.

    With regards to your Aged Creditors not be ran and saved down, there has been an idea raised on our Sage 200 Ideas hub, to see if we can implement a 'Schedule Reporting' option within the program which would automatically run this report at a set/date and time, I would suggest clicking the link below and popping a vote on the idea, another to thing to note, you can also prepare a Retrospective Aged Creditors report. This provides you with the additional flexibility of analysing your purchase debt across any ledger period that is earlier than the current period set on the Nominal Ledger. Invoices paid after the specific ageing date are shown as not paid and payments allocated after the specific ageing date are shown as not allocated in the report, this can be achieved by ticking the 'Retrospective' option on the criteria window when running the report.

    Schedule Reporting

    sage200uki.ideas.aha.io/.../S200UK-I-1326

    Regards

    Dale Norris

    Technical Support Consultant, Sage 200

    Office +44 (0)191 4795955

Reply
  • 0
    SUGGESTED

    Afternoon Roisin,

    Thank you for raising a query to us via the Sage 200 Community hub.

    As the Aged Creditors Report is ran based on Transaction date, then aged based on the settings within your supplier defaults, there is no way to produce a period based aged creditors, therefore there is no way to ignores invoices with a date of Feb which have fallen into period 3 in your case, I would suggest raising an idea to the 'Sage 200 UKI Ideas Portal' to see if it’s a change we can implement into future versions of the program.

    With regards to your Aged Creditors not be ran and saved down, there has been an idea raised on our Sage 200 Ideas hub, to see if we can implement a 'Schedule Reporting' option within the program which would automatically run this report at a set/date and time, I would suggest clicking the link below and popping a vote on the idea, another to thing to note, you can also prepare a Retrospective Aged Creditors report. This provides you with the additional flexibility of analysing your purchase debt across any ledger period that is earlier than the current period set on the Nominal Ledger. Invoices paid after the specific ageing date are shown as not paid and payments allocated after the specific ageing date are shown as not allocated in the report, this can be achieved by ticking the 'Retrospective' option on the criteria window when running the report.

    Schedule Reporting

    sage200uki.ideas.aha.io/.../S200UK-I-1326

    Regards

    Dale Norris

    Technical Support Consultant, Sage 200

    Office +44 (0)191 4795955

Children
No Data

*Community Hub is the new name for Sage City