Archive

Posts Tagged ‘AR Payment’

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.

How to back out an AR payment applied incorrectly

October 24th, 2011 No comments

Let say you have an AR payment applied to an incorrect invoice. And you need to remove the payment from incorrect invoice and apply it to a different invoice.

If you do not need to change the check number, then you can update the applied to invoice number in the AR Posted transaction Detail form. Pull up the record for the payment and change the apply to invoice number from the incorrect invoice number to the correct invoice number. 

If your check numbers are tied to the invoice numbers and you need to create a new payment to apply to the correct invoice, you will need to adjust the AR payment.
1) Open the AR payment form and add a new record for your customer.
2) Type will be adjustment and you will  need to enter your original check number in the number field. Save.
3) Enter the amount as a negative number and save
4) Click on the distributions and type in the invoice number that the payment was originally applied to.  Enter the amount as a negative amount. Verify that the amount remaining is 0
5) In the AR Adjustment Posting, post the payment adjustment.
6) In AR payments, create the new check and apply to the appropriate invoice

How to clear small outstanding balances in AR

October 24th, 2011 No comments

With various reason, such as foreign currency conversion, you may see small outstanding balance resident in AR for some customer account, and the customer truly didn’t owe that money.

One option is to write off small outstanding balances (either positive or negative) to either Discounts Allowed or Allowances.   To do this, you will need to create a zero dollar payment.   The steps are as follows:
1.  A/R Payments
New
Enter the Customer Number
Type = Check
Number = (new check number)
Save
2.  Click Distributions
Enter the invoice number with outstanding balance
The amount left open on the invoice will default in Dist Amount field on Amounts tab
Transfer this value (either positive or negative) into either the Disc field or Allowance field
Then set the Dist Amount = 0.00
Post the payment
Another option is to enter credit or debit memos to offset any remaining balances