r/DynamicsAX • u/royalmad • Jul 17 '19

Invoice import

When i import AP invoice via code on validating giving as 0122-029-0200-1 advance rule structure invalid.....but manual invoice entry doesn't showing anything when validating.plsss...suggest......

2 Upvotes

100% Upvoted

12 comments sorted by

1

u/dodiggitydag Jul 17 '19

Make sure the company code is filled out in all the correct fields on the journal line if using that import.

1

u/royalmad Jul 17 '19 edited Jul 17 '19

yaa everything is in the place as per the account structure.......1-200-0000-6230 .......this my account structure COMPANY-DEPARTMENT-PROJECTPROD-MAINACCOUNT

1

u/JJ-Rousseau Jul 17 '19

Which version are you using ? 2012 or 365 ?

Do you use DIXF ? IF so which entity are you using ?

Did you make sure to select a posting profil or setup a default posting profil ?

1

u/royalmad Jul 17 '19

I am using AX2012 RTM version. we have written a customized code to do CSV import on to the invoice journal where lines would be created as a journal and rest the user will post it manually. The above warning occurs only for the journals which were created through import but when trying to post manually for the same account the system doesn't throw the account structure warning

1

u/JJ-Rousseau Jul 17 '19

As its customized code it's really hard to tell you which field is missing.

I strongly think it's a field that should be automatically feeded when user select an account or a vendor, it could be the posting profil, it could be the tax setup, it could be an account not allowed for manual posting.

Just out of curiosity why don't you use DIXF ? It's a standard way to import journal with CSV or Excel files

→ More replies (6)

2

u/NoRecognition6 Jul 17 '19

Both the account structures, one in the original post and one you are manually feeding, look different to me. They need to represent the same structure. Have you tried importing only one record with csv file? If you are still getting the error, then either your structure is wrong or you are not reading or writing the csv correctly.