List of invoices and credit memos used to return serialized equipment back into inventory.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
When returning serialized equipment back into inventory, often users will do a negative quantity on a sales invoice or create a credit memo. This will return the serialized items to inventory at their original cost. The majority of the time, this cost is overstated because the item may have been sold several years ago. This daily alert shows you the serialized items that were returned to inventory through a negative quantity on a sales invoice or a credit memo, allowing you to review and determine if the item was brought back into inventory at the correct price.
This alert ignores inventory updates done through voided invoices because typically, equipment invoices are voided to correct and rebill the items, not to return the items to inventory.
Run Schedule: Daily at 6 pm
Type of Output: Email
* * *
Sample
Sample
*Please note that the column named Transaction pulls from the note written to the item ledger at the time of the transaction.
* * *
Variables
Variables
Variable W: Items to trigger on - Enter 'ALL' to show all items returned to stock, or 'Cost' to only show items with a cost on the invoice/credit back to inventory.
Variable X: Branch Numbers - List the branch numbers to trigger on, or leave blank to trigger on all branches.
* * *
Alert Functionality
Alert Functionality
1. This alert only triggers on serialized items.
2. The alert looks for transactions created in the past three days that have not already triggered the alert.
Sales Credit Memo - Machine returned via Customer Return:
Invoice with negative quantity - Sales invoice created with a negative quantity:
3. When the item has a standard cost on the item record, that is the amount that e-automate will use on a return.
If the item does not have a standard cost set, e-automate will use the average cost on the item.
To only show items on this alert that have a cost, set Variable W to 'Cost'. When Variable W is set to 'All', all serialized items will trigger the alert, even if the cost is $0.00.
* * *
Best Practices & Tips
Best Practices & Tips
See the documentation here on best practices for bringing used equipment back into inventory.
* * *
Related Alerts
Related Alerts
None at this time.
* * *
0 Comments