gengohub id
unread,Aug 8, 2022, 12:49:24 AM8/8/22Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to iDempiere
good health everyone,
I want to ask in the View Allocation window that my document status is
still progressing, where the document is entered into the workflow,
meaning it is complete when it is approved, but the document status is
still progressing, and the invoice status has not been paid off, but
in open balance it has reduced the balance of receivables, because in
the function does not detect the document is complete or not, what is
the solution?
this is the open balance function snippet
FOR ar IN
SELECT a.AD_Client_ID, a.AD_Org_ID,
al.Amount, al.DiscountAmt, al.WriteOffAmt,
a.C_Currency_ID, a.DateTrx
FROM C_AllocationLine al
INNER JOIN C_AllocationHdr a ON (al.C_AllocationHdr_ID=a.C_AllocationHdr_ID)
WHERE al.C_Invoice_ID = p_C_Invoice_ID
AND a.IsActive='Y'
LOOP