how to create Purchase Invoice using import process

Comments

• Options

  logger Member Posts: 126

  2017-12-18

  @ismailthesacrificer1@gmail.com,
  WHAT, AGAIN?!
  We already discuss it here https://forum.mibuso.com/discussion/70580/can-any-one-suggest-me

  Let's go!
  

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-18

  But i didn't get the solution for it. only header information is moving not the Line information. I need both information should move in purchase invoice

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @ismailthesacrificer1@gmail.com,
  I suggest you have a mistake in logic in your code. You can post you code here and we will take a quick look on it.

  Let's go!
  

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-18

  
  
  
  
  
  
  

  0
• Options

  logger Member Posts: 126

  2017-12-18

  @ismailthesacrificer1@gmail.com,
  Sorry, but major part of you code looks like you just taken it from blender.
  And gInsertData function has obvious mistakes. E.dg you use RowNo as parameter but always read data from row no. 1.

  Let's go!
  

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-18

  Can you evaporate it.. Please

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-18

  Thanks @logger for your Support and respond I got the solution for this.

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-18

  Hi @ logger but it should accept even the record already exists is there any method to not to get this error
  
  

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-19

  hello @ logger
  I was waiting for your reply it will be helpful if you respond.

  0
• Options

  lubost Member Posts: 614

  2017-12-19

  Notes to your code:
  - you use RowNo as parameter but always read data from row no. 1 as logger says
  - values in purchase line should be used from previously created header, not from columns
  - purchase line Document Type is missing
  - purchase line Line No. is missing

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-19

  Thanks @ lubost
  
  Yes i added purchase line Document Type and Line No.
  Can you please evaporate it i didn't understand it, yes its read only one record
  

  0
• Options

  nizar_mneimneh Member Posts: 3

  2017-12-19

  Document type and line.no. are not enough u have to choose the most important thing which is Document No., btw u can also use rapid services in nav2016 and choose the fields u want and whether to validate or not on each one, but the file u import should be excel

  0
• Options

  lubost Member Posts: 614

  2017-12-19

  Your code can create header and one line. If your Excel has more lines linked to one document no., you have two possibilities:
  - divide headers data and lines data into two sheets/files and create loop for import headers and loop for import lines
  - you can (theoretically) import data your way, but you have to change code to IF gPurchaseHeaderRec.INSERT(TRUE) THEN ; to avoid attempt to insert the same document twice. Bad message is that this code doesn't differentiate between double inserting and other error in insert trigger.

  0
• Options

  lubost Member Posts: 614

  2017-12-19

  ... and the best way is use Dataport/XMLPort.

  0
• Options

  ismailthesacrificer1@gmail.com Member Posts: 76

  2017-12-20

  TQ lubost and nizar_mneimneh for responding.

  0