Photocopier: Difference between revisions

From eStream Software
Line 112: Line 112:
| UDF_Qty || Calculated base on formula above
| UDF_Qty || Calculated base on formula above
|-
|-
| Amount ||  
| Amount || Calculated base on formula above
 
 
|}
|}



Revision as of 01:06, 15 November 2016

Introduction

This Customisation is for the company who provide service on photocopier Machine

Last Customisation Update : 19 Oct 2015

Sample Database

History New/Updates/Changes

19 Oct 2015

  • Fixed upgrade to Version 721 error.

03 Jul 2015

  • Fixed Unable to save Invoice if document is transfer from other Document

Todo

  • Copy all Fields
  • Min Qty Charge

Modules Require

  • DIY Script
  • DIY Field

Settings

Sales Quotation

Menu: Sales | Quotation...

  • 1 Quotation is for 1 Customer Profile
  • Can Keep a lot of Machine (unlimited)
  • Use Doc No S-XXXX as the Setting - To avoid mix with actual use of Quotation
  • Can use same itemcode for Different Reading
Photocopier-01.jpg
Field Description
Delivery Date Contract Expiry Date
UDF_CMR Current Meter Reading
UDF_DOCDATE Current Reading Date (Norm is Invoice Date)
UDF_QTY Current Qty Charge
UDF_REBATE Rebate Qty or %
UDF_MTHLYCHARGE Fixed Monthly Charges
UDF_FREEQTY Free Qty
UDF_ADDFEE Additional Fixed Fee Charges

Maintain Stock Item

Menu: Stock | Maintain Stock Item...

  • Need to keep 2 itemcode for 1 same item(physically)
- 1 for Norm Itemcode with Stock Control
- 1 for Non-Stock ItemCode for Meter Reading
- See example MACH_CANNON1(Norm Itemcode) & CANNON1(Meter Reading)

Sales Invoice

Menu: Sales | Invoice...

  • Will Check Expiry Date - Auto Untick the selection if Expired
  • Auto Get Previous Meter Reading & Monthly Charge
  • Will update Current Meter Reading, Current Qty Charge to Sales Quotation By ItemCode
Field Description
No. of Copies Current Meter Reading - Previous Meter Reading
Rebate It can be in % or Qty
Qty Charges No. of Copies - FOC Qty - (No. of Copies * Rebate)
Amount Charges
  • (Qty Charges * Unit Price) + Add Fees + Montly Charge (if No. of Copies > FOC Qty)
  • Add Fees + Montly Charge (if No. of Copies <= FOC Qty)
  • Below is the field relation between Sales Quotation & Sales Invoice
Invoice Field Quotation Field
ItemCode ItemCode
Description Description
Description2 Description2
UDF_PMR UDF_CMR
UDF_CMR Meter Reading enter by user
UDF_Rebate UDF_Rebate
UDF_FreeQty UDF_FreeQty
UDF_MthlyCharge UDF_MthlyCharge
UDF_AddFees UDF_AddFees
UOM UOM
UDF_UnitPrice UnitPrice
UDF_PMRDate UDF_DocDate
UDF_Qty Calculated base on formula above
Amount Calculated base on formula above

Steps

Menu: Sales | Invoice...

Photocopier-02.jpg
01. Select Customer.
02. Click 1. Get Price button.
03. Enter the Current New reading for each machine
04. Click Post button after done.

See also