Internal Invoice

From UG

Revision as of 16:56, 2 September 2010 by Alex (Talk | contribs)
Jump to: navigation, search


Contents

Requirements for Version 2

Version 2 completely changes the way Internal Invoices are calculated and generated.

Mantis

http://mantis.jaguarfreight.com/mantis/view.php?id=2343

Functionality overview

  • two formulas for calculating invoices should be supported:
  • in admin there should be and option to switch from one formula to another
  • dashboard indicator of CT records that have had additional sales inv/cr. notes generated after int. inv. have been generated. This will remind operator to "run" internal invoices generation again to "cover" new sales amounts - see #Dashboard counter with pdf and QB file

Fixed formula

Develop a table that would allocate based on the client and a pre-determined allocation between two offices. (For example, Jaguar Paris bills EA for $1,000 USD. The ratio of billing for EA is 60/40 Paris / New York. Paris would share in the revenue with New York for 40% of the $1,000 sales invoice because pre-determined ratio. (as defined by Karen)

Flex formula

An allocation of the final billed amount based on the percentage of purchase invoices processed and paid in each office over the total purchase invoices. (For example, Jaguar Paris raises a sales invoice for EA for $1,000 USD. Paris had $300 in purchase invoices paid for the shipment. In New York, we processed and paid for $200 in purchase invoices. Paris would share in the revenue with New York for 2/5 of the $1,000 sales invoice because New York had $200 in purchase invoices of a total $500 spent in purchase invoices. (as defined by Karen)

Invoice generation

Required: automation of the internal invoices “billing’ process which creates a receivable in one office and a payable in another. I would expect that an individual in any of our offices would be able to “kick’ off the internal invoice process automatically by requesting the “run” within Cybertrax. (Karen)

Dashboard counter with pdf and QB file

Once int.inv records are created system should post notification / files (pdf and QB import file) to dashboard.

Design for Version 2

Personal tools