Payable import
Payable invoice can be imported.
For obtaining opening balances CLIENT SHOUDL PROVIDE open payable aging in the below (attached format).Payable import.xls (13 kB)
| Invoice # | Invoice Type | Row code | Partner | Internal# date | Vat Date | Due Date | Variable symbol | Delivery Method | Purchase person | Autocode | Currency | Rate | Note | Product | Budget Code | Line Description | Quantity | Price | Tax Rate Autocode | Amount without VAT | VAT amount | Date From | Date To | Centers | |||||||||||
| S001 | INVOICE | 36 | V30001 | 30/05/2003 | 30/05/2003 | 29/06/2003 | S001 | Post | Honza Novák | CZK | 1.0 | test | ? | 107 | test | 2 | 100 | 200 | 0 | 01/05/2003 | 30/05/2003 | TYPE1 | 50 | TYPE2 | 50 | ||||||||||
| S002 | INVOICE | 36 | V30002 | 30/05/2003 | 30/05/2003 | 29/06/2003 | S002 | Post | Honza Novák | CZK | 1.0 | test | ? | 107 | test | 2 | 100 | 200 | 0 | 01/05/2003 | 30/05/2003 | TYPE1 | 40 | TYPE2 | 60 | ||||||||||
| PAYABLE IMPORT: | |||||||||||||||||||||||||||||||||||
| This page allows the user to import payable invoices from another application. | |||||||||||||||||||||||||||||||||||
| the data needs to be formated in the Amadeos format - typically done in excel, then when saving in excel save as CSV. BE CAREFUL when saving based on individuals PC setting sometimes in excel save as CSV us "'" and other times it uses ";". | |||||||||||||||||||||||||||||||||||
| To get teh exact format in excel click the download Text xls file and this should help in understanding what fields need to below in what columns. | |||||||||||||||||||||||||||||||||||
| First leave the test mode on to see if the data is in an acceptable format. | |||||||||||||||||||||||||||||||||||
| WARNING IMPORTING DATA IS FRUSTRATING! | |||||||||||||||||||||||||||||||||||
| If all seems OK with the test mode marked then de-mark the test for "real" import. | |||||||||||||||||||||||||||||||||||
| Next decide if you require Amaedoes numbers or prefer the imported numbering format. | |||||||||||||||||||||||||||||||||||
| The filename filed click browse and locate on the computer the csv file that should be imported. | |||||||||||||||||||||||||||||||||||
| Invoice # - This can be overridden based on teh import setting above | |||||||||||||||||||||||||||||||||||
| Invoice Type - https://www.amadeos.com/amadeos/servlet/invoicetype_payables_l | |||||||||||||||||||||||||||||||||||
| Row code - Row code see https://www.amadeos.com/amadeos/servlet/row_payables_l | |||||||||||||||||||||||||||||||||||
| Partner - enter the partner code NOT the name description | |||||||||||||||||||||||||||||||||||
| Internal#date - This is the invoice date | |||||||||||||||||||||||||||||||||||
| Vat Date - VAT tax date you would enter if entering into Amadeos manually - this is a coplex issue | |||||||||||||||||||||||||||||||||||
| Due Date - Date due | |||||||||||||||||||||||||||||||||||
| Variable symbol| - used normally as a reference for payment | |||||||||||||||||||||||||||||||||||
| Delivery Method - how delivered see https://www.amadeos.com/amadeos/servlet/transporttype_l?module_id=20 | |||||||||||||||||||||||||||||||||||
| Purchase person - Purchase person | |||||||||||||||||||||||||||||||||||
| Autocode - Budget code | |||||||||||||||||||||||||||||||||||
| Currency - currency the invoice issued in | |||||||||||||||||||||||||||||||||||
| Rate - rate used related to Base currency | |||||||||||||||||||||||||||||||||||
| Note - text optional | |||||||||||||||||||||||||||||||||||
| Product - see products https://www.amadeos.com/amadeos/servlet/product_l?module_20=1&event=103 | |||||||||||||||||||||||||||||||||||
| Budget Code - fpr payable this is partner type or the balance sheet side of payable account | |||||||||||||||||||||||||||||||||||
| Line Description - text description | |||||||||||||||||||||||||||||||||||
| Quantity - qty sold | |||||||||||||||||||||||||||||||||||
| Price - price per unit above | |||||||||||||||||||||||||||||||||||
| Tax Rate Autocode - VAT rate that should be used - must use code https://www.amadeos.com/amadeos/servlet/autocodevat_l?event=103&module_20=1 | |||||||||||||||||||||||||||||||||||
| Amount without VAT - line total amount excluding Tax | |||||||||||||||||||||||||||||||||||
| VAT amount - Line Tax amount | |||||||||||||||||||||||||||||||||||
| Date From - optional if there is a to from date for line | |||||||||||||||||||||||||||||||||||
| Date To - optional if there is a to from date for line | |||||||||||||||||||||||||||||||||||
| Date From - | |||||||||||||||||||||||||||||||||||
| Centers - IMPORT OF CENTERS ONLY WORKS FOR 1st level - in teh first field enter Center (see https://www.amadeos.com/amadeos/servlet/center_l?event=103&inactive=0) | |||||||||||||||||||||||||||||||||||
| BLANK Cell Z: 60 would represent 60%, 100 = 100% | |||||||||||||||||||||||||||||||||||
| Blank AA: Type 2 - next center to be used | |||||||||||||||||||||||||||||||||||
| Blank AB: 40 represent 40% the sum of Z and AB must be 100 - the user can make additional centers by using cell AC and AD ect. using the same principle. | |||||||||||||||||||||||||||||||||||
| EXAMPLE OF DATA FORMAT | |||||||||||||||||||||||||||||||||||
| Invoice # Invoice Type Row code Partner Internal# date Vat Date Due Date Variable symbol Delivery Method Purchase person Autocode Currency Rate Note Product Budget Code Line Description Quantity Price Tax Rate Autocode Amount without VAT VAT amount Date From Date To Centers | |||||||||||||||||||||||||||||||||||
| S001 INVOICE 36 V30001 30.05.2003 30.05.2003 29.06.2003 S001 Post Honza Novák CZK 1.0 test ? 107 test 2 100 200 0 01.05.2003 30.05.2003 TYPE1 50 TYPE2 50 | |||||||||||||||||||||||||||||||||||
| S002 INVOICE 36 V30002 30.05.2003 30.05.2003 29.06.2003 S002 Post Honza Novák CZK 1.0 test ? 107 test 2 100 200 0 01.05.2003 30.05.2003 TYPE1 40 TYPE2 60 | |||||||||||||||||||||||||||||||||||