Jiwa

by **Sunny** » Thu May 05, 2016 3:50 pm

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?

by **Mike.Sheen** » Tue May 24, 2016 9:55 am

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.