CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Moving Timecards between Entities in Intacct

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

by Hrayr Galoyan

If you have multiple entities setup in Intacct, you may come across a need to move timecards from one entity to another.

To move a timecard, first you need to export it from the source entity, reformat the import file to match Intacct requirements, re-import it into the target entity, and then delete the original timecard.

Exporting Timecards

You cannot export timecards directly from the “My Timesheets” or “Staff Timesheets” lists, because all you’ll end up with is the list of timesheets, without details. So you need to design a custom report for this purpose. Here is a partial screenshot of my report.


Basically, you include only those fields that you need for the import. To make it easier to reformat the report output for Intacct, I also sorted it by Employee ID and Begin Date. This helps me group individual time entries into one timesheet for import purposes later.

Formatting Report Output and Re-Import

Once you are happy that the report contains all the columns you need, and none of the columns you don’t need, export it into an Excel file. You will need to do some formatting in it.

Here is my report exported into Excel.


There are several things to do:

1.       Remove the report header

2.       Update column headers to match Intacct import specifications

3.       Reformat details to group time entries into timesheets

Here is how it looks after re-formatting.


Notice several important changes:

Duplicates are removed for EMPLOYEE_ID and BEGIN_DATE fields. If you leave the duplicates in, Intacct will import each line as a separate timesheet. Without duplicates, all lines up to the next employee ID and Begin Date are grouped into one timesheet.

BILLABLE field accepts T or F as valid values, so I used the LEFT function in Excel to only keep the first character.

With these changes done, save the Excel sheet as a CSV file and import using the standard import functionality in Intacct. The timecards import into the location determined by the employee record. You cannot override the location in the import file, so if an employee moved from one location to another, update the employee record first, and then import the timecards.

Delete the Original Timecards

Since the original timecards are still in the system, we now have duplicate data, so the originals must be deleted. Usually, the only holdup is if a timecard had a billable time (for Time and Expense type of projects) that was invoiced. If that happens, Intacct does not allow deleting the time. The solution is to delete the invoice first, delete the timecard, and then re-create the invoice.




Comments are closed.
On February 17, 2014 in General [Post:by]
Tagged With: multi-entity, timecards, timesheets, Intacct / 2311 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.