Inserting a running total from a Formula field to OE Invoice report

Posted By J-Y over 8 years ago

To all Sage300 Report and/or Crystal Report gurus:

I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt). The Optional field table is not part of the Database fields for that report which uses OEINPR3.DLL.

What I did is create a subreport on table icitemo to get my optional field value. I created a formula field with a Shared variable to pass the value to the main report in the subreport.On the main report I created another formula field to use the shared value which I multiply by the QtyOrdered. Crystal Report is not allowing me to create a running total on that formula field.

Does anyone know how I can achieve a running total?

TIA

Parents

0 49153 over 8 years ago

1. Don't use the datapiped report OEINV01.rpt, use the ODBC report OEINV04.rpt
2. Link the optional fields table with a left outer join - in case not all records have an optional field value. If you have multiple optional fields then you may need to filter on optional field name.
Now your running total should be able to use the optional field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 49153 over 8 years ago

1. Don't use the datapiped report OEINV01.rpt, use the ODBC report OEINV04.rpt
2. Link the optional fields table with a left outer join - in case not all records have an optional field value. If you have multiple optional fields then you may need to filter on optional field name.
Now your running total should be able to use the optional field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 J-Y over 8 years ago in reply to 49153

Thanks for the recommendation. Will give it a try.
Now when I try to use the out of the box OEINV04.RPT to see how the layout is printed, I get an error message [Description: ERROR: LoadLibrary] This is Sage 300 v2014. Any ideas?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 8 years ago in reply to J-Y

Edit OERPT.INI in the OExxA folder, search for OEINV01 and comment out the datapipe line:
type=DATAPIPE
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 J-Y over 8 years ago in reply to 49153

It works! No more error message. I can now see OEINV04.RPT. Thanks again. You are a lifesaver :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Inserting a running total from a Formula field to OE Invoice report

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING