Skip to main content

How Account Terms Sync from Sage 200 to Weighsoft

Explains how Weighsoft matches and syncs Account Terms from Sage 200, including the manual setup required in Lookups > Account Terms to link the two systems.

N
Written by Noel

Weighsoft can sync Account Terms from Sage 200, but the link between the two systems is not populated automatically. An administrator must manually configure each Weighsoft Account Term so that it matches the corresponding payment term in Sage 200.

How the matching works

When an account is sync'd from Sage to Weighsoft, the system looks for a Sage 200 Payment Term ID and number of days match a record in Lookups>Account Terms. Specifically, the sync matches on:

  • Sage 200's payment terms basis ID (the "syspaymenttermsbasisid" column in the Sage 200 database) against the Weighsoft Account Term's "Finance Package Identifier" field

  • Sage 200's payment terms days value against the Weighsoft Account Term's "Days" field

If no matching Account Term is found in Weighsoft, the sync will not update that account's terms.

Setting up the link

  1. Identify the payment terms basis ID used in Sage 200 for each term you want to sync. Sage 200 has four basis ID options: 0 = Calendar Monthly, 1 = From Start of Month, 2 = From End of Month, 3 = From Document Date.
    ​

  2. In Weighsoft, go to Administration > Lookups > Account Terms.

  3. For each Account Term entry, set the "Finance Package Identifier" (also referred to as "Finance Term Id") field to the matching Sage 200 basis ID.

  4. Ensure the "Days" field on that Account Term matches the number of days configured against the corresponding term in Sage 200.

  5. Repeat for each Account Term that should sync from Sage 200.

Example: In Sage 200, select basis ID 2 and enter the matching number of days against the customer account.
During the next sync, Weighsoft will find the Account Term with Finance Package Identifier = 2 (From end of month) and the matching Days value, and apply it to the account.
​

Finding the Sage 200 payment terms basis ID

Weighsoft support does not have access to a customer's Sage 200 database and cannot retrieve these IDs directly. A customer's IT team or Sage 200 partner can look up the "syspaymenttermsbasisid" column on their own Sage 200 database to confirm the basis ID values in use.

If the Finance Package Identifier field is left blank

If an Account Term's Finance Package Identifier field is not set, the sync cannot find a match for that term. Behaviour differs depending on your Weighsoft version:

  • From version 5.538 up to 5.544: if the sync could not find a match, it wrote a value of 0 or NULL into the account, overwriting any existing terms with the system default.

  • From version 5.544 onwards: if the sync cannot find a match, it leaves the account's existing terms unchanged rather than overwriting them.

Until the Finance Package Identifier fields are populated to match Sage 200, Account Terms will not sync, and terms on newly created accounts will instead refer to the Default Account Terms found in Administration>General>New Account/Address Defaults

Did this answer your question?