Jump to content


Photo

Line item totals calculated incorrectly - mom 4.3


  • Please log in to reply
3 replies to this topic

#1 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 11 August 2006 - 12:49 PM

Hello,

I recently discovered on an order that MOM was rounding up totals incorrectly on line items where an additional discount was applied.

Please try this yourself and tell me if you come to the same conclusion.

In my example I sold a customer 7 units of an item for $24.98 with an additional 5% discount.

The unit cost including the discount is $21.83
The extended price SHOULD BE $152.81 (7 units x 21.83)

Unfortunately, MOM rounds this line total to $152.82

Yes. It is only a penny but it is still wrong.

My observations:

The code in MOM is factoring the discount to 3 decimal places.

22.98 - (22.98 x discount/100)
=22.98 - (22.98 x .05/100)
=22.98 - (22.98*.05)
=22.98 - (1.149) **NOTE!!This is where MOM should round to 1.15!
=21.831


7 units x 21.831 = 152.82 WRONG
7 units x 21.83 = 152.81 CORRECT

With Correct I get paid. With WRONG I get flack from accountants and book keepers.

!! HELP !!
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#2 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 15 August 2006 - 05:49 PM

Ok - if anyone is interested I worked out the solution with the help of a fellow mom user:


ROUND((IT_UNLIST)*((100-ITEMS->DISCOUNT)/100),2)*QUANTS

This is how you calculated a line total in RR.

>
>
> Best,
>
> David
>
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#3 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 17 August 2006 - 07:45 AM

Ok - if anyone is interested I worked out the solution with the help of a fellow mom user:
ROUND((IT_UNLIST)*((100-ITEMS->DISCOUNT)/100),2)*QUANTS


Hi David,

Sorry, I didn't realize you needed a formula for RR (which I already had created.) Your original post appeared to me that you were asking why Dydacomp wasn't rounding properly in MOM.

Chris
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#4 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 17 August 2006 - 05:41 PM

Hey Planetdj,

No worries! I appreciate the support!!!

I wasn't sure what I needed at first. I was hoping that someone had a momwin update that would eliminate the RR fix .

Best,

DN
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users