Archive

Archive for October 15th, 2011

Easy way to link a show only field to Form

October 15th, 2011 No comments

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 grid column would be blank initially.  Only when you click on a row, the column value would show.  

What is the process for returning customer orders through the Order Shipping form in Syteline?

October 15th, 2011 No comments

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:

  1. Ensure that the invoice has been posted through the Invoice Posting form first.  Then go to the Order Shipping form and set the CO Line/Release to Filled and filter on the customer order in question.

  2. The line(s) for the customer order you filtered on should appear at which point you will need to select the lines in question and ensure you tick the CR RTN box.  Put in the qty to be returned (as a positive amt) and a return reason code. If you need to reverse your Freight and/or Misc Charges then go to Actions – Edit Freight Charges and type in a positive dollar amount for what you want to give as a credit to this customer (an alternative is to go to the Customer Orders form under the Amounts tab and type in the positive dollar amount in both the Freight and/or Misc Charges fields that you want to credit to this customer prior to step 1).  Lastly on the Customer Credit Return tab select the invoice for which the Credit Memo should be matched to once generated.

  3. You will then need to ship the line(s).

  4. Once the lines have been shipped if you go to Order Invoicing/Credit Memo and print the credit memo (ensure that you set Invoice or Credit Memo field to Credit memo).

  5. Once the credit memo has been generated and printed go onto the Invoice Posting form and post the credit memo.

  6. The last step (only if you have forgotten to select the invoice for which the Credit Memo should be matched to on the Order Shipping form) is to match the Credit Memo to the Invoice which was generated incorrectly and this is done by going on the A/R Posted Transaction form and filtering on the customer and then selecting the Credit Memo which was generated by selected the Detail button.  You will then need to set the Apply to Invoice field to the Invoice which was incorrectly generated, doing this will ensure that the Invoice is not outstanding on the customers account.

  7. At this point you may want to make changes to the line before it is reshipped and you can do that in Order Line Maintenance.

  8. Go to the Order Shipping form and and filter on the customer order in question and the line(s) should appear with the quantity on it.  You can update any information on the line here if required.

  9. Select the line(s) in question ship them as normal.

  10. Once the lines have been shipped if you go to Order Invoicing/Credit Memo and print the invoice.

  11. . Once the invoice has been generated and printed go onto the Invoice Posting form and post the invoice as normal.

IF THE ORDER HAS BEEN INVOICED AND WAS SHIPPED THROUGH A DELIVERY ORDER
An RMA return and credit must be performed. Return cannot be processed on the Order Shipping screen for these.

IF THE ORDER HAS NOT BEEN INVOICED:

  1. Go to the Order Shipping form and set the CO Line/Release to Filled and filter on the customer order in question.

  2. The line(s) for the customer order you filtered on should appear at which point you will need to select the lines in question and enter in a negative quantity and a return reason code.

  3. You will then need to ship the line(s).

AUTONUMBER

October 15th, 2011 No comments

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 the component to the highest value of a property, determined from both the collection and the application database, plus the increment specified by the argument of STEP.

If STEP( ) is omitted, AUTONUMBER uses a default increment of 1, setting the value of the component to one greater than the highest value in the collection and in the application database.

If FILTER is omitted, WinStudio attempts to construct filter criteria to retrieve the current maximum value from the application database.

Example

AUTONUMBER(STEP(1) FILTER(OrderNo=FP(OrderNo)))

Consolidate Payment Record in Bank Reconciliation

October 15th, 2011 No comments

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 = USD 200 ; Date :1 December 2010; Bank : BK1
Customer 2: Cheque Amount = USD 300 ; Date : 2 December 2010; Bank : BK1
2. A/R Payment Posting
3. GL –> Journal Posting
4. Bank Reconciliation
Transaction appear as 1 line ; Amount USD500 ; Date : 1 Dec 2010

If you do not want an A/R payment (Adjust, Check, Wire) or a returned check (check entered as a negative amount) included in a summarized Bank Reconciliation record, you will have to do separate AR payment postings.

When you have a single check posted, the customer number, check number, and customer name will be seen in the Bank Reconciliation form.

When you have more than one check posted, for different customers, a "summary" deposit is created. Since there is more than one customer here, the customer number, customer name, and check cannot be specified in the one line bank reconciliation "Deposit".  If you want to see specifics for each check, then you have to post them separately, one at a time.

