<& /elements/header.html, 'Batch Credit Import' &>
Import a file containing credits.
<& /elements/form-file_upload.html,
'name' => 'CreditImportForm',
'action' => 'process/cust_credit-import.cgi',
'num_files' => 1,
'fields' => [ 'format', '_date', 'credbatch' ],
'message' => 'Credit import successful',
'url' => $p."search/cust_credit.html?credbatch=$credbatch",
'onsubmit' => "document.CreditImportForm.submitButton.disabled=true;",
&>
<% &ntable("#cccccc", 2) %>
<& /elements/tr-input-date-field.html, {
'name' => '_date',
#'value' => '',
'label' => 'Date',
}
&>
<% include( '/elements/file-upload.html',
'field' => 'file',
'label' => 'Filename',
)
%>
|
|
Uploaded files can be CSV (comma-separated value) files or Excel spreadsheets. The file should have a .CSV or .XLS extension.
Default format has the following field order: custnum, amount, reasonnum, invnum, agent_custid
Field information:
- custnum: This is the freeside customer number. It may be left blank. If specified, agent_custid must be blank.
- amount:
- reasonnum: Credit reason
- invnum: Invoice number
- agent_custid: This is the reseller's idea of the customer number or identifier. It may be left blank. If specified, custnum must be blank.
<% include('/elements/footer.html') %>
<%init>
die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('Import');
my $credbatch = time2str('webimport-%Y/%m/%d-%T'. "-$$-". rand() * 2**32, time);