Share
ReportI need to create a turnover report which contains YTD, and LYTD as per item number. Which tables can I use to get this information?
*This post is locked for comments
You’re offline. This is a read only version of the page.
2
I need to create a turnover report which contains YTD, and LYTD as per item number. Which tables can I use to get this information?
*This post is locked for comments
Hi Rosemary,
This information is in the Inventory Sales Summary History table IV30101.
Keep in mind that the numbers in this table reflect the 'amounts since last close'. This table is not driven by transaction date.
Also, the table does not record information by location ID.
If you need that kind of info, you'll need to work your magic with the Item Transaction Amounts History table IV30300.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
