x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 6 replies
  • Subscribers 132 subscribers
  • Views 1167 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
764
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
414
replies
Mike Cook

IC Internal Usage - Reverse?

Posted By

Had a user today accidentally write off a huge QTY of an item today due to using wrong UOM.  Just wondering what other users would do to reverse this?  Obviously I can just adjust the items back in but our reports would still see that usage number and it will show it as a spike usage for years to come.  I'd like to find a way to back out that usage.

I wish there was a way to un-use an item.  Slight smile

Just looking for some input in case anyone has encountered before.  Normally I just adjust it, but in this case, it's a large QTY.

Parents
  • 0

    I am sure that Sage meant to have a reversal routine but didn't write the logic.

    The table info shows a return type but I tested an import and it didn't reverse.

    Table: Internal Usage Headers

    Table: ICICEH
    View: IC0288
    Record Length: 288

    Flags: A R 

    Keys: 6

    Title Flags Fields
    Sequence Number SEQUENCENO
    Transaction Number M  TRANSNUM
    Record Status M  STATUS, TRANSNUM
    Document Number DOCNUM
    IC-Unique Document Number D M  DOCUNIQ
    Status by Document Number M  STATUS, DOCNUM

    Fields: 22

    Field Type Title Presentation
    SEQUENCENO Long Sequence Number
    AUDTDATE Date
    AUDTTIME Time
    AUDTUSER String*8
    AUDTORG String*6
    TRANSNUM BCD*10.0 Transaction Number
    DOCNUM String*22 Internal Usage Number Mask: %-22C
    HDRDESC String*60 Description
    TRANSTYPE Integer Entry Type List:2 entries
    1 = Internal Usage
    2 = Return
Reply
  • 0

    I am sure that Sage meant to have a reversal routine but didn't write the logic.

    The table info shows a return type but I tested an import and it didn't reverse.

    Table: Internal Usage Headers

    Table: ICICEH
    View: IC0288
    Record Length: 288

    Flags: A R 

    Keys: 6

    Title Flags Fields
    Sequence Number SEQUENCENO
    Transaction Number M  TRANSNUM
    Record Status M  STATUS, TRANSNUM
    Document Number DOCNUM
    IC-Unique Document Number D M  DOCUNIQ
    Status by Document Number M  STATUS, DOCNUM

    Fields: 22

    Field Type Title Presentation
    SEQUENCENO Long Sequence Number
    AUDTDATE Date
    AUDTTIME Time
    AUDTUSER String*8
    AUDTORG String*6
    TRANSNUM BCD*10.0 Transaction Number
    DOCNUM String*22 Internal Usage Number Mask: %-22C
    HDRDESC String*60 Description
    TRANSTYPE Integer Entry Type List:2 entries
    1 = Internal Usage
    2 = Return
Children

*Community Hub is the new name for Sage City