Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incorrect account used during OE process (OE to GL)

Status
Not open for further replies.

ravazz

MIS
Dec 8, 2009
112
JM

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.

 
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.

 
Why do you need to change the account numbers?

Sage 300 Certified Consultant
 
@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
 
You know you can override GL account segments in Locations?

Sage 300 Certified Consultant
 
Yes we are aware.

But these transactions have been completed and are somewhere sitting in the OE awaiting to be transfer to GL
 
The best is to create the GL batch and then edit it.

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

Sage 300 Whisperer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top