{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Template123","PODownloadTest","Sheet1","Setup","Sample","ErrorLog","Settings123"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template123","index":0,"n_rows":35,"n_cols":171,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["PROCESSING STATUS",null,null,null,null,null,null,null,null,null,null,"INVOICE HEADER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INVOICE DISTRIBUTIONS"]
["Invoice Status",null,null,null,"Line Status",null,null,null,null,null,null,null,null,null,"P.O.","Supplier",null,null,"Invoice Details",null,null,null,null,null,null,null,null,null,null,null,null,"R12 Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice Currency",null,null,null,"Payment Currency",null,null,null,"Pre-Payment Details",null,null,null,null,null,"R12 Only",null,null,"Descriptive Flexfields",null,null,"Global Attributes",null,null,"Attachments",null,null,null,null,"Invoice Holds",null,null,null,null,null,"Distribution Details",null,null,null,null,null,null,null,null,null,null,"Tax",null,null,null,null,null,null,"R12 Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,"Prorating",null,null,"Accounting",null,null,null,null,null,null,"Asset",null,"P.O. Receipt",null,null,null,null,null,null,null,"Purchase Order Matching",null,null,null,null,null,null,null,null,null,null,null,"Project Accounting",null,null,null,null,null,null,"Line Descriptive Flexfields",null,null,"Distribution Descriptive Flexfields",null,null,"Distribution Global Attibutes"]
["Invoice ID","Invoice Status","Validation Status","Invoice Error","Line ID","Line Number","Tax Line ID","Line Status","Line Error","R12 Dist Status",null,"Operating Unit","Legal Entity","Customer Taxpayer","P.O. Number - Invoice Level","Supplier Number","Supplier Name","Supplier Site","Invoice Type","Invoice Sub Type","Invoice Number","Voucher Number","Invoice Date","GL Date","Liability Account","Invoice Received Date","Goods Received Date","Description","Invoice Total","Workflow Flag","Tax Control Amount","Calculate Tax During Import","Discountable Amount","Pay Alone","Terms","Terms Date","Payment Method","Payment Reason Code","Payment Reason Comments","Remittance Message 1","Payment Priority","Payment Due Date","Discount Due Date","Discount Amount","Remit To Bank Account","Bank Charge Bearer","Pay Group","Document Category","Tax Country","Supplier Tax Invoice Number","Supplier Tax Invoice Date","Supplier Tax Exchange Rate","Tax Invoice Internal Sequence","Tax Invoice Recording Date","Invoice AWT Group","Payment AWT Group","Requester","Currency Code","Exchange Rate Type","Exchange Rate","Exchange Date","Pay Currency Code","Cross Rate Type","Pay Cross Rate","Pay Cross Date","PP Apply Amount","PP Inv Num","PP Line Num","PP Dist Num","PP GL Date","Invoice Includes PP","Unique Remittance Identifier","URI Check Digit","Add Tax To Inv Amount","Invoice DFF Context","Invoice DFF 1","Invoice DFF 15","Global Category","Global Attr1","Global Attr20","Attach Status","Attach Category","Attach Desc","Attach Type","Attach Content","Hold Status","Hold Name","Hold Reason","Release Status","Release Name",null,"Line Type","Dist Description","Amount","Merchant Name","Merchant Document Number","Merchant Reference","Merchant Tax Reg Number","Merchant Taxpayer","Purchasing Category","Statistical Quantity","Unit of Measure","Tax Code","Includes Tax","Dist Inv AWT Group","Dist Pay AWT Group","Tax Amount","Income Tax Type","Income Tax Region","Tax Regime","Tax","Tax Jurisdiction","Tax Status","Tax Rate Name","Tax Rate","Primary Intended Use","Ship To","Product Fiscal Class","Business Category","Fiscal Class","Product Type","Product Category","Include in Taxable Line","Prorate","Line Group Number","Distribution Set","Account","Accounting Date","Track As Asset","Deferred Acctg Start Date","Deferred Acctg End Date","Deferred Acctg Period Type","Deferred Acctg Num of Periods","Asset Book Type","Asset Category","Receipt Number","Receipt Line","Quantity Received","Quantity Unbilled","Bill of Lading","Waybill Airbill","Shipment Number","Packing Slip","P.O. Number - Line Level","Inventory Item","Item Description","Reference1","Reference2","Release Number","P.O. Line Number","P.O. Shipment Number","P.O. Distribution Number","Quantity Invoiced","Unit Price","Final Match","Project Number","Task Number","Award Number","Expenditure Type","Organization","Item Date","PA Quantity","Line DFF Context","Line DFF 1","Line DFF 15","Dist DFF Context","Dist DFF 1","Dist DFF 15","Dist GDF Category","Dist GDF Attr1","Dist GDF Attr20"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"PODownloadTest","index":1,"n_rows":24,"n_cols":159,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["PROCESSING STATUS",null,null,null,null,null,null,null,null,"INVOICE HEADER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INVOICE DISTRIBUTIONS"]
["Invoice Status",null,null,null,"Line Status",null,null,null,null,null,null,null,"P.O.","Supplier",null,null,"Invoice Details",null,null,null,null,null,null,null,null,null,null,null,"R12 Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice Currency",null,null,null,"Payment Currency",null,null,null,"Pre-Payment Details",null,null,null,null,null,"R12 Only",null,null,null,null,"Descriptive Flexfields",null,null,"Global Attributes",null,null,"Attachments",null,null,null,null,"Invoice Holds",null,null,null,null,null,"Distribution Details",null,null,null,null,null,null,null,null,null,null,"Tax",null,null,null,null,null,null,"R12 Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,"Prorating",null,null,"Accounting",null,null,null,null,null,null,"Asset",null,"P.O. Receipt",null,null,null,null,null,null,null,"Purchase Order Matching",null,null,null,null,null,null,null,null,null,null,null,"Project Accounting",null,null,null,null,null,null,"Descriptive Flexfields",null,null,"Distribution Global Attibutes"]
["Invoice ID","Invoice Status","Validation Status","Invoice Error","Line ID","Tax Line ID","Line Status","Line Error",null,"Operating Unit","Legal Entity","Customer Taxpayer","P.O. Number - Invoice Level","Supplier Number","Supplier Name","Supplier Site","Invoice Type","Invoice Sub Type","Invoice Number","Voucher Number","Invoice Date","GL Date","Liability Account","Invoice Received Date","Goods Received Date","Description","Invoice Total","Tax Control Amount","Calculate Tax During Import","Discountable Amount","Pay Alone","Terms","Terms Date","Payment Method","Payment Reason Code","Payment Reason Comments","Payment Due Date","Discount Due Date","Bank Charge Bearer","Pay Group","Remit To Bank Account","Document Category","Tax Country","Invoice AWT Group","Payment AWT Group","Requester","Currency Code","Exchange Rate Type","Exchange Rate","Exchange Date","Pay Currency Code","Cross Rate Type","Pay Cross Rate","Pay Cross Date","PP Apply Amount","PP Inv Num","PP Line Num","PP Dist Num","PP GL Date","Invoice Includes PP","Unique Remittance Identifier","URI Check Digit","Remittance Message 1","Payment Priority","Add Tax To Inv Amount","Invoice DFF Context","Invoice DFF 1","Invoice DFF 15","Global Category","Global Attr1","Global Attr20","Attach Status","Attach Category","Attach Desc","Attach Type","Attach Content","Hold Status","Hold Name","Hold Reason","Release Status","Release Name",null,"Line Type","Dist Description","Amount","Merchant Name","Merchant Document Number","Merchant Reference","Merchant Tax Reg Number","Merchant Taxpayer","Purchasing Category","Statistical Quantity","Unit of Measure","Tax Code","Includes Tax","Dist Inv AWT Group","Dist Pay AWT Group","Tax Amount","Income Tax Type","Income Tax Region","Tax Regime","Tax","Tax Jurisdiction","Tax Status","Tax Rate Name","Tax Rate","Primary Intended Use","Ship To","Product Fiscal Class","Business Category","Fiscal Class","Product Type","Product Category","Include in Taxable Line","Prorate","Line Group Number","Distribution Set","Account","Accounting Date","Track As Asset","Deferred Acctg Start Date","Deferred Acctg End Date","Deferred Acctg Period Type","Deferred Acctg Num of Periods","Asset Book Type","Asset Category","Receipt Number","Receipt Line","Bill of Lading","Waybill/Airbill","Shipment Number","Packing Slip","Quantity Received","Quantity Unbilled","P.O. Number - Line Level","Inventory Item","Item Description","Reference1","Reference2","Release Number","P.O. Line Number","P.O. Shipment Number","P.O. Distribution Number","Quantity Invoiced","Unit Price","Final Match","Project Number","Task Number","Award Number","Expenditure Type","Organization","Item Date","PA Quantity","Dist DFF Context","Dist DFF 1","Dist DFF 15","Dist GDF Category","Dist GDF Attr1","Dist GDF Attr20"]
[]
[]
[null,null,null,null,null,null,null,null,"COBAIN - INCLUDE RECEIPT NUMBER",null,null,null,3904,1004,"Star Gate Ltd","STAR GATE - BUY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 Net (terms date + 15)",null,"Check",null,null,null,null,null,"Standard",null,null,"United States",null,null,null,"USD",null,null,null,"USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Support","After sales support",399,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10646,1,null,null,null,null,0,119,3904,null,null,null,null,null,1,1,null,399,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Support","After sales support",399,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10658,1,null,null,null,null,120,119,3904,null,null,null,null,null,1,1,null,399,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consulting","Legal Services",199,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10646,2,null,null,null,null,0,199,3904,null,null,null,null,null,2,1,null,199,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consulting","Legal Services",199,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10658,2,null,null,null,null,200,199,3904,null,null,null,null,null,2,1,null,199,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Training","Training post sales",2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10646,3,null,null,null,null,0,0,3904,null,null,null,null,null,3,1,null,2000,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expense","Test Data",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10646,4,null,null,null,null,0,6,3904,null,null,null,null,null,4,1,null,9,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expense","Test Data",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10658,3,null,null,null,null,7,6,3904,null,null,null,null,null,4,1,null,9,1]
[]
[]
[null,null,null,null,null,null,null,null,"COBAIN - EXCLUDE RECEIPT NUMBER",null,null,null,3904,1004,"Star Gate Ltd","STAR GATE - BUY",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"15 Net (terms date + 15)",null,"Check",null,null,null,null,null,"Standard",null,null,"United States",null,null,null,"USD",null,null,null,"USD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","After sales support",399,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,119,3904,null,null,null,null,null,1,1,null,399,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","Legal Services",199,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,199,3904,null,null,null,null,null,2,1,null,199,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","Training post sales",2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,3904,null,null,null,null,null,3,1,null,2000,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","Test Data",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,6,3904,null,null,null,null,null,4,1,null,9,1]

{"sheet":"Sheet1","index":2,"n_rows":9,"n_cols":28,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["PROCESSING STATUS",null,null,null,null,null,null,null,null,"INVOICE HEADER",null,null,null,null,null,null,null,null,null,null,"INVOICE DISTRIBUTIONS"]
["Invoice Status",null,null,null,"Line Status",null,null,null,null,"P.O.","Supplier",null,null,"Invoice Details",null,null,null,null,"Invoice Currency",null,"Distribution Details",null,"Tax",null,"Purchase Order Matching"]
["Invoice ID","Invoice Status","Validation Status","Invoice Error","Line ID","Tax Line ID","Line Status","Line Error",null,"P.O. Number - Invoice Level","Supplier Number","Supplier Name","Supplier Site","Invoice Number","Invoice Date","Description","Invoice Total","Pay Alone","Currency Code",null,"Dist Description","Amount","Tax Code","Product Category","P.O. Number - Line Level","P.O. Line Number","Quantity Invoiced","Unit Price"]

{"sheet":"Setup","index":3,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Download and Installation"]
[null,null,"Please complete the installation steps as per the download email, ensuring both the shared and product zip "]
[null,null,"files have been provided to your DBA."]
[]
[null,null,null,"To see the installation instructions, refer to: ",null,"Steps - Installation and Configuration"]
[]
[null,null,null,"NOTE you will not be able to use this wizard if the above steps have not been completed."]
[]
[null,null,"Configure the Workbook"]
[null,null,"After the above installation steps have been completed, this spreadsheet will require the following configuration."]
[]
[null,null,null,"a.","Login"]
[null,null,null,null," On the wizard toolbar click on the “i” button (About this Program) to configure your login address."]
[]
[null,null,null,null,"For detailed instructions refer to the following link: ","Set up the List Instances"]
[]
[null,null,null,"b.","Licence Key"]
[null,null,null,null,"If you do not have a Licence key, the wizard will operate in trial version mode and limit the number "]
[null,null,null,null,"of records that can be uploaded/downloaded."]
[]
[null,null,null,null,"If you have  a Licence Key click on the “i” (About this Program) provided on the wizard toolbar  "]
[null,null,null,null,"and click  the “Enter Licence Key” button.  Paste the licence number into the field provided."]
[]
[null,null,null,null,"For detailed instructions refer to the following link: ","Enter the Licence Key"]
[]
[]
[null,null,"Helpful links"]
[null,null,"The following link will assist you in using the application’s features to its best advantage:"]
[]
[null,null,null,null,"Online Documentation"]
[]
[]
[null,null,"Note that this Setup sheet can be deleted as it is not used by the program."]

{"sheet":"Sample","index":4,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["PROCESSING STATUS",null,null,null,null,null,null,null,null,"INVOICE HEADER",null,null,null,null,null,null,"INVOICE DISTRIBUTIONS"]
["Invoice Status",null,null,null,"Line Status",null,null,null,null,"Supplier",null,"Invoice Details",null,null,null,null,"Distribution Details",null,"Tax"]
["Invoice ID","Invoice Status","Validation Status","Invoice Error","Line ID","Tax Line ID","Line Status","Line Error",null,"Supplier Number","Supplier Site","Invoice Number","Invoice Date","Invoice Total","Invoice DFF 1",null,"Line Type","Amount","Tax Code","Includes Tax","Tax Amount","Account"]
[]
[null,"Rejected",null,"Warning only... Invoice date is older than a year old.\nInvoice total in row 11 is NOT equal to Distributions total as follows:\rInvoice       = 12\rDistributions = 311\rDifference    = 299\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.\nWarning only... Invoice date is older than a year old.",null,null,"Validated",null,null,"1004","STAR GATE - PAY",1000011447,"08-Aug-2003","12",null,null,null,200,null,"Yes",null,"01-000-1130-000"]
[null,null,null,null,null,null,"Validated",null,null,null,null,"","",null,null,null,null,111,"VAT - 15%","Yes",null,"01-000-1110-000"]
[]
[5142,"Pending",null,null,10250,null,"Pending",null,null,"1004","STAR GATE - PAY","1235k","30-May-2002","calc",null,null,"ITEM",123.45,null,null,null,"01-000-1110-000"]
[null,null,null,null,10251,null,"Pending",null,null,null,null,"","",null,null,null,"TAX",111,"CA - Sales Tax",null,null,"01-000-1110-000"]
[]
[null,"Validated",null,null,null,null,"Validated",null,null,"1004","STAR GATE - PAY","1235m","30-May-2002","calc",null,null,"ITEM",123.45,"CA - Sales Tax",null,null,"01-000-1110-000"]
[null,null,null,null,null,null,"Rejected","Value 999 for the flexfield segment Services Department does not exist in the value set 999SET. (VALUESET=Services Department)",null,null,null,"","",null,null,null,"TAX",111,"CA - Sales Tax",null,null,"01-999-1110-000"]
[null,null,null,null,null,null,null,null,null,""]
[19622,"Pending",null,null,31500,null,"Pending",null,null,"1004","STAR GATE - PAY","1212121","10-May-2004","calc",null,null,null,3060,null,"",null,"01-000-1230-000"]
[null,null,null,null,null,null,"Deleted",null,null,null,null,null,null,null,null,null,null,3060,null,"",null,"01-000-1230-000"]
[]
[19623,"Pending",null,null,31502,null,"Pending",null,null,"1004","STAR GATE - PAY","1212121","10-May-2004","CALC",null,null,"ITEM",3060,null,"",null,"01-000-1230-000"]
[null,null,null,null,31502,null,"Pending",null,null,null,null,null,null,null,null,null,"ITEM",3060,null,"",null,"01-000-1230-000"]
[]
[374600,"Processed","Needs Revalidation",null,null,null,"Processed",null,null,"1004","STAR GATE - PAY","1235k","30-May-2002","calc",null,null,"ITEM",123.45,null,"Yes",null,"01-000-1110-000"]
[null,null,null,null,null,null,"Processed",null,null,null,null,"",""]
[]
["There is an important setting on your Supplier Sites that determines how you can use this tool"]
[]
["If the Tax Calculation Level is set to Header or None, then AP will NOT calculate Tax on invoices you load with the tool",null,null,null,null,null,null,null,null,null,null,null,null,"Scenario"]
["You must load Tax Distributions using the tool, and we have provided two methods for you to achieve this",null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,"ITEM",1000,"VAT - 15%",null,null,"01-000-1230-000"]
[1,"Load Tax Distributions on their own line, i.e. look to the right on this row and this is demonstrated",null,null,null,null,null,null,null,null,null,null,null,1,null,null,"TAX",150,"VAT - 15%"]
[2,"Include the Tax amount in its own column. AP Invoice Wizard will load this in a separate Distribution",null,null,null,null,null,null,null,null,null,null,null,2,null,null,"ITEM",1000,"VAT - 15%",null,150,"01-000-1230-000"]
[]
["If the Tax Calculation Level is set to Line or Tax Code, then AP WILL calculate Tax on invoices you load with the tool",null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"ITEM",1150,"VAT - 15%","Yes",null,"01-000-1230-000"]
["You use a Tax inclusive or tax Exclusive Amount for the LINE Distribution.  You do NOT load separate Tax distributions",null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,"ITEM",1000,"VAT - 15%",null,null,"01-000-1230-000"]
[3,"Distribution Amount includes Tax"]
[4,"Distribution Amount excludes Tax"]
[]
["In all cases, the Invoice Total should agree with the Distributions total.  In scenario 4, the amount is still $1,150 even though only $1,000 is shown in the Distributions section"]
["By using the word \"calc\" in the Invoice Total column, AP Invoice Wizard will automatically calculate the total for you"]
["The \"Calc\" button on the Invoice Header form can also be used to determine the correct total"]
[]
[null,null,null,null,null,null,null,null,null,1004,"STAR GATE - PAY","Lance10","2013-10-18",100,null,null,"Item",92.38,"NY - Sales Tax",null,null,"01-730-7610-000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item",0,"NY - Sales Tax",null,null,"01-000-2520-000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item",7.62,"NY - Sales Tax",null,null,"01-730-7610-000"]
[]
[null,"Totara"]
[null,"Rejected",null,"Invoice total in row 50 is NOT equal to Distributions total as follows:\rInvoice       = 141.97\rDistributions = 160.49\rDifference    = 18.52",null,null,"Validated",null,null,1004,"STAR GATE - PAY",1000189,"2013-11-30",141.97,"Go away",null,"Item",123.45,"VAT - 15%",null,null,"01-000-1110-000"]
[null,null,null,null,null,null,"Validated",null,null,null,null,null,null,null,null,null,"TAX",18.52,"VAT - 15%"]
[]
[null,"Tremor"]
[null,null,null,null,null,null,null,null,null,1004,"STAR GATE - PAY","10042012-07","2012-04-10",8660]

{"sheet":"ErrorLog","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Time Stamp","Action","Details"]
["2015-11-23T16:55:40","Login SSO","\r\n\r\nInstallation & Connection Details\t\r\n-----------------------------------------\r\nAP Invoice Wizard (PIW) by More4Apps\r\nSpreadsheet Version\t9.6.35\r\nCommon Modules Version\t209\r\nShared Package Header Version\t12.1.1 24-Jun-14\r\nShared Package Body Version\t12.1.2 24-Jun-14\r\nPIW Package Header Version\t3.0.5 01-Apr-14\r\nPIW Package Body Version\t3.3.3 07-Feb-15\r\nR12 Servlet Version\t1.0.11 04-Feb-2010\r\nUser:\tMHE2@PH.RC@Prod\r\nResp:\tRCUK AP Invoice Entry\r\nOp Unit:\tAHRC - Operating Unit\r\nInstall:\t12.0.6      Database: 10.2.0.5.0\r\nEncoding:\tUTF-8\r\nLanguage:\tUS\r\nSession ID:\t210402879\r\nApplication Status Bar Text\tFALSE\r\n\r\nLicence Information\t\r\n-----------------------------------------\r\nRCUK\r\n\r\nThis key is for a Perpetual Licence which will never expire.\r\n\r\nYou may add up to 5 users using this Licence Key.\r\nThese can be changed at any time using a login with System Administration privileges.\r\n\r\nInitialise Session String\t\r\n-----------------------------------------\r\nbegin\r\n\t fnd_global.apps_initialize ( \r\n\t\t user_id=> 8702\r\n\t\t ,resp_id=> 51184\r\n\t\t ,resp_appl_id=> 200 ); \r\n\r\n\t fnd_global.set_nls_context(\r\n\t\t p_nls_language => 'AMERICAN',\r\n\t\t p_nls_date_language => 'AMERICAN',\r\n\t\t p_nls_sort => 'BINARY',\r\n\t\t p_nls_territory => 'UNITED KINGDOM',\r\n\t\t p_nls_date_format => 'YYYYMMDD',\r\n\t\t p_nls_numeric_characters => '.,' ); \r\n\r\n\t mo_global.set_policy_context('S', 83);\r\nend;\r\n\r\nWindows / Excel Versions\t\r\n-----------------------------------------\r\nOperating System:\tWindows 7 64-Bit (NT 6.01)\r\nExcel Version: \t\tOffice 2010 32-Bit (14.0)\r\n\r\n-----------------------------------------\r\n[ITCWS-2249/mhe2 23/11/2015 16:55:40]"]
["2015-11-23T16:55:40","Generate Catalog Info","\r\nCATALOG INFORMATION\t\r\n-------------------\t\r\n\r\nGeneral Information\t\r\n-------------------\t\r\nRelease:  12.0.6\r\nSite:  UK SBS 12.0.6 Production Environment (SSCPRD)\r\nWeb Agent:  https://ebs.ssc.rcuk.ac.uk:443/pls/SSCPRD\r\nInstance:  SSCPRD1\r\nEncoding:  UTF-8\r\nDB Version:  10.2.0.5.0\r\nServlet Agent:  https://ebs.ssc.rcuk.ac.uk:443/OA_HTML\r\n\r\nDatabase Characterset and Language\t\r\n----------------------------------\t\r\n(Parameter / Value)\t\r\n-------------------\t\r\nNLS_TERRITORY     AMERICA\r\nNLS_LANGUAGE     AMERICAN\r\nNLS_CHARACTERSET     UTF8\r\n\r\nSession Language\t\r\n----------------\t\r\n(Parameter / Value)\t\r\n-------------------\t\r\nNLS_TERRITORY     UNITED KINGDOM\r\nNLS_LANGUAGE     AMERICAN\r\n\r\nPackage versions\t\r\n----------------\t\r\n(Package Name / Header / Body / Status)\t\r\n---------------------------------------\t\r\nAPPS.M4APS_PROJECTWIZARD     1.0.5 20-Aug-07     1.2.0 14-Jul-09     VALID\r\nAPPS.M4APS_RECINVWIZARD     1.1.0 10-Oct-10     1.2.0 10-Oct-10     VALID\r\nAPPS.M4APS_TRANSWIZARD     1.0.4 27-Feb-09     1.0.16 27-Feb-09     VALID\r\nAPPS.M4APS_XML     12.1.1 24-Jun-14     12.1.2 24-Jun-14     VALID\r\nAPPS.M4APS_PIW_EXTENSION     1.0.2 19-Jan-15     1.0.2 19-Jan-15     VALID\r\nAPPS.M4APS_BUDGETWIZARD     3.0.5 25-Jun-07     3.0.9 03-Jul-07     VALID\r\nAPPS.M4APS_PAYINVWIZARD     3.0.5 01-Apr-14     3.3.3 07-Feb-15     VALID\r\nAPPS.M4APS_EVENTWIZARD     2.0.0 11-Sep-06     2.0.7 14-Aug-08     VALID\r\n\r\nInvalid Packages\t\r\n----------------\t\r\n(OBJECT_NAME / OBJECT_TYPE)\t\r\n---------------------------\t\r\n\r\nComplilation Errors\t\r\n-------------------\t\r\n(Package / Type / Line / Error)\t\r\n-------------------------------\t\r\n\r\nOOD Synonyms\t\r\n------------\t\r\n(Synonym Name / Table Owner / Table Name)\t\r\n-----------------------------------------\t\r\n\r\nLicense KEYS\t\r\n------------\t\r\n(License Name / Key)\t\r\n--------------------\t\r\nM4APS_RIW_LICENCE_KEY     7C1BA20BF42D071DFF43B864A2B58C14329ABF619A9372C859611BDC3E49171C\r\nM4APS_TW_LICENCE_KEY     145768DD41CEAA9F6BD1EA05FBEECDA212CF056C7FCBB0168ED19EE5358807841D2AE9A15477E2F6\r\nM4APS_PW_LICENCE_KEY     5C452C88469170E72460B0D536A7813332F56FF917D06E676FC02824F2B6E2C3E4C905F840902E4F521FCD4958254B51\r\nM4APS_PIW_LICENCE_KEY     B51DC015BAB4295D455B690AF535E065F4C38B8A2FA654AB66A00822261DE884\r\nM4APS_EW_LICENCE_KEY     21889234FD56CD2919BF4AA1C2C5AC47601A0AC2A36330506F28D077B3A9934532CE33F03732E985\r\nM4APS_BW_LICENCE_KEY     8940E0026F4DBA1A688D6BE6D82803D45454C2552792D0A41A2F33375F3D312DB7431D24D8E6A0495BC176FD9DD3C68BCCF7BBFC9430561F88E170BDD8630311\r\n\r\n"]
["2015-11-23T16:55:42","Cached Instance List","eInstanceList Keys/Values: \r\n\r\nCG_OU_ID [83]\r\nCG_OU_NAME [AHRC - Operating Unit]\r\nCG_ENCODING [UTF-8]\r\nCG_CHAR8211 [–]\r\nM4APS_PIW_UNICODE_ENCODING []\r\nXML_HEADER [12.1.1 24-Jun-14]\r\nXML_BODY [12.1.2 24-Jun-14]\r\nCGLK [B51DC015BAB4295D455B690AF535E065F4C38B8A2FA654AB66A00822261DE884]\r\nCGLK_PC [PIW]\r\nCGLK_SITE [RCUK]\r\nCGLK_EXP_DATE [29991231]\r\nCGLK_EXTRA [N]\r\nCGLK_NUMUSERS [5]\r\nCGLK_DOMESSAGE []\r\nCGLK_ASSIGNEDUSERS [5]\r\nCGLK_EXPIREDUSERS [0]\r\nCGLK_NAMEDUSER [N]\r\nCGLK_AUTOASSIGN []\r\nCG_RELEASE_NAME [12.0.6]\r\nLANGUAGE [US]\r\nCG_USER_NAME [MHE2@PH.RC]\r\nNINE_I [10]\r\nDB_VERSION [10.2.0.5.0]\r\nPRODUCT_HEADER [3.0.5 01-Apr-14]\r\nPRODUCT_BODY [3.3.3 07-Feb-15]\r\nFND_FNDPOMPV [2]\r\nM4APS_PIW_MAINTENANCEUSER []\r\nCG_RESP_NAME [RCUK AP Invoice Entry]\r\nM4APS_PIW_LATESTVERSION [9.6.35]\r\nM4APS_PIW_CUSTOM [N]\r\nl_Cat_Delimiter [.]\r\nAP_APXIISIM [1]\r\nAP_APXIIFIX [1]\r\nAP_INVOICES1 [N]\r\nAP_INVOICES2 []\r\nAP_INVOICES3 [N]\r\nAP_INVOICES4 []\r\nAP_INVOICE_DISTRIBUTIONS1 [Y]\r\nAP_INVOICE_DISTRIBUTIONS2 []\r\nAP_INVOICE_DISTRIBUTIONS3 [N]\r\nAP_INVOICE_DISTRIBUTIONS4 []\r\nAP_INVOICE_LINES1 [Y]\r\nAP_INVOICE_LINES2 []\r\nAP_INVOICE_LINES3 [N]\r\nAP_INVOICE_LINES4 []\r\nJG_AP_INVOICES_INTERFACE1 [Y]\r\nJG_AP_INVOICES_INTERFACE2 []\r\nJG_AP_INVOICES_INTERFACE3 [N]\r\nJG_AP_INVOICES_INTERFACE4 [REFERENCE_FIELD]\r\nJG_AP_INVOICES1 [N]\r\nJG_AP_INVOICES2 []\r\nJG_AP_INVOICES3 [N]\r\nJG_AP_INVOICES4 [REFERENCE_FIELD]\r\nJG_AP_INVOICE_LINES_INTERFACE1 [Y]\r\nJG_AP_INVOICE_LINES_INTERFACE2 []\r\nJG_AP_INVOICE_LINES_INTERFACE3 [N]\r\nJG_AP_INVOICE_LINES_INTERFACE4 [REFERENCE_FIELD]\r\nJG_AP_INVOICE_DISTRIBUTIONS1 [Y]\r\nJG_AP_INVOICE_DISTRIBUTIONS2 []\r\nJG_AP_INVOICE_DISTRIBUTIONS3 [N]\r\nJG_AP_INVOICE_DISTRIBUTIONS4 [REFERENCE_FIELD]\r\nl_Sysdate [20151123]\r\nl_category_set_id [1100000041]\r\nl_po_structure_id [50314]\r\n"]
["2015-11-23T16:55:42","Cached Session List","eSessionList Keys/Values: \r\n\r\nM4APS_PIW_LIMIT_RESPLOV -1 []\r\nCG_SOB_ID 83 [2023]\r\nCG_COA_ID 83 [50315]\r\nM4APS_PIW_ALLOWNONASCII 83 []\r\nM4APS_PIW_BANNED 83 []\r\nM4APS_PIW_MINVERSION 83 []\r\nM4APS_PIW_REQUIREDVERSION 83 []\r\nLoginMultiCallRun 83 [Done]\r\nAP_COPY_INV_LINE_DFF 83 []\r\nl_Default_Tax_Country 83 [GB]\r\nAP_USE_INV_BATCH_CONTROLS 83 [N]\r\nAR_ALLOW_TAX_CODE_OVERRIDE 83 []\r\nPA_DEFAULT_EXP_ORG 83 []\r\nPA_ALLOW_FLEXBUILDER_OVERRIDES 83 [Y]\r\nJGZZ_COUNTRY_CODE 83 [US]\r\nDISPLAY_INVERSE_RATE 83 [N]\r\nM4APS_PIW_NOCHECKPO 83 []\r\nM4APS_PIW_NOCHECK 83 []\r\nM4APS_PIW_NOACCTOK 83 []\r\nM4APS_PIW_MYBATCHESONLY 83 []\r\nM4APS_PIW_NO_GL_DATE 83 []\r\nM4APS_PIW_DISABLE_IMPORT 83 []\r\nM4APS_PIW_NO_ZERO_INVOICES 83 []\r\nM4APS_PIW_OVERRIDESECURITY 83 []\r\nM4APS_PIW_LIMIT_TAXLOV_TO_OU 83 []\r\nM4APS_PIW_NO_CLOSEDFORINVOICE_POS 83 []\r\nM4APS_PIW_NO_CLOSED_POS 83 []\r\nM4APS_PIW_DEFAULT_BATCH_SOURCE 83 []\r\nM4APS_PIW_USE_N_FOR_NULL_PRORATE 83 []\r\nM4APS_PIW_USE_DISTRIBUTION_DFF 83 []\r\nM4APS_PIW_INVOICEDATEWARNING 83 []\r\nM4APS_PIW_DISABLECALC 83 []\r\nM4APS_PIW_DISABLE_DOWNLOAD 83 []\r\nM4APS_PIW_DISABLE_IMPORTHOLD 83 []\r\nM4APS_PIW_ALLOW_HOLDCOL 83 []\r\nM4APS_PIW_ALLOW_CANCEL 83 []\r\nM4APS_PIW_ALLOW_UPDATE 83 []\r\nM4APS_PIW_ALLOW_RELEASECOL 83 []\r\nM4APS_PIW_ENABLE_DISTRIBUTION_DFF 83 []\r\nM4APS_PIW_RELEASEMYHOLDSONLY 83 []\r\np_Allow_Doc_Cat_Ovr 83 [Y]\r\nl_Use_Inv_Batch_Controls 83 []\r\np_System_Currency 83 [GBP]\r\np_Tax_Precision 83 []\r\np_Allow_AWT_Flag 83 [N]\r\np_Def_Tax_Code_Sys 83 []\r\np_Tax_From_System_Flag 83 [N]\r\np_Tax_From_Vendor_Flag 83 [N]\r\np_Tax_From_Ven_S_Flag 83 [N]\r\np_Tax_Hier_System 83 [0]\r\np_Tax_Hier_Vendor 83 [0]\r\np_Tax_Hier_Vendor_Site 83 [0]\r\np_Auto_Tax_Calc_Flag 83 [N]\r\np_GL_Date_Basis 83 [S]\r\np_Allow_Remit_To_Account_Override 83 [Y]\r\nGL_Min_Date 83 [20151101]\r\nGL_Max_Date 83 [20151130]\r\nl_Acct_Delimiter 83 [-]\r\nGL_BALANCING 83 [1]\r\nFA_COST_CTR 83 [3]\r\nGL_ACCOUNT 83 [4]\r\n"]

{"sheet":"Settings123","index":6,"n_rows":30,"n_cols":188,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["MHE2@PH.RC",null,null,null,"Flex Values here",1,"01","495","7040","000"]
["Prod",null,null,null,null,"","<=Request Name"]
["RCUK AP Invoice Entry",null,2,"<==Global DFFs Option",null,1,"<=RequestDays",3,null,null,null,null,null,"<=Password"]
[1,"<=Login Method","MORE4APPS","<==Batch Source",null,true,"<==Upload Holds",null,false,"<==Update Discount Amount"]
[2,"<==Validate / Upload options",1,"<==Debug Option",null,false,"<==Upload Releases",null,false,"<==Update Discount Due Dates",false,"<==Update Payment Priority"]
["2014-10-15","<==GL Date",1,true,true,false,"<==Cancel",null,false,"<==Update Pay Group",true,"<==Update DFFs"]
[1,"<==Display DBA toolbar option",true,"<==Extras Selected",null,false,"<==Update Payment Methods",null,false,"<==Update Remit Bank AC"]
[1,"<==Purge Option",false,"<==Extras All",null,false,"<==Update Payment Due Dates",null,true,"<==Update Remit Mess 1","#,##0.00_ ;[Red]-#,##0.00 "," Numeric Format field"]
["RCUK","<==Licencee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N.9999999.Northern Territory.Chasing GTs",null,null,null,null,null,null,null,"Special Val Type",5545,1234,null,null,"1|2|3|4|5|6|7|8|9|10|11|12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File"]
[false,"<==Extra Flag",true,"<=Header DFFs exist",null,false,"<=Global Header DFFs exist"]
[true,"<==My batches only",true,"<=Distribution DFFs exist",null,false,"<=Global Distribution DFFs exist"]
[null,"<==Num Copies",null,"<==Hold Name"]
[1,"<==Use Default Tax",null,"<==Hold Reason",null,null,null,null,null,null,null,null,null,"Mandatory Field Settings"]
["Example","http://machine.domain.com:8000/pls/finprod",-8,"<=Wizard Toolbar y-Coord",null,null,null,"Suppliers","po_vendors",null,false,"optLoadForm",null,"Mandatory Field","Available Field List"]
["Prod","https://ebs.ssc.rcuk.ac.uk:443/OA_HTML",-8,"<=Wizard Toolbar x-Coord",null,null,null,"Supplier Sites","po_vendor_sites",null,false,"optContinue",null,null,"Invoice Date"]
[null,null,4,"<=Wizard Toolbar Position Flag",null,null,null,"Payment Methods","fnd_lookup_values_vl",null,false,"optContinueQuietly",null,null,"GL Date"]
[null,null,-1,"<=Wizard Toolbar RowIndex",null,null,null,"Pay Groups","fnd_lookup_values_vl",null,true,"optStop",null,null,"Description"]
[null,null,-8,"<=Setup Toolbar y-Coord",null,null,null,"R11i Tax Codes","ap_tax_codes",null,null,null,null,null,"Payment Terms"]
[null,null,-8,"<=Setup Toolbar x-Coord",null,null,null,"R12 Tax Class Codes","zx_input_classifications_v",null,true,"File Attachment",null,null,"Terms Date"]
[null,null,4,"<=Setup Toolbar Position Flag",null,null,null,"Projects","pa_projects_expend_v",null,null,null,null,null,"Voucher Number"]
[null,null,-1,"<=Setup Toolbar RowIndex",null,null,null,"Tasks","pa_tasks",null,null,null,null,null,"Payment Method"]
[null,null,-8,"<=Login-Info Toolbar y-Coord",true,"<=Login Info Toolbar Visible",null,"Expenditure Types","pa_expenditure_types",null,null,null,null,null,"Pay Group"]
[null,null,-8,"<=Login-Info Toolbar x-Coord",null,null,null,"Organizations","pa_organizations_expend_v",null,null,null,null,null,"Requester"]
[null,null,4,"<=Login-Info Toolbar Position Flag",null,null,null,"Document Category","fnd_doc_sequence_categories",null,null,null,null,null,"Liability Account"]
[null,null,-1,"<=Login-Info Toolbar RowIndex",null,null,null,"Distribution Line Types","ap_lookup_codes",null,null,null,null,null,"Dist Description"]
[null,null,null,null,null,null,null,"Invoice Holds","ap_holds_hold_name_v",null,null,null,null,null,"Tax Code"]
[null,null,null,null,null,null,null,"Invoice Releases","ap_holds_release_name_v"]
[null,null,null,null,null,null,null,"Payment Terms","ap_terms"]