Results 1 to 3 of 3

Thread: JobCodes on sales invoices to appear in GL report

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    New Member DewaldSmit's Avatar
    Join Date
    Nov 2017
    Location
    Stellenbosch
    Posts
    5
    Thanks
    3
    Thanked 0 Times in 0 Posts

    JobCodes on sales invoices to appear in GL report

    Hi Everybody

    I trying to create an income statement per division by using the General Ledger Transaction report in Pastel's Intelligence Reporting and by employing the Project Codes as the codes for the divisions.

    If I add the JobCode field to my pivot table, only the JobCodes for the transactions posted in my cash book appears and not those entered for sales on customer invoices.

    On the Project Report the sales and costs are grouped together, however, so I guess they must be linked in a table somewhere - I just do not know where.

    I thought that this route might be easier than restructuring the entire COA.

    Am I going about this in the wrong way, or is there an easier way?

    I am using Partner V14.2.1.

    Any assistance would greatly be appreciated.

    Many thanks

  2. #2
    Full Member VLW's Avatar
    Join Date
    Oct 2017
    Location
    East London
    Posts
    26
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I would rather restructure the COA, less room for error if there is more than one person working on the data set. So many people overlook project codes. I'm not too familiar with partner ito account segments but pastel evolution works like a dream.

    Sent from my SM-A500FU using Tapatalk

  3. #3
    New Member DewaldSmit's Avatar
    Join Date
    Nov 2017
    Location
    Stellenbosch
    Posts
    5
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Many thanks VLW. It is a very small business and there is basically no budget for reporting, so I will have to do with what is available. Currently I am the only one doing the processing. I have considered restructuring the COA with the divisions being sub-accounts 100,200,300,etc. . This works if I want to report on the divisions individually, but when I want to report on the business as a whole, I want to group the Accounting fees (for example) as one line item on the summary report and not as 4 line items (one for each division).

Similar Threads

  1. [Question] Include Sales Order Number on Pastel Partner Tax Invoice using Report Designer
    By David Irish in forum Accounting Forum
    Replies: 2
    Last Post: 21-Jun-16, 11:14 AM
  2. [Question] Pastel Supplier Invoices Matching - Remove Credited Invoices
    By steffie250 in forum Accounting Forum
    Replies: 6
    Last Post: 10-Mar-15, 01:23 PM
  3. Pastel v14 importing invoices from ultra sales POS
    By Coolblue in forum Accounting Forum
    Replies: 0
    Last Post: 05-Feb-15, 09:35 PM
  4. PASTEL V12 - SALES INVOICES DELETING FROM BATCH
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 18-Sep-13, 10:25 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
  •