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

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

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

Add .06 as shipping cost.

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

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.

Subscription service based on FA
HRM CRM POS batch Themes

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

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

5 (edited by kvvaradha 09/08/2022 06:28:58 pm)

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

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

Subscription service based on FA
HRM CRM POS batch Themes

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

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

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

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

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

Add a negative discount of 6 cents