| 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" |
|