Reverse Transactions – Receipt Reversal Transaction in SAGE 300 ERP

By | November 18, 2013

Posted receipts cannot be edited in any ERP. SAGE 300 ERP allows you to reverse them to correct errors.

One might need to reverse a receipt when his customer stops payment on a receipt or if a receipt comes from an account with non-sufficient funds or check no. mentioned in receipt was wrongly entered or if receipt is made against another customer or so on.
When we do receipt reversal in SAGE 300 ERP that was entered in Accounts Receivable, Bank Services automatically updates the customer account in Accounts Receivable.

For an e.g. firstly let’s have a look on the Bank Book Balance. Then after making Receipt entry we can analyze the Bank Book Balance and see the impact. Untitled

Now let’s post the A/R Receipt entry of 1,000 USD (US Dollars) and the payment method is “Check”.

Receipt Entry

Now you can see the impact of A/R Receipt entry on the Bank Book balance in SAGE 300 ERP. Untitled

A Deposit is increased by 1,000 USD and now it is 8,695.99 USD.
A Current Balance is also increased by 1,000 USD and now it is 9,696.99 USD.

Reverse Transactions (Receipt Reverse):
You can see below the example of Reverse Transaction for A/R Receipt (Accounts Receivable) against the customer.

Reverse transaction

After selecting the Bank Code, Source Application, Reversal Date, Customer posts the entry.
After this your Bank Book and Bank GL balance both will be reduced.

Just with a few clicks the Receipt Reversal entry will be generated in SAGE 300 ERP, here no need to pass the manual entry for making Reverse Receipt.

New Stuff: Standard cost functionality in Sage 300 ERP
Now we can see the impact and verify the Bank Book Balance, Bank GL Balance and Vendor Balance one by one.

Bank Book Balance Status after A/R Receipt Reverse Transaction:
In below box you can identify the Bank Book Balance.Untitled

A Deposit is remaining same but Withdrawal is increased by 1,000 USD and Current Balance is decreased by 1,000 USD.

G/L Effect of Payment Reversal Transaction in SAGE 300 ERP

Effect of Payment Reversal on Bank GL Balance in SAGE 300 ERP:

Transaction Listing

Here we can see the selected part in the report out of which second is the A/R Receipt Entry of 1,000 which is on debit side.
The first is the Reverse Entry of the A/R Receipt of 1,000 which is on credit side. 

Effect of Payment Reversal on Vendor Balance in SAGE 300 ERP:

Customer transaction

We can see the selected part in the report out of which second is the A/R Receipt Entry of 1,000 which is in positive (debit).
The first is the Reverse Entry of the A/R Receipt Entry of 1,000 which is in negative (credit); one more thing you can see is before Receipt No. R is added as a prefix which indicates the Reverse Transaction.

SAGE 300 ERP takes care of both your bank as well as your accounting. It reduces the manual efforts of an end user thus making a payment reversal process automated through the SAGE 300 ERP.

Through the reference of G/L Transaction Listing Report and A/R Customer Transaction Report we can come on conclusion that our Bank GL and Vendor Balance are also properly affected. After posting Receipt Reversal transaction, system automatically affects the accounting in SAGE 300 ERP.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 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 and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

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