Vendor Reconcilition

[#1]

Dear QV Team, I am very new to this tool and trying to extract something useful for my daily requirement. i have to do a small reco between my books and the vendor books. As of now i am not able to put formulas, please help me the way to go forward.

[Anonymous]

You send some sample to be clear that you need?

[Oleg_Troyansky]

Hi Mukesh,

your request is way too open. If you'd like someone to help you, you will need to describe your problem with a lot more details and perhaps share your application with the specific challenges that you are trying to overcome.

cheers,

Oleg Troyansky

Learn advanced QlikView and Qlik Sense techniques in my book QlikView Your Business

[#4]

Dear Team,

i have the data as per below snapshot. i have transaction ids and some transactions happened for these ids i.e invoice, payment, credit memo, refund. Now, accounting wise when we close our books we reconcile the vendor ledger at Transaction id level. where we need to do it very closely that what is the final status of against each id. currently i do it manually in MS excel and takes lots of time.

Suppose for one id, invoice was generated for USD 100 and payment has also been processed for same, this bill is clear from my side. but there are few cases which are not paid, some are cancelled and we have to recover from our vendor. So accordingly i have to give the remarks to each case as depending upon the transaction type as below:

'Okay'-Which are settled. Total amount -1 to +1.

"Cancellation Recovery"- Which are paid and later cancelled, resulting final total balance as Debit.

"Open" Ids which are showing payable in our books.

Please start solving my problem from here..i have further challenges i will keep sharing with you.

[#5]

Remember we have to give remarks for Total amount only, but yes remarks will differ depending upon the different transaction type.

[#6]

Dear all, please help here.