Results 1 to 8 of 8

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
    Durban
    Posts
    2,519
    Thanks
    221
    Thanked 334 Times in 291 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.
    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

  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,515
    Thanks
    36
    Thanked 408 Times in 355 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 - 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)

  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,515
    Thanks
    36
    Thanked 408 Times in 355 Posts
    Hi David,

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

  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
    Durban
    Posts
    2,519
    Thanks
    221
    Thanked 334 Times in 291 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.
    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

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
  •