Results 1 to 3 of 3

Thread: Pastel 14 custom report

  1. #1
    New Member
    Join Date
    Oct 2019
    Location
    Mozambique
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel 14 custom report

    The revenue department in Mozambique currently requires us to submit a trial balance with the following requirements:
    * GL descriptions must be in Portuguese according to the Mozambican chart of accounts
    * Every GL account line must reflect the debit movements for the period, the credit movements for the period, and a total (debit less credit) column for the period selected.

    Is this possible in Pastel 14? Can a custom report be written for Pastel that can give this information? I have tried on Report Writer but could only find an option to show the cumulative balance per GL account and not the debit and credit movements in the account separately.

  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
    It should be possible to create a Sage Intelligence report to reflect the information you require.

    If you would like me to assist you, send me an email or private message, and we can discuss it further.
    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. #3
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    You can't do what you are looking for in the GL report writer. You will need the SI / Business Intelligence module. Maybe Alec Candiotes can assist (his info is in a few threads in the forum)- they have a power BI reporting tool.
    You can also do it manually in excel, either by creating an ODBC link to the database (32 bit MS Office - no 64 bit ODBC for pvsw, unless you upgrade to pvsw 13), or by exporting the GL transaction file to excel, then using the sumifs function to add the DR and CR per period, per account. It will take a while to refresh the data, but it can be done without the fancy tools. If you have to submit regularly, I would suggest using one of the app's or modules available, but if it is only once a year, you could perform the exercise manually.

Similar Threads

  1. Pastel Sage Custom Form does not show backorders
    By AddiG in forum Accounting Forum
    Replies: 0
    Last Post: 04-Nov-15, 06:00 PM
  2. [Question] Custom Form - Sage Pastel
    By Dientjie in forum Accounting Forum
    Replies: 4
    Last Post: 09-Jun-15, 12:07 PM
  3. Pastel custom Form Designer path help
    By johanbester in forum Accounting Forum
    Replies: 5
    Last Post: 09-Mar-15, 10:48 AM
  4. [Question] How to add a custom logo to pastel invoices/ statements ect?
    By Lehana Nel in forum Accounting Forum
    Replies: 2
    Last Post: 01-Aug-12, 10:05 AM
  5. [Question] Pastel Tax Box Report & Vat Detail report giving different figures!
    By Cin8 in forum Accounting Forum
    Replies: 3
    Last Post: 22-May-12, 03:57 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
  •