Non Shipment billing component

From UG

(Difference between revisions)
Jump to: navigation, search
(→Credit note number)
 
(31 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Acc Basics]]
+
[[Category:Acc]]
 +
== Info ==
-
== Parent mantis ==
+
*http://ct.jaguarfreight.com/mantis/view.php?id=2500
-
0002500: (Non Shipment Billing) ................... <parent >
+
-
 
+
== Business Requirements ==
== Business Requirements ==
=== Intro ===
=== Intro ===
-
Non-shipment billing - is to invoice a customer not related to a specific CT record or shipment.  
+
Non-shipment billing - is invoicing a customer for a service not related to a "standard" CT record based billing that we do on "Inv Tab".  
-
For example invoicing for services provided.  
+
See examples below.
==== Example 1 ====
==== Example 1 ====
-
In case of Arden Trucking project Jaguarfreight will invoice the customer monthly usage fee. It is equal to number of CTs created multiply by rate.
+
In case of Arden Trucking project Jaguar freight will invoice the customer Portal monthly usage fee. It is equal to number of CTs created that month multiply by certain Rate per CT.
==== Example 2 ====
==== Example 2 ====
-
Invoice with IT services fees for Client X:
+
Invoice for services:
-
* rate per hour X num of hours
+
* Rate per hour multiply by Number of hours  
-
* flat fee (per visit or per project)
+
 
==== Example 3 ====
==== Example 3 ====
 +
Invoice for services:
 +
* Flat fee (per visit or per project)
-
TBD
+
=== Originating office ===
 +
For now they will originate in NY office only.
=== Invoice number ===
=== Invoice number ===
Line 30: Line 32:
These invoices should have their own sequence starting with NY100.
These invoices should have their own sequence starting with NY100.
-
Invoice sequence: NY100, NY101, NY102
+
Invoice sequence: NY100, NY101, NY102, ...
-
=== Credit note number ===
 
-
<font color="red"> Mixed with inv num or separate? </font>
 
-
=== Item codes and Rates Table ===
+
=== Credit notes ===
 +
Ability to issue credit notes.
-
These invoices should have there own charge codes, which should be referred to as Item codes.
+
==== Credit note number ====
 +
Credit notes should match the invoice number it is being issued against, only adding the letter C to the end.
 +
In the event of multiple credit notes being issued against one invoice, these should be numbered accordingly (C1, C2, C3, etc...)
-
They should be a three digit codes (instead of the four digit code currently being used for invoicing).
+
Example 1.
 +
----------
 +
Day 1 Invoice number NY103 is created.
 +
Day 3 Credit note is issued against Invoice NY103 - assigned Credit note number should be NY103C1
 +
