RSM InTime A/R Invoice to Sage Intacct A/P Bill
First published on: 07/15/2025/7:19 pm
Workflow Summary
- The workflow will scan RSM InTime at regular intervals and retrieve details of A/R Invoices that have been finalized.
- Retrieve RSM InTime A/R Invoice and create A/R Bill invoices in Sage Intacct.
Workflow Description
At configurable intervals, the workflow queries RSM InTime to retrieve all new A/R Invoices since the previous execution. For each retrieved Invoice, a corresponding A/R Invoice is generated in Sage Intacct through the following process:
-
Check for every invoice if the corresponding object (Customer, Project) exists in Sage Intacct. Only create the object when it doesn’t exist. Updates on invoices in InTime shouldn’t happen, and therefore no updates will be done in Intacct.
-
Once the object is created in Sage Intacct, call the “markInvoiceAsExported”-method to mark the invoice as exported in InTime, supplying the authentication token, entity type equals “Reckoning” and the current date/time.
Mapping
The following mapping will be applied:
Creating A/R Invoice:
|
RSM InTime (A/R Invoice) |
Sage Intacct (A/R Invoice) |
Hardcoded Values / Comments |
|---|---|---|
|
Company.accountsRef |
Customerid |
Customer ID |
|
|
datecreated |
Transaction date |
|
YEAR(InvoiceInfo.invoiceDate) |
year |
Year yyyy |
|
MONTH(InvoiceInfo.invoiceDate) |
month |
Month mm |
|
DAY(InvoiceInfo.invoiceDate) |
day |
Day dd |
|
|
dateposted |
GL posting date |
|
YEAR(InvoiceInfo.invoiceDate) |
year |
Year yyyy |
|
MONTH(InvoiceInfo.invoiceDate) |
month |
Month mm |
|
DAY(InvoiceInfo.invoiceDate) |
day |
Day dd |
|
|
datedue |
Due date. Required if not using termname. |
|
YEAR(InvoiceInfo.dueDate) |
year |
Year yyyy |
|
MONTH(InvoiceInfo.dueDate) |
month |
Month mm |
|
DAY(InvoiceInfo.dueDate) |
day |
Day dd |
|
|
termname |
Payment term. Required if not using datedue. |
|
|
batchkey |
Summary RECORDNO Only include element when creating. |
|
“submit” |
action |
Action. Use Draft or Submit. (Default: Submit) |
|
InvoiceInfo.invoiceNumber |
invoiceno |
Invoice number |
|
InvoiceInfo.purchaseOrderNum |
ponumber |
Reference number |
|
|
description |
Description |
|
|
externalid |
External ID |
|
|
billto |
Bill to contact |
|
|
contactnam |
Bill to contact name |
|
|
shipto |
Ship to contact |
|
|
contactnam |
Ship to contact name |
|
|
basecurr |
Base currency code |
|
InvoiceInfo.currency |
currency |
Transaction currency code |
|
|
exchratedate |
Exchange rate date. |
|
|
year |
Year yyyy |
|
|
month |
Month mm |
|
|
day |
Day dd |
|
|
exchratetype |
Exchange rate type. Do not use if exchrate is set. (Leave blank to use Intacct Daily Rate) |
|
|
exchrate |
Exchange rate value. Do not use if exchangeratetype is set. |
|
“false” |
nogl |
Do not post to GL. Use false for No, true for Yes. (Default: false) |
|
|
customfields |
Custom fields |
|
|
customfield |
|
|
|
customfieldname |
Custom field ID |
|
|
customfieldvalue |
Custom field value. For a multi-pick-list custom field, implode multiple field values with #~#. |
|
“VAT” |
taxsolutionid |
Tax solution name, such as United Kingdom - VAT or Australia - GST. Required only if the company is configured for multiple tax jurisdictions and the transaction is occurring at the top level of the company. The available tax solution names can be found in the Sage Intacct UI in the Taxes application from the top level of a multi-entity company. (GB, AU, and ZA only). |
|
|
Invoiceitems |
Invoice lines, must have at least 1. |
|
|
lineitem |
|
|
|
accountlabel |
AR account label. Required if not using glaccountno. |
|
|
offsetglaccountno |
Offset GL account number |
|
InvoiceLineInfo.net |
amount |
Transaction amount |
|
Placement.purchaseDivision |
allocationid |
Allocation ID |
|
InvoiceLineInfo.description |
memo |
Memo |
|
Placement.purchaseBranch |
locationid |
Location ID |
|
Placement.purchaseDepartment |
departmentid |
Department ID |
|
|
key |
Key |
|
|
totalpaid |
Total paid. Used when nogl on bill is true |
|
|
totaldue |
Total due. Used when nogl on bill is true |
|
|
customfields |
Custom fields |
|
|
customfield |
|
|
|
customfieldname |
Custom field ID |
|
|
customfieldvalue |
Custom field value. For a multi-pick-list custom field, implode multiple field values with #~#. |
|
|
revrectemplate |
Rev rec template ID |
|
|
defrevaccount |
Deferred revenue GL account number |
|
|
revrecstartdate |
Rev rec start date |
|
|
year |
Year yyyy |
|
|
month |
Month mm |
|
|
day |
Day dd |
|
|
revrecenddate |
Rev rec end date |
|
|
year |
Year yyyy |
|
|
month |
Month mm |
|
|
day |
Day dd |
|
Placement.purchaseProject |
projectid |
Project ID |
|
Placement.purchaseLocation |
taskid |
Task ID. Only available when the parent projectid is also specified. |
|
Placement.purchaseCostCentre |
costtypeid |
Cost type ID. Only available when projectid and taskid are specified. (Construction subscription) |
|
Company.accountsRef |
customerid |
Customer ID |
|
|
vendorid |
Vendor ID |
|
|
employeeid |
Employee ID |
|
|
itemid |
Item ID |
|
|
classid |
Class ID |
|
|
contractid |
Contract ID |
|
|
warehouseid |
Warehouse ID |
|
|
taxentries |
Tax entries for the line. Required for VAT enabled transactions. Providing multiple entries is allowed if your tax solution supports it (AU and GB only). For ZA, only one tax entry is allowed. |
|
|
taxentry |
|
|
Lookup based on InvoiceLineInfo.vatCode and InvoiceLineInfo.vatRate |
detailid |
Unique ID of a tax detail with the tax rate to use |
|
InvoiceLineInfo.vat |
trx_tax |
Transaction tax, which is a manually calculated value to override the calculated value for the tax. The amount of the tax line is automatically included in the amount due (TOTAL_DUE) for the invoice. |
|
|
|
|
|
Last modified: 07/17/2025/2:04 pm |