Archive

Archive for October 24th, 2011

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

Obtaining Username in form script

October 24th, 2011 5 comments

In syteline 7 it was SessionManager.BaseUserName.
In Syteline 8

  • Create form component ‘UserEdit’ and bind it to variable ‘User’ with initial value ‘USERNAME()’
  • Get the value on form script by ‘ThisForm.Variables(“User”).Value’
    This will return the UserID who login to Syteline.
  • Use System.Environment.UserName to get the UserID login to Windows.

Here is a sample screen shot

ScreenHunter_04 Mar. 21 10.29

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