[Question] Pastel Decimal places

[Lewissangare]

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

[Mike C]

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.

[Neville Bailey]

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.

[Lewissangare]

Thanks, Will give it a try and update u...

[Lewissangare]

It worked... Thank you very much Neville.....I edited the LedgerParameters table in Pervasive and manually changed it to 2.... Really appreciate!!

[Tanja Reinhardt]

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

[Tanja Reinhardt]

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

[Lewissangare]

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!

[Tanja Reinhardt]

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!

[Lewissangare]

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.

[NannetteP]

Pastel Decimal Places

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!

Hi, I just want to know how to change it in Pastel Xpress V14 if it shows 3 decimals.

[NannetteP]

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!

Hi, how would I change it in Pastel Xpress V14?

[Lewissangare]

Hi, how would I change it in Pastel Xpress V14?

@NannetteP. Unfortunately iam not familiar with Pastel Xpress Tables but the procedure will be the same. You just need to locate the table name and column name. You then execute the script as above substituting the table name and column names for Xpress 14.

[Alwyn]

Name of table in pastel partner which contains selling prices

Hi Neville
Can you please advise which table in pervasive for Pastel Partner 14 contains the selling prices for inventory.

[Neville Bailey]

Hi Neville
Can you please advise which table in pervasive for Pastel Partner 14 contains the selling prices for inventory.

MultiStoreTrn