Incorrect account used during OE process (OE to GL)

[ravazz]

Our system is set to create OE GL batch on request using icon.

We are yet to create GL batch for a number of entries. We need to change the account number before creating these GL batches.

Which tables does it use to pull the information from to send over to GL.

 

[DjangMan]

Why not create the GL batch and change the GL batch? Or post the GL batch, unchanged, and then enter a journal entry to re-code the transactions. That will keep your audit trails intact.

 

[ettienne]

Why do you need to change the account numbers?

Sage 300 Certified Consultant

 

[ravazz]

@dejaman we need to modify it per item hence why we would rather doing it from OE

@ettinne the default code used is for one location and we want to update it for each location

Item code apple
Location 2
Gl is 7000-2

Item code apple
Location 3
Gl is 7000-3

 

[ettienne]

You know you can override GL account segments in Locations?

Sage 300 Certified Consultant

 

[ravazz]

Yes we are aware.

But these transactions have been completed and are somewhere sitting in the OE awaiting to be transfer to GL

 

[ettienne]

The best is to create the GL batch and then edit it.

Sage 300 Certified Consultant

 

[Jay Converse]

Then you need to configure your system with the proper segment overrides, and make the batches automatic.

Sage 300 Whisperer