Please visit our new TrackAbout Knowledge Base at https://supportkb.trackabout.com for the most-up-to-date documentation on TrackAbout and TrackAbout Mobile.
Difference between revisions of "Right Size Customer Balances"
(→Notes) |
|||
| Line 3: | Line 3: | ||
#Export a file from your accounting system. If manipulating the data in a spreadsheet after export, be sure to retain leading zeros of numeric data. '''[[Importing Data in to Excel|Consult this page for more details]]''' | #Export a file from your accounting system. If manipulating the data in a spreadsheet after export, be sure to retain leading zeros of numeric data. '''[[Importing Data in to Excel|Consult this page for more details]]''' | ||
| + | ##Be sure that your file has only the following columns: Customer Number, Product Code, Cylinder Balance, Product Code Description | ||
#Create a Support ticket by emailing Support | #Create a Support ticket by emailing Support | ||
#Fill the '''[https://docs.google.com/a/trackabout.com/forms/d/e/1FAIpQLSc2zKhc7r6a9US9J6HSv6wa1e_FMhAFLn9BnD8PXqekYZ_J4g/viewform Right Sizing request form]''' | #Fill the '''[https://docs.google.com/a/trackabout.com/forms/d/e/1FAIpQLSc2zKhc7r6a9US9J6HSv6wa1e_FMhAFLn9BnD8PXqekYZ_J4g/viewform Right Sizing request form]''' | ||
Revision as of 09:18, 21 September 2018
Rightsize Requests
If you need to reconcile customer balances against your accounting system using Not-Scanned assets, please submit a request for rightsizing to the Support team.
- Export a file from your accounting system. If manipulating the data in a spreadsheet after export, be sure to retain leading zeros of numeric data. Consult this page for more details
- Be sure that your file has only the following columns: Customer Number, Product Code, Cylinder Balance, Product Code Description
- Create a Support ticket by emailing Support
- Fill the Right Sizing request form
Prior to sending your rightsizing files, please double check for accuracy. Some common mistakes below are:
- Dropping leading zeros from customer numbers
- Duplicate product code lines for customers (this will cause the balance to double)
Notes
- During the right sizing process, each customer's existing balance for a given type is compared to the balance contained within the uploaded file. If balances do not agree between the uploaded file and TrackAbout, the process will create new TrackAbout Adjustment records to reconcile the balance.
- This page does not compare Exchange Asset Types. All Exchange Asset Types will be ignored.
- Important: We will not process Right-Sizing requests for dates more than 3 months in the past since customer adjustments may not be accurate when right sizing in the past.
Furthermore, even when right sizing within the past 3 months, if your company uses Payer Logic and you ask us to conduct a rightsizing in the past (not as of the current date), Payer Logic will not be enacted.
For Ignored Product Codes
If you use generic product codes that are "ignored", and you want to import them in to your customer balances, they must be set to "tracked" prior to the rightsizing, or else they will not show up on the balance.
- If any Product Codes have Tracking Status = Ignored, then the right sizing tool will set their balances = 0 for those Product Codes.
In order to avoid this, please follow the steps below:
- Set all ignored product codes to "tracked" using the Product Code Mappings page.
- When sending your rightsizing file, please provide the product codes that should be set back to ignored
- Your TrackAbout Support team will change the product codes back to ignored when the rightsize is complete