Sage 100

 View Only
Expand all | Collapse all

Client performed I/M Physical Count but incorrectl

  • 1.  Client performed I/M Physical Count but incorrectl

    Posted 01-05-2012 07:02
    Client performed I/M Physical Count but incorrectly posted the Variance Register to Dec 31, 2012, not 2011. The G/L was easily fixed but we're wondering if we should be overly concerned with all the I/M transactions that are still in Dec '12 in the I/M module. In general the qtys seem fine but it appears that transaction related things are incorrectly impacted. So therefore for example, the I/M Trial Balance Report for 12-31-11 is off because it's not picking up those 12-31-12 trans. But the I/M Stock Status and Valuation Report appear correct, as do all other qty-based reports, screens, etc. Restoring from backup isn't really an option because this happened 2 days ago, plus they'd like to avoid having to re-key the 1,700 item counts. Another option could be to manually reverse the postings with the wrong date via I/M Trans Entry, and then re-enter them with the correct date but again that's a lot of extra re-keying of data. I also thought of exporting the Phy Ct postings and reverse them via a VI import with the bad date, and re-import with the correct date but that could be a bit time-consuming especially since most items are FIFO. So again we come back to whether we should be concerned with these incorrect postings to Dec '12.


  • 2.  RE: Client performed I/M Physical Count but incorrectl

    Posted 01-05-2012 07:04
    What version?


  • 3.  RE: Client performed I/M Physical Count but incorrectl

    Posted 01-05-2012 07:37
    @BethBowers, 4.30.0.20


  • 4.  RE: Client performed I/M Physical Count but incorrectl

    Posted 01-05-2012 07:48
    Darn. The imports into Trans Entry are so much easier with FIFO in 4.40 - it would have definitely been the way to go.