| | Item Inquiry On SO Quantity Doesn't Match Orders Tab Total |
| Description | Locate one-step invoices for the item To identify one-step invoices for the item: - Open Library Master, Utilities, Data File Display and Maintenance.
- Browse to
...\MAS90\MAS_xxx\SOxxx\SO_InvoiceDetail.m4t (where xxx = the company code). - Select Key No, KITEM.
- Enter the item number in the Key field, and press Enter.
- Review the first invoice line returned for that item.
- Click the right arrow to move to the next record.
|
| Cause | Why the quantity doesn't match Unupdated one-step invoices in Invoice Data Entry cause this issue. These invoices don't have an associated Sales Order. When using Batch Processing, invoices in a batch don't appear in lookups until you update them. If you use Job Cost with Sales Order Entry, each line requires a cost code and cost type. |
| Resolution | Review one-step invoices When you create a one-step Sales Order invoice: - Sage 100 increases the Item Inquiry On SO quantity.
- Sage 100 increases the Committed quantity.
- Sage 100 populates the In Shipping field.
- The invoice doesn't reference a Sales Order on the Orders tab. [Writing St...Agent.docx | Word]
If the total on the Orders tab doesn't match the On SO quantity on the Main tab: - Open Item Inquiry.
- Check the In Shipping quantity.
- Determine whether unupdated one-step invoices exist for the item.
- Update any remaining one-step invoices as needed. [Writing St...Agent.docx | Word]
If Job Cost is used Enter a valid cost code and cost type on the Lines tab for the affected item. |
|