Items invoiced

[nate100]

Can sombody confirm that the following query will give me the sales order numbers that have been invoiced but no money collected on yet?


for each ih_hist
where ih_domain = "us1"
no-lock:
find first ar_mstr where ar_domain = "us1" and ar_nbr = ih_inv_nbr
no-lock no-error.

if not avail ar_mstr then
display "no money collected yet from " ih_nbr ih_nbr ih_inv_nbr .
end. /* for each ih_hist */

 

[mjdarm]

while posting the invoice, ar_mstr gets created automatically. hence if you check for not avail for ar_mstr may not work.

you will need to do a ar_mstr check where ar_nbr = ih_inv_nbr and ar_tyep = "i" and ar_applied = 0 and ar_open.
if yes then "no money collected for this invoice"

else
if ar_applied <> 0 and ar_amt <> ar_applied then
"partial money is collected".

Hope this helps.

 

[nate100]

Thank you so much for your response. I have a followup question.
I see that the type is I in the ar_mstr with a batch number. When Accounging enters, do they need to reference this batch number?

Thank you.

 

[Kishor Chari]

Batch nbr is used to group ar_nbrs . It not used by accountants in thier GL processing.

 

[nate100]

Hello Sir,
Thank you for your reply. Can you please help me understand what ard_det stores. Thank you.

 

[Kishor Chari]

Distribution line details ie a/c , sub a/c , cc , amt , disc etc.