Report Library - E-Commerce & Data Export

Egatebac.sty - Export Back Order File Contents to ASCII delimited text file

This report will create an ASCII tab delimited text file called egatebo.txt which will be placed in the default CAPITAL directory. The text file will contain information on all pending back orders in the system.

The information exported can be viewed if the report is loaded and print preview is selected. This exported information is suitable for import into another application such as an e-commerce package to list all current back orders. Each time the report is run, a complete copy of all current back orders are placed in the text file.

It should be noted that back orders tend to be constantly added and deleted from the back order file as new orders are raised and existing orders released (converted) into invoices. The most practical thing to do under these circumstances, is to export the entire file, rather than just changes to the file.

CAPITAL Visual Builder can be set-up to execute this report periodically using a scheduler application such as CAPITAL Scheduler or Microsoft Scheduler. The file can be generated automatically using the following switch settings:

VB.EXE /run=egatebac /exit

The above switch will start Visual Builder, run the report egatebac.sty and then exit (close down).

The ASCII file will contain the following information:

Column	Explanation
1	Customer account code. 8 characters uppercase.
2	Transaction number. This may be the sales order or invoice number. It is up to 9 characters wide and may be prefixed with letters. E.g., 1000, T3933, ABC500, etc.
3	Date of the transaction in dd/mm/yy format.
4	Stock ID. This is a unique 7 digit numeric code that can be used to cross-reference stock items with other CAPITAL files.
5	The product code. This is up to 25 characters wide and is always in uppercase.
6	Back order description line. The first line of description about the back ordered item up to 40 characters. This is normally equivalent to the product description, but may be changed by the operator.
7	Quantity back ordered. This number may contain decimal points. The maximum width of the number never exceeds 7 digits.
8	Sell price. The maximum width is 15 characters which including a decimal point and 2 numbers after the decimal.
9	Quantity allocated. This is normally the quantity that has already been picked or reserved for the customer. Its characteristics are the same as those of the quantity back ordered. It should be noted that some businesses prefer to auto-allocate all quantities and only unallocate the items that could not be found, after picking and packing.

____________________________