Opening Outstanding
Introduction
Import for invoice and bills for members and vendors during inception of System.
Mandatory Fields
Import Features
| Import Fields |
|---|
| Ind - Ind should be only one character either M - Member or V - Vendor. |
| Document Type - I - Invoice, R - Receipt, B - Bill, P - Payment, J - Journal Voucher, D - Debit Note, C - Credit Note |
| Ref Doc Type. - SI - Sales Invoice, PB - Purchase Bill, OA - On Account Receipt, AD - On Advance Payment - Ref Doc should be SI for I and C doctype - Ref Doc should be PB for B and D doctype |
| Ref No - Refno should be 6 characters only |
| Ref Date - Ref Date should be in dd-MMM-yy format only Ref Date Cannot be greater than the Doc Date |
| Due Date - Due Date should be in dd-MMM-yy format only. |
| Main A/c - Main A/c should be 6 characters only - Invalid Main A/c or Sub/Ac For Vendor/Member - Duplicate Main A/c and Sub A/c |
| Sub A/c - Sub A/c should be 6 characters only |
| Doc No - Doc No should be 6 characters only |
| Doc Date - Doc Date should be in dd-MMM-yy format only |
| Debit/Credit - should be only one character either D - Debit or C - Credit. |
| Amount. - Amount should be 1 to 9999999.99. |
| Notes - Notes should be upto 200 characters only. |
Features
| Features |
|---|
| Import |
| Delete All |
| Export To Excel - To download the report of Opening Outstanding |