Skipping GLE_Sourcejournal on inventory adjustment

[ggastelum]

I am manually inserting data into IM1_inventorymasterfile,
IM2_inventoryItemwhsedetl, IM5_transactionDetail,
IMM_compntusagedetail for any new
inventory made at my clients warehouse. I am altering those
tables because I know they are altered after a transaction
entry is used for an adjustment and then the transaction journal is printed. My issue is that I am having problems
updating the GLE_sourcejournal table. When I do an update
to gle-sourcejournal, the data for the "IA" row (which I
update) becomes corrupted. If I don't update the
GLE_sourcejournal, will there be any issues at a later
time caused by not updating the GLE_sourcejournal table?
Also, Does anyone know of a way to do an update on the GLE
table without corrupting the data? Thanks for any help.

George.

 

[PgmrChris]

I'm not sure what is causing your G/L corruption.. but I can help you with your question on whether it is necessary. The GLE Source Journal table primarily is a "sequence counter". When you post to G/L.. say an inventory adjustment, it will look in the GLE table for record "IA".. and see what the next available G/L batch number is.. It will consume it and bump it so the next IA-type posting gets a unique number.

The result of not incrementing the GLE batch number is that G/L postings of the same type on the same date will l look like they were posted together (because they will have an identical posting date and G/L batch number) when in fact, they could be seperate events.. there will be no way to distinguish which is which from inside of MAS90.

Most G/L reports allow you to filter G/L transaction detail by both a batch number and a posting date, so if you don't do multiple postings of the same G/L source code on the same day, this may not be much of an issue for you..

Hope this helps!

 

[ggastelum]

Chris,

Thanks for the help. I am trying to create one adjustment
number for all inventory that enters the warehouse in a day.
It sounds as if I can avoid updating the GLE_Sourcejournal
table. If you recall, You helped me with the IMH table
where I couldn't get any data into the table using SQL.
I have moved past that and am now trying to update the
IM1_InventoryMasterfile, IM2, IM5 and IMM tables. I noticed
those were the only tables being altered when running the
transaction journal. I am having problems doing an update
or insert into those tables as they also get corrupted.
Oh well. Again, thanks for your help. You are very
knowledgeable about this product.

George