Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Pastel Decimal places

  1. #1
    Full Member
    Join Date
    Jan 2015
    Location
    Harare
    Posts
    25
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Pastel Decimal places

    SOS,

    We use pastel Partner V14t. The company is setup to handle up to 3 decimal places, inventory 3 decimal places on quantity and invoicing to 2 decimal places. My problem is that when we print customer invoices they have 3 decimal places which i assume is taking it from the company setup. I would now want to change everything to 2 decimals. I have tried using pervasive but cannot find the table with company setup & decimals. Please Help

  2. #2
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,240
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Hi Lewissangare - the setup for decimal places would be in Setup - Company Parameters - Formats. I am not too sure if you can change from 3 decimal places to 2 once you have made that transition. I think that Neville Bailey will have to help us out on this one.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  3. #3
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,374
    Thanks
    35
    Thanked 392 Times in 339 Posts
    There are two data tables that contain the decimal settings.

    "LedgerParameters", field named "HomeCurrencyFormat" - this sets the decimal places for the ledgers.

    "InventoryParameters", fields named "QtyDecimals", "CostDecimals" and "SellDecimals" - these set the decimal places for inventory quantities, inventory unit costs and inventory selling prices.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  4. Thank given for this post:

    Lewissangare (19-Aug-15), Mike C (18-Aug-15)

  5. #4
    Full Member
    Join Date
    Jan 2015
    Location
    Harare
    Posts
    25
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks, Will give it a try and update u...

  6. #5
    Full Member
    Join Date
    Jan 2015
    Location
    Harare
    Posts
    25
    Thanks
    1
    Thanked 0 Times in 0 Posts
    It worked... Thank you very much Neville.....I edited the LedgerParameters table in Pervasive and manually changed it to 2.... Really appreciate!!

  7. #6
    New Member
    Join Date
    Feb 2016
    Location
    Swakopmund, Namibia
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Lewissangare View Post
    It worked... Thank you very much Neville.....I edited the LedgerParameters table in Pervasive and manually changed it to 2.... Really appreciate!!
    Hi Lewissangare
    Could you please just detail the steps how to edit this in Pervasive?

    Thanks
    Tanja

  8. #7
    New Member
    Join Date
    Feb 2016
    Location
    Swakopmund, Namibia
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    There are two data tables that contain the decimal settings.

    "LedgerParameters", field named "HomeCurrencyFormat" - this sets the decimal places for the ledgers.

    "InventoryParameters", fields named "QtyDecimals", "CostDecimals" and "SellDecimals" - these set the decimal places for inventory quantities, inventory unit costs and inventory selling prices.
    Hi Neville
    I'm desperate here.
    Where do I find these ledger parameters and how do I change them.
    Please help!!!

    Thanks
    Tanja

  9. #8
    Full Member
    Join Date
    Jan 2015
    Location
    Harare
    Posts
    25
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Tanja.
    Assuming you are running Partner V14 ....Goto pervasive control centre. Locate your server and company database. Goto tables and and select table named LedgerParameters.
    Run the following script.

    "select HomeCurrencyFormat from "LedgerParameters"

    Then change to whatever decimal places you wish to have. Dont forget to save/refresh!!!!

    Hope this works!

  10. #9
    New Member
    Join Date
    Feb 2016
    Location
    Swakopmund, Namibia
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Lewissangare View Post
    Hi Tanja.
    Assuming you are running Partner V14 ....Goto pervasive control centre. Locate your server and company database. Goto tables and and select table named LedgerParameters.
    Run the following script.

    "select HomeCurrencyFormat from "LedgerParameters"

    Then change to whatever decimal places you wish to have. Dont forget to save/refresh!!!!

    Hope this works!
    Yay!!!!! it worked! Struggled a bit, but with a bit of help from my Programmer Boss it came right :-)
    Thank you for your help!

  11. #10
    Full Member
    Join Date
    Jan 2015
    Location
    Harare
    Posts
    25
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Tanja Reinhardt View Post
    Yay!!!!! it worked! Struggled a bit, but with a bit of help from my Programmer Boss it came right :-)
    Thank you for your help!
    Glad to have helped.

Page 1 of 2 12 LastLast

Similar Threads

  1. What is your favorite places for tour?
    By snehasaini in forum General Chat Forum
    Replies: 0
    Last Post: 13-Sep-13, 02:42 PM
  2. What is your favorite places for tour?
    By sonamsharma in forum General Chat Forum
    Replies: 8
    Last Post: 20-Aug-13, 09:52 AM
  3. Pastel Partner to Pastel Express
    By vieome in forum Accounting Forum
    Replies: 2
    Last Post: 19-Feb-13, 12:45 PM
  4. Replies: 2
    Last Post: 14-Apr-11, 11:22 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
  •