FAQ for the Sage Construction Management integration with Sage 300 Construction and Real Estate

How many Sage 300 Construction and Real Estate data folders can one instance of Sage Construction Management connect to with the AccountingLink?

Each Sage 300 Construction and Real Estate data folder will require their own Sage Construction Management instance. If one data folder is used with multiple GL prefixes, you will only need one Sage Construction Management tenant.

 

How can I get the AccountingLink for Sage 300 Construction and Real Estate?

You can purchase the AccountingLink for Sage 300 Construction and Real Estate at an additional cost.

 

Are any installations required for the AccountingLink for Sage 300 Construction and Real Estate?

Yes, our integration is leveraging the APIs built by hh2. The hh2 Sync Client will need to be installed and configured before the AccountingLink will work.

 

How long does it take for data to become available for any manual data pulling?

The hh2 Sync Client has different configurable sync options that will determine how often the data is transferred between each system. It may up to 5 minutes for the quickest option because updates have to go from Sage Construction Management to hh2 Sync Cloud Services to hh2 Sync Client to ERP or vice versa.

 

How will formats in Sage Construction Management be forced to match the required formats in Sage 300 Construction and Real Estate?

We don’t have a way to query the custom formats in the legacy ERPs so these formats will need to be matched manually in Sage CM. If they don’t match formatting, there will be expected issues when sending data with the wrong format (Jobs, Commitments, etc.)

 

Is there any integration mapping between the Sage CM payment terms and the payment terms in Sage 300 Construction and Real Estate?

No, we do not have a way to map the payment types now so payment terms should be set up manually to match in each system. Payment terms need to be manually setup on Vendors and Customers.

 

Are there any issues with the hh2 APIs if a Replicator is used for Sage 300 Construction and Real Estate?

There shouldn't be any issues. If you have under resourced hardware or potentially large data sets, having both data syncs running simultaneously may put more load on your hardware and result in a change in performance. Deltas are used to minimize this. For large datasets, a Replicator can be used to pull an offline data cache for reporting.

 

When sending over costs through the APIs, will I need to post those within each module and then also post again in Job Cost?

The only endpoint that can post the transaction is the new Job Cost Commitment ones which we can turn on for your test environments and customers. Apart from that, user settings for posting controls are going to dictate the posting behavior.

AP Invoices created through the platform will need to be posted by the user in Accounts Payable. That posting process will create unposted transactions in Job Cost and General Ledger. Depending on posting settings in AP, those General Ledger and Job Cost transactions will either automatically post or the user will need to manually post them in their respective modules.

Direct Cost entries created via the platform will need to be manually posted in Job Cost.

 

Is there any hh2 API that will handle posting Job Costs automatically?

Only the new API for Commitments is there an ability to remotely post the transactions. The control associated with posting would typically be batch numbers and most of the methods we use to get the data into Sage does not provide a response where we can grab the batch numbers for data feeds. The only case where Job Cost Transactions will be automatically posted would be Committed Cost transactions created as a result of creating Commitments via the Commitment API. In all other cases, Job Cost Transactions must be posted by the user. This would include the following types of transactions:

  • Original Estimates

  • Approved Estimate Changes

  • Approved Scheduled Value Changes (OCOs)

  • Direct Costs

  • Misc Worksheet Entries

 

How will the hh2 integration work when using transaction files?

Named files are not supported. If you have named files enabled for a given type of transaction file, we can specify a single specific file name that we would sync data from. This applies to the following file types only:

  • PR Master

  • PR System

  • PR Transaction

  • JC Transaction

Note: For all other types, we do not provide any name configuration.

 

Can I export Labor Timecards from Sage Construction Management and import them in Sage 300 Construction and Real Estate?

Yes, you can export Labor Timecards in .CSV format using the Time & Expenses module in Sage Construction Management.

See Export Labor Timecards from Sage Construction Management and Import Them in Sage 300 Construction and Real Estate for more details.