Results 1 to 7 of 7

Thread: Fixing cust. age analysis - long standing dupe invoice (eur)

  1. #1
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question Fixing cust. age analysis - long standing dupe invoice (eur)

    Hi, we have a few long standing issues on our age analysis I'd like to iron out once and for all. One them is for a customer called OUT005. Many years ago (and I mean many years ago) we created duplicate invoice. We just never fixed it. So now the time has come.

    I'm scared to simply pass a credit note on 01/03/2019 for €2,099.82 for several reasons:
    • The exchange rate was different
    • The invoice I need to link a CN to doesn't exist (see detailed ledger)
    • Won't this CN somehow throw out all my reporting numbers?


    Question:
    Can anyone please advise me what is the best/cleanest way to clear out this value for my customer?

    Click image for larger version. 

Name:	1.jpg 
Views:	140 
Size:	60.5 KB 
ID:	7663
    Last edited by michellepace; 14-Sep-19 at 02:22 PM.

  2. #2
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    HI Michelle

    Great question. I love that you are taking on the challenge to finally clear something like this.

    Do you know when the erroneous invoice was raised? The PSQL database keeps 5 years of data (current and 4 prior years) in the transactional data file. It keeps an even longer history in the History lines and history header database. So my suggestion is to make a copy of your database and do the follow test in the copy.

    Pass a credit note on 01/03/2019 linked to the original invoice with the exact same lines and exchange rate as originally booked. Then check the result and see whether you like the end result. If you are not yet happy do a few more tests in the same way until you find a solution that you are happy with. Then do that in the live database.

    Happy to give you some more guidance over the phone if this is unclear.

    If you battle to see the original invoice we can help you with our MyBI software to see it.

    Hope this helps.

    Kindest regards,
    Alec
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  3. #3
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question

    Hi Alec, thanks for your reply.

    Quote Originally Posted by Alec Candiotes View Post
    Do you know when the erroneous invoice was raised? The PSQL database keeps 5 years of data (current and 4 prior years) in the transactional data file. It keeps an even longer history in the History lines and history header database.
    I'm afraid not. I don't have that history. I queried the pastel database and all I have in the History tables is one line of data as shown below. Presumably, because I ran the Change > Delete History / Clear Files option at the beginning of this FY for anything older than 2 years. Simply put, the invoice no longer exists.

    Click image for larger version. 

Name:	screenshot.jpg 
Views:	138 
Size:	28.4 KB 
ID:	7666

  4. #4
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts


    I'm getting too complicated??
    Am I not making a big deal out of nothing here? if I pass a CN on the balance brought forward as shown below. And I use today's exchange rate... then as i see it OUT005 will get zero'ed out and my SALES for the year will be decreased by 2,099.82 x (16.26) = R34,143.07... and so really... where's the problem? Am I just getting too complicated?

    Click image for larger version. 

Name:	CN.jpg 
Views:	115 
Size:	47.9 KB 
ID:	7674

    Thanks eveyone for your help and patience with me on this forum.

  5. #5
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Ok I see. Yes in that case I would not over think it to much.

    But may I suggest you consider putting it through with a EURO 2,009.82 at a 0.00001 exchange rate. In this way you only only credit the foreign exchange rate but have almost no South African Rand impact. As I understand this is merely a forex error, not a Rand error. However if this is also a Rand overstatement then I would use the same exchange rate used when the duplicate invoice was captured if you can at all recall it (perhaps use something like Oanda.com to look at historical exchange rates.

    Let me know what you think.

    Kindest regards,
    Alec
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  6. #6
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by Alec Candiotes View Post
    Ok I see. Yes, in that case, I would not over think it to much. But may I suggest you consider putting it through with a EURO 2,009.82 at a 0.00001 exchange rate. In this way you only only credit the foreign exchange rate but have almost no South African Rand impact. As I understand this is merely a forex error, not a Rand error.
    Brilliant! Yes, perfect I think I'm going to do just that. Thank you

  7. #7
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Fantastic! It is my pleasure.
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

Similar Threads

  1. [Question] COID Letter of good standing
    By Bexter12 in forum Labour Relations and Legislation Forum
    Replies: 4
    Last Post: 18-Sep-20, 10:21 AM
  2. [Question] COID Letter of good standing
    By Bexter12 in forum Labour Relations and Legislation Forum
    Replies: 4
    Last Post: 16-Apr-19, 07:59 AM
  3. Help fixing my pool..
    By Pap_sak in forum General Chat Forum
    Replies: 9
    Last Post: 11-Mar-15, 10:30 AM
  4. [Question] Landlord not fixing water leak
    By mother in forum General Regulatory Compliance Forum
    Replies: 5
    Last Post: 03-Oct-11, 09:47 AM
  5. [Question] Standing Settlement Instructions (SSI)
    By leuce in forum Business Finance Forum
    Replies: 0
    Last Post: 18-Oct-10, 04:35 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •