Results 1 to 4 of 4

Thread: Customer Statements - Pastel Xpress V11

  1. #1
    Email problem
    Join Date
    Dec 2017
    Location
    Johannesburg
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Customer Statements - Pastel Xpress V11

    I run a guesthouse that uses a reservation/property management system not integrated into Pastel. Instead of recapturing each individual invoice generated by the reservation system to Pastel Xpress V11 (yes... I know its old and outdated, but it works for us!), I have generated a CSV file from the reservation system and imported it through a sales journal to create the guest "invoices" on Pastel. All payments from guests are then allocated against these "invoices" through the various cashbooks.

    My problem is for year end when I need to generate an "outstanding customers" report/statement. It seems that if I have used the sales journal function, the "invoices" I have created do not pull through to the "invoices due" report and I would have to manually reconcile on a customer statement.

    Does anyone have any suggestions as to how I can generate a list of outstanding customer invoices on Pastel to reconcile with our reservation system?

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,647
    Thanks
    44
    Thanked 438 Times in 384 Posts
    If you have set up your customer accounts for Open Item processing, rather than as Balance Forward processing, you could run an Age Analysis report, with the "Print Transactions" and "Show OI Unmatched Only" options ticked.
    Neville Bailey - Sage Pastel Accounting Consultant
    Phone: 031 521 0080 or 087 095 7895
    neville@accountingsoftwaresupport.co.za
    www.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:

    mawirepower (14-Mar-19)

  4. #3
    Email problem
    Join Date
    Dec 2017
    Location
    Johannesburg
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Neville, you are a legend. Thank you so much!!!

  5. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,647
    Thanks
    44
    Thanked 438 Times in 384 Posts
    Quote Originally Posted by FountainHillGH View Post
    Neville, you are a legend. Thank you so much!!!
    You're welcome!

    Now read my post here, and do something about your old version of Pastel!
    Neville Bailey - Sage Pastel Accounting Consultant
    Phone: 031 521 0080 or 087 095 7895
    neville@accountingsoftwaresupport.co.za
    www.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. Consolidated customer statements in Pastel Xpress V14
    By Carolyn in forum Accounting Forum
    Replies: 5
    Last Post: 21-Nov-17, 12:04 PM
  2. [Question] Pastel Xpress 2009 - Customer Statements
    By Chris85 in forum Accounting Forum
    Replies: 1
    Last Post: 02-Nov-16, 03:22 PM
  3. [Question] Pastel V14 Customer Statements issue
    By Lewissangare in forum Accounting Forum
    Replies: 1
    Last Post: 12-Jan-16, 09:55 AM
  4. Pastel Customer Statements Question
    By Zoidbug in forum Accounting Forum
    Replies: 2
    Last Post: 18-Aug-15, 08:05 AM
  5. How to View Customer Statements in Pastell Xpress
    By fuzegraphics in forum Accounting Forum
    Replies: 3
    Last Post: 10-Dec-12, 02:09 PM

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
  •