Recurring

From eStream Software
Revision as of 06:54, 26 September 2015 by Twfaung (talk | contribs) (→‎Quotation)

Introduction

This Customisation is for simple calculation for the management property which normally monthly charge Maintenance, Sinking Fund & etc.

Last Customisation Update : 26 Sep 2015

Sample Database

History New/Updates/Changes

26 Sep 2015

  • Remove 5 Cent rounding Script & use build in 5 Cent rounding
  • Fixed Customise Statement report not follow company profile information
  • Set Customer Payment UDF_PostDN Default Value = False

12 Aug 2015

  • Fixed Posting Overdue DN should excluding the GST amount from the calculation

Know Bugs

  • Lead Time = 0 got bug - being overide by Rebate when is below Min Charge

Todo

  • Allow Select DocNo Set - WIP
  • Gas Reading - WIP
  • Generate by SQFT by Customer
  • All Reading in 1 Invoice
  • Rest back to Previous Reading on Delete at Doc Listing
  • Multi range price
EG
0 - 100 @ 0.10/unit
101 - 200 @ 0.15/unit

Modules Require

  • DIY Field
  • DIY Script
  • Multiple Pricing (Price Tag)
  • Multiple Document Number Set (Optional)

Setting

Maintain User

Untick the Access Right for Prompt Replace Unit Price Dialog under the Group : Sales

Maintain Customer

  • Below fields MUST had Value (minimum is 0 not empty or Null)
- UDF_WaterReading
- UDF_ElectricReading
- Price Tag

Quotation

  • DocNo Format := CompanyCategoryCode;Type
 eg
 B-Shop;Main  => For Maintenance
 B-Shop;Water => For Water Billing
 B-Shop;Park  => For Car Park
  • For Water & Electric, Detail can be empty cause system will auto APPEND the itemcode
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg Note:

- Master Description if using

- 1.Generate Maintenance it will use the Quotation Master Description.
- 2.Generate Water it will shown how much the water usage [Master Description (MMM YYYY) - CurrentReading -PreviousReading=Usage@UnitPrice].
- 2.Generate Water with "Include Grid Detail Info." Option tick it will use the Quotation Master Description.
----------------------------------------------------------------------------------------------------------------------------------------------------

Stock Item

  • ItemCode 'WATER'
  • ItemCode 'ELECTRIC'
  • ItemCode 'RTN5Cents' => For Rounding Mechanism
  • Price Tag => For Different UnitPrice for WATER & ELECTRIC
Use Disc column as Rebate & Min Charge => Format := Rebate+MinCharge
eg
Type Description Input Value
Both Rebate 11.75 & MinCharge 5 11.75+5
Rebate Only Rebate 12.30 & MinCharge 0 12.30+0
Min Charge Only Rebate 0 & MinCharge 5 0+5
  • Lead Time => 0: Both, 1: Rebate Only, 2: Min Charge Only
  • For MinCharge make sure it had Value else set at 1

Customer Payment

  • Auto Generate Sales DN for overdue IV if UDF_PostDN Default Value is set to True (Default is False)
  • Only Knock-off to DN will not regenerate DN again if overdue
  • Formula for Age
   Age := DocDate - Knock off Due Date
  • Formula For Qty
   if Age < DayOf(DocDate) then
     Qty := Age else
     Qty := DayOf(DocDate);
  • Formula for UnitPrice
   Unit Price := Rate/365 * Knock off amount (Excluding GST)

Customer Due Listing

  • Auto Generate Sales DN for overdue IV
  • The rate is from Ref Price of OVERDUE itemcode (just enter 0.1 for 10% pa)
  • Formula Qty
   if Age < DaysInAMonth(edDueDate.Date) then
     Qty := Age else
     Qty := DaysInAMonth(edDueDate.Date);
  • Formula UnitPrice
   Unit Price := Rate/365 * Outstanding amount (Excluding GST)

Sales Document Listing

Is a batch delete base on the parameter selected

Steps

  • Coming Soon....

See also