We have a critical report named “TWM Income Statement Client and Vendor Detail” that we use to be able to see detail by GL Account by Client or Vendor. Our historical data was imported as Journal Entries with the Vendor tagged in the “Name” field in the JE line item. We DO have visibility to all of that Vendor data.
Starting in December 2020, when we went live with NetSuite, we started processing all of our Vendor payments through the NetSuite Vendor Bill process (where the Vendor name is part of the header information). At that time, we lost all visibility to the Vendor data in this report.
Dec 2020 and Jan 2021 all payments were lumped into “No Entity” and we can no longer see the Vendor detail.
Need a solution so that the Vendor data is displayed properly on the Income Statement report OR need a NEW report that will work properly. I’m certain we are not the only Client that has asked for report where you can drill down by GL Account by Client/Vendor/Employee. In fact, the whole point of bringing in the granular Client, Vendor and EE data is to be able to report on it.
Thank You for any help....