Results 1 to 5 of 5

Thread: Pastel Partner Statement is Wrong

  1. #1
    New Member
    Join Date
    Mar 2014
    Location
    kempton park
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Partner Statement is Wrong

    I am using Pastel Partner V14 recently I was allocating open items.The problem is when I finished allocating I discovered they on a fully matched invoice they now appear another amount big than the invoice value.I have unallocated all the invoice and I am still left with a debit amount which I don't know where it come from.I have checked the customer ledger and this amount does not appear anywhere it only appear in my statement.

    Please help me how do I solve this problem

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,461
    Thanks
    35
    Thanked 401 Times in 348 Posts
    It sounds as though you might have some corruption in the Open Item table.

    If you run the customer age analysis, only for this customer account, and tick the box "Print Transactions", and then look at the last row of the report, do you see a line item with the description "I/O Difference"?

    If you do, then you have Open Item corruption.

    Normally, when you process a transaction to an account that is set up for Open Item processing, the transaction updates the Ledger Transactions data table, as well as the Open Item data table. The two data tables are supposed to be in sync. However, sometimes you get corruption due to power fluctuations or an unstable computer/network, and some of the entries in the Open Item data table get deleted, duplicated or changed in odd ways.

    I can fix the corruption with my database editor if you have TeamViewer.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    New Member
    Join Date
    Mar 2014
    Location
    kempton park
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes this customer do have an I/O difference.I do have Team Viewer.

  4. #4
    New Member
    Join Date
    Jan 2016
    Location
    Centurion
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi, Sorry to add to this thread after so many years. I have been searching if there is perhaps an answer to my problem.
    I have client's statements who are incorrect. Fortunately I remembered for a fact that a certain client paid their previous month's invoice, and could immediately pick it up.
    It reflects the client's payment on the debit side of the statement instead of the credit side, and thus doesn't deduct it. But if I look on the customer detailed ledger, the correct outstanding balance reflects.
    Please see pics...
    Click image for larger version. 

Name:	HPG001.JPG 
Views:	17 
Size:	64.2 KB 
ID:	6991Click image for larger version. 

Name:	HPG001CL.jpg 
Views:	11 
Size:	33.0 KB 
ID:	6992

  5. #5
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,461
    Thanks
    35
    Thanked 401 Times in 348 Posts
    That is an indication of Open Item data corruption.

    I can fix that for you via TeamViewer, using my datafix software.

    Please send me an email or PM if you would like to arrange a remote consultation.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

Similar Threads

  1. [Question] Pastel Statement
    By Dientjie in forum Accounting Forum
    Replies: 3
    Last Post: 24-Jun-15, 11:25 AM
  2. [Question] Pastel Partner - Deleting a Batch posted in the wrong period
    By Zaid Ismail in forum Accounting Forum
    Replies: 1
    Last Post: 21-May-15, 04:11 PM
  3. Statement on Pastel Xpress
    By bamani in forum Accounting Forum
    Replies: 0
    Last Post: 24-Feb-14, 02:22 PM
  4. Error on Pastel statement
    By iluska in forum Accounting Forum
    Replies: 0
    Last Post: 11-Jul-12, 03:11 PM
  5. [Question] Pastel Partner Statement print running total
    By Suziem in forum Accounting Forum
    Replies: 6
    Last Post: 19-Apr-12, 10:29 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
  •