I am currently building a Generic Inquiry to identify valid Purchase Receipts that require an AP Bill. The logic is that if a receipt has no corresponding AP Bill, it should then check whether there is a related Purchase Return; otherwise, it is considered valid and requires an AP Bill but I seem to be getting a duplicate. Any insight as to how to make it efficient? Sharing my GI. Thank you for your time in looking.
You can add this as a column to PO3020PL (Purchase Receipts) if it doesn’t already exist and then filter receipts for those waiting on AP bills.
When a return is entered, you’ll have to reconcile the receipt and the return with AP transactions, so those also show up here until the accounting side has been cleared
Not sure if that helps or solves your immediate needs
+4I am currently building a Generic Inquiry to identify valid Purchase Receipts that require an AP Bill. The logic is that if a receipt has no corresponding AP Bill, it should then check whether there is a related Purchase Return; otherwise, it is considered valid and requires an AP Bill but I seem to be getting a duplicate. Any insight as to how to make it efficient? Sharing my GI. Thank you for your time in looking.
But with that said, what’s your actual perfect line look like for the above situation?
What information do you want displayed for it?
Do you just want a tickbox for “Has Reciept”? Do you want the numbers concatenated? Just the most recent one?
I am currently building a Generic Inquiry to identify valid Purchase Receipts that require an AP Bill. The logic is that if a receipt has no corresponding AP Bill, it should then check whether there is a related Purchase Return; otherwise, it is considered valid and requires an AP Bill but I seem to be getting a duplicate. Any insight as to how to make it efficient? Sharing my GI. Thank you for your time in looking.
But with that said, what’s your actual perfect line look like for the above situation?
What information do you want displayed for it?
Do you just want a tickbox for “Has Reciept”? Do you want the numbers concatenated? Just the most recent one?
I am not yet able to test
From my understanding, if a Purchase Receipt has no associated AP Bill but does have a receipt, then it is considered valid even without a bill.
However, if a Purchase Receipt has neither an AP Bill nor a corresponding receipt, then it should require an AP Bill.
So I was hoping to filter an inquiry that if AP Bill is blank it should have another column like Purchase Return.
Our method is pretty darn simple, but works well. Our accounts payable team review the “unbilled receipts” regularly to try and track down any missing vendor bills and reduce purchasing accrual if that’s your ultimate goal as well
Like I said - I would think this is included by default on PO3020PL but if not, simply add a row for the POReceipt.UnbilledQty then add a saved filter for UnbilledQty <> ‘0’ AND status = released
You should get a list of all PO Receipts without the attached AP bill. Returns are “billed” when the Debit Adj. is entered and go to zero the same as a normal PO Receipt
Our method is pretty darn simple, but works well. Our accounts payable team review the “unbilled receipts” regularly to try and track down any missing vendor bills and reduce purchasing accrual if that’s your ultimate goal as well
Like I said - I would think this is included by default on PO3020PL but if not, simply add a row for the POReceipt.UnbilledQty then add a saved filter for UnbilledQty <> ‘0’ AND status = released
You should get a list of all PO Receipts without the attached AP bill. Returns are “billed” when the Debit Adj. is entered and go to zero the same as a normal PO Receipt
Thank you for this. Will try to look into it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
