+ Reply to Thread
Results 1 to 3 of 3

Identify Duplicate Invoice Payments

  1. #1
    Registered User
    Join Date
    03-10-2020
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    4

    Identify Duplicate Invoice Payments

    Hi folks,

    I am trying to create a spreadsheet that will help identify duplicate invoice payments made to our ERP system on a daily basis. I would like one tab to have all the data loaded from the current fiscal year, and then a daily import of the previous days invoice payments. I would then like to match the previous days payments up with anything that's already loaded with the same vendor, invoice number and amount. Is there a way that after the daily import and you review to see if there are duplicates or not, the data would then automatically go to the tab with the master data so everyday you start with a "fresh" page?

    I have attached what I have started...thanks
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 03-11-2020 at 03:23 AM. Reason: Shortened title. we know you need help and a sheet

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    453

    Re: Identify Duplicate Invoice Payments

    Depending on your ERP software, many programs alert you or will NOT allow you to have duplicate check numbers for payment to the same vendor. Also, many softwares (I cant speak for yours as you didn't mention what it is) allow you to see the Payments (with check #)....we typically can look at that before applying payment, BUT again it is generally not needed as our program will REJECT duplicate check numbers. What software are you using?

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,599

    Re: Identify Duplicate Invoice Payments

    .
    Paste in Regular Module; place commandbutton on sheet attached to this macro :

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-12-2019, 01:47 AM
  2. [SOLVED] Count of Invoice Delayed in Payments
    By Vcare in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2018, 07:35 AM
  3. Formula for Total Rising Invoice Payments
    By JamMad in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-26-2016, 12:10 PM
  4. [SOLVED] Sum invoice payments without duplicates
    By kgkgkg9009 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-17-2016, 07:46 AM
  5. Macros Needed to identify duplicate invoice numbers
    By ella.nguyen2603 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2014, 05:54 PM
  6. Replies: 1
    Last Post: 06-12-2014, 10:58 AM
  7. [SOLVED] identify duplicate data in excel spreadsheet
    By Mandeep Dhami in forum Excel General
    Replies: 3
    Last Post: 07-16-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05974 seconds
  • Memory Usage 8,934KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (3)postbit_legacy
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1