Update G/L Accum G/L Account

SUGGESTED

Posted By Cliff Black 2 months ago

Hello, I need to update my G/L Accum Account with new G/l Information for all Active Asset. Is there a way to export a spreadsheet, update the information and then import it back into Sage Fixed Asset with the Syst No and the New G/L Accum info?

Top Replies

Andrew Doak 2 months ago +1 suggested

Hello Cliff,

You can absolutely create a spreadsheet with the system number and new GL accounts and import. If you go to File, Company Utilities, Custom Export, you can export the existing assets and their…

Parents

0 Andrew Doak 2 months ago

SUGGESTED

Hello Cliff,

You can absolutely create a spreadsheet with the system number and new GL accounts and import. If you go to File, Company Utilities, Custom Export, you can export the existing assets and their current G/L account numbers. See How to do a custom export. The system only needs the system numbers and G/L account information in the excel sheet. To reimport, see How to import changes to existing assets.
Cancel
Vote Up +1 Vote Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 Andrew Doak 2 months ago

SUGGESTED

Hello Cliff,

You can absolutely create a spreadsheet with the system number and new GL accounts and import. If you go to File, Company Utilities, Custom Export, you can export the existing assets and their current G/L account numbers. See How to do a custom export. The system only needs the system numbers and G/L account information in the excel sheet. To reimport, see How to import changes to existing assets.
Cancel
Vote Up +1 Vote Down

Reply

Verify Answer

Reject Answer

Cancel

Children

No Data

Update G/L Accum G/L Account

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING