Misc Costs totaling 3 times on invoice

Posted By Michael Ericksen over 4 years ago

I am attempted to show the total of the misc costs on an invoice. I have created a calculated field for the misc costs that is equal to the extinvmisc only when the linetype is <> 1. This does calculated correctly, but when I use a sum formula it is three times the correct amount.

Any Ideas?

0 Jay Converse Acumen over 4 years ago

Your formula is wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Michael Ericksen over 4 years ago in reply to Jay Converse Acumen

I removed all the headers and just showed the detail line. The misc charge shows up three times for each invoice. All the other line items only show up once, Any ideas?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 4 years ago in reply to Michael Ericksen

Probably a join creating a one-to-many link.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 wheumann over 4 years ago in reply to Michael Ericksen

Agreed - join is the likely culprit. If you have comments (table OECOINO) in the join, the connection happening behind the scenes creates one record for each invoice line / comment combination. So if you have 3 comments, you would have 3 records and Crystal is adding the value each time. This is solvable with a formula, but much easier if you just use the data from the header table. OEINVH.INVMISC should have the total of all misc charges.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Misc Costs totaling 3 times on invoice

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING