GL balances

[Prerna99999]

hi

Doing a conversion from AccPac...Don't know AccPac at all. I know GLPOST is the main balance table. I also know that I need balances not just by account but also split by the optional fields (at this company they are using Product, Lender,etc) and also with the transaction currency and base currency. Guess in AccPac these may be referred as source currency and functional currency.

Can someone give me which tables I need to join keeping the above in mind so I can get my balances to load to the other ERP...

Thx!

 

[Jay Converse]

GLAFS

 

[Prerna99999]

Hi

GLAFS does not have distinction by currency....need to keep the currency in mind...also OPTFIELD is not a field there...and I know I need balances split by this...Would you be able to tell me how to combine these requirements?

 

[Jay Converse]

Yes it does, look again. And there are no balances by OPTFIELD.

 

[ettienne]

I would extract the transaction detail from GLPOST, the related optional field data is in GLPOSTO.