
Hi,
I've a question about trade agreements. Is it possible to create items via trade agreements and particular via the Excel button?
For example see below:
Excel upload out of AX:
| Item | Price | From date | To date |
| 123 | 100 | 01012015 | 02012015 |
| 456 | 120 | 01012015 | 02012015 |
At above sheet I want to add 3 new items:
- Item 789 with a price of 75 from 02012015
- Item 987 with a price of 80 from 02012015
- Item 654 with a price of 90 from 02012015
My expected result is:
| Item | Price | From date | To date |
| 123 | 100 | 01012015 | 02012015 |
| 456 | 120 | 01012015 | 02012015 |
| 789 | 75 | 02012015 | |
| 987 | 80 | 02012015 | |
| 654 | 90 | 02012015 |
After this is done in Excel, whish is to publish the data into AX.
Is that possible?
Kr,
Nanda Spekschoor
*This post is locked for comments
I have the same question (0)If you don't have the items in AX, first import items and only then trade agreements.
It definitely is possible - AX 2012 has Data Import Export Framework for this type of things.