Results 1 to 4 of 4

Thread: Pastel Open Item Matching - O/I Diff

  1. #1
    Junior Member
    Join Date
    Aug 2016
    Location
    Western Cape
    Posts
    19
    Thanks
    5
    Thanked 1 Time in 1 Post

    Pastel Open Item Matching - O/I Diff

    When requesting the age analysis, some customers have an O/I diff.

    Can this problem be fixed by simply converting all the customers first to “balance forward” and then back to “open item” again? I think/hope that it will fix the O/I diff and will result in one total amount for all the outstanding invoices (which can be matched as the payments are made and new invoices after this will display individually under open item matching) – will it work?

    The company setup is Open Item matching, but some customers have been manually changed to balance forward. The above should fix it so that all is open item right?

    Then another question: am I correct that the O/I diff and the subsequent funny-looking age analysis has no influence on the total amount outstanding according to the detailed ledgers? In other words the “total due” amounts in the age analysis are the same as the individual detailed ledgers total, therefore that is the actual amount outstanding (irrespective of the ageing).

    Thanx
    Marlene

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Yes, you are correct in all you've said.

    It is, however, possible to have a data fix done to those customer accounts, which will preserve all the Open Item history. Let me know if you would prefer to go that route, and we can arrange a TeamViewer session.
    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)

  3. Thanks given for this post:

    betst07 (08-Jul-19)

  4. #3
    Junior Member
    Join Date
    Aug 2016
    Location
    Western Cape
    Posts
    19
    Thanks
    5
    Thanked 1 Time in 1 Post
    Thank you so much Neville.

    Could you give me your e-mail address please?

  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
    Quote Originally Posted by betst07 View Post
    Thank you so much Neville.

    Could you give me your e-mail address please?
    neville@accountingsoftwaresupport.co.za
    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)

Similar Threads

  1. Pastel Partner - matching open items - only some accessible
    By Blue Skies Accountant in forum Accounting Forum
    Replies: 16
    Last Post: 29-Jul-19, 11:48 AM
  2. [Question] Pastel Xpress V17 Bank Manager - Matching Supplier Invoices (open Item)
    By Roanne Duncan in forum Accounting Forum
    Replies: 2
    Last Post: 03-Aug-17, 08:13 AM
  3. [Question] Pastel - changing from balance brought forward to open item
    By Heidivf in forum Accounting Forum
    Replies: 2
    Last Post: 07-Jul-16, 02:40 PM
  4. [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
  5. [Question] CORRUPTION ON OPEN ITEM FILE
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 06-Feb-13, 07:47 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
  •