VbzCart/docs/ui/pages/rstk/rcv/single/invoice entry/format

From Woozle Writes Code
< VbzCart‎ | docs‎ | ui‎ | pages‎ | rstk‎ | rcv‎ | single‎ | invoice entry
Revision as of 23:05, 14 January 2016 by 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....")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 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):

\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