Solved

Required Import Scenario template for Project Transactions


Userlevel 4
Badge

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

icon

Best answer by meganfriesen37 29 May 2023, 22:46

View original

2 replies

Badge +18

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

 

Userlevel 7
Badge +10

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved