Skip to main content
T
TAyers1257
February 21, 2024
Question

Transaction Detail Account Report

  • February 21, 2024
  • 1 reply
  • 0 views

Summary: When I print the Transaction Detail Account Report, filtered by a specific number (Work Order or Invoice Num, which is the same, eg "5409" because I apply "billable" Items from a Vendor Bill to a Customer Invoice and I want to see the profit associated with a specific Work Order. The Item setup includes the revenue account and a COGS account as the item is setup as an assembly item. My problem is I see all the transactions when filtered by "5409" EXCEPT the COGS expense account. If I change the date on the Vendor Bill to the current year (January 2024), it appears, but if the Vendor Bill date is December 2023, it fails to appear. I was told it was an issue with the expense account being a COGS, but when I changed it to a regular expense account, it still did not appear. It only appears if I change the Date on the Vendor Bill to the current year. I did not close the year yet; I am on an accrual basis so that does not appear to be an issue. The date range is also expansive so that is not the issue.

 

Can you help me figure out how to get these transactions to show up on the report as it is an easy tool to audit a specific Customer Work Order? Thank you!!

1 reply

H
Heide DC
February 21, 2024

Welcome to the Community, @TAyers1257.

Allow me to help you sort this out in no time. To give you a precise solution and expectation about the product feature specific to Transaction Detail by Account, may I see the actual filter choices you've made to customize this report?

I'll appreciate if you share some screenshots on your Filters tab when you customize the report and also see your output for the Transaction Detail by Account report. Please see the screenshots below as sample references:



 

In this manner, I can give you a precise answer for your case.

I'll wait for your response here. Take care always.

Terms & ConditionsAccessibility statement