Sage 300 ERP – Tips, Tricks and Components
Greytrix is one of the oldest Sage Development Partner of two decades and Reseller of Sage 300 ERP (formerly known as Sage Accpac ERP) and has been awarded "Sage Partner of the Year" multiple times for rendering quality services for Sage product lines both as developers and resellers. Greytrix has accumulated hundreds of man years of experience in Sage 300 ERP. In these blogs, Greytrix will endeavour to share its knowledge with regards to implementation, training, customisation, components, current technology trends and help users to understand in depth techno – functional aspects of Sage 300 ERP! Contact our team at accpac@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home

Prevent duplicate invoices in accounts payable

By sageaccpac | March 12, 2018
0 Comment

In this blog, we will discuss an option in Sage 300 ERP i.e. “Vendor and Amount and Vendor and Date”. In A/P Vendor –> Invoice Tab, drill down option is exist with three options (None, Warning, Error) for ‘Vendor and Amount’ and “Vendor and Date”. Kindly refer below screenshot for the same.

New Stuff: E-mail Messages sending with Custom Template on Order Confirmation in Sage 2017

AP vendors

The selected option in “Vendor and Amount” and “Vendor and Date” specify how you want Accounts Payable can ignore duplicates, warn you, or stop you from posting or adding the invoices.

Vendor and Amount Combo box: – Depends on the selected option, the Accounts Payable can ignore, warn and stop when you enter two or more invoices for the same amount from this vendor.

Vendor and Date Combo box: – Depends on the selected option, the Accounts Payable can ignore, warn and stop when you enter two or more invoices for the same date from this vendor.

Option “None” :- If we have selected the option “None” for the vendor “1200”, the Accounts Payable can allow to enter the duplicate invoices for the same amount and same date and it does not warn and stop when you add or post the invoices.

Option “Warning”:- If we have selected the option “Warning” for the vendor “1200”, the Accounts Payable can allow entering the duplicate invoices for the same amount and same date but it would warn when you add or post the invoices. Kindly refer below screenshot for the same.

Vendor And Amount Setting

We have created the one Invoice “APINV-1002” with Amount “108.25” and Date “03/01/2018”. Kindly refer below screenshot for the same.

AP Invoice Entry

And again we have been creating the Invoice “APINV-1003” with same Amount “108.25” and same Date “03/01/2018” it would pop up below warning messages.

Warning Message pop up

Option “Error”:- If we have selected the option “Error” for the vendor “1200”, the Account Payable cannot allow to enter the duplicate invoices for the same amount and same date and it pop up the error messages. Kindly refer below screenshot for the same.

AP Vendor settings

We have created the one Invoice “APINV-1002” with Amount “108.25” and Date “03/01/2018”. Kindly refer below screenshot for the same.

created the one Invoice “ with Amount and Date

And again we have been creating the Invoice “APINV-1004” with same Amount “108.25” and same Date “03/01/2018” it would pop up below error messages.

Error message pop up

About Us
Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique solutions of Sage 300 integration with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 300 Services, please contact us at accpac@greytrix.com. We will be glad to assist you.

Category: Sage 300 Tags: Account Payable, Sage 300, Sage 300 ERP, Vendor and Amount, Vendor and Date
Post navigation
← E-mail Messages sending with Custom Template on Order Confirmation in Sage 2017 User-defined options to migrate Item masters into Sage 300 ERP →

Greytrix Websites and Blogs

  • Greytrix
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Intacct– Tips, Tricks and Components
sage crm and sage 300 integration

Categories

  • Sage 300
    • ACCPAC SDK
  • Sage 300 People
  • Sage 50 US
  • Sage Business Cloud
  • TDS
  • Uncategorized

Recent Posts

  • Validation on Generating Duplicate Vendor/Customer
  • Enhanced O/E Sales History Screen based on Items
  • Mailing open invoices to the customer
  • Auto Populate Updated Unit Price on OE Invoice Screen based on Contact Pricing in Sage 300
  • Export IC Adjustment details using Sage 300 Customized Utility.

Archives

Awards

Greytrix Top ISV Partner
Greytrix Revenue Growth Enterprise Business
Greytrix Africa Highest Revenue
Greytrix Prtner of the Year
Greytrix Partner Award
Copyright 2023
Sage 300 ERP – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress