PO Variances by Item / PO/ Vendor

Have a client that would like to be able to easily track PO purchases variances by line item and vendor.

 

 

You can see the posting in the G/L in the PO Purchases Variance account by the vendor,  but it really doesn't show the item.

 

Don't really see a file that keeps track of the variances - pre calculated.

 

The PO receipts history file appears to show the the receipts of goods records although for some odd reason we were not seeing the receipt of invoice records?     Not sure at this point if I'm just doing something wrong and accidentally filtered out the receipt of invoice records or they just aren't there.

 

Shouldn't I be seeing receipt of invoice records?   Or am I making this too hard and there is an easier way to do this?

 

Client is currently in 4.3.

Parents
  • Probably can be done with A/P history and receipt history although it could be a little painful getting everything to match up. 

     

    This is one of those projects where the client wants it as long as it doesn't cost  too much (budget about two hours) so was hoping for a simple data source.  But it doesn't look like I'm going to be able to meet that constraint by the time it's debugged.

  • in reply to TomTarget

    Tom,

    Were you ever able to create such a report?  I have just received the exact same request from our Accounting team where they want to see the PO Variance Amount by Item, not by PO.  I have been looking through PO and AP files and couldn't find one that contains this variance amount by item, nor could determine what files I could possibly link and do a calculation on.  

    Any input you can provide would be helpful and much appreciated, if it can be done.

    We are on Sage 100c Advanced v2022.1

  • in reply to Kenny98

    Recently Sage added PO invoice line data to receipt history tables, so you might be able to look there for transactions posted after you upgraded to a version with this change. 

    Before that, you'd have to deal with linking AP invoice history with the RoG data in PO receipt history, which is not an easy task.

    Either way you are looking at a custom report, and you have to filter out amounts that are currently on the Purchases Clearing report (quantity received <> quantity invoiced).

Reply
  • in reply to Kenny98

    Recently Sage added PO invoice line data to receipt history tables, so you might be able to look there for transactions posted after you upgraded to a version with this change. 

    Before that, you'd have to deal with linking AP invoice history with the RoG data in PO receipt history, which is not an easy task.

    Either way you are looking at a custom report, and you have to filter out amounts that are currently on the Purchases Clearing report (quantity received <> quantity invoiced).

Children
  • in reply to Kevin M

    Thanks for the info Kevin.  I found the Variance field in PO Receipt History Detail file and created a crystal report that will help going forward.  As you stated, nothing prior to our upgrade to v2022.

    I'll try working with the AP invoice history and PO receipt history files to see what can come out of it, but based on what I see so far and your comment, this one's going to take awhile.

    Thanks again