Don't get lost: IMan Guides » Sage 300 User Guide » Supported Import Types » Common Services

Common Services

Back To Top

Bank Entries

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Writeback Fields

BK0450.SEQUENCENO Sequence Number
BK0450.ENTRYNBR Auto-generated entry number
BK0450.LINES The number of lines in the entry

Implementation Notes

Posting

To post the entry set the ‘Post Entry’ (POSTENTRY) field to True.

Back To Top

Bank Reversals

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Implementation Notes

Process Bank Code (PBANK)

The bank of the original entry.

Process Source Application (PBANK)

The module of the original entry. Please consult the Sage300 Object Model for each of the values.

Payor Code (PAYORID)

The vendor/employee id of the original entry.

Remittance ID (IDREMIT)

The id of the original document.

Back To Top

C/S Exchange Rates

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Implementation Notes

To facilitate easier import, the CS0005 and CS0006 views have been combined and flattened. This is converse to the Sage300 implementation where exchange rates are implemented as a header-detail view.

Back To Top

T/X Tax Entries

Views/Record Types Supported

All

Update

Insert only

Limitations

None

Implementation Notes

Manually adding tax entries can assist with some imports, particularly if those entries are entered directly into the G/L.

If importing a type of entry (e.g. G/L Journals) in addition to Tax Entries it is recommended to create the first entry type first, filter any erroneous before creating the Tax Entries. In this configuration the Tax Entries will be ‘insynch’ with the entries posted in the first entry type.