Hi,
I want to import open items in AX2012 (FP), this by means of the DIXF framework.
I'm using the "Opening Balance" target entity for this purpose:
I want to import into de LedgerJournalTable (journal header) & LedgerJournalTrans (voucher lines).
The concerned fields are JournalNum (Journal Batch Number) and Voucher number which have been setup
as number sequences. These numbers are formatted as next:
- For JournalNum:
- For Voucher:
These sequence numbers are activated in the system. Next, I've activated auto number sequencing for the concerned fields in
the DIXF as next:
Next, when I choose "Preview" from my import file, I get:
I expected that DIXF would be smarter here and propose the next sequence to apply in correct format for JournalNum &
Voucher, e.g. PBJ-00001 and POVO-00001 and so on ... but ok ...
Until now, everything OK, but when I apply "Source to Staging" (Get Staging Data) I get next errors in the log:
hmmm ... what to do next ?
Besides this error, I wander how AX (or DIXF) maps to the right sequence number while importing open item information,
this because Voucher & Journal num should be created for the journal header (which involves these numbers should be in each
of the detail lines (voucher lines) the same for the imported journal). Does this "auto-numbering" works anyway or do I miss something here ???
Thx for any response ! :)
Greetingz,
Emmanuel Nuyttens.