The detailed payment information which is used to calculate one of these summarized bank reconciliation records can be obtained by looking at the A/R Distribution Journal.

No List Cache

October 15th, 2011 No comments

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.

image

Process a returned customer check

October 15th, 2011 1 comment

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 is returned, follow these steps:

1) Go into Bank Reconciliations
Filter for bank code
Put cursor in bottom to add a bank rec
Add bank rec type "Deposit"
Transaction Number = this is the bank rec trans #, similar to manual check number. They can start with 100 and let system increment after that
Ref Type = A/R
Ref Num = Customer Number
Customer Check Number = check number returned
Amount = Amount of check
Bank Amount = Amount of check
Generate Returned Check Fee = Yes
Save the record

2) Open the Returned Checks form
Enter the bank code
Process Returned Checks = Yes
Preview – Process
They should see the record in the grid
Commit – Process
Debit Memo should have been created
If the check is re-deposited, the user can select the Process Returned Check Deposit option on the Returned Check form, and the system will create a credit memo to offset the debit memo.

Auto Expand Key# like Customer# and Invoice#

October 15th, 2011 No comments

In Syteline, many key number like Customer#, Invoice# and such, they have prefix and fixed length.  When key in the number, system can auto expand or auto fill the number based on its format, such as key in “C1”, it will expand to “C000001”. 

To get this auto expand function in a component field of a form, you need to do two things,

1) Give the component a proper component class.  For example, for customer#, it can use component class “CustNum”, "CustNumForBillTo” and quite a few other, depend on your other need (validation, populate other field like name). 

2) Set the component data type, underline type to “NUMSORTCHAR”.

How to debug problems with SyteLine e-mails not being sent out

October 15th, 2011 No comments

The Exchange server is primarily responsible for the broadcast of e-mails generated within SyteLine .

An Exchange server is a Microsoft messaging system including mail server, email client and groupware applications.  If e-mails are not being generated from SyteLine, for example when a purchase order is printed, then there are certain procedures to follow to establish where the error lies.

The first thing to check is the Exchange server itself.
Sign onto the utility server as administrator (sign into the domain and not the local machine)
Go to start-run-cmd
Try to ping the Exchange server (or whatever is running SMTP)
SMTP (Simple Mail Transfer Protocol) is a TCP/IP protocol used in sending and receiving e-mail.
This will return the IP address if all works okay.
Then type :
Telnet IP-address of exchange server 25
(Note that the 25 is the open port number)
Then type :
Helo (This command is used to identify the sender (client) to the SMTP server  use: ehlo if helo does not work.)
Then type :
Mail to:<e-mail address> press enter
(this e-mail address should be the ?SMTP from e-mail? on the intranets form)
Then type :
Rcpt to:< e-mail address> press enter
Then type :
Data
Then type your e-mail message
Once finished with your e-mail message body, then on a new line place a full stop.
NEXT you need to check that ‘RELAY’ is switched on, on the exchange server.
To do this , on the exchange server go to
system manager
admin groups
1st admin
Servers
Protocols
SMTP
Then right click on the exchange server name.
Go the the ‘Access’ tab
Into relay and then add.
Then go into SyteLine and into the vendor document profile
Set up a profile for the vendor and the destination e-mail address.
Ensure the vendor document profile is set to active.

Categories: Development Tags: , ,

Syteline 8 – Change Windows Administrator Account and/or Password

October 15th, 2011 No comments

I found this article is pretty useful on understanding various Syteline service too.

There are two types of logins used for Syteline 8.00, 8.01 and 8.02.  This article discussed the areas that use Windows Accounts and SQL ‘sa’ accounts would need to be updated.

  • Windows Login – This Login should be part of the Windows Administrator Group. This solution is specifically for the instance of changing which windows account is being used and/or changing the password of the windows account being used for Syteline.

  • SQL Server Login – This is a SQL Server login named ‘sa’ which is created with the installation of the SQL Server.  This solution can also be used if you are going to be changing the ‘sa’ password.  On some of the forms indicated below you may also be prompted to input the SQL Server Login ‘sa’ account and password.

