IC Internal Usage - Reverse?

Posted By Mike Cook over 1 year ago

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.

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.

0 Jay Converse Acumen over 1 year ago

Restore from yesterday's backup.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cook over 1 year ago in reply to Jay Converse Acumen

We process so many transactions and are operation 16 hours a day, so I don't think that would be feasible as that would reset everything, would it not?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 1 year ago in reply to Mike Cook

That's right, so you'll have to live with the numbers on your reports.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cook over 1 year ago in reply to Jay Converse Acumen

that's what I figured. I "could" do a dummy OE credit to put the items back to stock and reduce the usage #'s but then I'd have to screw around with the GL's as one side put it into a usage GL and the other would be an OE credit side. But it would complete the task of putting stock back in and reducing the usage.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 4139750 over 1 year ago

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

0 Mike Cook over 1 year ago in reply to 4139750

yeah I saw that before as well. it's too bad as people do make errors.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

IC Internal Usage - Reverse?

Table: Internal Usage Headers

Keys: 6

Fields: 22

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING