Importing New Records - Vendor Credits
Follow the steps for Importing New Records

Field Required Type Sample Value Notes
Vendor_Credit_Memo_Id No Key Id Field "123"  
Vendor_Id Yes, unless lookup fields are used to identify the vendor Identifier "456" Must match an existing Vendor Id in the system
Vendor_Name No, unless Vendor_Id is not specified Lookup "ABC Supplies" Must match an existing Vendor name in the system
Name_On_Credit_Memo No Text "John Doe"  
Credit_Memo_Date Yes Date "2024/02/01"  
Entered_Date Yes Date "2024/02/02"  
Printed_Date No Date "2024/02/03"  
Credit_Memo_Amount Yes Decimal "1500.75"  
Credit_Memo_Method Yes Datasource Data "Bank Transfer" Must match an existing credit memo method in the system
Credit_Memo_Number No Text "CM-98765"  
Credit_Memo_Account_Id Yes, unless lookup fields are used to identify the credit memo account Identifier "789" Must match an existing Credit Memo GL Account Id in the system
Credit_Memo_Account_Number No, unless Credit_Memo_Account_Id is not specified Lookup "1-00-00-4165-125" Must match an existing Credit Memo GL Account number in the system
Credit_Memo_Memo No Text "Refund for overpayment"  
Internal_Memo No Text "Handled by accounting dept."  
Posted_Date No Date "2024/02/05"  
Voided_Date No Date "2024/02/06"  
Void_Comment No Text "Duplicate entry"  
Credit_Memo_Classification_Id No, unless your school uses classifications Identifier "789" Must match an existing Classification Id in the system
Credit_Memo_Classification_Name No, unless your school uses classifications and Credit_Memo_Classification_Id is not specified Lookup "General Admin" Must match an existing Classification Name in the system
Ap_Account_Id1 Yes, unless lookup fields are used to identify the AP account Identifier "123" Must match an existing AP Account Id in the system
Ap_Account_Number1 No, unless Ap_Account_Id is not specified Lookup "1-00-00-4165-125" Must match an existing AP Account number in the system
Ap_Account_Amount1 Yes Decimal "1500.75" Must sum to credit memo amount
Ap_Classification_Id1 No, unless your school uses classifications Identifier "456" Must match an existing AP Classification Id in the system
Ap_Classification_Name1 No, unless your school uses classifications and Ap_Classification_Id is not specified Lookup "General Admin" Must match an existing AP Classification Name in the system
Vendor_Invoice_Id1 No Identifier "123" Must match an existing Vendor Invoice Id in the system
Amount1 No Decimal "625.50"

Notes: All Ap fields are repeated 4 more times (for a total of 5 potential Ap credits).
Vendor_Invoice_Id and Amount are repeated 9 more times (for a total of 10).

See also

Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
    School Name *
    Relation to School *
    select
    Last Name *
    Your First Name *
    Your Email *
    Your Phone # *
    PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.