- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Purchases Clearing Reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-21-2011 11:50 AM
We have some Purchases Clearing Items where the inventory and/or invoice has been cleared, but we have a negative dollar amount in the right hand column, due to a return, or a price difference after invoicing. HOw do I clear the negative item without affecting the vendor's AP account?
Re: Purchases Clearing Reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-21-2011 12:15 PM
Just to be claer, this is in both our Inventory items, and / & * items
Re: Purchases Clearing Reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-21-2011 01:23 PM
What version of MAS?
Re: Purchases Clearing Reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-23-2011 06:47 PM
I would try doing a reciept of goods and invoice and when you receive in the item add an additional line in the invoice using the /misc with a qty of 1 for the same amount but as a negitive or positive to offset the receipt. I would also use a variance account - this should then net out to a zero AP invoice.
It is exciting learning new things.....
Re: Purchases Clearing Reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-24-2011 05:09 AM
It depends on whether the inventory needs to be changed or not.
The biggest problem we have is when returns are posted. If the return is posted with a purchase order number entered, the return quantity will be "removed" from the PO and create a back-order situation. (MAS is assuming the item will be re-shipped from the vendor against the same PO). If this is the case and you are not expecting replacements, I've found 3 options:
1. You receive the item again and process a second return WITHOUT citing the PO number.
2. Receive the item and inventory adjust the item back out.
3. Post another invoice with a negative inventory quantity (to bring the inventory equal to invoice quantity, changing the invoice AMOUNT to ZERO to not affect the amount payable to the vendor. If you do this, you must also go back into the PO and clear the BO quantity that was created.
If the inventory on hand is not correct and an additional receipt (or return - now citing the PO number) will correct it, neither of these entries will affect the Vendor payable.
If inventory is correct and a vendor credit or adjustment invoice threw things out of balance (perhaps the credit was posted as and AP invoice instead of a PO invoice), I enter a new invoice through PO, use an Invoice number "ADJ####", enter the inventroy quantity to clear the PO, and change the amount to zero.
In the scope of my GL, none of these become significant amounts, so whether it falls into inventory adjustment, purchase returns, or purchase variance doesn't bother me too much. I look at the three numbers togther to get a sense of any problem trends developing. (I know this will upset the purists but it's the reality of "my world".)
Re: Purchases Clearing Reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-28-2011 08:34 AM
Rfellner: If I understand your post correctly, your PO clearing report is listing a dollar amount left over but no quantity? Is that what you're saying?
If so, can you report this to support or your reseller with steps to dupe, so that we can look into this? This doesn't sound right.
Your time is appreciated.
Have an idea? Submit an enhancement request


