Hi Team,
Does anyone have have import scenario template to import “Bills and Adjustment” transaction to Project Transaction screen. Please help me on this.
Regards,
Ramya Krishna
Solved
Required Import Scenario template for Project Transactions
Best answer by meganfriesen37
Hi
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
1 person likes this
+11Hi
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
Megan Friesen, Contego Software Solutions, Canada
+19Hello
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
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.