Share
ReportI am fetching open invoices from vendor ledger and detailed vendor ledger to pick the remaining balance, which will be our total creditors amount.
But our requirement is to pick this remaining amount per GAP, which we are picking from Invoice Line amount table.
So one invoice can have multiple GAP number and their amount respectively.
Our problem is we don't have all GAP number here in the table, neither on detailed and vendor ledger entry table.
How could we get per GAP remaining amount from the sql server database.
Please help.
*This post is locked for comments
All responses (
Answers (
43,745
