Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Date Settings:

    • Created Date - the date the invoice was created. Transactions for open or closed invoices will be included in the report

    • Due date - the due date specified on the invoice. Transactions for closed invoices only will be in this report

    • Posting Date - the date the invoice was posted. Transactions for closed invoices only will be in this report

    • Sent Date - the date that the invoice was sent (or printed if you are printing them). Transactions for closed invoices only will be in this report

  • Column Definitions:

    • User Balance - the balance as of the date selected, including transactions prior to the date
      Notice: disbursed payments are reflected in the User Balance column, even when the disbursed payment was made after the Date value you specified when creating the Report

    • Total - the total value of all outstanding invoice balances

    • Current - the amount on the account that is NOT overdue / aged

Aged Invoice Detail Balance

...

  1. Create SQL job in MSSQL Studio Management

  2. Set the SQL job to use 'BOSS' database or whatever your main EngageIP database is named

  3. Enter the SQL in the box below[cce lang='sql']
    declare @date datetime;
    set @date = convert(varchar,DATEADD(MONTH,DATEDIFF(MONTH,-1,getdate()),0),101)--'2017-01-01'
    exec logisense_boss_aged @date,'30','30','30','30'
    update agedreportsettings set date = @date where ownerid = 1
    [/cce]

    Code Block
    DECLARE @DATE datetime;
    SET @DATE = CONVERT(VARCHAR,DATEADD(MONTH,DATEDIFF(MONTH,-1,getdate()),0),101)--'2017-01-01'
    EXEC logisense_boss_aged @DATE,'30','30','30','30'
    UPDATE agedreportsettings SET DATE = @DATE WHERE ownerid = 1
    • Configure the date that you require, by default it’s the first day of next month

    • Configure the periods as you have selected on your AR settings on the Setup tab. By default, they periods are all set to 30 day periods

    • Define the ownerID of the owner you wish to have the AR generated for (usually ID 1 is correct)

  4. Configure the job to run on the schedule you require

  5. Test by manually executing the job and check that it has updated the AR as expected