Hello Experts, Could you please help me build a query that shows all payment means and the G/L account it hits. I also would like to be able to select a date range. Please see picture to see how it should look like.
Hello Dear Experts,
I have the following query, I am trying yo link the G/L account names for each payment. However, my account names comes out blank. Can anybody help?
SELECT
T0.[DocDate] AS 'Payment Date',
T0.[DocNum] AS 'DocNum',
CAS...
Hello kothandaraman.nagarajan ,This query does not show the Sales orders with no delivery and Sales orders with delivery but no invoice. Do you have a suggestions to pull those Sales orders as well?
msundararaja.perumal I am sorry for not explaining well. I attached a screenshot from A/P Invoice and its Outgoing payment Journal Entry. What I actually need here is the G/L account of the A/P that was paid. Just a reminder, One A/P invoice might ...