This article focus is the basic Utility Server setup.  You may have more then one Utility Server or your environment may consist of one server that has the SQL Server and Utility Server installation combined.  The Syteline Installation Guide Chapter 2 – Setting Up the Utility Server – Configure the Utility Server is the page we will be starting with pags 28 – 44..

Start>All Programs>Infor>Setup>Infor ERP SL Configuration Wizard

1.  Click Once Deployment – This option builds the manifest for the Click Once Client web user interface.

     – This process creates  Virtual Directory ‘SLClientDeploy’, which requires a Windows Account for the ‘Service Logon’ – Domain\Administrator. 

     – You need to select this option to set the new Windows Administrator Account and\or  updatePassword.

     – No SQL login is required for this option.

2.   Syteline IDO Request Web Service – IDO Runtime Service using HTTP for the Click Once Client web user interface.  This process creates a Virtual Directory ‘IDRequestService’, which requires a Windows Account for the ‘Service Logon’ – Domain\Administrator

      – You need to select this option to set the new Windows Administrator Account and/or update Password

      – No SQL Login is required for this option.

3.   Inbound Queue Web Service – This is necessary for asynchronous or what is also called non-transactional replication.  If  your environment is NOT replicating data to an database that is not on the same intranet, you do not need to modify this option.  Please see Syteline Multi-site Planning Guide for more information.  This process creates a Virtual Directory ‘InboundQueue’, which requires a Windows Account for the ‘Service Logon’ – Domain\Administrator

     – You need to select this option to set the new Windows Administrator Account and/or update Password.

     – No SQL Login is required for this option.

4.  Infor Inbox Web Serviice – This web service allows users to access their Syteline system ‘Inbox’ using a Web interface without having to login to Syteline.  This is primarily used for Event System Emails.  If you are not using the Event System you would not need to modify this option.  This process creates a Virtual Directory ‘InforInbox’, which requires a Windows Account for the ‘Service Login’ – Domain\Administrator.

    – You need to select this option to set the new Windows Administrator Account and/or update Password

    – No SQL Login is required for this option.

5.  Infor Task Manager Service – This option is used for polling the _app databases for Active Tasks to complete, such a printing and previewing of reports, executing Background Tasks scheduled to run at specific times.  The Infor Task Man Service is located in the Windows Services Panel >Administrative Tools>Services.

    – You need to select this option to set the new Windows Administrator Account and/or update Password

    -  No SQL Login is required for this option.

6.  Replication Service – This option is used for multi-site environments.  If you are single site, you do not need to select this option.  This service is created and can be viewed in the Windows Services Panel>Administrative Tools>Services.

   – You need to select this option to set the new Windows Administrator Account and/or update Password.

   – No SQL Login is required for this option.

7.  Replication Listener Service – This option is used for multi-site environments.  If you are single site, you do not need to select this option.  This service is created and can be viewed in the Windows Services Panel>Administrative Tools>Services.

   – You need to select this option to set the new Windows Administrator Account and/or update Password.

   – No SQL Login is required for this option.

8.  Data Collection Web – This option is used for interfacing with remote Data Collection devices.  If you are not using Data Collection, you do not need to select this option.  This option creates a virtual directory ‘fsdatacollection’ , which requires a Windows Account for the ‘Service Login’ – Domain\Administrator.

   – You need to select this option to set the new Windows Administrator Account and/or update Password.

   – No SQL Login is required for this option.

Note:  The next 4 options are for APS – also known as Advanced Planning and Scheduling.  If you are not running APS, you do not need to complete the next 4 options (9, 10, 11 and 12). If you are running APS, please continue on with the next 4 options.  Also, if you are running APS, your environment may have a separate APS server, these steps would need to be completed on the APS server and not on the Utility Server.

9.  Planning and Scheduling COM + Components – This option is for the COM + Components (middleware) for the APS application.  This option creates a COM + Component Object in Component Services, which requires a Windows Account for the ‘Service Login’ – Domain\Administrator.

  – You need to select this option to set the new Windows Administrator Account and/or update Password.

  – No SQL Login is required for this option.

10.  Planning and Scheduling Gateway – This option creates a connection to the SQL Server Syteline Database and installs a Gateway service, which requires a Windows Account for the ‘Service Login’ – Domain\Administrator.. This service is created and can be viewed in the Windows Services Panel>Administrative Tools>Services.

   – You need to select this option to set the new Windows Administrator Account and/or update Password.

   – You need to select this option to update the password for the SQL ‘sa’ user.

   – There may be more then one Gateway to update with the password for the SQL ‘sa’ user and Windows Account.  Repeat for each Gateway.

