Batch Upload Workspace

Modules in this category

• Batch Upload Workspace
• ProFiles Data Interchange
• Batch Upload Workspace
• ProFiles Data Interchange

Module categories

• Data tools
• Database
• Day-to-day
• Document tools
• Email
• Finance
• Licensing
• Reporting
• Royalty
• Security
• System-wide

Category: Data tools

This modules is comprised of two distinct sub-modules: Batch Upload of Sales and Royalty Data The entry of thousands of SKU-based line items in every royalty report for every contract can become a cumbersome if not impossible task in very short order. The Batch Upload Process is designed to alleviate that problem. Using a pre-defined format which includes up to 53 columns of detailed Sales and SKU information for each single sale of an item, the Batch Upload process will automatically create the SKUs in ProFiles, validate and populate the Sales information in all of the contracts, calculate royalties, post those royalties, and update any items necessary in Accounts Receivable and Accounts Payable. All of this by simply running a process. Along the way, several audit and verification reports are provided. After each report, the option to terminate the upload process is provided. This allows for correcting data errors at the source, not after the error has been propelled forward. The Batch Upload Process reduces weeks of manual entry and posting into a single process that can be completed in a few short hours. Batch Upload Pre-Processor As an enhancement to the standard Batch Upload, the Batch Upload Pre-processor performs two very time efficient processes which can reduce the actual upload time dramatically. Many times the data in a batch upload is pulled from multiple sources or a sales processing system where a single item may appear thousands of times in a single period on several invoices for several customers. Furthermore, pure sales/shipping information sometimes only knows product and has no real reference to Contracts. The Batch Upload Pre-processor takes care of this. Its first process will accept a sales upload file with no contract identifiers and perform an extensive search through the ProFiles data to automatically associate the sales items with the appropriate contracts.