Hi NAV Forum,
I have a batch of 50 manual cheques that I need to upload to NAV. I also need to upload the vendor invoice into the system.
Our IT company gave me an Excel template which is supposed to:
(1) book the invoice
(2) book the payment
(3) apply the payment against the invoice
I can successfully upload the template into NAV. Both the invoice and payment appear to be properly recorded in NAV. However, the payment is not being applied against the invoice. Every vendor is left with open invoices and open payments.
Our IT company has been at this for a week and they have no clue how to fix it.
Please help!
A screenshot of the upload is here. https://1drv.ms/u/s!Ar4e4yx76y7rg0O-DFErj2HArC9A
Note that the upload is lines 1:269. Yellow line 270 is not apart of the upload. There are 68 fields in the template. They are below. I have filled out the template exactly as the IT company instructed.
Thank you,
cg
| Field 1 |
Posting Date |
| Field 2 |
Document Date |
| Field 3 |
Document Type |
| Field 4 |
Document No. |
| Field 5 |
Incoming Document Entry No. |
| Field 6 |
External Document No. |
| Field 7 |
Applies-to Ext. Doc. No. |
| Field 8 |
Account Type |
| Field 9 |
Account No. |
| Field 10 |
Description |
| Field 11 |
Payer Information |
| Field 12 |
Transaction Information |
| Field 13 |
Business Unit Code |
| Field 14 |
Salespers./Purch. Code |
| Field 15 |
Campaign No. |
| Field 16 |
Currency Code |
| Field 17 |
Gen. Posting Type |
| Field 18 |
Gen. Bus. Posting Group |
| Field 19 |
Gen. Prod. Posting Group |
| Field 20 |
Tax Bus. Posting Group |
| Field 21 |
Tax Prod. Posting Group |
| Field 22 |
Debit Amount |
| Field 23 |
Credit Amount |
| Field 24 |
Tax Liable |
| Field 25 |
Tax Area Code |
| Field 26 |
Tax Group Code |
| Field 27 |
Use Tax |
| Field 28 |
Quantity |
| Field 29 |
Amount |
| Field 30 |
Tax Amount |
| Field 31 |
Tax Difference |
| Field 32 |
Bal. Tax Amount |
| Field 33 |
Bal. Tax Difference |
| Field 34 |
Bal. Account Type |
| Field 35 |
Bal. Account No. |
| Field 36 |
Bal. Gen. Posting Type |
| Field 37 |
Bal. Gen. Bus. Posting Group |
| Field 38 |
Bal. Gen. Prod. Posting Group |
| Field 39 |
Deferral Code |
| Field 40 |
Bal. Tax Bus. Posting Group |
| Field 41 |
Bal. Tax Prod. Posting Group |
| Field 42 |
Bill-to/Pay-to No. |
| Field 43 |
Ship-to/Order Address Code |
| Field 44 |
Occupant Contact No. |
| Field 45 |
Property Contract No. |
| Field 46 |
Property Contract Line No. |
| Field 47 |
Item of Property No. |
| Field 48 |
Unit No. |
| Field 49 |
Property Code |
| Field 50 |
Entity Code |
| Field 51 |
Shortcut Dimension 3 Code |
| Field 52 |
Owner Contact No. |
| Field 53 |
Occupant Company Contact No. |
| Field 54 |
Shortcut Dimension 4 Code |
| Field 55 |
Shortcut Dimension 5 Code |
| Field 56 |
Shortcut Dimension 6 Code |
| Field 57 |
Shortcut Dimension 7 Code |
| Field 58 |
Shortcut Dimension 8 Code |
| Field 59 |
Payment Terms Code |
| Field 60 |
Applied Automatically |
| Field 61 |
Applied |
| Field 62 |
Applies-to Doc. Type |
| Field 63 |
Applies-to Doc. No. |
| Field 64 |
Applies-to ID |
| Field 65 |
On Hold |
| Field 66 |
Bank Payment Type |
| Field 67 |
Reason Code |
| Field 68 |
Comment |
| Field 69 |
Direct Debit Mandate ID |
*This post is locked for comments
I have the same question (0)
