Some Customer Card Balances Showing Incorrect Credits + Incorrect Average Days To Pay Data

Question

I was reading this post&nbsp;https://community.myob.com/t5/AccountRight-Sales-and-purchases/Customer-Card-showing-a-credit/td-p/6...&nbsp;as we have a similair problem.&nbsp;I have now come accross at least 2 cutomer cards that are showing Credits, but there is no logical reason for this and no real actual credits for these customers.&nbsp;What is involved having our company file rebalanced and how long would we be without it?&nbsp;We also have a similiar thing with AVERAGE DAYS TO PAY data. For some Customer cards the data is totally incorrect showing things like 20,000 days? Is that a similiar issue?&nbsp;Any help would be great.&nbsp;Thanks, Nathan&nbsp;

steven_m · Accepted Answer

Hi&nbsp;nduro&nbsp;
&nbsp;
I understand that our team has reviewed and arranged for those card balances to be recalculated within your company file.&nbsp;
&nbsp;
If you do have any further enquiries don't hesitate to post on this Forum again.

steven_m · Answer

Hi&nbsp;nduro&nbsp;
&nbsp;
The process for getting that company file sent in for that card rebalance would be you would look at taking a backup at your end and then uploading that file through to us for our team to review. While we have that company file, you can continue to work on the file and our repair team will be in contact to arrange for a current file to come in if required.
&nbsp;
If you feel that you do need the&nbsp; file needs to come in for that re-balance getting screenshots of the following information would be required:

The&nbsp;Returns and Credits window for the customer - Sales&gt;&gt;Sales Register&gt;&gt;Returns and Credits
The&nbsp;Aged Receivables - Outstanding invoice analysis&nbsp;window - Card File&gt;&gt;Cards Lists&gt;&gt;Choose the customer's card&gt;&gt;Arrow next to the list Balance
The&nbsp;Reconciliation [Detial] report&nbsp;for that customer run for the date of 31/12/9998- Reports&gt;&gt;Sales&gt;&gt;Ageing&gt;&gt;Reconciliation [Detial]

You also mentioned the average days to pay showing unusually odd numbers. This is something that we are aware of occurring and have passed onto the required team. It is commonly caused by recording a $0.00 invoice and then updating the values on that invoice after the fact. This particular situation occurs irrespective of the card balance issues you are experiencing.
&nbsp;

nduro · Answer

Hi Steven,&nbsp;Thanks for this information. I would like to try this process and see if we can get the file fixed and cleaned up.&nbsp;That is good if we can keep working with file, will you investigate it from the backup file. We use the file 5 days a week so will need to be able to keep working.&nbsp;I can provide the screenshots etc.&nbsp;Please advise what the next steps will be and who to send it to etc?&nbsp;Thanks,&nbsp;Nathan

steven_m · Answer

Hi&nbsp;nduro&nbsp;
&nbsp;
The requested screenshots can be added to a Forum post using the Choose File (bottom of the post reply field) or through the use of the Photos option when composing the message.
&nbsp;
Alternatively, if you would prefer to send that information privately, it can be sent through as a private message to myself. Note: If you are using the private message system you would only be able to use the Photos/images option to upload those screenshots.

nduro · Answer

Hi&nbsp;Steven_M&nbsp;Thanks for this. I will prepare the images and send them via private message.&nbsp;Can you please just explain a bit more for me how the rebalance process works, so we can keep working on our current file, while the MYOB team work on the copy upload to rebalance it.&nbsp;Whats happens with the time different and data changes in between when we send a copy of the file and keep using our master local file?&nbsp;Are they eventually merged or something at end?&nbsp;Just worried about data lose and timeing of the process.&nbsp;Thanks&nbsp;Nathan

steven_m · Answer

Hi&nbsp;nduro&nbsp;
&nbsp;
The data file repair process for AccountRight 20xx files is:

The user would take a backup of the file
Upload that backup to our Dropzone/secure FTP accountThey can continue to work on the file, if able to do so.
Our team will assess the file and work on a repair on that file
Once a repair has been found, they do send that file back to you to look at the repaired file to ensure you are happy and the fix has worked
If you have used that file while we have completed that work, our team can work with you to arrange for the current file to come in for that same fix and then return that file back to you.

The above process has been structured to try to minimise the downtime for the user. As such, the company file comes in for an initial fix. If its been worked on during that time at the user's end we arrange for an updated copy of the file to be sent in for the same repair.

Forum Discussion

Some Customer Card Balances Showing Incorrect Credits + Incorrect Average Days To Pay Data

10 Replies

Related content

Incorrect Billing

Finalized BAS Report - Incorrect

incorrect pay entry

incorrect overtime payment

Incorrect Super payment

Payroll YTD figures are incorrect.

Incorrect amounts

backup date incorrect