Hi @ramya15 

If you are importing Bills and Adjustments using the stock ACU Import AP Bills scenario (or manually entering them), as soon as the Bills are released/posted, if the Project and Task fields have been populated on the bills, it should automatically create the related project transactions for you.  You need to make sure that all GL accounts that should go to projects have an Account Group linked to them.  So for AP bills, this should be an “Expense” type account group.

On your Project Preferences and Accounts Payable Preferences screen, you will likely also want to have “Automatically Post on Release” selected.

Megan

Hello @ramya15 ,

Are you migrating historical project records? Are you trying to migrate project history to the projects, without duplicating the impact on Payables and General Ledger (maybe Bills and GL were migrated separately without project id’s)?

If so, you can import the Project historical balances, including AP bill transactions directly to Project Transactions. When we migrate project balances separately from Payables migration and GL migration, it’s important to leave the account and subaccount blank on the Project Transactions. Also, debits are entered as positive numbers and credits are entered as negative numbers in this siutation.

I’ve attached an import scenario for project transactions.  It’s from version 2021 so you may need to update the Import Scenario where you see red text.

I recommend entering one project as a test to make sure you see the desired result and correct debit/credit signs on the transactions. Good luck.

Laura