Custom Modification to OEINV01 1

[Bluejay07]

Hello,

I would prefer to ask this question here compared to the crystal reports forum. I'm using Accpac 5.5 and Crystal Reports 11.

I'm trying to customize OEINV01. A client would like the quantity back ordered removed and replaced with Cases Shipped. I'm assuming I would require the following formula:
(Quantity shipped * UOM Conv Factor) / Case Conv Factor

Here's the dilemma. From what I can tell, the conversion factor isn't included with the details (Group Header 2a). As a result I believe I would have to create a subreport linked to ICUNIT with the item number, quantity shipped and unit of measure as parameters. I know how to manouver around crystal reports but I am by no means an expert. I have placed the parameters on the subreport and they do show up so I know the values are being passed to the subreport. If I place any value from ICUNIT (itemno, unit or conversion) they do not appear on the report.

I thought that maybe I might need to filter the report a bit more and I tried setting the UNIT equal to 'Case' and even that didn't seem to make any difference. I am using SAMINC as a test database with one single item that was invoiced and shipped.

My problem is two-fold:
- I can't tell if ICUNIT is being accessed;
- How do I loop through the entries to get the appropriate conversion factors?

(There are currently no shared values in the subreport. I am still trying to get a value dislpayed)

Does anyone know what I may be doing wrong or can someone suggest an alternate method?

Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[Bluejay07]

I believe the issue is because the item number is formatted. Anyone know how I can send an unformatted number?

If at first you don't succeed, then sky diving wasn't meant for you!

 

[ettienne]

A sub report is your best option. You need to pass the itemno to the subreport, make sure you pass the unformatted itemno and not the formatted itemno - I think this is where you are going wrong. You also need to pass the qty to use in the calculation to the subreport, create a parameter in the subreport to accept the qty. Your selection formula in the subreport needs to filter on UNIT = "Case" as you said.

 

[Bluejay07]

Thanks for the reply ettienne.
The database fields only has a formatted item nuumber and does not have the formatted number. Any suggestions?

If at first you don't succeed, then sky diving wasn't meant for you!

 

[ettienne]

Use ICITEM and ICUNIT in the sub report, link the 2 tables on the ITEMNO field. Then use ICITEM.FMTITEMNO in the subreport link.

 

[Bluejay07]

Thank you.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[DjangMan]

I'd avoid the data pipe reports where possible. Editing non-data pipe reports is far easier. And they upgrade much nicer as well.

 

[Bluejay07]

Thanks for the advice DjangMan. I'll try to remember that for the future. For this issue, I had a few more adjustments to make but and got everything working. So far the client seems happy.

If at first you don't succeed, then sky diving wasn't meant for you!