integrity:report_discrepancies
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
integrity:report_discrepancies [2020/03/27 15:53 (4 years ago)] – kevin | integrity:report_discrepancies [2024/02/05 09:40 (7 weeks ago)] (current) – kevin | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Reporting Discrepancies ====== | ====== Reporting Discrepancies ====== | ||
+ | See: https:// | ||
+ | |||
This is a list of things to investigate if you experience a report not matching another report of the same reporting period. | This is a list of things to investigate if you experience a report not matching another report of the same reporting period. | ||
Line 17: | Line 19: | ||
* " | * " | ||
* " | * " | ||
- | Many sales report has an option to include incomplete types such as " | + | Many sales reports have an option to include incomplete types such as " |
- | * Best Practice: Review what types of invoice types you are including in a report if you intend to compare against a financial report. | + | * Best Practice: |
* Example: | * Example: | ||
==== Check Date Ranges ==== | ==== Check Date Ranges ==== | ||
If you are running a financial report it will be run for an entire book month. | If you are running a financial report it will be run for an entire book month. | ||
- | * Best Practice: | + | * Best Practice: |
* Example: | * Example: | ||
==== Changing an Inventory Category ==== | ==== Changing an Inventory Category ==== | ||
- | With supervisor privileges, a user with rights can change the category that an inventory item resides in. This will change where sales history will land in inventory reports but NOT change the income and cost of goods ledgers where past invoices have been posted to. Looking back on reports that look at these areas will have different results after such a change. | + | With supervisor privileges, a user with rights can change the category that an inventory item resides in. This will change where sales history will land in inventory reports but NOT change the income and cost of goods ledgers where past invoices have been posted to. Looking back on reports that look at these areas will have different results after such a change. |
- | * Best Practice: | + | * Best Practice: |
==== GL coded entry on Invoice ==== | ==== GL coded entry on Invoice ==== | ||
Using the feature to place a general ledger code directly onto an invoice makes accounting easy but has a sales report consequence. | Using the feature to place a general ledger code directly onto an invoice makes accounting easy but has a sales report consequence. | ||
- | * Best Practice Solution: Create a CATEGORY and INVENTORY item to sell and use that on an invoice instead. | + | * Best Practice Solution: |
==== Integrity ==== | ==== Integrity ==== | ||
- | If you are not running integrity report this can have a ledger, invoice reports and detail reports not matching as it depends on the view of the data that a report totals against. If the integrity error is the invoice total does not match the detail. This can be why a summary report does not match the detail reporting. | + | If you are not running integrity report this can have a ledger, invoice reports and detail reports not matching as it depends on the view of the data that a report totals against. |
- | * Best Practice: Make a habit to run integrity reports | + | * Best Practice: |
==== Changing Category Ledger Codes ==== | ==== Changing Category Ledger Codes ==== | ||
With category security, an administrator can make changes to the category income and cost of goods sold ledger codes for a category. | With category security, an administrator can make changes to the category income and cost of goods sold ledger codes for a category. | ||
- | * Best Practice: Restrict who has privileges to make this type of financial change. | + | * Best Practice: |
- | + | ||
+ | ==== Inventory Value and Oversold Inventory ==== | ||
+ | Overselling Inventory will post to COGS and reduce the Inventory Balance Sheet account using the standard cost of the item being sold. The Inventory Value report (Not a ledger report) does not consider the value of oversold inventory, however it does display it as a separate total on this rpeort. Oversolds should be factored in when reconciling Inventory Ledger to Value report. | ||
+ |
integrity/report_discrepancies.1585349629.txt.gz · Last modified: 2020/03/27 15:53 (4 years ago) by kevin