That's why a software called Quadrate were exist to solve this problem as a data porter. I am one of the few guys in the team were given this access right to process those invoice batch uploading for payment.
Since this was not my first time in handling this tool, after a few minutes of refreshment, I had to hands on the real tasks. It's almost month end, I must ensure that all the billing files are uploaded before the 1st day of the month.
Well, never assume some thing is easy or very hard, I forgot to remind myself. The situation looked good at first several files. The tool transferred the data into SAP smoothly, and turn into real lines of billing for statement. When I began to relax, suddenly a file was stuck, no matter how I format the numbers into the required length and number format, Workbench never take the order, and showed error in uploading.
After consulting my mentor, Mr. Smith, I came to know that Quadrate is not straight forward as I thought, there are certain "rules" that I need to know before running the tool.
For example, with the same batch, if any two lines, are pointing to the same dealer code (invoice#) and the $amounts are opposite each other, means for the same dealer code, the billing amount is actually returned as 0, Quadrate then can not identify both line item, and showed error. Then I need to manually change split the invoice into two different invoices, change the invoice number is the way to make Quadrate understand that I am uploading two different invoices, instead of one.
Another trick was, when the first line item in the invoices is a negative amount, Quadrate will not take in either. I need to manually moved the item to next line.
Maybe there are more tricks hidden somewhere just I never met yet. Hopefully, Mr. Smith still remember how to handle those and share with me.
