You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL for Invoice Status based on As-of Date

in Payables, Payments & Cash Management 2 comments

Hi Team,

Can you please help provide a sample SQL where I can select the invoice amount and status based on as-of date.

For example, as of 24th Jan 2024.. invoice 001 was cleared on 1st Jan 2024, if I run the report using the as-of date 31st Dec 2023; invoice 001 should still appear as unpaid.

Is there a code for that?


Thank you

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!