Results 1 to 8 of 8

Thread: Pastel Xpress V14 Issue

  1. #1
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    12
    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
    12
    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
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,057
    Thanks
    201
    Thanked 295 Times in 254 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"
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  4. Thanks given for this post:

    Alandt (05-Oct-16)

  5. #4
    Junior Member
    Join Date
    Oct 2016
    Location
    South Africa
    Posts
    12
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,282
    Thanks
    32
    Thanked 374 Times in 324 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "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
    12
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,282
    Thanks
    32
    Thanked 374 Times in 324 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "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
    12
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank you! Will do as soon as I can.

    Have a wonderful day!

Similar Threads

  1. [Question] Xpress Ver 11 Server Issue
    By WilliamSmit in forum Accounting Forum
    Replies: 2
    Last Post: 12-Feb-16, 02:41 PM
  2. PASTEL PARTNER ISSUE
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 17-Sep-15, 08:54 AM
  3. [Question] issue in pastel database
    By Danyal in forum Accounting Forum
    Replies: 0
    Last Post: 12-Apr-15, 07:55 AM
  4. Pastel Xpress Startup - Issue with no of companies
    By J7J in forum Accounting Forum
    Replies: 2
    Last Post: 03-May-12, 09:46 PM
  5. Replies: 2
    Last Post: 14-Apr-11, 11:22 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
  •