Skip to main content

Import Excel data into Invent Table using temple in Ax2009

By

How to import Excel data into invent Table in ax2009.

You know while importing data into invent table we need to follow few steps then only the data will import in correct format.


1)                         Go to Ax2009 -> Administration module -> periodic->Excel Spreadsheet -> Create Template using template Wizard.
2)              While creating template must and should we can use two tables along with Invent table. I.e.
                           I)                    Invent table
                           II)                  InventTableModule
                           III)                InventItemLocation
3)  After creating the template .copy and paste the data into template one by one .And make sure   either                            fill all the mandatory fields or not.
4)  In Invent Table we have to fill Item Type like in this format only 000::Item.

5) Next Go to Invent Table Module tab fill only mandatory columns. Then we have to also fill one more       column i.e. Dimension No. = AllBlanks. Make sure no gap.

Final Step we have to fill the invent Table module also.

After completing this process import the Excel with the same definition Group into ax.

These cases data will import into particular tables but it’s not populating in invent Table form. The problem  is we have to Fill invent Table Module table like below format then only data will populate into Forms.

  Item Number    Module Type

Invtrial02
000::Inventory
Invtrial02
001::Purchase order
Invtrial02
002::Sales order

We have to enter each item as three rows then only data will populate into forms.
Hope this will help you friends. I tried this is working fine. If anyone got any issues feel free to comment me.

Comments

Post a Comment

Popular posts from this blog

Using File path on a form getting Error in Axapta

By
Hi Folks, After a long time am coming  back to posting few new things here for AX Developer... When we want to select the file path in form level. Normally what we will do create one EDT and extends with filepath (EDT), but that time when you are trying to select the path we will get error like stack-trace/Error message .Don’t worry there is no problem with your ax application. Simple we need to provide the method to the form like filepathLookUpTitle (). Below method we need to add it into form level methods, i.e. str filePathLookupTitle() {     return "Select document folder"; } Thanks Happy Daxing....
20 comments
Read more

Convert word Documents into PDF report [using X++ in Dynamics AX 2009]

By
Hi Friends, This is the way we can convert word format report into PDF in ax2009 static void dsiple_PDS(Args _args) {     Args args;     ReportRun rr;     str reportName = "ReportName";     PurchRFQLine rfqLineTable;     str myPath;     str pdfFileName;     int i;     COM wordApplication;     COM wordDocuments;     COM wordDocument;     COM wordRange;     str a[];     str path;     str pdfPath;     str finalPath;     int length;     int minus;     ;     i = 1;     myPath = winApi::getTempPath();     info(myPath);     args = new Args(reportName);     args.caller(rr);     //rr =...
1 comment
Read more
By
 Note 2 ==== SE24 - Global class (Class and methods)  SE37 - function module - configure  SE38 - report  BAPI -  Function module  Object Type  Interface type  Form  - Flow  Form open - FP_Job_ open spool; function              LV_fm_name - cal function Job_close =============== ASN order confirmconfirmation  - VA03  FP_job_open VL02n - ASN  VF03  - Invoice document  VA02  - Sales order confirmation  Interface we cant debug - use Break-point from dev and activate then debug
Post a Comment
Read more