Author Topic: Exporting stock file into text file format  (Read 8671 times)

0 Members and 1 Guest are viewing this topic.

atlasville

  • Newbie
  • *
  • Posts: 2
Exporting stock file into text file format
« on: October 05, 2012, 03:49:51 PM »
Is it possible to export the theoretical stock file into text format? The guy that counts my stock requires it in ths format for input into his system.

He will also provide a text file of the difference that I would need to import afterwards. Can this be done?

Regards

ORlando
« Last Edit: October 06, 2012, 08:09:12 AM by admin »

Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 515
    • 4POS Point of Sale Solutions
Re: Exporting stock file into text file format
« Reply #1 on: October 06, 2012, 08:08:34 AM »
First of all - remember that you need to enter the ACTUAL stock into 4POS - NOT the difference! 4POS will calculate the difference so it can recalculate the value of your stock!

I personally don't think this is the best way to do your stock. Would it not be better to use a hand-held scanner to scan the physical stock & then importing it as a stock-take?

Also, you can simply create the file on excel (as above) - you don't even need a portable scanner. Or even : use the stock take utility to enter the physical stock using your own scanner!

Otherwise :

Any and all info of 4POS can be exported into any file you wish.

This is not done in 4POS but there are thousands of freeware programs available to cater for any type of export. All you need is a little know-how & thinking out of the BOX so to speak. We have decided NOT to have any export options simply due to the fact that it can be done as explained.

Option 1:
1.1. Load Cutepdf or PDFmailer (links elsewhere in this forum)
1.2. Print your report eg. stock take report to your PDF printer.
1.3. Use Adobe to either copy or export to Excel

Option 2. (More technical for some...)
2.1. Add a printer manually into your printers & faxes using the Generic Text driver.
2.2. Select the output port as Print to file
2.3. Print the report to that printer & specify the name & folder you wish to save the file to.

Option 3:
3.1. Use Option 1 to create the PDF file & then run a program line PDF2XL (Available on the internet) to export to excel.

There may be many more options, but this is just a sample.
« Last Edit: October 06, 2012, 08:11:07 AM by admin »

atlasville

  • Newbie
  • *
  • Posts: 2
Re: Exporting stock file into text file format
« Reply #2 on: October 08, 2012, 02:01:31 PM »
I exported the "stock content value" into a text file however the fields contained in this report are insufficient for the stockcount:

I would like the following
Product code
Product description
Units on hand (theoretical)
Cost price per unit
Stock group name

Where can I get this information?

Regards

Orlando