Archives

Archive for October, 2011

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. […]

Oct 24th, 2011 | Filed under Application, Implementation

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

Oct 24th, 2011 | Filed under Development, VB .Net

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 […]

Oct 24th, 2011 | Filed under Application

In Syteline 8, there is an utility program called Void AP Posted Payments Utility, which you can use to void an AP posted payment.  But if any of the following conditions exist, you can’t use this utility.  1) Multi-site environment 2) You compress Journal transactions 3) You are trying to void a manual type check […]

Oct 16th, 2011 | Filed under Application, Implementation

Let say you want to show item material status in Item Availability Form, you may just create a new edit field in form, then bind the form component to COLLECTION(SL.SLItems(PROPERTY(Stat) FILTER(Item = FP(Item)))) . Please note that if you want to do this in grid column, since the value is not in collection, so the […]

Oct 15th, 2011 | Filed under Development, VB .Net

If your user has processed a customer order shipment incorrectly and needs to do Credit Return or needs to change the invoice date on an invoice generated from Order Entry then follow the steps below… IF THE ORDER HAS BEEN INVOICED: Ensure that the invoice has been posted through the Invoice Posting form first.  Then […]

Oct 15th, 2011 | Filed under Application

In Syteline form grid, if you have line# and you want it to be auto populated, you may use the AUTONUMBER function, just set the component default value property to AUTONUMBER. Syntax AUTONUMBER( [ STEP( ) ] [ FILTER( ) ] ) Remarks During processing of the New standard operation, AUTONUMBER sets the value of […]

Oct 15th, 2011 | Filed under Development, VB .Net

When doing an AR payment posting, if there are multiple payments from same customer or differ customers, the cash account entry will be consolidated into single one.  So in Bank Reconciliation, there will be single total line cash record, instead of check by check. For example, 1. Create Payment Customer 1 : Cheque Amount = […]

Oct 15th, 2011 | Filed under Application

Sometime, in an In Collection Validator, you would get a “Cache Property not in Cache” error.  Make sure to check the “No List Cache” check box.  This will force to refresh IDO collection in Cache.

Oct 15th, 2011 | Filed under Development, VB .Net

Parameters can be setup on the Accounts Receivable Parameters form. A Returned Check Fee amount can be entered there. They can also designate to create Debit Memo for the customer for the returned check amount, plus returned check fee amount. In order to create a Debit Memo to send to the customer when a check […]

Oct 15th, 2011 | Filed under Application