Page 1 of 1

Stock Take Database Update.

PostPosted: Thu May 05, 2016 3:50 pm
by Sunny
For a customer we needed to update a Stock Take form.
Customer gave us a csv file from their scanxpress system.
Created a new Stock Take form and noted the Stock Take No.
Wrote a straight forward SQL script to import the csv file and write the "Quantity Found" value into table IN_StockTakeLines, IN_StockTakeLineDetails filtered by Part No and Stock Take No.
The JIWA Stock Take form Updated, Saved and Activated successfully.

Since this is not a regular task, we thought this was the quickest method, but writing a Plugin would be a more convenient method for customer and better for data integrity(?).
Do we have a sample Plugin which Creates a new stock take form and includes all the items in a csv file with the scanned items and Qty found values?

Re: Stock Take Database Update.  Topic is solved

PostPosted: Tue May 24, 2016 9:55 am
by Mike.Sheen
Sunny wrote:Do we have a sample Plugin which Creates a new stock take form and includes all the items in a csv file with the scanned items and Qty found values?


Not at this stage. If we were directed to produce one, it'll appear in the samples forum and/or Jiwa databases if it is decided to be a standard plugin. You're the first person I know of to express an interest in such a plugin, so if you or your customer really want it you can ask [email protected] for a quote on getting it done.

Re: Stock Take Database Update.

PostPosted: Fri Feb 09, 2018 2:19 pm
by Ernst
Add a me to to this

Re: Stock Take Database Update.

PostPosted: Thu Jun 27, 2019 5:41 pm
by DannyC
I'd also be interested

Re: Stock Take Database Update.

PostPosted: Sun Jun 30, 2019 11:03 am
by Atronics
We have several clients who would use this.