Hello Everyone,
I am new the forum, but have been a lurker for-sometime now. With that said I've learned a vast amount of information; yet, now i find myself in dire need of a little help.
To start, I'm trying to reconcile inventory (RX Scripts) that currently does not have a unique identifier. Though, I've created one with the data that appears on both the inventory sheet and the receipt. i.e. RX number and fill date combined together, which provides us with a relative unique number.
However, in pharmacy we have secondary and primary billing which will send the same RX and fill date to two different insurance payers. One pays half and the other pays the remaining amount. Which throws off values on the inventory sheet where we reconcile the claims. Thus causing us to go in and add another unique number to each claim to make it truly unique. When you have only ten claims it's not an issue, but when we have a thousand or more it becomes a huge issue.
Currently, we are using the function of if(isna(Vlookup( to provide reconciliation. If you have any helpful information, I would be forever grateful.
Bookmarks