Macola history report missing data

[csge]

Hello all,

I'm running macola progression on pervasive sql. When we run history repots, there is data missing from random customers on random dates.

Is there a way to tell if this information is still there and fix it, or should I restore from backup ? ?

note: One user had her hard drive fill up and often locked up while running history reports. I don't know if the missing data is the data she was working with when she was locking up.

Thanks for your help.

Jamie

 

[SusanD5320]

Sorry, had it backwards, May thru April. May=Period 1.

 

[kscheeler]

Susan,

If you have invoices that have not been posted to sales history, you can do that at any time. Regardless of the default year and period that show up, you can type in the year and period you want a specific date range to post to.

If you've posted invoices to a period that's wrong, what you need to do is (this is assuming you know SQL or Access)
1. Delete the records from OESLSHST_SQL for the year/period that is wrong.
2. Change the trx_posted_fg field in OEHDRHST_SQL for the two periods that were wrong.
3. Repost the invoices to the correct year/periods

As an example, if you were running a calendar year/month and you posted March's (3) invoices into February (2), you would have to delete period 2 in the OESLSHST_SQL table and flag all invoices in the OEHDRHST_SQL from 2/1 to 3/31 as "unposted" and then repost them to sales history. Once for February and a then for March.

Kevin Scheeler