VbzCart/docs/ui/pages/rstk/rcv/single/invoice entry/format: Difference between revisions
imported>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....") |
imported>Woozle (a bit more clarity, I hope) |
||
| 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 | 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: | ||
Revision as of 01:48, 17 January 2016
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 strings (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:
- 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):
\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