Macros are available for two purposes:
▪To customise the default billing job description within the stock grid and invoice description. The macro can be specified at a global level, or can be overridden for a particular contract.
▪To customise the stock description at a job level. Macros with Meter as part of the macro are available. The macros are stock-specific and can be edited via the stock record Contracts tab in the Macro Desc field.
There are three areas where macros can be edited:
1.On the ribbon, go to Tools > Options > Contract > Managed Print Services.
Within this area of Options, any macro with Meter in it is unavailable. The default Fault Desc. and Invoice Desc. can be changed by adding macros to the descriptions, or more generic information can be entered here. The available macro options are shown below.
2.On the ribbon go to Contracts > View/Edit Contract.
3.On the ribbon go to Stock > View/Edit Stock.
The list of macros is available either by right clicking on the field, or by clicking the + button attached to the field.
Macros in Tools > Options
These are also in meter-specific macros.
Macro |
Description |
|---|---|
Project.Card.Name |
The name of the cardfile attached to the contract. |
Project.Project # |
The contract number. |
Project.Serial # |
The contract serial number. |
Project.Missed Cycles |
The number of times the contract has had its billing skipped. |
Project.Item.Code |
The contract Item code. |
Project.Item.Make |
The contract Item make. |
Project.Item.Model |
The contract Item model. |
Project.Item.Description |
The contract Item description. |
Project.Job.Bill Date |
For non-manual contract copier billing, this is the same as the Next Bill Date, otherwise it is the submission date, if supplied. There are sub-categories under this and following Project.Job entries in this table. |
Project.Job.Date In |
The date the job was created. |
Project.Job.Date Due |
The date due on the job that was created. For copier billing jobs, this normally relates to the Next Bill Date on the contract. |
Project.Job.Read Date |
When manually entering a read, this date corresponds to the Date field in the Billing Meter Read screen. When a meter read job is generated via an MPS Connector (ie. FMAudit), this date will contain a value if it is supplied as part of the feed. |
Project.Job.Previous Job.Bill Date |
This corresponds to the Bill Date value for the previous job of the same type for the contract when ordered by Date Due. |
Project.Job.Previous Job.Date In |
The Date In of the previous job on the contract. |
Project.Job.Previous Job.Date Due |
The Date Due of the previous job on the contract. |
Project.Job.Previous Job.Read Date |
The Read Date of the previous job on the contract. |
Project.Job.Previous Job.Date Out |
This is the Date Out value for the previous job of the same type for the contract when ordered by Date Due. This is typically the invoice date of the previous job. |
Project.Job.Next Job.Bill Date |
This is the calculated Next Bill Date for the contract. It takes into account the current Next Bill Date and billing frequency. |
Meter specific macros (including the above macros)
Macro |
Description |
Project.Meter.Counter.Name |
The meter name as per the meter setup on the contract. |
Project.Meter.Rate TF |
The rate ex as per the meter setup. |
Project.Meter.Rate TP |
The rate inc as per the meter setup |
Project.Meter.Base TF |
For a Base Charge meter type, this is the rate ex, otherwise this is an empty value. |
Project.Meter.Base TP |
For a Base Charge meter type, this is the rate inc, otherwise this is an empty value. |
Project.Meter.Min TF |
For a Min Charge meter type, this is the rate ex, otherwise this is an empty value. |
Project.Meter.Min TP |
For a Min Charge meter type, this is the rate inc, otherwise this is an empty value. |
Project.Meter.Effective Periods |
Returns the number of billing periods of the contract this particular meter is being billed for. For a quarterly billed meter on a monthly billed contract, this value will normally be 3. This calculation also takes into account the number of billing periods skipped. For instance, if the contract's billing had been skipped 4 months previously, this value would be 6 as it is now billing two quarters. |
Project.Meter.Missed Cycles |
This displays the number of missed cycles. If no cycles have been missed, this is an empty value. |
Project.Meter.Min Charge Pages |
This is the number of pages that would be required to make up the minimum charge. It considers who the meter is being billed to when performing the calculation. For example, a contract that has a Finance black meter as well as a minimum charge. A similar effect can be achieved by using a minimum volume on a black, colour or scan meter. |
Project.Meter.Job.Expire Date |
If a prepaid meter generates a purchase of a prepaid block of pages, this macro evaluates to the date that the pages expire. It is based on the next bill date at the time the prepaid block is purchased. |
Project.Meter.Job.Expire Meter Read |
For a prepaid meter, this evaluates to the meter read on the linked meter when any purchased pages will expire. |
Project.Meter.Over Rate TF |
The overs rate ex as per the meter setup. This evaluates to nothing for non-rate-based meter types. |
Project.Meter.Over Rate TP |
The overs rate inc as per the meter setup. This evaluates to nothing for non-rate-based meter types. |
Project Meter.Job.Over Total |
The dollar amount of the total overs charged. |
Project.Meter.Minimum Volume |
The minimum volume as per the meter setup. |
Project.Meter.Job.Meter Read |
The new count of the meter, ignoring the effect of any estimates. |
Project.Meter.Job.Effective Meter Read |
The new count of the meter, including any estimated amounts. |
Project.Meter.Job.Estimated Meter Read |
The new count of the meter if the read is an estimate. This evaluates to nothing for a real read. |
Project.Meter.Job.Previous Job.Meter Read |
This corresponds to the meter read value for the same meter on the previous job of the same type for the contract, when ordered by date due. |
Project.Meter.Job.Previous Job.Effective Meter Read |
Meter read on previous contract job. |
Project.Meter.Job.Previous Job.Estimated Meter Read |
Estimated meter read on previous contract job. |
Project.Meter.Job.Qty |
The total quantity billed for the particular meter including standard, unders and overs billing but excluding estimated amounts. |
Project.Meter.Job.Estimated Qty |
The total quantity billed for the particular meter including standard, unders and overs billing only including estimated amounts. |
Project.Meter.Job.Pages |
The total quantity billed for the particular meter including standard, unders and overs billing but excluding any estimated amounts. This evaluates to nothing for non-rate-based meters. |
Project.Meter.Job.Effective Pages |
The total quantity billed for the particular meter, regardless of whether it is an actual or estimated amount. |
Project.Meter.Job.Standard Qty |
The standard quantity billed for the meter. |
Project.Meter.Job.Under Qty |
The unders quantity billed for the meter. |
Project.Meter.Job.Over Qty |
The overs quantity billed for the meter. |
Project.Meter.Job.Purchases Prepaid Blocks |
The number of prepaid blocks purchased. |
Project.Meter.Job.Purchased Prepaid Pages |
The total number of prepaid pages (blocks X block size) purchased. |
Project.Meter.Job.Previous Job.Prepaid Count |
The number of prepaid pages available after the previous meter read. |
Project.Meter.Job.Prepaid Count |
The number of prepaid pages available after the current meter read. |
Project.Meter.Prepaid Block Size |
The prepaid bulk pages as per the meter setup for a prepaid meter. |
Project.Meter.Job.Bill Date |
This is the next bill date when a contract is being billed. Exactly the same as Project.Job.Bill Date. Kept separate for symmetry. |
Project.Meter.Job.Date In |
The date the meter read job was created. Exactly the same as Project.Job.Date In. |
Project.Meter.Job.Date Due |
The date the meter read job is due. Exactly the same as Project.Job.Date Due. |
Project.Meter.Job.Read Date |
When manually entering a read, this date corresponds to the Date field in the Billing Meter Read screen. When a meter read job is generated via an MPS feed, this date will contain a value if it is supplied as part of the feed. Exactly the same as Project.Job.Read Date. |
Project.Meter.Job.Previous Job.Bill Date |
The bill date of the job the last time this meter was billed. May be different to Project.Job.Previous Job.Bill Date if the meter is billed at a different periodicity to the contract. |
Project.Meter.Job.Previous Job.Date In |
The Date In of the job the last time this meter was billed. May be different to Project.Job.Previous Job.Date In if the meter is billed at a different periodicity to the contract. |
Project.Meter.Job.Previous Job.Date Due |
The Date Due of the job the last time this meter was billed. May be different to Project.Job.Previous Job.Date Due if the meter is billed at a different periodicity to the contract. |
Project.Meter.Job.Previous Job.Date Out |
The Date Out (the invoice date) the last time this meter was billed. May be different to Project.Job.Previous Job.Date Out if the meter is billed at a different periodicity to the contract. |
Project.Meter.Job.Previous Job.Read Date |
The read date the last time this meter was billed. May be different to Project.Job.Previous Job.Read Date if the meter is billed at a different periodicity to the contract. |
Project.Meter.Job.Next Job.Bill Date |
The date the next time this meter is due to be billed. This is calculated using the current date due, and either the periodicity of the meter or the periodicity of the contract. |
There are also a corresponding set of macros for a linked meter, if available. They can be formed by adding the wording Linked Meter after the Meter part of the macro, ie. Project.Meter.Linked Meter.Counter Name. There is also some special handling of macros when they are for meter billing kits.
Meter Kit Macro Handling
Macro |
Description |
|---|---|
Project.Meter.Rate TF |
The sum of all rate ex for included stock where the stock relates to a rate-based meter type, and it is not a third party purchase order meter. |
Project.Meter.Rate TP |
The sum of all rate inc for included stock where the stock relates to a rate-based meter type, and it is not a third party purchase order meter. |
Project.Meter.Base TF |
The sum of all rate ex for included stock where the stock relates to a Base Charge meter type. |
Project.Meter.Base TP |
The sum of all rate inc for included stock where the stock relates to a Base Charge meter type. |
Project.Meter.Min TF |
The sum of all rate ex for included stock where the stock relates to a Min Charge meter type. |
Project.Meter.Min TP |
The sum of all rate inc for included stock where the stock relates to a Min Charge meter type. |
Date Macros
Each date has a corresponding set of sub macros attached to it. The first two are each dates. They are:
▪Previous Month
▪Next Month
For each individual date macro (including Previous Month and Next Month) there are the following sub macros:
▪Day
▪Month
▪Year
▪LongDateFormat
For example, if the contract's bill date was 30th May 2019, the following macros would evaluate:
Project.Job.Bill Date |
30/05/2019 |
Project.Job.Bill Date.Previous Month |
30/04/2019 |
Project.Job.Bill Date.Month |
May |
Project.Job.Bill Date.Next Month.LongDateFormat |
Sunday, 30th June, 2019 |
Project.Job.Bill Date.Next Month.Month |
June |
Suggested Macros
All of the above macros can be used in any combination to suit specific needs. As a starting point, consider the following macros, as these work nicely with estimates, and the clawing back of estimates.
The suggested macro for purchase order stock is very similar, except that it includes the additional information about the customer (which would be redundant for meter billing stock) and serial number.
The suggested macro to use for billing stock is:
{{Project.Meter.Counter Name}}{{"Last Read="Project.Meter.Job.Previous Job.Meter Read" "}}{{"Last Estimated Read="Project.Meter.Job.Previous Job.Estimated Meter Read" "}}{{Project.Meter.Job.Previous Job.Date Due}}{{"Current Read="Project.Meter.Job.Meter Read" "}}{{"Estimated Read="Project.Meter.Job.Estimated Meter Read" "}}{{"Prints="Project.Meter.Job.Qty" "}}{{"Estimated Prints="Project.Meter.Job.Estimated Qty" "}}
For example, below image shows the stock description using the macros that are fired:
In this case, the macros fired are:
{{Project.Meter.Counter Name}}{{"Last Read="Project.Meter.Job.Previous Job.Meter Read" "}} – Black Last Read=12,000
{{Project.Meter.Job.Previous Job.Date Due}} – 15/03/2019
{{"Current Read="Project.Meter.Job.Meter Read" "}} – Current Read = 16,000
{{"Prints="Project.Meter.Job.Qty" "}} – Prints=4,000
For 3rd party purchase orders, the suggested macro is:
{{Project.Card.Name}}{{"Serial No="Project.Serial #" "}}{{Project.Meter.Counter Name}}{{"Last Read="Project.Meter.Job.Previous Job.Meter Read" "}}{{"Last Estimated Read="Project.Meter.Job.Previous Job.Estimated Meter Read" "}}{{Project.Meter.Job.Previous Job.Date Due}}{{"Current Read="Project.Meter.Job.Meter Read" "}}{{"Estimated Read="Project.Meter.Job.Estimated Meter Read" "}}{{"Prints="Project.Meter.Job.Qty" "}}{{"Estimated Prints="Project.Meter.Job.Estimated Qty" "}}
For service reads, the suggested macro is:
{{Project.Meter.Counter Name}}{{"Current Read="Project.Meter.Job.Meter Read" "}}{{Project.Meter.Job.Read Date}}
Further information