QuickBooks:  Sales Orders and Purchase Orders

QuickBooks' Sales Order and Purchase Order forms work a bit different from other forms in QuickBooks (desktop editions). To prevent confusion when working with them in FullSpeed you need to understand those differences.

Working with Sales Order (SO) and Purchase Order (PO) Forms

Unique Columns in SOs and POs

QuickBooks may automatically add some of the following columns toward the right side of a SO or PO form:

Clsd                        (Closed)

Rcv'd                        (Received)

Bkordered                        (Backordered)

Invoiced                        

These columns may not necessarily appear when you first enter lines on a new PO or SO. Often they will be added later if/when you edit the form. The Backordered column may not appear until you receive Items against a PO, for instance.

QuickBooks displays the Rcv'd, Invoiced, and Backordered columns with a gray background, indicating they are not directly accessible to you. However, the Clsd column is not grayed by QuickBooks, so it is accessible to you but works differently from other columns. FullSpeed cannot read from or write to the Clsd column. That's something you probably wouldn't want FullSpeed to do anyway, but you need to understand that trying to get FullSpeed to write formula results to it will likely cause QuickBooks to display an error message.

Another column to know about...

Man. Part Num                (Manufacturer's Part Number)

The Man. Part Num column, if you include it in your PO form's template, is most peculiar of all. QuickBooks sometimes makes it inaccessible. FullSpeed was not designed to handle this situation; however, working around the problem is easy, as described below.

In some cases FullSpeed can detect that a QuickBooks form column such as Clsd is inaccessible to it. When that happens, FullSpeed displays **No Access** in that column of the macro's worksheet.

Rules for using FullSpeed with SO and PO Forms