x Want to participate? Join the group to interact
  • Replies 10 replies
  • Subscribers 16 subscribers
  • Views 3049 views
  • Users 0 members are here
Browse Forums
Announcements
238
topics
27
replies
General Discussion
1k
topics
3k
replies
Intelligence Reporting
311
topics
787
replies
Sean Bouw

How would you be able to Tell if you Need a Data Fix

Posted By

Please Remember the below is a Guideline to assist you with your House-Keeping.

Although this is not an exact Science however you can use it as a Guideline so that you could react Swiftly and not break anything in the Process.

So, if your answer is yes to the below then you should consider doing a Data Integrity (Further Below) and Possibly send your info for a DataFix:

  • Is your Trial Balance out of Balance 
  • When you look at your Customer Age Analysis, Statement and Detailed Ledger does the amounts not all talk the same "Language" (amounts differ)
  • When you look at your Supplier Age Analysis, Remittance Advice and Detailed Ledger does the amounts not all talk the same "Language" (amounts differ)
  • When you doing a Stock Take and you run a Inventory Valuation by Code and by Group and the amounts are different
  • Do you have a "Ghost" Customer Account, Supplier Account, Inventory Code?
  • Are you Missing a General Ledger Code?
  • If you Run the Below Data Integrity Report Do you see a lot of Words and Numbers telling you that you have issues?

To Run a Data Integrity Report Do the following:

  • Make A BACKUP
  • Go to File…Data Integrity
  • Select Next
  • Select "Verify the Data Only"
  • Select Process

If Unsure, you will need a Pastel Specialist to assist you.

Otherwise if the above is not applicable to you Make you a cuppa Coffee, Take off you Shoes and #WorkHard.

  • Hi Sean,

    This is a great share especially with year end round the corner.

    Sage appreciates our Business Partners collaboration.

    Thanks

    Joanne

  • How do I fix the open item difference on the customer age analysis ?

  • in reply to Ismail

    you will need to get a datafix done.Let me know if you need me to do it for you. [email protected] 

  • Datafix

    Many people do not quite understand the significance of "Open Item out of Balance" In reality it means there are transactions missing - either in the Open Item file (Statement)  or in the Customer detailed ledger file.

    Example:  if the Open Item file contains a reference to a payment  made to a supplier - the chances are that you DID pay..  If the detailed ledger misses transactions - you customers may not be seeing outstanding invoices...

    It is critical.  Please use a reputable service provider to fix your data.  Some service providers will take the short cut (cheaper) and just delete the offending portion of a transaction.  A reputable provider will dig deeper and check your bank statement to verify if payments or deposits have been made...

  • in reply to WellingtonWC

    The Sage City Mayor is correct in saying "Please use a reputable service provider to fix your data"
    All you need to confirm is that the Consultant that is helping you has Passed their Module 1,2,3,4 and 5.

    If this is True then this Consultant should be skilled enough to handle your Data Fix.

  • in reply to Joanne Barnard

    Joanne,

    is there a support group for datafix on Sage City, please.  (I am properly qualified)

  • in reply to WellingtonWC

    Hi Wellington, 

    No there is no support group for datafixing. 

    Kind Regards

    Joanne

  • in reply to Ismail

    Good Morning, Start by printing the Customer Detailed Ledger and the Customer Statement.  Then cross-tick the two.  You will find records that are missing from on or the other report.  Circle them.

    If there are payments missing  - please check your actual bank account to verify the amount paid.  Very often the Statement might LOOK "wrong" but it is due to open item allocation errors.  

    I find the best is to go an un-allocate all the records for a specific Deposit/Payment reference and then to re-allocate carefully.  

    IF there are journals or invoices missing - print the original source document.

    Once you have precise idea of the details of every erroneous item, contact a datafix professional.  Hopefully you find one that is prepared to work overnight to fix your data so that you don't have to stop live operations

    You are welcome to contact me

  • in reply to Ismail

    Good Morning, 

    As Sean has advised you would need to get a datafix done. This can be done by a reputable dealer or you can contact Sage Support to book your data in for a datafix.

    Kind Regards

    Joanne

*Community Hub is the new name for Sage City