Receipt Import

Sage300 A/R Receipt Import (SAMACCARRCP)

This imports A/R Receipts from a CSV file into Sage300 as an A/R Receipt batch.

The receipts are a mixture of applied receipts and prepayments, where the determination of the receipt type is based on the data in the file.

The integration has the flow of:

  1. Read
  2. Hierarchy
  3. Map
  4. Connector

Read

Pulls data from the CSV file.

Hierarchy

Transforms flat dataset into a hierarchical one consisting of three levels:

  1. Receipt batch (Receipts)
  2. Receipt header (Receipt)
  3. Receipt details (Allocation).

Map

Adds some fields (Bank, Description, Batch Total, Batch Count & Batch Number) into the Receipt Batch (Receipts) transaction type so IMan is then able to specify and capture those details.

The ReceiptType field in the receipt header (Receipt) transaction uses a formula based on the value of Memo field to determine if a receipt is a prepayment or applied receipt.


The ReceiptAmount field in the receipt header (Receipt) calculates the total of the receipt using the Sum function. The total is then used to set the Receipt Total field in Sage300.

Connector

Maps the data into Sage300.