Results 1 to 8 of 8

Thread: Pastel Xpress V14 Issue

  1. #1
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Post Pastel Xpress V14 Issue

    Hi all!

    I hope that somebody will be able to assist me.

    I am using Pastel Xpress V14 to Invoice my clients.

    Earlier today a client requested a statement from the beginning of this financial year's till the end September.

    I went to the client's account, entered the dates and then I saw that there was an amount due at 90 days.

    I investigated and noticed that on the 27/07 the payment was made, even with the reference to my cashbook, but there is no amount credited to the statement.

    However, this is a strictly COD Client, and I double checked (even on the bankstatement recons) that the payment has been made.

    Now when I go the Due Invoices, there comes and invoice up with the same amount. I checked the cashbook's history, and the payment for the invoice is there.

    I then printed out a detailed ledger, and everything is 100% there.

    If you need more information please feel free to contact me.

    This is the only account that has that "issue".

    Thank you in advance.

  2. #2
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Sorry if this thread was created in the wrong category. Please move it to the appropriate category should it be necessary.

  3. #3
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,850
    Thanks
    249
    Thanked 371 Times in 327 Posts
    Hi Alandt - when you entered the payment in the cash book did you enter it under G (General Ledger) or did you match it to his invoice under C (Customer)?

    If the first scenario (G) you will need to do a Journal entry under Customer Journals.

    If the second scenario (C) it could be that you have to match the payment via "Match Open Item"
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  4. Thanks given for this post:

    Alandt (05-Oct-16)

  5. #4
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Morning Mike!

    Thank you for the reply.

    The invoice was matched as a Customer, thus C.

    I double checked on the transactions for that month and it was matched to the invoice.

    When I go to match Open Item, the invoice is there and the balance is R 0.00 of the invoice. But when I go and have a look at my unpaid invoices, I see that amount due at 90 Days.

    I really don't know why this is happening.

  6. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Run the customer age analysis, but only for that customer, and tick the box named "Print Transactions".

    Do you see a line item "O/I Difference" at the end of the report?
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

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

  7. #6
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Neville,

    I have done as requested, and yes, there is a line O/I Difference at the end of the report, with the exact amount that is "due".

  8. #7
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    OK, that means that you have some data corruption in the Open Item table.

    Drop me an email and we can arrange a TeamViewer session so that I can fix it with my database editor.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

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

  9. Thanks given for this post:

    Alandt (05-Oct-16)

  10. #8
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank you! Will do as soon as I can.

    Have a wonderful day!

Similar Threads

  1. Pastel Xpress Startup - Issue with no of companies
    By J7J in forum Accounting Forum
    Replies: 3
    Last Post: 13-Jun-19, 02:47 PM
  2. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  3. [Question] Xpress Ver 11 Server Issue
    By WilliamSmit in forum Accounting Forum
    Replies: 2
    Last Post: 12-Feb-16, 02:41 PM
  4. PASTEL PARTNER ISSUE
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 17-Sep-15, 08:54 AM
  5. [Question] issue in pastel database
    By Danyal in forum Accounting Forum
    Replies: 0
    Last Post: 12-Apr-15, 07:55 AM

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
  •