VbzCart/ui/pages/rstk/rcv/single/invoice entry/format - Revision history

Woozle: shortened field aliases; alternate entry format for cat #

2016-01-19T01:09:19Z

shortened field aliases; alternate entry format for cat #

← Older revision		Revision as of 01:09, 19 January 2016
Line 4:		Line 4:

	The first line of the bulk-entry area lets you define the column order using the following column names:		The first line of the bulk-entry area lets you define the column order using the following column names:
	* '''~~InvcQtyOrd~~''' - quantity ordered		* '''QtyOrd''' - quantity ordered
	* '''~~InvcQtySent~~''' - quantity sent		* '''QtySent''' - quantity sent
	* '''~~InvcCatNo~~''' - supplier's catalog #		* '''CatNo''' or '''Cat#''' - supplier's catalog #
	* '''~~InvcDescr~~''' - supplier's description		* '''Descr''' - supplier's description
	* '''~~CostInvPer~~''' - cost per item		* '''CostPer''' - cost per item
	* '''~~CostInvTot~~''' - cost total (i.e. at quantity: ~~InvcQtySent~~ x ~~CostInvPer~~)		* '''CostTot''' - cost total (i.e. at quantity: QtySent x CostPer)
			* '''Style''' or '''Title''' - supplier's catalog # for the Title
			* '''Size''' - supplier's suffix for the Item (CatNo = Style+Size)
			* '''*''' - ignore this column

	'''Example''' (partial):		'''Example''' (partial):
	<pre>		<pre>
	\~~InvcQtyOrd~~\~~InvcQtySent~~\~~InvcCatNo~~\~~InvcDescr~~\~~CostInvPer~~\~~CostInvTot~~		\QtyOrd\QtySent\CatNo\Descr\CostPer\CostTot
	\1\1\119433\US AND THEM LG\12\12		\1\1\119433\US AND THEM LG\12\12
	\1\1\119434\US AND THEM XL\12\12		\1\1\119434\US AND THEM XL\12\12
Line 22:		Line 25:
	\2\0\118303\BREATHE LARGE\8.75\0.00		\2\0\118303\BREATHE LARGE\8.75\0.00
	</pre>		</pre>

			'''Style''' and '''Size''' are for Suppliers whose invoices only give Title-unique catalog #s, with added Size (or other option) codes afterwards: VbzCart will build an Item-unique pseudo-catalog-number for the Supplier by combining these two columns, allowing them to be entered more or less as-is.

Woozle: a bit more clarity, I hope

2016-01-17T01:48:42Z

a bit more clarity, I hope

← Older revision		Revision as of 01:48, 17 January 2016
Line 1:		Line 1:
	The invoice bulk-entry area lets you define the order in which the line-item columns should appear, so you can type them in almost exactly verbatim from the original document.		The invoice bulk-entry area lets you define the order in which the line-item columns should appear, so you can type them in almost exactly verbatim from the original document.

	This is done using [[prefix-delimited string]]s (PDSs), since HTML ~~does~~ not support the use of the TAB character ~~in text boxes~~, and any other character might be found within the text that you want to enter. Using PDSs lets you choose any delimiter character you like ~~-- the~~ backslash ("\") ~~character~~ seems to work well for invoice entry, since it is almost never ~~used~~.		This is done using [[prefix-delimited string]]s (PDSs), since [[HTML]] text-entry controls do not support the use of the TAB character, and any other standard delimiter character (such as a comma) might be found within the text that you want to enter. Using PDSs lets you choose any delimiter character you like. The example below uses backslash ("\"), which generally seems to work well for invoice entry since it almost never appears on invoice detail listings.

	The first line of the bulk-entry area lets you define the column order using the following column names:		The first line of the bulk-entry area lets you define the column order using the following column names:

Woozle: Created page with "The invoice bulk-entry area lets you define the order in which the line-item columns should appear, so you can type them in almost exactly verbatim from the original document...."

2016-01-14T23:05:54Z

Created page with "The invoice bulk-entry area lets you define the order in which the line-item columns should appear, so you can type them in almost exactly verbatim from the original document...."

New page

The invoice bulk-entry area lets you define the order in which the line-item columns should appear, so you can type them in almost exactly verbatim from the original document.

This is done using [[prefix-delimited string]]s (PDSs), since HTML does not support the use of the TAB character in text boxes, and any other character might be found within the text that you want to enter. Using PDSs lets you choose any delimiter character you like -- the backslash ("\") character seems to work well for invoice entry, since it is almost never used.

The first line of the bulk-entry area lets you define the column order using the following column names:
* '''InvcQtyOrd''' - quantity ordered
* '''InvcQtySent''' - quantity sent
* '''InvcCatNo''' - supplier's catalog #
* '''InvcDescr''' - supplier's description
* '''CostInvPer''' - cost per item
* '''CostInvTot''' - cost total (i.e. at quantity: InvcQtySent x CostInvPer)

'''Example''' (partial):
<pre>
\InvcQtyOrd\InvcQtySent\InvcCatNo\InvcDescr\CostInvPer\CostInvTot
\1\1\119433\US AND THEM LG\12\12
\1\1\119434\US AND THEM XL\12\12
\1\0\138332\HEARTBEAT WMNS MEDIUM\8.05\0.00
\2\0\138333\HEARTBEAT WMNS LARGE\8.05\0.00
\2\0\138334\HEARTBEAT WMNS EXTRA LARG\8.05\0.00
\1\0\118302\BREATHE MEDIUM\8.75\0.00
\2\0\118303\BREATHE LARGE\8.75\0.00
</pre>