1 Reply Latest reply: Jan 18, 2016 9:14 AM by Olly Bond RSS

    Horizontal Detail Capture Monarch V8

    Jeffrey Peters

      Hi everyone!

       

      I have the report below that I need the yellow highlighted fields. I am interested in seeing vouchers that have amounts in GL account # 22200 which does not have the equal amount related to a receiver which is prefixed RC below. Is this possible? Our current version of Monarch we are using is V8.

       

       

       

       

      Voucher: 156784 Date: 03/25/15 Remit-To: Currency: USD Currency:          Amount: 1,070.00

       

      PO Number: Effective Date: 03/31/15 Ship-To:           Exch Rate: USD 1.0 = USD 1.0

       

        Account: 22100 8000

       

       

       

      Supplier: accoil Due Date: 03/25/15  Invoice: 42659595

       

      Bank: WD Non-Disc Amt: 0.00

       

      ACCOUNTEMPS Disc Date: 03/25/15   Entity: CONF Type: Amount Applied: 1,070.00

       

      Check Form: 1       Confirmed: Yes    Confirmed By: lmm Hold Amount: 0.00

       

      ERS Voucher: No

       

      Batch: 14602

       

       

       

           Ln Account  Sub-Acct CC   Project Enty           Amount Description

       

          --- -------- -------- ---- -------- ---- ---------------- ------------------------

       

            1 70200 7540 CONF         1,070.00 CONTRACT LABOR

       

       

       
       

      1. apvorp.p 2+ 28.3.1 Voucher Register Date: 01/15/16

       

      Page: 6 Easley Manufacturing-PROD Time: 12:20:15

       

        Voucher: 156916 Date: 03/31/15 Remit-To: Currency: USD Currency: Amount: 1,070.00

       

      PO Number: Effective Date: 03/31/15 Ship-To:           Exch Rate: USD 1.0 = USD 1.0

       

        Account: 22100 8000

       

       

       

      Supplier: accoil Due Date: 03/31/15  Invoice: 42694161

       

      Bank: WD Non-Disc Amt: 0.00

       

      ACCOUNTEMPS Disc Date: 03/31/15   Entity: CONF           Type: Amount Applied: 1,070.00

       

      Check Form: 1       Confirmed: Yes    Confirmed By: lmm Hold Amount: 0.00

       

      ERS Voucher: No

       

      Batch: 14602

       

       

       

           Ln Account  Sub-Acct CC   Project Enty           Amount Description

       

          --- -------- -------- ---- -------- ---- ---------------- ------------------------

       

            1 70200 7540 CONF 1,070.00 CONTRACT LABOR

       

       

       

      Base Supplier accoil Total

       

      Amount: 12,520.72

       

      Non-Disc Amt: 0.00

       

      Amount Applied: 12,520.72

       

      Hold Amount: 0.00

       

       

       

      Supplier: ACWHCA Name: ACME WHISTLES

       

       

       

        Voucher: 153880 Date: 02/12/15 Remit-To: Currency: USD Currency:          Amount: 975.00

       

      PO Number: PO43159      Effective Date: 02/09/15  Ship-To: WM GVL    Exch Rate: USD 1.0 = USD 1.0

       

        Account: 22100 8000

       

       

       

      Supplier: ACWHCA Due Date: 03/14/15  Invoice: 1097493

       

      Bank: WD Non-Disc Amt: 0.00

       

      ACME WHISTLES Disc Date: 12/02/15   Entity: CONF Type: Amount Applied: 975.00

       

      Check Form: 1       Confirmed: Yes    Confirmed By: jxp Hold Amount: 0.00

       

      ERS Voucher: No

       

      Batch: 14458

       

       

       

          Receiver Pur Order    Item Number UM P  Receipt Qty  Invoice Qty           PO Cost Cur      Invoice Cost Cur

       

          -------- --- -------- ------------------ -- - ------------ ------------ ----------------- --- ----------------- ---

       

          RC102058   1 PO43159  8023496 EA          500.0 500.0 1.95 USD 1.95 USD

       

       

       

           Ln Account  Sub-Acct CC   Project Enty           Amount Description

       

          --- -------- -------- ---- -------- ---- ---------------- ------------------------

       

            1 22200 5BE0 8000 CONF           975.00 ACCRUED PO RECEIPTS