In the ‘Enter Cash Receipts’ task of MAS 500, the ‘Write-Off’ check box field is enabled if the new balance of the invoice is less than the maximum write off limit defined in Set Up AR Options. When we tick the ‘Write-Off’ field, the system will write-off the new balance of that invoice. In this case, system uses the General Ledger account defined in the customer class associated with the invoice/customer to record the write-off. So currently, the user can write-off the new balance using one General Ledger Account.
We at Greytrix have enhanced this functionality, so that the user can write-off the balance of an invoice against multiple General Ledger Accounts.
We have provided a ‘Write-Off Details’ button on ‘Enter Cash Receipts’ task as shown in the below screenshot.
The ‘Write-Off Details’ button is synchronized with ‘Write-Off’ field i.e., when the ‘Write-Off’ field is disabled the ‘Write-Off Details’ button is also disabled and vice-versa.
Upon clicking of ‘Write-Off Details’ button the ‘Enter Write Off G/L Account’ screen will appear as shown in the below screenshot.
On the ‘Enter Write Off G/L Account’ screen, user can select a GL Account and enter a write-off amount that will be applied against that GL Account. User can see the ‘New Balance’ amount (came through ‘New Balance’ field located in ‘Enter Cash Receipts’) in the ‘Write Off Amount’ textbox. There is also a textbox ‘WriteOff Total’ to show the total amount entered by user till now. The value at ‘WriteOff Total’ textbox should match with the value of ‘Write Off Amount’ textbox to proceed.
On the ‘Enter Cash Receipts’ screen when the user ticks the ‘Write-Off’ field and details are entered in the screen ‘Enter Write Off G/L Account’ then the write-off amount will be applied against the specified GL Account No.
On the ‘Enter Cash Receipts’ screen when the user ticks the ‘Write-Off’ field but no details are entered in the screen ‘Enter Write Off G/L Account’ then the standard functionality of MAS 500 will be used.
Thus the modification will be such that the user can use the standard functionality as well as the enhanced functionality.
If you think you would be benefited from this utility, feel free to contact us at sage@greytrix.com.
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 100 integration with Sage CRM, and Salesforce.com along with Sage 100 Migration from Sage 50 US, Sage Intacct, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.
For more details on Sage 100 Services, please contact us at sage@greytrix.com. We will be glad to assist you.