x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 55 subscribers
  • Views 167 views
  • Users 0 members are here
Browse Forums
Announcements
767
topics
17
replies
Financial year end
79
topics
180
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
176
topics
312
replies
Install your software
141
topics
380
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
152
topics
326
replies
Protect and repair your data
45
topics
139
replies
Run your accounts remotely
87
topics
200
replies
Working with the bank
117
topics
297
replies
GeoffA

B/fwd row on customers sale tab

SOLVED
Posted By

We have a couple of anomalies which have previously gone unnoticed.

They affect any customer that has had a refund. For example, customer A had a refund back in November 2015 (8 years ago) the value of the refund was £1122.64. If we look at the sales tab on the customer form, the B/forward row shows a value of £8981.12 in the payments column and the row for November for the current year shows a payment for £1122.64?

It looks like the value is being carried forward for every year since the original payment back in 2015 and still showing up as a payment in the current year? We cannot figure out why this is happening but a similar thing has happened with every customer that has had a refund.

If anyone could shed some light on this we would be very grateful.

These payment are shown as type SP.

Thanks

Geoff

Parents
  • 0
    SUGGESTED

    Hi Geoff,

    Thanks for using Community Hub.

    Generally an SP transaction would be allocated against an SC (Sales Credit) transaction. If the credit exists you can allocate them together at the correct date in 2015 using the Bank > Customer Receipts window. if the credit does not exist, you may need to create it, again at a date in 2015 and then allocate.

    Regards,

    Andy
    Sage UKI

  • 0 in reply to Andy Rickeard

    Thanks Andy, I appreciate your time.

    As far as I can see the refund payments are correctly assigned, this is what it looks like:-

    When you double click on the 8981.12 amount it brings up this window:-

    When you double click on the November 1122.64 line it brings up this window:-

    I'm not sure if this helps explain what is happening or not?

    Thanks

    Geoff

Reply
  • 0 in reply to Andy Rickeard

    Thanks Andy, I appreciate your time.

    As far as I can see the refund payments are correctly assigned, this is what it looks like:-

    When you double click on the 8981.12 amount it brings up this window:-

    When you double click on the November 1122.64 line it brings up this window:-

    I'm not sure if this helps explain what is happening or not?

    Thanks

    Geoff

Children

*Community Hub is the new name for Sage City