11.  Planning and Scheduling Server – This option creates the Server Service controls which runs the APS Planning function and the Scheduler, which requires a Windows Account for the ‘Service Login’ – Domain\Administrator.. This service is created and can be viewed in the Windows Services Panel>Administrative Tools>Services.

   – You need to select his option to set the new Windows Administrator and/or update Password.

   – You need to select this option to update the password for the SQL ‘sa’ user.

   – There may be more then one Server to update with the password for the SQL ‘sa’ user and Windows Account.  Repeat for each Gateway.

12.  Planning and Scheduling Web -  This option creates a web page ‘Analyzer_Syteline’ to allow Planning and Scheduling analysis via the network.  This option allows you test the viability of alternative planning and scheduling situations using a copy of your database, without effecting your production database.

   – No Windows Account used for this option.

   – You need to select this option to update the password for the SQL ‘sa’ user.

   – There may be more then one Analyzer Web setup, repeat for each Analyzer.

13.  End-User Client/Administrative Clients – Option sets the Utility Server URL.

   – No Windows Account used for this option

   – No SQL Login is required for this option.

Categories: Development, VB .Net Tags:

How to setup an Area Based Tax System

October 15th, 2011 No comments

For Businesses operating in Canada:

The Syteline system presumes that the main tax system (GST) will be setup as Tax System 1 with a Tax Mode of either Item or Area depending on the requirement of the province. The Syteline system also presumes that PST and HST will be setup as Tax System 2 with a Tax Mode of Area.

For any European Economic Countries and Australia:

The Syteline system presumes that the main tax system (Sales Tax or VAT Tax) will be setup as Tax System 1 with a Tax Mode of Item.

For the United States:

The Syteline System presumes that the main tax system (Sales Tax) will be setup as Tax System 1 with a Tax mode of Area.

The Parametric Sales Tax System allows the User to set up Tax Systems to change sales tax at the "Item" level or an "Area" level.
The Area Based Tax System, which applies to U.S. Companies, allow taxes to be charged at the header level, Setting up the Tax Codes entrails assigning tax rates to a State Tax Code. The flags "Include Price" and " Include Misc." Should be set to YES and the A/R tax account number needs to be defined.
Under the Area Tax System, if an item is tax exempt (as specified in the item master), the system will ignore the tax code at the header level and not charge sales tax. If the item is taxable, the system will charge tax based on the "ship to" customer’s tax code ( or the "bill to" if it is the same as the "ship to" customer). If a line item is "dropped shipped", tax will be charged based on the tax code of the "drop ship" customer. This will override the tax status of the line item and the header tax code. If the user wished a message to appear, asking if sales tax should or should not be charged based on the tax code of the drop ship customer, then the following two flags must be set to YES:
"Prompt on Line Item" flag on the Tax System screen. This flag will prompt that the item is taxable or non taxable at the item level of an order.
"Prompt for State Tax" flag on the Tax parameters screen. This flag will prompt that the item is taxable or non taxable in the item master sales screen and page two of the Customer Order Header.
The Item Based Tax System will mainly apply to Canada, UK and European countries. It allows sales tax to be charged at the item level and tax codes to be specified in the item master. (For example, the GST in Canada.) The system will look at the tax rate of the item and override the tax code on the header.
The Parametric Sales Tax System was designed to allow flexibility mainly for the European Community. Many of the fields and flags should be ignored ( or set to "NO") for U.S. Countries.
The following fields give a brief description of what all is involved with the tax structure. The fields with a * indicate they are relevant for the AREA based tax system ( U.S. Countries.)

I. GENERAL PARAMETERS:

  • EC Reporting: "Y" Activates EC VAT information.

  • ED Weight Conversion Factor: Converts Weight field in item file to kilograms ( unit weight on EC SSD.)

  • Capitalize State: "Y" – Upper Case

