Solved

Batch invoicing of service contract

  • 5 July 2023
  • 1 reply
  • 124 views
ELJO
Rank
Userlevel 3
Badge +6
  • ELJO
  • Sidekick (Customer)
  • 19 replies

Hi,
we need help to figure out how to use the parameters in order to create invoices for the correct periods. 

We are going to use a database task Schedule for Invoicing och Service Contracts:

We have the following set ups of Service Contracts that we want to batch invoice:

Yearly, Prior:
Price Unit: 1 Year
Invoice Rule: Prior
Interval: 1 Year

Yearly, Post:
Price Unit: 1 Year
Invoice Rule: Post
Interval: 1 Year

Every 6th months, Prior:
Price Unit: 1 Month
Invoice Rule: Prior
Interval: 6 Month

Every 6th months, Post:
Price Unit: 1 Month
Invoice Rule: Post
Interval: 6 Month

Quarterly, Prior:
Price Unit: 1 Month
Invoice Rule: Prior
Interval: 3 Month

Quarterly, Post:
Price Unit: 1 Month
Invoice Rule: Post
Interval: 3 Month

Monthly, Prior:
Price Unit: 1 Month
Invoice Rule: Prior
Interval: 1 Month

Monthly, Post:
Price Unit: 1 Month
Invoice Rule: Post
Interval: 1 Month

What parameters should we use and where to have our jobs running automatically once every month, last day of the month?

We use IFSAPP 10.17. 

icon

Best answer by FNSMITHUN 5 July 2023, 15:29

View original

1 reply

F
Rank
Userlevel 6
Badge +17

Hi @ELJO 

I would suggest you run this job at the beginning of every month, then you have the invoice ready for the month and the Pior or Post invoicing rule will set the invoice due dates in accordance with the payment term. You can schedule the job with the below setup so that it runs first day of every month and generate the invoice for the service contract invoice plan line which are having invoice period From Date lesser than or equal to the first day of the respective month.

For example: if you have 3 contracts as below. The invoices will be generated for all 3 contracts considering we are running job on 01/01/2023. The Prior & Post invoice doesn’t have impact on invoice generation, but this will set the generated invoice due as beginning or end of the month, year, quarter etc.

Yearly, Prior:  (Invoice generated for an year)
Price Unit: 1 Year
Invoice Rule: Prior
Interval: 1 Year

Every 6th months, Post: (Invoice generated for an 6 months)
Price Unit: 1 Month
Invoice Rule: Prior
Interval: 6 Month

Monthly, Prior: (Invoice generated for a 1 months)
Price Unit: 1 Month
Invoice Rule: Prior
Interval: 1 Month

The problems here is the yearly, half yearly or quarterly invoices are generated at the beginning of the invoicing period even though you set invoice rule as Post. So, if it would be possible to have a different contract type based on invoicing period & Rule then you can schedule multiple jobs to run one at the end of the year, quarter etc for these types of contracts.

 

Hope this help!!

Regards,

Mithun K V

Reply


Terms & ConditionsCookie settings