AP Payment and Credit Note creation utility

By | January 18, 2023

Accounts Payable is an important module not only in Sage 300 ERP but also in different ERP’s. It deals with the Vendor side transactions. Having your all pending bills track along with regular payment processing helps us to keep track of funds available with us as well it helps maintaining good business relation with the vendors.

It may be possible for trading business or organizations which outsource services will have many AP invoices to be paid or credited daily basis. To create such large no. of payment and/or credit note entries will be time consuming and also can be error prone job if executed manually. In this blog we are going to discuss regarding the utility which we have developed for one of our client with name “AP Payment and Credit Note Creation”.

New Stuff :- COM Components: Accpac FieldEdit Control.

We came up with this solution to reduce the effort and time to make such large no. of entries where the basic process what user follows is just pays the balances or makes the credit note against invoices. The utility allows user to view the Invoices based on their aging range. On selection from invoices from different batches utility creates either Payment batch or Credit note batch as per user preference. Please find below screenshot of the utility for your reference:

APCreation_1

Let’s look at it’s some fascinating features:

  • Bank Selection: It allows user to specify bank for payments. Default Bank Account for Payment Entry Screen will be set by default which user can change.
  • Batch Date: User can set the date with which Payment or Credit Note batch will be created. By default, it will bring session date as value for batch date.
  • Batch Description: Entered batch description will get linked to the created batch.

Workflow:

  1. The invoice for which user want to make Payment/Credit-Note entry, user have to select the check box for that Invoice entry.
  2. If user want to make the partial payment go-to “AppliedAmt” column and entered the amount for which user want to make payment.
  3. Now select Create Payment/CreditNote button for creating the entries.
  4. It creates AP Payment Entries or Credit Notes entries based on selection.

Note: All the entries generated will be created in single batch. We can make changes to consider user preference.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce(listed on Salesforce Appexchange), Dynamics 365 CRM, 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 and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ add-ons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading, and VAT for the Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with an easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.