Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

FRx Row format Total excluding 1 row.

Posted on by Microsoft Employee

I have a row total on an FRx report that for whatever reason will Not include a specific row. No matter how I do the total calculation, it will not include Row 30. I have tried +30 + 74 +76 79, 30+74+76+79, @30 + @74 + @76 + @79, etc. 

See format below. 

Row 30 is the Total Mfg Costs - $/Box

Row 74 is the Additional Plant Costs - SMP - $/Box Avg

Row 76 is the Additional Plant Costs - Corp Allocation - $/Box Avg

Row 79 is the Additional Plant Costs - Other Expenses (Income) 

Total Mfg Costs- $/ Box CAL (@700+@730+@820+@835+@850+@910+@970+@1330+@1495+@5380+@6460+@6820)/@25
Cost of Good Sold-Material Only $ / Box CAL (@700)/@25
Cost of Goods Sold with Discounts & Freight - $/Box Avg. CAL (@700+@730+@910+@970)/@25
Direct Labor - $/Box Avg. CAL (@1330)/@25
Indirect Labor - $/Box Avg. CAL (@3040+@3130+@3370)/@25
Overhead (includes Indirect Labor) - $/Box CAL (@5380-@5290)/@25
Direct Fab Costs-Direct SGA-Cab Mfg - $/Box Avg. CAL @1495/@25
Addtional Plant Costs-SMP - $/Box Avg. CAL (@5890/@25)*-1
Addtional Plant Costs -Corp Allocation - $/Box Avg. CAL (@5950/@25)*-1
Additional Plant Costs - Other Expense (Income) - $/Box Avg. CAL (@5590+@5680+@5710+@5740+@5860+@5770)/@25
---
CAL
CAL
DES
Total Hillsboro "ALL IN" Box Cost - $/Box Avg. TOT @30 C

Categories:
  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: FRx Row format Total excluding 1 row.

    consider switching the rows TOT vs CAL

    Frx is really old, hard to find good help (hence my not quite non answer).

    Jan Harrigan has a great site for Frx help.  Perhaps this particular page will assist you.

    www.frxbuzz.com/simplify-frx-totals-calculations

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx Row format Total excluding 1 row.

    30 is a calculation. The totals formula's I have tried are as follows:

    @30+@74+@76+@79

    30+74+76+79

    30 TO 79

    But it continuously excludes Row 30

  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: FRx Row format Total excluding 1 row.

    what is the formula / link to the gl on rows 30,74,76&79.  30 would appear to be different.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans