The resulting batch may be posted by setting the ‘Post Created Batch’ (POSTCREATEDBATCH) field to one of the following values.
Value
Notes
0
Do not post the batch.
1
Post the batch if there are no errors during batch creation.
2
Post the batch irrespective of any errors. The batch will only be posted if the Error Action has been set to either Reject Record or Continue; when set to Abort the batch will not be posted.
Entry record can be either A/R Invoice Header (AR0032) or A/R Invoice Batch (AR0031).
Distributing Tax
Tax can be distributed using the invoice header over the detail lines as per the Distribute Tax button found on the Tax tab of the user interface. To distribute tax set the following fields with respective values:
Field
Description
Value
SWMANLTX
Tax Override
1
DISTTAXES
Distribute Taxes Over Details
True
Batch Posting
The resulting batch may be posted by setting the ‘Post Created Batch’ (POSTCREATEDBATCH) field to one of the following values.
Value
Notes
0
Do not post the batch.
1
Post the batch if there are no errors during batch creation.
2
Post the batch irrespective of any errors. The batch will only be posted if the Error Action has been set to either Reject Record or Continue; when set to Abort the batch will not be posted.
Prepayments
Prepayment Made Against Invoice (SWPREPAY)
When True a prepayment will be made against the invoice. When a prepayment is made against the invoice the following fields are processed:
Field Id
Name
Description
PPARBTCHAPPEND
(Optional)
Append Prepayment To Existing Batch
Specifies if the prepayment should be appended to an existing open A/R Receipt Batch. If a batch cannot be found matching the criteria a new A/R Batch will be created.
1
Append to Batch Per Day By Description - The prepayment will be appended to the first open batch with the same description which has a batch date of the day of import.
2
Append to Batch Per Day By Bank - The prepayment will be appended to the first open batch with the same bank which has a batch date of the day of import.
3
Append to Batch By Description - The prepayment will be appended to the first open batch with the same description.
4
Append to Batch By Bank - The prepayment will be appended to the first open batch with the same bank code.
PPBANKCODE
(Mandatory)
Bank Code
The bank to which the deposit is made.
PPARBTCHDESC
(Optional)
A/R Receipt Batch Description
When not specified the A/R Receipt Batch Description defaults to:
“A/R Invoice Prepayment”
PPBANKCURN
(Optional)
Bank Currency
The default batch currency.
PPDEPSTNBR
(Optional)
Deposit Number
PPDEPDATE
(Optional)
Deposit Date
PPDEPCOMMENT
(Optional)
Deposit Comment
PPDATERMIT
(Optional)
Receipt Date
PPDATEBUS
(Optional)
Posting Date
PPTEXTPAYOR
(Optional)
Payor
PPTEXTRMIT
(Optional)
Entry Description
PPTXTRMITREF
(Optional)
Entry Reference
PPCODEPAYM
(Optional)
Payment Code
PPIDRMIT
(Optional)
Check/Receipt No.
PPBANKRATE
(Optional)
Bank Rate
The Bank Rate
PPCHECKDATE
(Optional)
Check Date
The deposit date.
PPAMTRMIT
(Mandatory)
Receipt Amount
The receipt amount.
PPCODECURNBC
(Optional)
Receipt Currency
PPDATERATETC
(Optional)
Customer Rate
PPDATERATETC
(Optional)
Customer Rate Date
PPRATETYPETC
(Optional)
Customer Rate Type
PPCHECKNUM
(Optional)
Check/Receipt Number
This is a writeback field, but may also be specified.
PPDOCNBR
(Optional)
Receipt Document Number
Writeback field to capture A/R Prepayment Document Number
Deleting Empty/Erroneous Batches
If an error occurs during the creation of a batch OR if the batch is empty i.e. has no entries, the batch can be deleted by setting the 'Delete Empty/Erroneous Batch' (DELEMPTYBATCH) to '1'.
Tax can be distributed using the invoice header over the detail lines as per the Distribute Tax button found on the Tax tab of the user interface. To distribute tax set the following fields with respective values:
Field
Description
Value
SWMANLTX
Tax Override
1
DISTTAXES
Distribute Taxes Over Details
True
Updating Recurring Invoices
When updating an existing recurring charge, set the Customer & Recurring Charge fields.
To update an existing line it is necessary to identify or matched to the line being updated. This is achieved by setting the either the CNTLINE or IDDISTCODE fields.
To control which should be used for matching the ‘Line Match Method’ (MATCHMTD) field controls how the lines are matched.
Field Id
Line Match Method Value
Notes
Line Number (CNTLINE)
(Default)
0
The value may be obtained either at the time the Recurring Invoice is created, or via a lookup against the Recurring Charge Details.
Distribution Code
(IDDISTCODE)
1
When matching by distribution code, ensure there are no duplicate distribution codes in the recurring charge. When duplicate distributions are present only the first one is updated.
Document Number (Set when document is auto-numbered)
Implementation Notes
All forms of receipts (Applied, Prepayment, Unapplied & Miscellaneous) may be created. To set the receipt type, change the AR0042.RMITTYPE field as per the AOM.
Batch Posting
The resulting batch may be posted by setting the ‘Post Created Batch’ (POSTCREATEDBATCH) field to one of the following values.
Value
Notes
0
Do not post the batch.
1
Post the batch if are no errors during batch creation.
2
Post the batch irrespective of any errors. The batch will only be posted if the Error Action has been set to either Reject Record or Continue; when set to Abort the batch will not be posted.
Deleting Empty/Erroneous Batches
If an error occurs during the creation of a batch OR if the batch is empty i.e. has no entries, the batch can be deleted by setting the 'Delete Empty/Erroneous Batch' (DELEMPTYBATCH) to '1'.
This allows A/R Statements can be printed or exported.
Statements are generated one customer at a time, which is specified by the IMan dataset. The statement print does not give you the possibility to print a range of statements like you can through the UI.
Views/Record Types Supported
N/A
Update
Create only
Limitations
Letter/Label printing is not supported.
Writeback Fields
None
Implementation Notes
Field
Description
Print Invoice
When set to true will print the report to the specified printer.
Printer Name
The name of the locally installed printer. The printer cannot be a network printer.
Export File Path
The file to export the report to.
Invoice Form
The Crystal Report form.
Customer
The customer id (or national account) to print the statement for.
Run Type
Set to 0 for Customer Statements (default) and 1 for National Accounts.
Remaining Fields
Are used to specify the other parameters used to generate the statement.
