FrontAccounting forum — Import of GRN

Re: Import of GRN

null@example.com (gabrielem) — Sat, 15 Nov 2014 10:55:32 +0000

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.

Re: Import of GRN

null@example.com (elax) — Wed, 27 Nov 2013 12:01:29 +0000

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

Import of GRN

null@example.com (robertzhao) — Wed, 27 Nov 2013 03:06:57 +0000

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