AR aging in query generator includind AR down payment invoices

[Former Member]

How to add AR down payment invoice with OINV for open invoice open amount in Query Generator? How to add column total on the column header (Ctrl + F?)

How to change the Preview to landscape when query data pop-up?

I tried to export to Excel but did not save to correct path that I setup in the general setting path tab, only can save as txt file but PDF turned out fine, why? I used SAP Business One, ExclDocs. Word to WordDocs\English, Picture to Bitmap, Attachment to attachment.

[Former Member]

Will create AP Invoice to offset AR Down Payment Invoice and PO Receipt.

[Former Member]

Hi Lily Chien,

Please post one question per one thread.

If you need the A/R Invoice + Down Payments Invoice Detail. Try this Query,

SELECT Distinct(T0.DocNum), T0.DocDate, T0.CardCode, T0.DocTotal, T0.DpmAmnt, T0.DocStatus 
FROM OINV T0 
INNER JOIN ODPI T1 ON T0.DpmAmnt = T1.DpmAmnt 

Regards,

Madhan.

[Former Member]

You have too many questions in one thread. Please follow forum rule: i.e. one question per one thread.

Answer to your question by your subject: AR down payment invoices are belong to particular category of invoices that would be treated as deposit. In another word, it is not fully booked yet. You have to create formal invoice to confirm it. Therefore it may not be possible to be included in the Aging report.

Thanks,

Gordon