Linking GeneralJournal to PurchaseReceipt

(0) Share

Report

Posted on by SU-22040800-0

2,463

I'm building a report in T-SQL, and trying to link the General Journal entries, against a specific GL account, to the Purchase Receipt number.

Is this possible?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

There are many Views are there to achieve these kind of requests.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Please use the below SQl to link General Journal entries with Purchase Receipt
using voucher, ledger account and purchase receipt number

-- Purchase order product receipt transactions
select journalAccountEntry.LEDGERACCOUNT, vendPackingSlipJour.PACKINGSLIPID, * from GeneralJournalAccountEntry as journalAccountEntry

inner join GeneralJournalEntry as generalJournalEntry
on journalAccountEntry.GeneralJournalEntry = generalJournalEntry.RecId
inner join SubledgerVoucherGeneralJournalEntry as subledgerVoucherGeneralJournalEntry
on subledgerVoucherGeneralJournalEntry.GeneralJournalEntry = generalJournalEntry.RecId
inner join VendPackingSlipVersion as vendPackingSlipVersion
on (vendPackingSlipVersion.LedgerVoucher = subledgerVoucherGeneralJournalEntry.Voucher
or vendPackingSlipVersion.CostLedgerVoucher = subledgerVoucherGeneralJournalEntry.Voucher)
and vendPackingSlipVersion.AccountingDate = subledgerVoucherGeneralJournalEntry.AccountingDate
and subledgerVoucherGeneralJournalEntry.Voucher = 'Voucher#1'
inner join vendPackingSlipJour as VendPackingSlipJour
on vendPackingSlipJour.RecId = vendPackingSlipVersion.VendPackingSlipJour
inner join purchTable
on purchTable.PurchId = vendPackingSlipJour.PurchId
where journalAccountEntry.LEDGERACCOUNT = 'XYZ-123-123'
and vendPackingSlipJour.PACKINGSLIPID = 'PurchReceipt#'

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
Verified answer

SU-22040800-0 2,463 on at

Like (0)

Report
Copy link

Link copied!

Hi everyone

Thanks for the responses on this.

The issue i'm facing on this, is that I have charges that are posted when matching the invoice, that i need to match to the receipt that is linked to the charge.

For example, i have REC_1 for 50, and REC_2 for 150, and a 10% charge that is calculated on these when matching the invoice. When the invoice is matched, and posted, the charges post to the correct charge account at 5 and 15, as two separate lines.

I need to link the receipt numbers (REC_1 & REC_2) with the charge amounts (5 & 15) and show that on a report.

any ideas?

Was this reply helpful? Yes No
SU-22040800-0 2,463 on at

Like (0)

Report
Copy link

Link copied!

Hi All

I resolved this by posting the charges at receipt.

Was this reply helpful? Yes No