How is SOLD qty calculated?

[GPINC]

How is "SOLD" qty calculated on the Item Quantities Maintenance window? Great Plains defines "Sold" as "the quantity of this item that has been sold, in the base unit of measure." That doesn't help much. Is it qty off posted Invoices after payment is received?

Thanks in advance.

 

[barbola]

Inventory is updated when the invoice is posted. This updates the Quantity Sold for the site on the invoice.

 

[GPINC]

Thanks- this means our Sold QTY is not updating like it should. Is there any other method besides Check Links/Reconcile that can correct this quantity? [We do have a modified Great Plains which might be our issue.]

 

[macleod1021]

If the reconcile isn't picking up any errors, then it sounds like the quantities in the database were inputted incorrectly. You would need to audit your SOP invoices in order to find the problems. Once you find the problems you can manually correct them and/or create an adjustment transaction to correct the quantity on hand values. You should ask your accountant which way he prefers you to do it because it will need to be reconciled at month/year end.

This does bring up the next question of whether it's a problem with the modifications. Does your add-in specifically affect SOP or Inventory transactions? If so, then you should get the vendor involved to see if it's a problem with the product or how it's being used. Also, if you don't mind telling us, what add-ins do you have?

 

[GPINC]

Thanks for the response. The modifications are VB code done by an ex-consultant to our GP8. Extra data is being captured per line item in SOP transaction that is saved to a separate database. We will be moving over to GP9 (unmodified) at the end of this year because we've had too many problems with the modifications.