Archive

Posts Tagged ‘replication rules’

Basic set up need to process cross site payments

April 26th, 2014 No comments

Syteline multi-site supports centralized AR payment process.  Here are the basic set-up steps

1.  Site Groups

Create a site group that contains all sites that will be sharing cross-site A/R Payments

NOTE:  All sites within the group must have the same domestic currency

2.  Replication Rules

Set up Replication Rule for category A/R for each site within the Site Group

Interval Type = Transactional

3.  Inter-Site Parameters

Add record for all From Site/To Site combinations

Populate Inter-Site Accounts on Payment Tab

4.  Accounts Receivable Parameters

Populate the Site Group field

Once the Basic Set-Up has been performed, you should be able to see invoices from all sites within the Site Group in the A/R Quick Payment Application grid.   However, Open Credits from remote sites will not appear in the A/R Quick Payment grid.   Those credits should be applied to invoices in remote site prior to entering payment in Payment site.

Example of journal entries for cross-site payment posting:

Three sites exist for Entity XYZ. Site A is designated as the centralized collection site where all customer payments are collected. If Site A receives a $300 payment from a customer to pay 3 invoices, each from a different site, the following journal entries must occur.

  1. Invoice customer – $100 from each entity.
Site A transactions: Debit Credit
A/R $100
Sales $100
Site B transactions: Debit Credit
A/R $100
Sales $100
Site C transactions: Debit Credit
A/R $100
Sales $100
  1. Post payment of $300 – distribute $100 to each entity.
Site A transactions: Debit Credit
Cash $300
A/R $100
Inter-Site Liab (Entity B) $100
InterEntity Liab (Entity C) $100
Site B transactions: Debit Credit
InterEntity Asset $100
A/R $100
Site C transactions: Debit Credit
InterEntity Asset $100
A/R $100

NOTE: To reverse the inter-site transactions; each site will create a manual entry when corporate pays cash to the sites.

Add, Change Multi-Sites Replication Rules

January 6th, 2014 No comments

There is simple three steps process for adding/changing replication rules in Syteline.

1) Add/Edit rules in Replication Rules form

Notes: you setup all rules for source site in source site DB.

2) Regen trigger

Open “Replication Management” form,

Regen the replication trigger.

This will make the trigger program in place to replicate transactions from now on.

3) Run the Manual Replication Utility

This will replicate all the existing records, by letting the create date and modified date blank.