Description |
Add a button to the voucher screen to call an import screen.
The import routine should have :
# An export function to allow the user to export a sample file from AP that can be imported as a voucher
# the export function should take the data from the voucher that is on the screen and prefill the export file
# when you import the file you just exported it should create a voucher.
From attached Jira:
*Imports to AP Voucer screen*
* We should be able to import open vouchers into the Accounts payable system
* These vouchers will be for miscellaneous items
Functional requirements:
* work like the GL Import and export
* Be able to go into a voucher and export it into the format for a voucher.
File layout
*Header*
|
h1. Field|
h1. Additional Description|
|Record identifier|H (for header)|
|Voucher Id|Sequential Voucher Number|
|Type|Voucher,Debit Memo...|
|Vendor|Vendor Id from the vendor list|
|Invoice No|free form|
|Invoice Date|date|
|Recurring Flag|yes no flag|
|Check Comments|Free form|
|Post Date
|Date field|
|Terms|Validated to the common terms codes|
|Due Date|date field|
|Reference|Refernce field|
|Ship Via|Validated to the list of |
|Contact|Valid contact from the related vendor entity(if empty default from vendor)|
|Ship from|Valid location from the vendor entity (if empty default from vendor)|
|Ship to|Valid location from the Company file - (if empty default to first active)|
|Location|Valid location from the vendor entity (if empty default from vendor)|
|Pay to|Valid location from the vendor entity (if empty default from vendor)|
|Voucher no|User Defined|
|AP Account|Verify to GL and ensure account is in AP Category|
|Withheld Amt| |
|Currency|Default to Functional currency - validte to currency table|
|ORdered by| |
| | |
*Detail*
|
h1. Feild |
h1. Additional Description|
|Record Identifier|D (For Detail)|
|Voucher id|Sequential Voucher number (links to header)|
|Misc Description| |
|Billed|tblAPBillDetail.dblQtyReceived and send to tblAPBillDetail.QtyOrdered|
|Cost|tblAPBillDetail.dblCost|
|GL Account|Validate to chart of accounts|
|1099 form|Validate to 1099 forms|
|1099 category|Validate to 1099 categories|
|strComment|add to import file layout as free form by customer|
|ysnSubCurrency
| |
|
strSubCurrency|
|Allow null|tblAPBillDetail.strCurrencyExchangeRateType|
|currency|tblAPBillDetail.intCurrencyId |
|Description|tblAPBillDetail.strMiscellDescription|
|strContractNumber
|tblAPBillDetail.strContractNumber|
|strPurchaseOrderNumber|tblAPBillDetail.strPurchaseOrderNumber|
Sample file (iRely Demo Data)
H,1,Voucher,0001005002,111222,12/14/2016,check comment,12/31/2016,Net 30,1/15/2016,reference,truck,Corporate,Corporate Offic,008,008,Corporate offic, [12345,20000-0000-000,0,USD,george.olney@irely.com|http://jira.irelyserver.commailto:12345,20000-0000-000,0,USD,george.olney@irely.com]
D,1,Rent Expense,100,10,60000-0003-101,1099 MISC,Direct Sales
D,1,Phone Expense,100,10,60000-0001-100,none,none
strSubCurrency
|tblAPBillDetail.|
|