FrontAccounting forum — How to round total selling price from $1,499.94 to $1,500

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (apmuthu) — Sat, 16 Sep 2023 03:57:53 +0000

Add a negative discount of 6 cents

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (gabbropee) — Thu, 31 Aug 2023 14:27:22 +0000

I'm trying to round total selling price from $1,499.94 to $1,500 in direct invoice under sale module but it doesn't work and I tried it in the Direct supplier invoice under purchase module and is working.

Please someone should help me on how to achieve the same result with direct invoice under sale

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (poncho1234) — Sat, 10 Sep 2022 19:48:24 +0000

gabbropee wrote:

I have an item for sale, the unit price is 83.33.
If I sell 18 pcs it will be 1,499,94 but I want to round it to 1,500.
Please I need help on how to round the total price to 1,500
Thank you in advance

You may be better off using a 'kit' for this scenario, read about kits in the wiki - https://frontaccounting.com/fawiki/inde … AliasCodes

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (kvvaradha) — Thu, 08 Sep 2022 18:25:10 +0000

I have told the rounding trick above. But this unit mapping is a different concept. That we have coded here like this. Each unit will have a separate price for it and also both purchase and sales prices are available to update and use it

This video will help you to understand it.

https://youtu.be/MM415WT-kZY

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (gabbropee) — Thu, 08 Sep 2022 13:35:10 +0000

kvvaradha wrote:

This is something we need to round and check it.
There are two scenarios here.
1,499.94
And
1500.09
For both cases we have to round it to 1500.
Lets workout this way.
$amount = 1499.94
$rounded_amount = round(1499.94); // 1500 here
ov discount = rounded_amount- amount
// here this will get the discount in both negative and positive. You should store it on ov discount. I guess it was not used from last updates. Use it by updating the code. If you need you can add discount gl for the discount given.

Please can you explain this further.
We have a product that it's unit price is 83.333 but we sell in carton. 18 PCs in 1 carton and the carton price is 1500.
I have not really figured out the best way to handle this. Please help me if you know the best way to go about it.
Thank you

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (kvvaradha) — Thu, 31 Mar 2022 13:37:49 +0000

This is something we need to round and check it.
There are two scenarios here.

1,499.94

And

1500.09

For both cases we have to round it to 1500.

Lets workout this way.

$amount = 1499.94
$rounded_amount = round(1499.94); // 1500 here

ov discount = rounded_amount- amount

// here this will get the discount in both negative and positive. You should store it on ov discount. I guess it was not used from last updates. Use it by updating the code. If you need you can add discount gl for the discount given.

Re: How to round total selling price from $1,499.94 to $1,500

null@example.com (apmuthu) — Wed, 30 Mar 2022 03:35:16 +0000

Add .06 as shipping cost.

How to round total selling price from $1,499.94 to $1,500

null@example.com (gabbropee) — Tue, 29 Mar 2022 23:35:34 +0000

I have an item for sale, the unit price is 83.33.
If I sell 18 pcs it will be 1,499,94 but I want to round it to 1,500.

Please I need help on how to round the total price to 1,500

Thank you in advance