Results 1 to 3 of 3

Thread: Pastel report

  1. #1
    Junior Member
    Join Date
    May 2016
    Location
    Cape Town
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel report

    Good day,

    My colleague is trying to pull a report in Pastel to compare monthly inventory stock against sales in order to do a purchasing forecast.

    Does anyone know if there is a report such as this , as the graph option only allows one item at a time and I cannot find something similar, only sales on their own and inventory items etc. but not a way to integrate them in to Pastel or some such.

    tx

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,781
    Thanks
    44
    Thanked 452 Times in 397 Posts
    It should be quite an easy exercise to plot such a graph in Excel, by typing in the stock value and the sales value, per month, as data points.

    It's also possible to create a custom BI report.
    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
    Junior Member
    Join Date
    May 2016
    Location
    Cape Town
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Mr Bailey,

    I ended up pulling an inventory summary to excel and it can be sorted and formulated there.

    Thanks.

    More questions on the way

Similar Threads

  1. REORDERS REPORT PASTEL V12
    By Coolblue in forum Accounting Forum
    Replies: 1
    Last Post: 22-Nov-21, 03:38 PM
  2. [Question] Pastel 14 custom report
    By Carol1982 in forum Accounting Forum
    Replies: 2
    Last Post: 08-Oct-19, 09:59 AM
  3. Pastel Tax Report
    By Mike C in forum Accounting Forum
    Replies: 7
    Last Post: 02-Jun-15, 08:04 AM
  4. [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
  5. Report writer in Pastel
    By Martinco in forum Accounting Forum
    Replies: 1
    Last Post: 23-Jun-11, 02:29 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
  •