• Registered: 11/27/2013
  • Posts: 1

Topic: Import of GRN

Hi

My company receives many GRN daily from purchasing agents, and currently we enter them manually into FA.

Is there a way to import GRN from a csv file? Or can someone let me know what data are inserted into which table(s) when we enter a Direct GRN?

Thanks in advance!

Robert

  • elax
  • Senior Member
  • Offline
  • From: UK
  • Registered: 05/17/2011
  • Posts: 326

Re: Import of GRN

You can't just insert data directly in the database, as GRN as an impact on standard cost and posting delayed post due to negative inventory.
However you can use textcart and copy paste your csv into the UI.

/Elax

  • Registered: 10/06/2013
  • Posts: 5

Re: Import of GRN

Quite old question, but any way I'm thinking the answer can be usefull for reader also.
Even better way, but require more development time, is to use the API and perform some auto loading trough them. FA has a basic API module based on Slim Framework a very good and light Framework for RestFull API. Is quite easy to personalize it and then you can perform some automated task to send data to it.