Forum Discussion

ABS66's avatar
ABS66
Contributing User
2 months ago

FOB pricing.. I need to multiply by 4 decimal places

Hello! I am trying to update the pricing on an invoice, to show FOB pricing.  The invoice is in USD.  I can enter the price (USD) as 4 decimal places, but I cannot multiply it by 4 decimal places.

If I have 50 different items on an invoice, I don't want to calculate the FOB cost for each item separately.  I want to multiply the price (USD) by an adjusting percentage. That sounds really confusing, but it isn't!

 

Example:

6 units @ 688.10 usd = 4128.60 usd.

To add freight costs : x 1.06934 - calculated separately.

If I multiply 688.10 by 1.06934 outside of MYOB, I get 735.8097 each, 4,414.86 for 6 units.

If I multiply the unit cost 688.10 in MYOB, I can only multiply by 1.06, I get 729.39, 4,376.32 for 6 units.  Too inaccurate to use, out by $38.54.. and that's just the first line.

 

Does anyone know how I can multiply each line by 4 decimal places?  I just want to click on the unit price (usd) and *1.06934.

 

Any help will be appreciated :-) 

 

Vanessa

2 Replies

  • Hi ABS66​,

     

    From what I've gathered, you can't just multiply the unit cost by the freight cost in one go. You need to either manually allocate the freight cost to your inventory item or recalculate the cost to include both the unit and freight costs. And about your query on multiplying the line item to 4 decimal places, you can adjust the item price selling details to the exact amount and make sure to check the option for prices being tax-inclusive.

     

    However, if I'm missing the mark, hopefully, one of our members here can chime in with some advice for your specific issue.

     

    Cheers,

    Princess

  • ABS66's avatar
    ABS66
    Contributing User
    2 months ago

    Hi Princess,

     

    I can multiply the unit cost in one go.  The only issue is, I can only multiply by 2 decimal places.