Report Question

[Dan Peake]

Thanks in advance to all who reply:

I have a primative invoice setup using A4 V6.0 DOS

My invoice will allow 5 line items. Each item containing fields like

qty_1 part_num_1 description_1 price_1 $total_1
qty_2 part_num_2 description_2 price_2 $total_2
and so on, to line five.

I have about twenty unique part numbers, two of which I must pay a royalty to a third party - hence the need for a report.

The 'royalty' part numbers ("FCX" and "SRS") can appear in any of the five invoice lines. So the search is the first step, I can deal with that, but the report is the tricky part. I would like the body of the report to read as follows:

Part# Qty Sales
------------------------
FCX 16 $32.00
SRS 64 $128.00

Thanks for your help!

Dan

[Steve Pick]

RE: Report Question

Dan,

First, there should be no reason why you restrict an invoice to five line items.

Is the invoice structured as INV_HEAD (parent)and INV_ITEM (child).

Assuming you have INV_ITEM then you can have a field called PAY_ROYLTY which is a calculated field

In Field rules INV_ITEM set PAY_ROYLTY to
IF(Partno="FCX".or.Partno="SRS",1,0)
Have a calculated field in report or dbf for royalty which is
amount*PAYROYALTY

That should do it, if I understand the question correctly.

I have a situation where we pay halfthe sales amount if the inventory is shared with another company. However, there are exceptions.

I use a color expresson for the Part_no field such that if SHARED_INVENTORY>0 then flash different color.

If I see the part_no flashing then I manually set a field "Apply_commission" from the default No to Yes when appropriate. This allows the field rules to lower the shared inventory as well as our inventory by the posting mechanism.

Lastly I fill the vendor ID field in manually for that item and then I run a report showing the commission applied for that invoice for all items where the vendor ID is not blank.

Is this as clear as mud?

Steve

[Gary Smith]

RE: Report Question

See attached exe file.