You’re offline. This is a read only version of the page.
We are using the DIEF to import a csv file from the sales exported by another system. In all it is working as expected except it is not updating the next number to allocate correctly in the voucher number sequence. I have tried using a straight number sequence and also getting the system to allocate the number sequence at the time of posting but I get the same problem.
I have read and checked against the "Importing a General Journal using Data Import/Export Framework AX 2012" and can't see where I could have gone wrong.
Can anyone please point me in the right direction?
Many thanks
Paulina
*This post is locked for comments
The best way to avoid this use two separate Journal Names such as one is for daily routing journal entry and another is only for purpose of journal upload only. Therefor two seperate JV Name will travel with its own sequesnce.
Hi Paulina,
You are manually assigning the voucher number (number sequence) due to this reason the system does not realise it has been used.
If the system were to generate the voucher number (number sequence) then and only then will the next record in the number sequence be updated.
When uploading a journal using DIEF/DIXF in AX2012 there are 2 options:
Good morning Paulina,
Can you test the following:
Each journal name has a parameter that allows you specifying the voucher number at the time a posting is made.
The parameter is called 'number allocation at posting' and basically overwrites the temporary numbers that you see when creating journal lines.
Can you check whether this functionality helps you overcoming your issue?
Probably setup a new journal with the parameter active and a specific temporary and final voucher series number in a demo/test environment first to find out.
Best regards,
Ludwig
Good morning, Thank you for your answer, I apologise for the delay in getting back to you on this one. The csv file I am importing does not have the offset account on the individual lines but a balancing entry line in the CSV file.
Hello Paulina,
Does every line in your journal have an account and offset account setup?
From the screenshot shown above it looks as if you are making a large split posting that gets only a single number assigned.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (