Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Pastel Partner - matching open items - only some accessible

  1. #1
    New Member
    Join Date
    Nov 2016
    Location
    Northamptonshire, UK
    Posts
    4
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Question Pastel Partner - matching open items - only some accessible

    Hi there,

    I'm hoping someone can help my with Partner v14. For a long time now customer and supplier payments have not been matched to invoices within Partner.

    I am trying to go back through history and match as many off as I can (to aid identifying bad debt etc)

    However, one strange issue: The matching option only lets me search througha a handful of customers/trade debtors with which I can match receipts and invoices.
    Not all of them are available to be matched off?

    NONE of my suppliers populate the list to be matched off.


    My aged debtor analysis quite frankly looks ridiculous, and I was hoping this was the key to begin tidying it up - but i can only process a dozen customers (out of several dozen) and no suppliers?

    Anyone know why this may be?


    (I've also noticed that the window that pops up when you process a customer receipt, to allocate the remittance to o/s items, is onlly 'popping' up for these few customers, for the other customers this option doesn't happen)

    Kind regards,
    David

  2. #2
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,850
    Thanks
    249
    Thanked 371 Times in 327 Posts
    Hi David. It might sound obvious, but is the default AND the individual processing style for each/all of your customers and suppliers set to "Match open item". If they have been set to "Balance Forward" you will need to change them ... which is quite a big job ... so I believe.
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  3. Thanks given for this post:

    Blue Skies Accountant (01-Dec-16)

  4. #3
    New Member
    Join Date
    Nov 2016
    Location
    Northamptonshire, UK
    Posts
    4
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Mike C View Post
    It might sound obvious...
    Thank you Mike C.

    No it doesn't sound obvious at all, I have no experience of Partner (coming from the UK I am only really aware of Sage Line 50 and SAP etc).

    I am currently in Ghana where our site is using it for their accounts (and no-one here knows more than a basic understanding of its functionality) - thank you for your suggestion!

    So I have found that (as you say) the customers I can see are indeed 'open item' processing - and the ones I can't see are 'balance forward'.

    But the option to change them from one to the other is greyed out and not selectable

    Is it possible to make the change - You said above that it i big job? Do I need admin permissions? Or can it not be changed once it has been initially set?

    Many thanks,
    David

  5. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi David,

    You can change supplier/customer accounts from Balance Forward to Open Item processing, by going to Change...Open Item/Balance Forward Conversions.

    I suggest that you read my post here on the implications of converting.
    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)

  6. Thanks given for this post:

    Blue Skies Accountant (01-Dec-16)

  7. #5
    New Member
    Join Date
    Nov 2016
    Location
    Northamptonshire, UK
    Posts
    4
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    I suggest that you read my post here on the implications of converting.
    Thank you very much Neville (what a shame that Partner doesn't just re-open all individual items?!!?)

    To be honest, I don't see that I have much of a choice if I'm to tidy up the ledgers and get things rolling smoothly in the future...


    So can I double check my understanding - If I were to proceed with the option whereby Partner creates "a single open item transaction for each ageing period for the existing balance outstanding" this would mean that say:

    In May, 3x invoices were raised for 1,000 / 2,000 / 3,000 respectively (totalling 6,000 in May) and this customer/supplier has 60 day pymt terms.
    Also in May cash was received/paid for the previous 60 days items - 4,500.

    so in the 'Match-open items' window for May - I will see a balance of 1,500 un-allocated which I will need to somehow tidy up

    (eventually I will have balances that just need writing off)

    bw
    David

  8. #6
    New Member
    Join Date
    Nov 2016
    Location
    Northamptonshire, UK
    Posts
    4
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Or...

    It will show unmatched invoices of 6,000 (no split or breakdown) in May, also an un-allocated receipt in May of 4,500
    (and presumably 60 days later in July/Aug, another un-allocated receipt of 6,000)

    Apologies for the questions, I cant yet get onto the system to check myself...

    bw
    David

  9. #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
    Hi David,

    Your first scenario is what will happen.
    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)

  10. Thanks given for this post:

    Blue Skies Accountant (01-Dec-16)

  11. #8
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,850
    Thanks
    249
    Thanked 371 Times in 327 Posts
    Hi David - let us know how it goes. Remember to do regular backups so that if something goes wrong you can restore to an earlier backup.
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  12. #9
    Junior Member
    Join Date
    Dec 2015
    Location
    Rustenburg
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I am able to check for "Open Item History" in Pastel Partner. Can one do the same in Pastel Express

    Good morning. I can check for "Open Item History" in Pastel Partner. Can one do the same in Xpress?

  13. #10
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by Jillikins View Post
    Good morning. I can check for "Open Item History" in Pastel Partner. Can one do the same in Xpress?
    Yes, you can.
    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)

Page 1 of 2 12 LastLast

Similar Threads

  1. Pastel Partner V12 - Locate server/Open company issue
    By DSKotze in forum Accounting Forum
    Replies: 12
    Last Post: 23-Jun-17, 09:16 AM
  2. [Question] Pastel Partner V11- conversion from open item to balance brought forward
    By MelJones in forum Accounting Forum
    Replies: 0
    Last Post: 04-Apr-16, 09:33 AM
  3. [Question] importing inventory items into pastel
    By StenetteFarrell in forum Accounting Forum
    Replies: 11
    Last Post: 10-Nov-15, 07:04 AM
  4. Pastel: Matching historical invoices and payments
    By TravisZA in forum Accounting Forum
    Replies: 4
    Last Post: 13-Jun-15, 03:34 PM
  5. Pastel matching problem
    By vieome in forum Accounting Forum
    Replies: 3
    Last Post: 28-Jun-12, 08:25 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
  •