Day 5 Additional Credit note is issued against same invoice - assigned credit note should be NY103C2
-
They will need their own item code table (similar to the current Charge Code Table [[TOC]]).
+
=== Item codes Table ===
-
'''TBD - Exact structure and requirements to be defined. '''
+
These invoices should have their own charge codes, which should be referred to as '''Item codes (IC)'''.
-
=== Invoice ===
+
Item codes should be a three digit codes (instead of the four digit code currently being used for CT invoicing).
-
FIELDS TO BE INCLUDED ON THE INVOICE
+
They will need their own item code table (similar to the current Charge Code Table [[TOC]]).
-
* '''Inv#:''' see [[#Invoice number ]]
+
==== Item Code Fields ====
-
* '''Bill To:'''. Have to select '''Bill To Party Company''' from dropdown list.
+
* '''IC number'''  
-
:* Dropdown list should be mapped to ''Admin > Address Book > Bill To Parties''.
+
: ''type/format:'' 3-digit numbers
-
:* Bill To Parties in dropdown list should be displayed as Unique Id: ''Company Name - City - Remark''. Example: ''"Allstar Marketing Group, LLC - Hawthorne"''.
+
-
* '''Bill To Address:'''. Editable textarea with Address of Bill To Party:
+
* '''IC Description'''  
-
:''[Company name]''
+
: ''type/format:'' alphanumeric, max= make it same as in [[TOC]]
-
:''[Address line 1]''
+
-
:''[Address line 2]''
+
-
:''[Address line 3]''
+
-
:''[City], [State] [Postcode]''
+
-
:''[Country]''
+
-
* '''Date:'''. Text label. Set to current date ''(date of Invoice generating)''.
+
=== Invoice fields ===
-
* Total Amount
+
Note that many of fields below are the same as on CT invoice.
-
* Terms
+
-
====  TOC ====
+
* '''Inv#:''' see [[#Invoice number ]]
-
* Item Code Number
+
-
* Description
+
-
* Etc (like Quantity, Rate) '''To be better defined'''
+
-
* Currency
+
-
* Amount
+
-
=== List of invoices ===
+
* '''Bill To:'''.  Dropdown list should be mapped to ''Admin > Address Book > Bill To Parties''.
-
Need a table with all invoices/CN in the system.
+
-
=== Invoice pdf ===
+
* '''Bill To Address:'''. Editable textarea with Address of Bill To Party:
-
Pdf needs to be generated.
+
-
=== Credit notes ===
+
* '''Date:'''. Default to current date. Editable.
-
Ability to issue credit notes.
+
-
== Design Ideas ==
+
* '''Total Amount.''' Use standard format as in CT billing. Autocalculated based on what is entered in [[#TOC]]
 +
* '''Currency:''' use standard.
-
'''Item Code Table'''
+
====  TOC ====
 +
* '''IC Number'''
 +
: to be entered by operator
 +
: default: blank
 +
: see [[#Item Code Fields]]
-
[[File:Item codes.JPG]]
+
* '''IC Description'''
 +
: to be entered by operator
 +
: default: blank
 +
: [[#Item Code Fields]]
 +
* '''Quantity'''
 +
: to be entered by operator
 +
: default: 1.00
 +
: max = 1 000 000 000.00
 +
* '''Rate'''
 +
: to be entered by operator
 +
: default: 0.00
 +
: max = 1 000 000 000.00
-
'''Non Shipment Invoicing Menu'''
+
* '''Amount'''
 +
: to be calculated by the system. Formula: Amount = Quantity X Rate
 +
: not editable
 +
: default: 0.00
-
[[File:Menu.JPG]]
+
=== Invoice pdf ===
 +
Pdf needs to be generated. Use standard layout (as in CT billing).
 +
== Design Ideas ==
 +
Create this module under Main Menu > Acc > Non Shipment Billing Component
 +
== SA Notes ==
 +
The following basic functionality obviously required - see below.
-
'''Invoice Table'''
+
=== List of invoices ===
-
 
+
Need a table with all invoices/CN of this kind in the system.
-
[[File:Inv table.JPG]]
+
-
 
+
-
 
+
-
 
+
-
'''Issuing New Invoice'''
+
-
 
+
-
[[File:Inv form.JPG]]
+
-
 
+
-
 
+
-
 
+
-
'''Invoice PDF'''
+
-
[[File:Inv pdf.JPG]]
+
Add basic standard table of records capabilities: paging, search, sort
-
== Detailed Design ==
+
Display most important fields as columns.
-
TBD by SA
+
== History ==
== History ==

Current revision as of 13:54, 31 October 2013


Contents

[edit] Info

[edit] Business Requirements

[edit] Intro

Non-shipment billing - is invoicing a customer for a service not related to a "standard" CT record based billing that we do on "Inv Tab".

See examples below.

[edit] Example 1

In case of Arden Trucking project Jaguar freight will invoice the customer Portal monthly usage fee. It is equal to number of CTs created that month multiply by certain Rate per CT.

[edit] Example 2

Invoice for services:

  • Rate per hour multiply by Number of hours


[edit] Example 3

Invoice for services:

  • Flat fee (per visit or per project)

[edit] Originating office

For now they will originate in NY office only.

[edit] Invoice number

These invoices should have their own sequence starting with NY100.

Invoice sequence: NY100, NY101, NY102, ...


[edit] Credit notes

Ability to issue credit notes.

[edit] Credit note number

Credit notes should match the invoice number it is being issued against, only adding the letter C to the end. In the event of multiple credit notes being issued against one invoice, these should be numbered accordingly (C1, C2, C3, etc...) 

Example 1. 
----------
Day 1 Invoice number NY103 is created.
Day 3 Credit note is issued against Invoice NY103 - assigned Credit note number should be NY103C1 
Day 5 Additional Credit note is issued against same invoice - assigned credit note should be NY103C2

[edit] Item codes Table

These invoices should have their own charge codes, which should be referred to as Item codes (IC).

Item codes should be a three digit codes (instead of the four digit code currently being used for CT invoicing).

They will need their own item code table (similar to the current Charge Code Table TOC).

[edit] Item Code Fields

  • IC number
type/format: 3-digit numbers
  • IC Description
type/format: alphanumeric, max= make it same as in TOC

[edit] Invoice fields

Note that many of fields below are the same as on CT invoice.

  • Bill To:. Dropdown list should be mapped to Admin > Address Book > Bill To Parties.
  • Bill To Address:. Editable textarea with Address of Bill To Party:
  • Date:. Default to current date. Editable.
  • Total Amount. Use standard format as in CT billing. Autocalculated based on what is entered in #TOC
  • Currency: use standard.

[edit] TOC

  • IC Number
to be entered by operator
default: blank
see #Item Code Fields
  • IC Description
to be entered by operator
default: blank
#Item Code Fields
  • Quantity
to be entered by operator
default: 1.00
max = 1 000 000 000.00
  • Rate
to be entered by operator
default: 0.00
max = 1 000 000 000.00
  • Amount
to be calculated by the system. Formula: Amount = Quantity X Rate
not editable
default: 0.00

[edit] Invoice pdf

Pdf needs to be generated. Use standard layout (as in CT billing).

[edit] Design Ideas

Create this module under Main Menu > Acc > Non Shipment Billing Component

[edit] SA Notes

The following basic functionality obviously required - see below.

[edit] List of invoices

Need a table with all invoices/CN of this kind in the system.

Add basic standard table of records capabilities: paging, search, sort

Display most important fields as columns.

[edit] History

Retrieved from "https://wiki.jaguarfreight.com/Non_Shipment_billing_component"
Personal tools