The field Histtype in the table Rm00104 has two values 0 and 1. When you run a query selecting value of type 0 or 1 could have an effect on total sales or cash. Does anyone know what the difference is between these two? Is there a program that can be run to re-sync the values in this table?
*This post is locked for comments
I believe the difference is whether the data is calendar year or fiscal year. They two records would be the same if your fiscal year is the same as the calendar year, otherwise they would (and should) be different.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (