Does anyone have experience with loading project balances. We have approx. 300 projects “live” that need to be brought over to Acumatica. Once the projects are loaded, how best to perform a mass update on project cost / revenue received to date?
If possible, just focusing on cost-to-date ATM. We’ll make a very simple budget structure that just relates to “cost types” Cost-to-date needs to be loaded against this simple structure.
Best answer by Laura02
View original
+18
Hello,
Import project to date costs to Project Transactions screen with account and subaccount columns left blank so as not to duplicate costs that are already recorded on your GL.
Revenue lines should have negative amount (credits) and Costs should have positive amounts.
I recommend testing one project in your test environment to make sure you achieve desired results.
+8
To add to Laura’s comment, please note this way your JC Transactions won’t have any link to GL Transactions because system will not generate GL Batches at all. Also, with this instructions in mind when you importing GL Transactions (if you import Trans not GL Balances) you MUST leave the Project Reference blank otherwise the GL Transactions will be generated in JC again. So Make sure your JC and GL Import batches are agreed before you proceed.
I wish Acumatica would allow importing GL Transactions with full reference to Job, Task, Cost Code, and Account Group to import GL Trans once and GL and JC updated together but it is not possible.
+18
I wish Acumatica would allow importing GL Transactions with full reference to Job, Task, Cost Code, and Account Group to import GL Trans once and GL and JC updated together but it is not possible.
If you want to import project transactions via GL, you can include Job, Task and Cost code. Then use the GL number that is linked to your Account Group. When importing from Excel, I use Vlookup on chart of accounts to convert data containing Account Group to GL account. When importing project detail via GL, use debits and credits, both revenue and cost numbers will be positive (no “-” sign in any financial amounts).
Thank you for adding this second option for the user to this thread.
+2
+8
Good to hear Acumatica has added (completed actually) this functionality to import JC transactions using GL Import scenarios. When in late 2020 I worked on my client data migration, it wasn’t available (only Job field was functional). I will use it next time.
Thanks Heidi, it doesn’t seem to allow me into any of these posted articles….
Any idea where I request the access the areas?
+8
if you are not an employee of Acumatica clients or partners you will not have access to KBs. I don’t have access to share the resource either 😕 otherwise by linking your account to the corporate account you can get access
if you are not an employee of Acumatica clients or partners you will not have access to KBs. I don’t have access to share the resource either 😕
Thanks!
We are a partner (Quest) but down here in Australia… so it is MYOB Advanced here…
Surely we can qualify
Hi
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
