voucher

I receive data from our ERP system on vouchers that create errors. I want to have a measure that tells me how many voucher lines were closed within the last week. But... a voucher can create multiple errors - one might be closed during that week, but if the same line has an open error I don't...

My queries go against transactional tables with 30-40 columns and millions of rows, and I'd like to speed them up. I see columns by Chris Webb and others talking about how List.Buffer and Table.Buffer can greatly reduce query times, but the M function descriptions are pretty sparse on how to...

Hopefully others have encountered this situation. There's a lot I need to wrap my head around in DAX and the order that calculations happen is one of them. I'm not sure whether the following measure is doing what I think it's doing without having to create multiple intermediate helper columns...

Hello, I have two workbooks one is for making bookings and a second that has a list of numbers allocated to vouchers. Workbook one has data like surname, date of appointment & staff initials. I want this data transferred to workbook 2 which is where we allocate voucher numbers to...

I would like help discovering why a disconnected slicer is not returning the expected data. Hopefully I’m missing something obvious. I would like to return a payment schedule based on our Accounts Payable (AP) groupings. The days to pay bucket is the Payment Date (if one exists) - Accounting...

Hi All, I am using the following code: Sub ReturnInvoice() Do Dim myWord$ myWord = InputBox("Insert the Voucher Number", "Voucher Search") If myWord = "" Then Exit Sub Application.ScreenUpdating = False Dim xRow&, NextRow&, LastRow& LastRow = Cells(Rows.Count, 1).End(xlUp).Row NextRow =...

I have the following measure which is returning 100% for every row. Voucher Spend as Pct of GL:= [Voucher Amt] / CALCULATE ( [Voucher Amt], ALLSELECTED ( Vouchers[Account] ) ) Voucher Amt:=SUM(Vouchers[Voucher Amount]) What I would like is for when I select certain accounts that the measure...

<tbody> PV no payee date amount method of payment cheque no. MPESA ref; cash Account No of installment Prepared by Approved by 45 X ltd 30/11/2017 45000 Cheque 124 General expenses 4 Me You 46 XY Ltd 30/11/2017 55900 LQWERTY1 printing/stationary 1 You Me 47 XYZ ltd 30/11/2017 69000...

I have sales data which I need to count the number of voucher for each day. Is there a formula to do so? Desired outcome: 4-5-0-3-2 for the five days. <tbody> DATE VOUCHER NO. 1-Oct-16 091 1-Oct-16 092 1-Oct-16 093 1-Oct-16 094 1-Oct-16 094 2-Oct-16 095 2-Oct-16 095 2-Oct-16...

Hi everyone, My company is purchasing thousands of item via Paypal and I am building a macro to get data from checkout page. Normally I want to get the Funding type and Funding sources. So here is what I do: 1) Copy whole content of the checkout page (Ctrl C) 2) Paste all content into my...

Hi, This is my first post on the forum so many thanks in advance for any help I might have. I work for a small activity centre and I'm looking for a way to enhance our gift voucher system and once I get my head around it potential use something similar to generate invoices which are a big...

Hello, I am going to be taking the MOS certification test for excel. Just curious if there is any one here who has taken the test (2010 test 77-882 (U.S.)) has any pointers for preparing for said test? Also, any suggestions on the best (and most affordable) way to purchace the test...