Sage 100

Is there any way to report on the actual cost of an item according to the receipt of invoice from the history files? In the receipt of invoice entry screen you enter the cost by line item, but I do not see any line records in the PO Receipt History Detail file of ReceiptType ""I"". Is the detail of the variance by item lost as soon as you update the receipt register?

I had to write the same report last week @ThereseLogeais suggested linking the PO Receipt History Detail and AP Invoice History detail - it worked great. On the main report I used AP History Header and Detail and a sub-report of PO Receipt History detail - linking on PO Number and Item Code the sub-report gets the recevied $ amount and then a formula on the main to calculate the variance.

Yikes. Hard to keep that logic straight................. What version of MAS? One might think the long term way to track this data (v4.4 and later) would be with a UDF pulling the data from the invoice entry fields (if you posted the invoice at time of ROG). But then again, theoretically, you should be able to use the PO value once the invoice is posted as the PO value changes to the invoice value (another dear old WAD). This falls apart if you have multiple receipts with multiple invoice values. Only the last one is kept in the PO file.

@LisaDion - did that method let you group by the item code? @JeffSchwenk - this customer tends to have lots of POs with multiple receipts. I'll examine the AP approach in the morning - my brain is screaming ""no mas - need beer"".

Yes my report is grouped by item

@LisaDion - thank you for the help - Ap invoice history did just what I need.

Phil, would you mind posting this Crystal?

Here you go - turned out to be simpler than I thought - most of the po/item info is in the AP invoice history tables. Note that this was created on a 4.4 JobOps system, so for standard MAS you will need to do a verify database. I don't believe any JobOps fields are actually in the report.