II. TAX SYSTEMS: (File, System, TS) – Can have both tax systems working simultaneously.

  • AREA (US Business) – allows tax rates to be entered at the header level.

  • ITEM (European/ UK) – only allows tax rates to be entered at the item level. (Taxes based on each item of the sale -VAT.)

  • PROMPT ON LINE ITEM- Will show the item is taxable or not at the item level of an order. Will also give y/n message to change "drop ship" tax codes per line item.

  • PROMPT TAX CODE LABEL- Allows use of set up labels ( header).

  • PROMPT TAX CODE ITEM LABEL- Allows use of set up labels (item).

  • PROMPT AMOUNT LABEL- Allows use of set up labels (amount).

  • TAX ID LABEL- (ex: Federal ID# on Vendor Screen)

  • ACTIVE FOR PURCHASING- Can turn off Purchasing Side (normally "No"). Can be edited at the distribution level. (Primarily used for EC).

  • USE WHOLESALE PRICE- Will cause a secondary Unit Price Field to be displayed/updated on the Item Master screen. (Calculates taxes in place of the "real" item master unit price.) Wholesale price used first.

  • APPLY TO PROGRESSIVE BILLING- Indicates if taxes should be billed during Progressive Billing.

  • RECORD ZERO RATED- "Y" if it is necessary to record/report transactions which have a tax amount of zero. (May be used for later reporting.) Ex: Selling children’s clothing (textile industry.)

  • TAX ID PROMPT LOCATION- Enables/Disables prompting for the Tax ID on Customer/Vendor screens. (C,V,B)

  • DEFAULT ITEM TAX CODE- Used for new items entered into the Item Master.

  • AR/AP TAX CODE: Tax Code = That of the Customer Vendor.

  • FREIGHT/MISC. TAX = AR/AP Tax Code default.

  • DEFAULT CUST/VEND TAX CODE – Default for Customer/Vendor Screen.

  • COMMISSION TAX CODE – That default rate will calculate tax on commissions.

  • NON A/P TAX CODE – Will default to what is filled in for Non-A/P Payments.

III. TAX PARAMETERS

  • Set to company’s specific reporting and functionality requirements.
  • STARTING TAX PERIOD DATE – Stores the dates following the last submission of the VAT return and SSD report.

Usual Field Values For US:

  • CASH ROUNDING FACTOR = 0 (If >0, "Cash Only Flag" is prompted on Billing Terms screen. "Y" will round final invoice to the nearest cash rounding factor.)
  • PROMPT FOR TAX DISC. = NO; if yes, will prompt to only pay taxes on the final amount they are paying (after discount). Must apply to the Taxing Authority to qualify.
  • PROMPT FOR PRICE INCL. TAX = If YES, tax is fixed in price when invoice is posted.
  • PRINT TAX CODES ON INVOICE = "Y" prints tax codes on invoices.
  • PRINT TAX FOOTER ON INVOICE = "Y" prints a Tax summary on invoices.
  • *PROMPT FOR STATE TAX: YES – Will prompt for if an item is taxable/non-taxable in the item master. Will also give Y/N message to change "drop ship" tax codes per line item.
  • TWO EXCHANGE RATES -Used for Multi-Currency.

IV. TAX JURISDICTIONS

Used to record where taxes are located. Allows the user to group the tax codes into Jurisdictions. Each tax code can be assigned a Jurisdiction. Ex: EC = FR (France UK) Tax ID in France. (Not applicable in US.)

V. TAX CODES

1 Set of Tax Codes per Tax System. * Choose between E (Exemption) or R (Rate).

  • TAX AT ITEM LEVEL: (Item Master, Sales)
  • TAXABLE BLANK: Taxed at Rate that is on the header (Tax Code Type = E (Exemption) or N – Not Taxable – That line item will not be taxed.)
  • HEADER BLANK- Individual items get taxed at the rate set by the Tax Codes at the item level.
  • HEADER-ZERO – Entire order is presumed tax exempt.
  • ASSESS ON RETURN – Active for Vouchers. Indicates tax was never paid on the item and must be assessed at the time of return.
  • DEDUCTIBLE – Active for Vouchers. Indicates that the item purchased is deductible from taxes. (i.e. Syteline user is not the end user of the item.)
  • INCLUDE PRICE, DISC., FRT., MISC. – Y/N – What amount should be taxes?
  • INCLUDE PRICE ON PREV. SYSTEM – Causes the tax amount calculated on Tax System 1 to be added to Tax System 2.
    * Tax Account # must be entered.