accounts receivable

 

A/R Adjustments

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Writeback Fields

AR0041.CNTBTCH Batch Number
AR0041.CNTENTER Batch Entry Count
AR0041.ENTRYTOT Total of Entries
AR0042.CNTBTCH Entry Batch Number
AR0042.CNTITEM Entry Number

Implementation Notes

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.

A/R Comment

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

A/R Customer

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

A/R Invoice

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Writeback Fields

AR0031.CNTBTCH Batch Number
AR0031.CNTINVCENT Batch Entry Count
AR0031.AMTENTR Batch Total
AR0032.CNTBTCH Entry Batch Number
AR0032.CNTITEM Entry Number
AR0032.IDINVC Document Number (Set when is auto-numbered)
AR0033.CNTBTCH Entry Detail Batch Number
AR0033.CNTITEM Entry Detail Entry Number
AR0033.CNTLINE Entry Detail Line Number

Implementation Notes

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'.

Value

Notes

0

Do not delete the batch.

1

Delete the batch.

A/R Invoice Print

This allows A/R invoices & credit notes to be printed to either a local printer or exported to file.

Views/Record Types Supported

N/A

Update

Create only

Limitations

None

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.

Batch Number & Batch Entry

When populated will print the invoice using the batch and entry numbers.

Customer & Invoice

When populated will print the invoice using customer and invoice numbers.

A/R Item (Setup)

Views/Record Types Supported

All

Update

Insert & Update

Limitations

None

A/R National Accounts

Views/Record Types Supported

All

Update

Insert /Update

Limitations

None

A/R Recurring Invoice

Views/Record Types Supported

All

Update

Insert & Update

Limitations

None

Writeback Fields

AR0047.CNTLINE Line Number

Implementation Notes

Taxes

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.

A/R Receipt

Views/Record Types Supported

All

Update

Insert only

Limitations

No Project and Job Costing Support

Writeback Fields

AR0041.CNTBTCH Batch Number
AR0041.CNTENTER Batch Entry Count
AR0041.FUNCAMOUNT Batch Functional Total
AR0042.CNTBTCH Entry Batch Number
AR0042.CNTITEM Entry Number
AR0042.DOCNBR 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'.

Value

Notes

0

Do not delete the batch.

1

Delete the batch.

A/R Refund

Views/Record Types Supported

All

Update

Insert only

Limitations

No Project and Job Costing Support

Writeback Fields

AR0140.CNTBTCH Batch Number
AR0140.CNTENTER Batch Entry Count
AR0140.ENTRYTOT Total of Entries
AR0141.CNTBTCH Entry Batch Number
AR0141.CNTITEM Entry Number
AR0141.IDINVC Document Number (Set when refund is auto-numbered)
AR0142.CNTBTCH Entry Detail Batch Number
AR0142.CNTITEM Entry Detail Entry Number
AR0142.CNTLINE Entry Detail Line Number

Implementation Notes

Entry record can be either A/R Refund Batch (AR0140) or A/R Refund Header (AR0141).

A/R ShipTo Address

Views/Record Types Supported

All

Update

Insert/Update

Limitations

None

A/R Statement Print

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.